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 = '699187'
group by i.id
Germination: surface sow and keep moist, tamp the soil, requires light for germination
Other: Seed needs warm temperatures after sowing to germinate (75 degrees F +)
Discover the beauty and benefits of the Leptospermum scoparium, also known as Broom Teatree, Manuka, or Tea Tree. This evergreen shrub is native to New Zealand and southeast Australia and is most commonly found on the drier east coasts of the North Island and South Island of New Zealand, as well as in Tasmania, Victoria, and New South Wales in Australia. The fresh, pungent leaves of the Manuka plant make a fragrant and refreshing tea substitute. In fact, taste trials have shown that the tea made from this species receives higher marks than traditional China tea. The plant prefers well-drained, acid or neutral soil and can grow up to 5 meters in height. While it can tolerate strong winds, it cannot survive maritime exposure. Enjoy the Manuka's beautiful blooms from May to June, as it attracts various insects for pollination. Learn more about the Leptospermum scoparium at plants.usda.gov.