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 = '698392'
group by i.id
Scarification: Soak in 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
Looking for a small shrub species native to Canada and the northern parts of the US? Look no further than Viburnum edule, commonly known as the squashberry, mooseberry, pembina, highbush cranberry, lowbush cranberry, or moosomin in Cree language. With smooth gray bark, sharply toothed leaves, and few-flowered terminal cymes of milky-white flowers, this deciduous shrub can reach heights ranging from 2 to 12 feet. Its orange to red drupe fruit contains one seed and often overwinters on twigs. Highbush cranberry may occur as a dominant or codominant understory species in open or closed coniferous forests or in deciduous forests with quaking aspen, paper birch, or balsam poplar. It is also an important component of forest-edge and hedgerow habitats, providing cover for small mammals and birds. Highbush cranberries are a major food source for wildlife, including grizzly and black bears, elk, deer, rabbits, and songbirds. If you're interested in more information about Viburnum edule and its ecosystem types, cover, fire regimens, and wildlife uses, check out the USDA Plants database and FEIS website.