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 = '3313'
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
In a Nutshell:
* Rosa rugosa ( rugosa rose , Japanese rose , or Ramanas rose ) is a species of rose native to eastern Asia , in northeastern China , Japan , Korea and southeastern Siberia , where it grows on the coast , often on sand dunes . more...
* A red-flowered form.
* The leaves are used in the treatment of fevers. The flowers act on the spleen and liver, promoting blood circulation. They are used internally in the treatment of poor appetite and digestion, and menstrual complaints arising from constrained liver energy. The root is used in the treatment of coughs. The fruit of many members of this genus is a very rich source of vitamins and minerals, especially in vitamins A, C and E, flavanoids and other bio-active compounds. It is also a fairly good source of essential fatty acids, which is fairly unusual for a fruit. It is being investigated as a food that is capable of reducing the incidence of cancer and also as a means of halting or reversing the growth of cancers. more...
* Very fragrant 2 1/2-3 1/2" flowers, rose to white in wild populations, brick-red to red 1" rose hips, often at the same time as the flowers, extremely thorny, wrinkled (rugose) leaves, attractive dark green, lovely orange in fall, withstands salt spray, so is good for shore plantings, native to northeast Asia, naturalized in Europe and the U.S., especially in coastal areas. more...