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 = '699745'
group by i.id
Germination: sow 1" deep, tamp the soil, mulch the seed bed
Looking for a new, tasty addition to your garden? Look no further than Phaseolus vulgaris 'Borlotti'! Also known as the Roman or cranberry bean, this Italian-bred variety is grown for its delicious thick-skinned seed pods that are packed full of flavor. The green pods make a great vegetable and have a mild taste that pairs well with a variety of dishes. For best results, be sure to harvest the seed pods when they are still small and tender to promote continued production. This annual plant is hardy in zone 10 and prefers a well-drained soil with plenty of sun and moisture. It can even fix nitrogen, making it a great addition to your garden ecosystem. Not only is it a great vegetable, but it also contains protein and can be ground into a flour or fermented into 'tempeh'. Try Phaseolus vulgaris 'Borlotti' today and enjoy the delicious, nutritious benefits it has to offer.