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 = '697716'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: none required
Germination: sow seed 1/4" deep, tamp the soil, mulch the seed bed
Looking for a beautiful and rugged shrub to add to your garden? Look no further than Ceanothus cordulatus, also known as Snow Bush or Whitethorn Ceanothus. This shrub is native to California and adjacent regions of Oregon, Nevada, and Baja California, where it grows on mountain ridges and in forested areas. The plant grows wider than it does tall, up to 1.5 meters, with gray stems and yellow-green twigs that are fuzzy when new. The evergreen leaves are oval and up to 3 centimeters long, with three ribs and generally not toothed. The inflorescence is panicle-shaped and up to 4 centimeters long, producing white to off-white flowers with five sepals and five petals. The fruit is a rough, ridged capsule containing three seeds. Whitethorn Ceanothus is highly dependent on fire and regenerates by stump-sprouting or seed depending on the severity of the burn. It is a beautiful and durable addition to any garden and thrives in a variety of ecosystems, from montane chaparral to alpine environments.