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 = '1495'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: warm stratify for 180 days, cold stratify for 60 days
Germination: sow 1/4 deep, tamp the soil, mulch the seed bed| sow seed 3/8" deep, tamp the soil, mulch the seed bed
Looking for a small tree or multistemmed shrub that thrives in most soils and sun or shade? Check out Viburnum prunifolium, also known as blackhaw, blackhaw viburnum, sweet haw, or stag bush. This deciduous plant is native to southeastern North America, from Connecticut to Texas, and features creamy white flowers in flat-topped clusters and 1/2 inch berries that start pinkish and finish a stunning bluish black. The fruit is used in preserves, and the plant provides great fall color and early winter food for birds. Medicinally, the bark of the blackhaw tree has been used for centuries to treat gynecological conditions, including menstrual cramps and menopause. Black haw also has antispasmodic properties and has been used to treat digestive cramps and bile ducts. Please note, black haw is not currently on the FDA's "generally recognized as safe list," and pregnant women should avoid it until their third trimester.