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 = '493'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: warm stratify for 60 days, cold stratify for 30 days
Germination: sow seed 3/8" deep, tamp the soil, mulch the seed bed
Cornus drummondii, also known as Roughleaf Dogwood, is a beautiful and versatile small deciduous tree that is native to the Great Plains and Midwestern regions of the United States. With its lovely off-white four-petaled flowers that bloom during the summer months, it produces small white fruits that ripen from August to October and are a favorite of at least forty species of birds. This hardy tree can grow up to 25 feet in height and is often used as a buffer strip around parking lots, in the median of highways, and near the decks and patios of homes. Its dense thicket can be used as a hedge, border or cover for wildlife. Cornus drummondii is a perfect choice for those looking for a beautiful, low-maintenance tree that is both ornamental and functional.