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 = '457'
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, mulch the seed bed
Other: germination may be delayed for up to 90 days
Introducing the Clematis integrifolia Solitary Clematis, a native flowering vine that is highly prized by gardeners for its showy flowers. This fairly short variety grows only to 3 feet high and produces nodding, urn-shaped blue flowers that are 1.5 inches wide. The plant is native to Europe and Asia, and thrives in American Horticultural Society zones 8 to 1 in the USA. Solitary clematis is a woody-based, erect-stemmed, non-climbing clematis that typically grows in a dense, somewhat sprawling, shrubby mound to 12-18” tall. Its green leaves and bell-shaped flowers give way to attractive, plumose, silvery green seed heads. This herbaceous perennial sends up new stems each spring and blooms from May to July, with continued sporadic bloom sometimes occurring throughout the rest of the summer. It is perfect for summer gardens, and produces magnificent solitary blooms that will add a vibrant splash of color to any landscape. Consider the Clematis integrifolia Solitary Clematis for its stunning beauty and easy-to-care-for qualities.