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 = '332'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: cold stratify for 60 days
Germination: sow seed 1/16" deep, tamp the soil, mulch the seed bed
Campsis radicans, also known as Trumpet Creeper or Trumpet Vine, is a woody vine native to woodlands of the southeastern United States and is popular as a garden perennial across the country. It is hardy to about -20°C and stands out for its beautiful and showy trumpet-shaped flowers of orange or reddish-orange color attracting hummingbirds and other pollinators. However, it is a fast-growing and aggressive spreader and can grow up to 5 to 10 meters tall if not maintained properly. Its thick woody vines and root rhizome growth have high erosion preventive properties and can grow in almost all types of soil. Regular severe pruning is essential to control its rampant growth. While its blossoms are a treat to watch, it may cause skin irritation to humans and cattle due to its "cow itch" nickname. Despite being susceptible to various insects, the plant's ability to spread rapidly helps counteract these risks. Overall, Campsis radicans is an excellent garden plant to beautify trellises, fences, walls, and other landscapes if handled with care.