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 = '768'
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: seedlings need shade for their first year
Juniperus communis, or Common Juniper, is a small coniferous evergreen tree or shrub with needle-like leaves in whorls of three, ranging from 10m tall to a low, prostrate spreading shrub in exposed locations. It is dioecious, with male and female cones on separate plants, which are wind pollinated. The fruit are berry-like cones, usually spherical, and initially green, ripening in 18 months to purple-black with a blue waxy coating. The seeds are dispersed when birds eat the cones, digesting the fleshy scales and passing the hard, unwinged seeds in their droppings. The plant is cultivated in the horticulture trade and used as an ornamental shrub in gardens. The astringent blue-black seed cones, commonly known as "juniper berries", are seldom eaten raw and are sold dried and used to flavour meats, sauces, stuffings, and even certain beers and gin. The leaves and stems can be boiled to create tea that is often described as having a spicy gin-like flavour. Common Juniper is widely distributed throughout the cool temperate Northern Hemisphere and is valued for a range of traditional medicines, culinary uses, and decorative craft items.