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 = '558'
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 cold water, let stand in water for 24 hours
Stratification: warm stratify for 120 days, cold stratify for 90 days
Germination: sow seed 1/4" deep, tamp the soil, mulch the seed bed
Other: Spring sowing of unstratified seed will produce germination the next spring
Looking for a unique and hardy addition to your garden? Look no further than Crataegus chlorosarca, an Asian species of hawthorn with beautiful black fruit. While recommended as an ornamental plant and known to thrive in cold climates, it is rarely cultivated, making it a unique and standout addition to any landscape. The wood of the plant is heavy, hard, and close-grained, making it useful for creating tools and other small items. Additionally, the fruit can be used in pies, preserves, and more, with up to five large seeds in the center. While seedling trees take 5 to 8 years to bear fruit, grafted trees often flower in their third year. This plant is easy to grow and tolerates a variety of soil types, making it an adaptable and low-maintenance addition to any garden or landscape.