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 = '697762'
group by i.id
Scarification: Soak in hot tap water, let stand in water for 24 hours
Stratification: cold stratify for 30 days
Germination: sow seed 1/4" deep, tamp the soil, mulch the seed bed
Looking for an interesting and unique addition to your garden? Consider Dalbergia hupeana, also known as Hardy Rosewood. This tropical-looking tree can actually be grown as far north as zone 7. Its exfoliating bark is reminiscent of Eucalyptus and adds to its exotic appearance. Dalbergia hupeana can reach a height of up to 15m and produces hermaphrodite flowers. It thrives in sunny wild uplands, forests, and woodland slopes at elevations of 800 - 1400 meters. The hard and durable wood of this tree is often used to make oil presses, spokes, and tool handles, and has potential antiphlogistic and poultice properties. While slightly toxic, Dalbergia hupeana is a fascinating and visually stunning choice for any garden.