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 = '3733'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: cold stratify for 90 days
Germination: sow seed 1/16" deep, tamp the soil, lightly mulch the seed bed.
Other: germination may be delayed for up to 90 days
Clematis Recta var. Purpurea, also known as the Erect Clematis, Ground Clematis, and Ground Virginsbower, is a hardy, free-standing shrub that is a native of Eastern, Southern, and Central Europe. Though it can be trained to climb, this ground clematis is typically left alone to crawl along the ground, producing an abundance of small, fragrant, white fringed flowers in late spring to early summer. Caution must be taken, as the flowers and leaves have diaphoretic, diuretic, and rubefacient properties and are poisonous. However, a homeopathic remedy made from the plant is used to treat rheumatism and skin eruptions. The foliage of this cultivar is an attractive deep purple shade, making it an interesting addition to any garden. This plant prefers well-drained soil and full sun, and is hardy to zone 3. Edible uses include young shoot tips, but some caution must be taken due to its toxicity. Overall, Clematis Recta var. Purpurea is an easy to care for plant that adds both beauty and medicinal properties to any garden.