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 = '699335'
group by i.id
Other: Germination time is erratic and can take from 10 days to 3 months.
Discover the beauty of the Eucalyptus botryoides, also known as Bangalay, bastard jarrah, woollybutt or Southern Mahogany. This stunning tree is native to southeastern Australia and can reach up to 40 meters high, featuring rough bark on its trunk and branches. The species reproduces by resprouting from its woody lignotuber or epicormic buds after bushfire. The white flowers appear in summer and autumn. The hard, durable wood is perfect for panelling and flooring. Experience the wonder of this Australian native tree in your outdoor space today.