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 = '1322'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: cold stratify for 90 -120 days
Germination: sow seed 3/8" deep, tamp the soil, mulch the seed bed
Other: can be fall sown without stratification.
Looking for a beautiful and functional addition to your garden? Consider the Rosa rugosa, also known as rugosa rose, hedgehog rose, or saltspray rose. This species of rose is native to eastern Asia and highly rated by gardening organizations. It produces beautiful pink blooms in the spring and sporadically throughout the summer and fall, followed by large, edible hips that are rich in vitamins and antioxidants, which can be used to make flavorful jellies. In addition, the leaves and roots of the Rosa rugosa can be used medicinally to treat fevers, coughs, and menstrual complaints. Best suited to temperate coastal maritime conditions, the Rosa rugosa is highly adaptable, easy to grow, and requires little attention or maintenance to thrive. Order seeds today and enjoy the beauty and health benefits of this remarkable species!