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 = '697829'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: cold stratify for 60 days
Germination: surface sow and keep warm and moist
Looking for a compact and beautiful lilac shrub that can adorn your garden? Syringa pubescens ssp. microphylla Littleleaf Lilac is the perfect choice for you. Its compact and upright growth habit makes it an ideal choice for hedges and borders. This deciduous shrub produces fragrant lavender-pink flowers that showcase in late spring to early summer.
Syringa pubescens ssp. microphylla Littleleaf Lilac can grow up to 6 feet in height and width. It has small, glossy, dark green leaves that turn yellow in the fall. This lilac variety is also drought tolerant and low maintenance, making it an excellent choice for people who love beautiful plants but don't want to spend hours taking care of them.
This easy-to-grow shrub prefers full sun but can also tolerate partial shade. It requires well-drained soil and moderate watering. Once established, it can withstand long periods of drought, making it an excellent choice for hot and dry regions.
In addition to being an ornamental plant, Syringa pubescens ssp. microphylla Littleleaf Lilac has medicinal properties. Its bark and leaves contain compounds that exhibit antioxidant and anti-inflammatory effects. These compounds are used to treat a variety of health conditions, including fever, diarrhea, and rheumatism.
Overall, Syringa pubescens ssp. microphylla Littleleaf Lilac is an outstanding plant that has something to offer for everyone. Visit http://plants.usda.gov to learn more about this beautiful shrub and how to grow it in your garden.