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 = '1503'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: warm stratify for 90 days +, cold stratify for 60 days +
Germination: sow seed 3/8" deep, tamp the soil, mulch the seed bed
Introducing Viburnum trilobum, commonly known as American Highbush Cranberry, a native shrub that is sure to impress with its stunning white flowers in flat-topped clusters to 4.5". This very handsome shrub, according to the famous horticulturist Michael Dirr, produces 1/3" round, bright red fruit that is perfect for making preserves and jellies. In addition to its edible fruit, the Viburnum trilobum is great for hedges and screens. With new leaves that start off reddish and turn shiny green when mature, this shrub puts on an autumnal show of yellow, red, and purple foliage. Native to New Brunswick to British Columbia, south to New York and Oregon, Viburnum trilobum needs adequate water and begins to produce fruit at approximately five years of age. Interestingly, birds and other animals play a role in spreading its seeds in their droppings leading to other locations. So why not add the beauty and functionality of the American Highbush Cranberry to your landscape today?