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 = '340'
group by i.id
Germination: sow seed 1/16" deep, tamp the soil, mulch the seed bed
Looking for a pepper plant that produces a constant supply of sweet and delicious peppers? Look no further than Capsicum annuum 'Sweet Banana'! This plant grows an abundance of long yellow sweet peppers from mid summer until frost, ensuring a steady supply of fresh produce for your kitchen. Although the plant is technically a perennial, it is typically grown as an herbaceous annual and reaches a height of 0.5-1.5 meters with a densely branched stem. The single white flowers give way to green peppers, which ripen to a variety of colors including red, brown, and purple. With its reliable yield and delightful flavor, Capsicum annuum 'Sweet Banana' is a must-have for any home gardener or food enthusiast.