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 = '700282'
group by i.id
Scarification: Soak in cold water, let stand in water for 24 hours
Stratification: none required
Germination: sow seed 1/4" deep, tamp the soil, mulch the seed bed
Hardenbergia violacea, also known as Coral-pea, False Sarsaparilla, Purple Coral Pea, Vine Lilac or Happy Wanderer, is a vigorous evergreen climber that can grow up to 6 meters in height. It has typical pea-like flowers that are usually violet but can also come in white, pink, or other colors. The leaves are dark green, "hard," and leathery, and with prominent venation. This plant is native to Australia and is found in many habitats, making it a hardy garden plant. It has gained the Royal Horticultural Society's Award of Garden Merit in the UK and can be grown in mild and coastal areas where temperatures don't fall below -5°C, either in a south or west-facing location or indoors with full daylight. The boiled leaves can produce a slightly sweet drink, and the flowers can be used to produce a grey-blue dye. Overall, Hardenbergia violacea is an excellent choice for those looking for a beautiful and hardy climber for their garden.