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 = '700323'
group by i.id
Germination: Broadcast, drill or hydroseed. Surface sow and keep moist, mulch the seed bed
In a Nutshell:
* Lolium perenne, common name perennial rye-grass or English ryegrass or winter ryegrass, is a grass from the family Poaceae. It is native to Europe, Asia and northern Africa, but is widely cultivated and naturalised around the world.
* The plant is a low-growing, tufted, hairless grass, with a bunching (or tillering) growth habit. The leaves are dark green, smooth and glossy on the lower surface, with untoothed parallel sides and prominent parallel veins on the upper surface. more...