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 = '2327'
group by i.id
Germination: sow seed 1/16" deep, tamp the soil, lightly mulch the seed bed.
Teucrium canadense, also known as Canada Germander, American Wood Sage, and simply Germander, is a versatile perennial herb native to North America. The plant can grow up to 3 feet tall, forming clumps with ovate or lanceolate leaves up to 5 inches long and lilac lipped flowers. The plant is well-adapted to growing in a variety of habitats, from riverbanks to poorly drained areas, making it an ideal choice for any garden. American Germander contains a number of chemicals with pharmacological properties, such as flavonoids and volatile oils, that have been used for medicinal purposes by Native Americans. It is diaphoretic, diuretic and emmenagogue, and its leaves can also be applied externally to cuts as an antiseptic. And with its ability to attract pollinators, such as bees and butterflies, Teucrium canadense is not only functional, but beautiful as well. Order now and experience the many benefits of this versatile herb in your garden today!