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 = '1498'
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 1/4" deep, tamp the soil, mulch the seed bed
Looking for a tough, easy-to-grow shrub with showy flowers and fruit? Look no further than Viburnum sargentii Sargent Cranberry. Native to northeastern Asia, this deciduous shrub boasts white flowers with purple anthers, clustered in flat-topped cymes up to 4" across, and scarlet fruit that lasts into winter. The new leaves start out bronzy, turn green in summer, and become yellowish or reddish in the fall. With a multistemmed, upright rounded habit, this shrub grows to 12-15' tall and wide, making it perfect for use as a border, screen, mass planting, or in small groupings. While it prefers full sun to partial shade, it's soil adaptable and can grow on a variety of fertile, moist soils. Viburnum sargentii Sargent Cranberry is also known for its relatively large, red, fleshy fruits, which are surrounded by a ring of sterile flowers. However, landscaping this shrub also comes with its liabilities. Aphids can be particularly problematic to it, borer occasionally attacks it, and it needs occasional rejuvenation pruning. Otherwise, this shrub is very tough and easy to grow, making it a great choice for difficult growing sites. Propagation can be done either by cuttings or by seed.