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 = '1304'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: cold stratify for 180 days
Germination: sow seed 3/8" deep, tamp the soil, mulch the seed bed
Highly valued for its beautiful flowers, Rosa blanda, also known as the smooth rose, meadow/wild rose, or prairie rose, is a species of rose native to North America. It is closest to a “thornless” rose, with only a few thorns at the base. Its variable characteristics make it often confused with other prairie rose species, but its stunning white to pink streaked with red flowers are a defining feature. This deciduous shrub is a hardy perennial that can bear fruit, a good source of essential fatty acids and vitamin E. Its sturdy nature allows it to grow in dry, nutrient poor habitats, making it an ideal addition to any garden or landscape. Rosa blanda is a true North American beauty, offering beauty and function, both in nature and in the kitchen.