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 = '1428'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: cold stratify for 30-60 days
Germination: sow seed 1/16" deep, tamp the soil, mulch the seed bed
Introducing the Syringa komarowii ssp. reflexa Nodding Lilac! This stunning shrub, native to central China, is a showstopper in any garden. With its erect branches and oval-oblong leaves, it can grow up to 6 meters tall. The fragrant flowers ranging from pink to mauve, sometimes with a white base, are produced in early summer on panicles 4-25 cm long. Attractive to bees, butterflies, and birds, the clusters of flowers often hang limply, boldly nodding, which is how the plant got its common name. This subspecies has longer flowers, making it even more impressive. Though it may lack fragrance, its narrowly conical, sometimes pendulous clusters of purple-pink flowers with white inside as the flowers begin to fade make a beautiful accent to any garden. Elevate your garden game with the Syringa komarowii ssp. reflexa Nodding Lilac!