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 = '1310'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: cold stratify for 120 days
Germination: sow seed 3/8" deep, tamp the soil, mulch the seed bed
Other: can be fall sown without stratification.
Introducing the Rosa davurica Amur Rose, Cinnamon Rose, Daurian Rose: a beautifully vibrant and versatile shrub that is sure to enhance any garden or landscape. With its 2" pinkish-purple flowers, scarlet hips to 1/2", and striking red branches, this shrub is a true visual delight.
Native to northern Asia, the Rosa davurica spreads into dense thickets by suckering from its roots, making it an excellent choice for creating privacy or defining boundaries. It can reach a height of approximately 1.5m, adding depth and dimension to your outdoor space.
In addition to its stunning appearance, this shrub also offers numerous health benefits. The fruit of the Rosa davurica contains about 2.8% dry weight vitamin C, making it a delicious and nutritious addition to your diet. The fruit is approximately 13mm in diameter, with a sweet flavor, although the flesh is fairly dry. Care must be taken when consuming the fruit, as there is a thin layer of flesh surrounding the many seeds. However, the seeds themselves are a good source of vitamin E and can be ground and mixed with flour or added to other foods as a supplement.
Planting and caring for the Rosa davurica is relatively easy. It thrives in sunny places at forest margins and grassy areas on hills and slopes, with an elevation ranging from 400 to 2500m. It can grow in a variety of soil types, including sandy, loamy, and heavy clay soils, as long as the soil is well-drained. It prefers neutral to slightly acidic soils but can tolerate alkaline soils as well. The shrub can tolerate semi-shade or no shade, making it adaptable to different lighting conditions. Regular watering is essential to maintain moist soil for optimal growth.
With its captivating flowers, vibrant hips, and impressive adaptability, the Rosa davurica is a versatile and alluring addition to any garden or landscape. Whether you're looking to create a stunning focal point or add structure and privacy to your outdoor space, this shrub is an excellent choice. Experience the beauty and health benefits of the Rosa davurica Amur Rose, Cinnamon Rose, Daurian Rose for yourself. Order yours today and transform your garden into a haven of color and vitality.