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 = '492'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: warm stratify for 120 days, cold stratify for 90 days
Germination: sow seed 3/8" deep, tamp the soil, mulch the seed bed
Introducing the Cornus controversa Giant Dogwood, a stunning addition to any garden or park. This deciduous tree is native to China, the Himalayas, and Japan and grows up to 50 ft (15 m) tall with multiple tiered branches that create a tiered effect. In summer, flat panicles of white flowers appear on every branch, followed by blue-black berries. In autumn, the leaves turn a rich red-purple color. This tree is resistant to anthracnose and is cultivated in gardens and parks in temperate regions. The leaves are used in folk remedies to relieve pain and reduce swelling, and the fruit provides oil used in the lubricating and soap industry. With its pagodalike shape and layered branching pattern, the Cornus controversa Giant Dogwood is a gorgeous and unique addition to any landscape.