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 = '697761'
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 hot tap water, let stand in water for 2 days.
Stratification: warm stratify for 120 days, cold stratify for 120 days
Germination: sow seed 1/4" deep, tamp the soil, mulch the seed bed
Other: Germination may be irregular and some seed may lie over 2 years before germination.
Crataegus pinnatifida, also known as Chinese hawthorn or mountain hawthorn, is a small to medium-sized tree with bright red fruit that is 1.5 inches in diameter. The fruit can be eaten raw or cooked, has a pleasant flavour, and can be used in making pies, preserves, and dried for later use. Chinese cuisine uses the ripe fruit in desserts like tanghulu and shanzhagao and to make traditional candies like haw flakes and haw rolls. The fruit is also used in traditional Chinese medicine as a digestive aid. Additionally, the wood is useful for making small items like tool handles and mallets. The fruit is known to be antibacterial, anticholesterolemic, cardiotonic, hypotensive and vasodilator, containing flavonoids and organic acids that can help improve blood circulation and lower blood cholesterol levels. Crataegus pinnatifida is hardy, and can grow in a variety of soils, tolerate wind, atmospheric pollution, and drought. Try this delicious and nutritious fruit today! Visit our website for more information.