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 = '1514'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: none required
Germination: sow seed 1/4" deep, tamp the soil, mulch the seed bed
Looking for a charming and manageable-sized flowering vine for your garden? Look no further than Wisteria frutescens, commonly known as American Wisteria. This woody, deciduous, perennial climbing vine produces dense clusters of blue-purple flowers on racemes 5-15cm long in late spring to early summer. Unlike its Asian counterparts, it grows only two-thirds as tall, and its racemes are half as long, making it a perfect choice for smaller gardens. Plus, it is much less invasive than its Asian counterparts, making it a safer option. So if you want to add a touch of charm to your garden, go for Wisteria frutescens!