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 = '5966'
group by i.id
Other: early spring sowing is prefered, use 42-50 lbs/acre
In a Nutshell:
* Flax was extensively cultivated in ancient Ethiopia and ancient Egypt . In a prehistoric cave in the Republic of Georgia dyed flax fibers have been found that date to 34,000 BC . more...
* Linseed has a long history of medicinal use, its main effects being as a laxative and expectorant that soothes irritated tissues, controls coughing and relieves pain. The seed, or the oil from the seed are normally used. more...