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 = '565'
group by i.id
Austria, Belgium, Bulgaria, Denmark, Estonia, Finland, France, Germany, Greece, Hungary, Ireland, Italy, Latvia, Liechtenstein, Lithuania, Luxembourg, Malta, Netherlands, Poland, Portugal, Romania, Slovenia, Spain, Sweden
Scarification: Soak in water, let stand in water for 24 hours
Stratification: cold stratify for 120 days
Other: fall sowing in mulched beds is prefered to artificial stratification
Crataegus phaenopyrum, commonly known as Washington Hawthorn or Washington Thorn, is a stunning ornamental plant that can grow up to 10 meters in height. The small red berry-like fruits that grow closely together in large clusters are a favorite of squirrels and birds, and have a mild flavor that can be eaten raw or cooked. The wood of the tree is hard and can be used to make tools. With a rounded, dense thorny crown and shiny dark green leaves that turn orange-red and purple in the fall, this tree is a sight to behold. It produces beautiful white flowers with pink anthers, making it one of the last hawthorns to bloom. The shiny bright red 1/4 inch fruit is perfect for screening or to use as a specimen. Native to the southeastern U.S., it can tolerate atmospheric pollution. This tree is generally available in many areas within its hardiness range and has a medium growth rate, making it an excellent option for residential street trees and median strip plantings in the highway. Due to its attractive fruit, stunning fall colors, and unusual winter form, the Washington Hawthorn can provide a beautiful addition to any landscape.