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 = '1143'
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 180 days
Germination: sow seed 3/8" deep, tamp the soil, mulch the seed bed
Experience the beauty of the European Bird Cherry (Prunus padus) on your property. This majestic tree is native to northern Europe and northern Asia, growing even north of the Arctic Circle in Norway, Sweden, Finland, and Russia. It is a deciduous small tree or large shrub up to 16m tall with flowers in racemes that are hermaphroditic and pollinated by bees and flies. Bird cherries are also known as hackberry, hagberry, or Mayday tree. Please note that it should not be confused with Prunus avium (wild cherry). The fruit of this tree is seldom used in western Europe, but it was used medicinally during the Middle Ages. The variety commutata is sold as an ornamental tree in North America under the common name Mayday. Its hardiness and fragrant white flowers make it a favorite among homeowners and landscapers alike. Experience the elegance of the European Bird Cherry on your property today. Order now!