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 = '466'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: cold stratify for 4-6 weeks
Germination: sow seed 1/8" deep , keep moist
Clematis texensis, also known as the scarlet leather flower, is a native climbing vine in the buttercup family that is endemic to the Edwards Plateau of Texas. It can grow up to nine feet and produces bell-shaped, scarlet-colored flowers on new growth in the spring and summer that have thick, leather-like petals. This clematis is hardy, drought-tolerant, and ideal for sunny conditions. After the blooms, a feathery ball of plumed seeds is displayed. Crosses with other clematis varieties have yielded a selection of showier varieties, ranging from pink to dark scarlet red. Additionally, the dried stems of this vine can be brewed into a tea that treats headaches and migraines, and it functions as a counter-irritant when applied topically. Order now to enjoy the beauty of this climbing vine in your garden!