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 = '1312'
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 3/8" deep, tamp the soil, mulch the seed bed
Other: summer sowing in mulched beds results in germination the following spring.
Add a touch of sweet fragrance and bright color to your garden with Rosa eglanteria, also known as Sweetbrier Rose or Eglantine Rose. This stunning rose species is native to Europe and western Asia, where it grows in hedgerows and along forest edges. Its 1" fragrant single pink roses bloom in small clusters, creating a beautiful display and attracting pollinators. After the blooms fade, the plant produces 1/2" orange to scarlet hips, which last well into winter, adding a pop of color to the winter landscape. The plant typically grows on lime with erect, arching branches, reaching a maximum height of 10 feet in 20 years. This perennial subshrub is moderate in growth rate and is routinely available for nursery stock production. It's suited to medium-textured soils and has medium drought tolerance. Sweetbrier Rose is a perfect addition to any garden or landscape design, and its delicate beauty is sure to impress.