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 = '4930'
group by i.id
Germination: sow seed 1/4" deep, tamp the soil, mulch the seed bed
Discover the beauty of Limonium sinuatum, also known as wavyleaf sea lavender or statice. Originally from the Mediterranean region, this short-lived perennial (often treated as an annual) produces clusters of beautiful funnel-shaped flowers in summer. The blooms come in a variety of colors, including white, pink, purple, and yellow. Not only is this plant excellent as a fresh cut flower, but the papery flowers can also be used in dried arrangements. While it is a landscaping escapee in California, it is commonly found in Southern Spain, North Africa, Canary Islands, and Israel where it grows in sandy areas. Add a touch of Mediterranean flair to your garden with Limonium sinuatum.