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 = '1429'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: cold stratify for 60-90 days
Germination: sow seed 1/4" deep, tamp the soil, mulch the seed bed
Looking for a gorgeous tree to enhance your garden? Consider Syringa reticulata, aka Japanese Tree Lilac. This species of Lilac is native to eastern Asia, and is the largest of the family, growing up to 49' tall. It's a deciduous tree with elliptic-acute leaves and produces creamy-white fragrant flowers in broad panicles in early summer. The fruit is a dry, smooth brown capsule that splits in two to release the seeds. It's a popular ornamental tree in Europe and America, as it's easy to grow and tolerates urban conditions well. It's best suited to cool summer climates and is effective as a specimen in the landscape or as a screen along property lines. Prune as needed immediately after flowering. Some diseases may affect the tree, but it has good resistance to many pests common among the Lilac family. So why not add Syringa reticulata to your garden?