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 = '700296'
group by i.id
Germination: requires light for germination, surface sow and keep moist
Other: Sterile soil should be used, care should be taken to not sow the seed too thick
Experience the grandeur of the Rhododendron calophytum, commonly referred to as Beautiful-face Rhododendron. This striking flowering plant, belonging to the Ericaceae family, originates from the high-altitude forests of central and eastern China. It is an evergreen shrub that makes a substantial impact with its impressive 40ft height and 26ft breadth. The Rhododendron calophytum has an impressive display of leathery, narrow leaves that can reach up to 12 in long. Announce spring's arrival with clusters of bell-shaped flowers, rendered in delicate hues of white or pale pink, spotted with maroon inside. This exquisite shrub has been recognized for its outstanding horticultural characteristics by the UK's Royal Horticultural Society, earning the prestigious Award of Garden Merit. Ideally suited to thrive in acidic soils, the Beautiful-face Rhododendron is hardy in temperatures down to 5°F. Displaying a unique blend of innate ruggedness and elegant beauty, this plant is set to be the crown jewel of any garden.