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 = '1516'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: none required
Germination: sow seed 3/8" deep, tamp the soil, mulch the seed bed
This beautiful climbing vine is a stunning addition to any garden. Wisteria sinensis var. Alba, or White Chinese Wisteria, produces breathtaking white flowers that bloom in the spring. The plant can be trained into a tree-like shape, making it a versatile addition to your landscape. With shiny green leaves and a distinctive grape-like fragrance, this deciduous perennial vine is hardy in USDA plant hardiness zones 5-9 and is shade-tolerant. Although parts of the plant are toxic, it's not harmful when used as a decorative plant. The vine prefers moist soil and full sun exposure for optimal blooming. Don't miss out on one of the most popular and breathtaking flowering vines available.