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 = '766'
group by i.id
Scarification: Soak in hot tap water, let stand in water for 6 hours
Stratification: warm stratify for 90 days, cold stratify for 90 days
Germination: sow seed 1/4" deep, tamp the soil, mulch the seed bed
Other: Or, sow outside in spring for germination the following spring.
If you're looking for a unique and hardy addition to your garden, the Juniperus californica, or California juniper, is a versatile and attractive shrub or small tree that thrives in a variety of habitats. Found primarily in California and extending into southern Nevada and Arizona, it grows at moderate altitudes of 750-1,600 meters. The bark is ashy gray and appears "shredded," while the foliage is bluish-gray and scale-like. The cones are berry-like and contain a single seed. This plant provides food and shelter for native wildlife and was used as a traditional Native American medicinal plant and a food source. Cultivated as an ornamental plant that tolerates alkali soils and provides erosion control, the California juniper is a popular species for bonsai as well.