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 = '698804'
group by i.id
Scarification: Soak in hot tap water, let stand in water for 24 hours, repeat process on seed that did not imbibe
Stratification: none required
Germination: sow seed 1/8" deep, tamp the soil, mulch the seed bed
Dodonaea viscosa, also known as Florida Hopbush, Hopsbush, or Native Hops, is a versatile flowering plant that grows as a shrub or a small tree to a maximum height of 9m. It can be found in tropical, subtropical, and warm temperate regions in Africa, the Americas, Asia, and Australasia. The plant bears yellow to orange-red flowers without petals, which is believed to increase wind exposure for pollination. The fruit is a capsule with two to four wings. The plant's wood is strong and durable, traditionally used for weapons, walking sticks, axe-handles, and weights. The plant's leaves have many medicinal properties, including febrifuge, diaphoretic, and vulnerary. It is often used to treat toothache, sore throats, skin rashes, and stings. The Dodonaea viscosa plant is easy to grow from seeds and can be tolerant of pruning, making it an excellent hedging plant. It is drought resistant, resilient to salinity and pollution, and can be used for dune stabilization and reforestation. With its dense foliage, it is a popular choice for windbreaks. The plant has many common names, including 'a'ali'i' and ‘a‘ali‘i-ku ma kua and ‘a‘ali‘i ku makani in Hawaiian and broad leaf hopbush, candlewood, native hop, and wedge leaf hopbush in Australia.