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 = '383'
group by i.id
Scarification: Soak in hot tap water, let stand in water for 24 hours
Stratification: cold stratify for 60 days
Germination: sow seed 1/4" deep, tamp the soil, mulch the seed bed
Looking for a hardy, compact, and dense shrub for your garden? Look no further than Ceanothus americanus, commonly known as New Jersey Tea. Growing to 2-3 feet tall, this shrub boasts fragrant white flowers in late spring that attract butterflies. Its leaves have a fresh wintergreen scent and can be dried for a caffeine-free tea substitute. Best grown in well-drained, sandy or rocky soil and tolerant of drought, this adaptable shrub makes an excellent border plant or ground cover for hard-to-grow areas. Plus, its deep, woody roots make it well-suited to withstand wildfires and even sprout anew after being top-killed. Discover the beauty and resilience of New Jersey Tea for yourself!