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 = '698376'
group by i.id
Germination: surface sow and keep moist, tamp the soil. Cover to keep light out. Remove cover after germination.
Solidago canadensis, also known as Canada Goldenrod, is a stunning herbaceous perennial plant belonging to the Asteraceae family. Native to northeastern North America, it is often grown as an ornamental in flower gardens. While not shade tolerant, Canada Goldenrod is found in a range of habitats and is one of the first plants to colonize an area after disturbance. It is also valued for providing good to fair food for domestic livestock like cattle and horses. The plant's flowers are used as an antiseptic and to treat sore throats, among other ailments. Despite its many positive attributes, Canada Goldenrod is considered an invasive species in many regions, including Europe and Asia. Nonetheless, it continues to charm gardeners and is widely admired for its small yellow flowers which sit atop branching inflorescences.