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 = '509'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: warm stratify for 90 days, cold stratify for 90 days
Germination: sow seed 3/8" deep, tamp the soil, mulch the seed bed
Looking for a beautiful and beneficial plant for your garden? Look no further than Cornus racemosa, also known as Northern Swamp Dogwood or Gray Dogwood. This shrubby plant species can grow up to 10 ft tall and is native to southeastern Canada and northeastern United States. Its older stems have a distinctive gray bark, and it produces clusters of small white berries that are favored by many species of birds. The stems holding the flowers are a striking red color, providing a beautiful contrast to the white berries. This plant is perfect for adding color and interest to your landscape. Plant Cornus racemosa today and enjoy the beauty and benefits it provides.