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 = '700855'
group by i.id
Scarification: soak in warm water, let stand in water for 6 hours
Stratification: none required
Germination: Sow shallowly, cover the seed with compost or sharp sand, ensure that the compost surface is damp.
Looking for a beautiful and functional addition to your garden or landscaping? Look no further than the Eutrochium dubium, also known as the coastal plain joe pye weed. This North American flowering plant is a herbaceous perennial that can grow up to 68 inches tall, producing numerous flower heads in flat-topped arrays. The dark purple disc florets of these flowers are a favorite of birds, making this plant not only visually stunning but also functional in attracting wildlife to your yard. Eutrochium dubium prefers full sun to part shade and can grow in a range of soil types, as long as it doesn't dry out. Whether you're an avid gardener or simply looking to enhance your outdoor space, the Eutrochium dubium is the perfect choice for a beautiful and sustainable addition to your landscaping.