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 = '697828'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: warm stratify for 60 days, cold stratify for 60 days
Germination: sow seed 1/16" deep, tamp the soil, mulch the seed bed
Other: Simply giving the seed a 90 day cold stratification may break dormancy.
Looking for an attractive shrub or small tree to add to your garden? Consider Syringa reticulata ssp. amurensis, also known as the Amur Lilac or Amur Tree Lilac. This plant hails from northern China and boasts creamy-white flowers in clusters up to 6 inches in size. With a bushy, spreading, and rounded habit, it usually has multiple stems and resembles a smaller and more delicate version of the S. reticulata. Its bark is an appealing feature, with a rich brown color that sometimes peels off in sheets. This plant has an informal and spreading growth habit, making it an excellent choice for borders or hedges. Its foliage is summer green and doesn't change color in the fall. Flowers are fragrant, long-lasting, and cream-colored, making them an excellent addition to any outdoor space. This plant is tolerant of deer, rabbits, and slopes, and can grow up to 15 feet in height and width. It's important to note that it can be affected by pests and diseases. To grow this plant, it needs full sun to some shade and soil that ranges from some sand to some clay, with a pH of 5 to 7.5. It has a bloom time range of early summer to mid-summer and is hardy in USDA zones 4 to 7. If you're looking for a unique plant that's not well-known but worth considering, look no further than the Syringa reticulata ssp. amurensis.