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 = '700279'
group by i.id
Germination: requires light for germination, surface sow and keep moist
Kunzea ericoides, also known as Kānuka, White tea-tree, or Burgan, is an impressive tree or shrub endemic to Australia and New Zealand, typically found in coastal scrub and colonizing land recovering after a fire or reverting to a natural state after being used for agriculture. This stunning plant's small flowers can turn an entire hillside white, creating a breathtaking snow-like appearance. The tree's leaves and young shoots have numerous health benefits, which can be utilized to make a refreshing tea. Kunzea ericoides is hardy and easy to grow, so why not consider adding this stunning and beneficial plant to your outdoor space today? You won't be disappointed!