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 = '1329'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: warm stratify for 60 days, cold stratify for 60 days
Germination: sow seed 1/16" deep, tamp the soil, mulch the seed bed
The Rosa virginiana, also known as the Virginia Rose, Common Wild Rose or Prairie Rose, is a woody perennial in the rose family that is native to eastern North America. This deciduous shrub forms suckering shrubs up to 5 ft in height, covered in numerous hooked prickles. Its glossy leaves are pinnate with 7-9 leaflets, and it produces 2 1/2" pink flowers bearing single or small clusters from midsummer to fall. The plant grows very quickly, producing bright red hips that last in winter and turning yellow, orange, scarlet, crimson, and brown in the fall. Rosa virginiana is incredibly versatile and can even grow on sandy soils by the ocean, making it a popular addition to gardens. In fact, it has gained the Royal Horticultural Society's Award of Garden Merit. Furthermore, indigenous people use its roots as a medicinal herb for treating sore eyes or to wash cuts on the feet. This highly disease-resistant shrub is perfect for creating hedges, soil stabilization and as ground cover as it forms thickets with its suckers.