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 = '5565'
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/4" deep, tamp the soil, mulch the seed bed
If you're looking for a unique and eye-catching ornamental plant, Ampelopsis arborea - also known as peppervine, might be just what you need. Native to the United States, this deciduous to semi-evergreen vine can be ground cover-like, but is often high-climbing and bushy, growing up to 35 feet or more. Its bi- or tri-pinnately compound foliage is dark-green, turning pale-yellow in fall, and its flat-topped clusters of tiny green flowers are followed by clusters of pea-sized, bluish-purple berries.
This fast-growing and short-lived plant can be slow to germinate, sometimes taking over a year, but it is easy to propagate through seed, cuttings, or layering. While it is particularly aggressive and rampant, the species is seldom cultivated and is considered by many to be a pest.
The Ampelopsis arborea Pepper Vine is a hardy plant that is tolerant of drought and medium fertility, and grows well in coarse, fine, or medium textured soils. It is also fire-resistant and adapted to both wetland and dryland environments. This plant is sure to be a unique and interesting addition to any garden or landscape.