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 = '2129'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: cold stratify for 180 days
Germination: sow seed 1/4" deep, tamp the soil, mulch the seed bed
Other: fall sowing in mulched beds is prefered to artificial stratification
Discover the hardy and versatile Vitis amurensis Amur Grape, native to the Far East. With the ability to survive temperatures as low as -40°C, this grape plant is perfect for vertical gardening or as an ornamental plant. Its leaves are not only decorative, but also add a delightful flavor when wrapped around other foods and baked. The fruit, when ripe, is sweet and can be eaten raw. The Amur grape is often crossed with other species to produce early ripening wine and dessert grapes for cold climates. Though originally found in pre-glacial subtropical vegetation, it is now most commonly found in the forests of Manchuria, Amur Oblast, Primorsky Krai, North East China, Japan, and Korea. It prefers about 700 mm of rain per year and acidic soil, making it well-suited to Northern Russia, North West Europe, and the Pacific Northwest. Add this versatile plant to your garden and enjoy the fruits of its labor.