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 = '700420'
group by i.id
Germination: sow seed 1/16" deep , tamp the soil, keep moist
Looking for an eye-catching and unique addition to your garden? Look no further than Anemanthele lessoniana! This beautiful grass, also known as gossamer grass, New Zealand wind grass, or pheasant's tail grass, is a rare find in the wild but has become a popular ornamental garden plant for its distinctive orange, copper, and gold highlights that shimmer in drier soils. With its evergreen to semi-evergreen leaves that arch up to three feet in USDA zone 8, Anemanthele lessoniana adds a charming touch to any garden. In fact, it's even earned the Royal Horticultural Society's Award of Garden Merit. Don't miss out on this one-of-a-kind grass!