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 = '176'
group by i.id
Germination: sow indoors 2 months before the date of the last frost, can be sown outdoors in the fall for spring germination
Looking for a delicious and easy-to-grow vegetable for your garden? Look no further than the Allium cepa 'Red Creole' Red Creole Edible Onion! This evergreen bulb can grow up to 0.6m and is hardy to zone 5, making it a great option for even colder climates. The flowers bloom from Jun to July and are pollinated by bees and insects, producing a harvest of delicious, flavorful onions. The 'Red Creole' variety is known for its deep red color and robust flavor, making it a favorite of chefs and home gardeners alike. This plant prefers well-drained, moist soil and can grow in both acid and alkaline soils. Don't miss out on the opportunity to add this delicious and versatile vegetable to your garden today!