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 = '700104'
group by i.id
Germination: Sow on milled peat moss, do not cover, place under mist or in high humidity environment. Germination takes place in 3 to 5 weeks.|Keep moist by misting.
Discover the beauty of Eucalyptus goniocalyx, also known as Bundy, Long-leaved Box, or Mountain Graygum. This native Australian tree boasts rough and persistent bark with fibrous, greyish texture, becoming deeply fissured and shaggy in larger trees. Its adult leaves are stalked, lanceolate, and a vibrant green, while white flowers grace its branches in early autumn to mid-winter. Widely distributed on the tablelands of New South Wales and in Victoria, this tree is a must-see in Australia's diverse flora. Learn more about this unique species and its versatile use in producing cineole-based eucalyptus oil.