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 = '700441'
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
Introducing the Rhododendron aureum, also known as Golden Rhododendron! This evergreen shrub is native to high mountain areas of East Asia, including China, Japan, and Korea. It thrives in alpine and sub-alpine thickets, as well as grasslands or liverwort-mosses strata at elevations of 1000-2500 metres. Growing up to 0.5m in height and 1m in width, it is hardy to zone 2 in the UK and blooms in May with bright yellow, campanulate flowers. This plant prefers well-drained, moist, and acidic soil and can grow in semi-shade or no shade. Its flowers are used in Tibetan medicine as an antirheumatic, diaphoretic, and haemostatic agent, although caution is advised due to their toxicity. The Golden Rhododendron is an excellent addition to any woodland garden or shady edge, and its surface-rooting habit allows it to coexist with other trees. Grow your own Rhododendron aureum from seed in a greenhouse, and enjoy this showy shrub for years to come!