Sheffield's Seed Company Page

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 = '700338' group by i.id

Buying options