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 = '699738'
group by i.id
Introducing the Golden Summer Crookneck Squash, a winter squash with a unique curved neck and distinctive longitudinal ridges. This bush type plant produces an abundance of delicious buttery-yellow squash that are easy to grow and harvest when they reach 8 inches long. Golden Summer Crookneck is one of the earliest producing crookneck squashes on the market, ensuring that you will have a bountiful harvest all summer long! As it matures, the squash turns deeper yellow and develops a sweet, yellow-orange flesh that is tender and full of flavor.