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 = '699350'
group by i.id
Germination: Keep moist by misting.|Sow on milled peat moss, do not cover, place under mist or in high humidity environment. Germination takes place in 3 to 5 weeks.
Introducing the stunning Eucalyptus forrestiana Fuschia Gum - a small tree with smooth bark that grows up to 6 meters tall and has bright red buds and yellow flowers that bloom from January to June. This mallee Eucalyptus forms a dense dark green canopy and has smooth light brown-grey bark that sheds in long strips during late summer. It's a highly decorative plant that's commonly used as a small street tree in semi-arid areas due to its ability to tolerate drought. The adult leaves are disjunct, glossy, green, thick, and concolorous, making it a perfect addition to any garden. Add a touch of vibrant color and elegance to your outdoor space with Eucalyptus forrestiana Fuschia Gum. Get yours now!