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 = '2412'
group by i.id
Germination: sow seed 1/16" deep, tamp the soil, keep moist
Looking for a stunning addition to your garden? Consider Hesperis matronalis, also known as dame's rocket. This biennial plant grows up to 100 cm tall with multiple stems and lanceolate-shaped leaves. In early to mid-spring, the plant produces large showy terminal racemes with fragrant four-petaled flowers in shades of white to purplish, and even mixed colors. Native to Europe and naturalized in the eastern U.S., this plant self-seeds quickly and spreads easily. While it makes an attractive garden plant, it has been found to be ecologically invasive in North America. The seeds can even be sprouted and added to salads for a tasty and nutritious treat. Don't miss out on the beauty of Hesperis matronalis!