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 = '511'
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
The common dogwood, Cornus sanguinea, is a versatile and attractive ornamental plant native to Europe and western Asia. It grows as a medium to large deciduous shrub, reaching heights of 2-6 meters. The stems of the plant can range in color from greenish to red or purplish, and in the fall, the foliage may turn a striking blood red. The plant is highly adaptable and can thrive in both sun and shade.
In addition to its aesthetic appeal, Cornus sanguinea has several practical uses. The seed of the plant contains a non-drying oil that is used in soap making and lighting. The pericarp, or outer covering of the fruit, also yields a non-drying oil that is used for lighting. The wood of the plant is strong and tough, making it suitable for small items such as tool handles and turnery. It also produces good quality charcoal and serves as an excellent fuel.
The plant's ecological significance is also notable. Many frugivorous birds find the berries of Cornus sanguinea irresistible and prefer them over cultivated fruits. By planting this species in organic gardens and permaculture systems, one can prevent damage to orchard crops while benefitting from the fact that these birds also hunt pest insects during the breeding season. Moreover, the plant spreads through seeds and stolons, making it effective at occupying areas of land and forming dense groves. However, its invasive potential should be taken into consideration depending on the circumstances.
Overall, Cornus sanguinea is a versatile and attractive plant with numerous benefits and uses. Whether for its ornamental value, practical applications, or ecological contributions, this common dogwood is an excellent addition to any garden or landscape.