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 = '568'
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 sulfuric or nitric acid for 30 minutes and wash under cold water for 5-10 minutes
Stratification: cold stratify for 120 days
Germination: sow seed 1/4" deep, tamp the soil, mulch the seed bed
Crataegus succulenta, also known as Fleshy Hawthorn or Succulent Hawthorn, is a species of hawthorn widely spread across southern Canada and the United States. It is a deciduous shrub that can grow up to six meters tall and is hardy to zone four. The plant's flowers bloom from May to June and are hermaphrodite, pollinated by Midges. The fruit that this plant produces is highly valued for making jellies, and it can also be dried for later use. The fruit itself is small with sweet, juicy, and pulpy flesh. Crataegus succulenta is adaptable to different types of soils as it can grow in sandy, loamy, and heavy clay soils, but requires well-drained soil. It prefers acidic to alkaline soil types, semi-shaded areas, and can tolerate both dry and moist conditions. The plant is also wind-resistant but not tolerant of maritime exposure and atmospheric pollution. This plant is the most wide-ranging hawthorn in North America, and although it has many variant forms, they are considered synonyms.