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 = '3207'
group by i.id
Australia, Austria, Belgium, Bulgaria, Canada, Cyprus, Czech Republic, Denmark, Estonia, Finland, France, Germany, Greece, Hungary, Ireland, Italy, Latvia, Liechtenstein, Lithuania, Luxembourg, Malta, Netherlands, Poland, Portugal, Romania, Slovak Republic, Slovenia, South Africa, Spain, Sweden, Switzerland, United Kingdom
Scarification: Soak in water, let stand in water for 24 hours
Stratification: cold stratify for 120 days
Germination: sow seed 3/8" deep, tamp the soil, mulch the seed bed
Looking for a versatile, native species that can be used for a variety of purposes? Look no further than Prunus emarginata, also known as Bitter cherry or Oregon cherry. This species of Prunus is native to Western North America and can be found from British Columbia all the way down to California and Arizona. It thrives in recently disturbed areas, open woods, and nutrient-rich soil. Did you know that the leaves can be used to make a green dye? Or that the fruit can be made into a dark grey to green dye? The bark is incredibly strong and flexible, making it perfect for basket weaving, while the wood is close-grained and often used for furniture. Plus, it's an excellent fuel. Medicinally, Native tribes have used the bark for poultices and infusions. Although the cherries may not be palatable to humans, they provide important forage for animals, especially birds. So whether you're a basket weaver, woodworker, or just looking for a reliable native shrub, Prunus emarginata is definitely worth considering.