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 = '1308'
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.
Looking for a beautiful and beneficial shrub for your garden? Look no further than Rosa carolina, also known as the Carolina Rose or Pasture Rose. This deciduous shrub is native to eastern North America and can be found in a wide variety of open habitats, from woods to roadsides. The fragrant light pink flowers emerge in early summer, and are followed by pear-shaped hips that are a good source of essential fatty acids and other bio-active compounds. The fruit skins have been eaten to treat stomach complaints, and the plant is being investigated as a potential cancer-fighting food. Hardy to zone 4, Carolina Rose is a low-maintenance and shade-tolerant choice for any garden.