select i.*, substring_index(group_concat(distinct pa.country order by rsi.date_added desc),',',-1) as source_country
from inventory_item_manage i
left outer join sheffields_2017.receiving_shipments_item_has_inventory_item hrsi on i.id = hrsi.inventory_item_id
left outer join sheffields_2017.receiving_shipments_item rsi on rsi.id = hrsi.receiving_shipments_item_id
left outer join sheffields_2017.po on rsi.po_id = po.id
left outer join sheffields_2017.po_address pa on pa.po_id = po.id
where i.inventory_id = '2057'
group by i.id
Germination: surface sow and keep moist, tamp the soil, requires light for germination
Discover the beauty of the Great Blue Lobelia (Lobelia siphilitica), a stunning perennial flower native to eastern and central Canada and the United States. This herbaceous plant, belonging to the Campanulaceae family, thrives in moist to wet soils in zones 4 to 9. Growing up to a meter tall, it is an impressive addition to any garden.
In late summer, the Great Blue Lobelia produces a spike of zygomorphic flowers, adding a pop of vibrant color to your outdoor space. Its blooms, lasting from August to October, attract bees and other insects for pollination. While this plant is self-compatible, it relies on these pollinators for effective reproduction.
Not only is the Great Blue Lobelia visually striking, but it also has a rich history. Some Native American Indian tribes believed that the finely ground roots could prevent divorces and reignite love between arguing couples when secretly added to their food.
The medicinal uses of this plant add to its allure. The root has been used as a cathartic, diaphoretic, and emetic, while the leaves are known for their analgesic and febrifuge properties. Infusions made from the leaves have been effective in treating colds and fevers. Additionally, a poultice of the root or crushed leaves can alleviate headaches and heal difficult-to-treat sores.
Embrace the beauty, history, and medicinal benefits of the Great Blue Lobelia in your garden. Order your seeds today and create a stunning display that will leave a lasting impression. For more information, visit our website.