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 = '700301'
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
Discover the beautiful Rhododendron glanduliferum - a unique rhododendron species that originates from the northeastern part of Yunnan, China. Naturally found at impressive altitudes of approximately 7,500–7,900 ft, this evergreen shrub typically matures to a height of 13 ft, boasting robust, leathery leaves that range from oblong-lanceolate to oblanceolate shapes. Their size can reach up to 10–19 × 3.8–4.5 cm. What sets this species apart are the exquisite white flowers they produce, renowned not only for their exceptional size but also their intoxicating heavy scent, adding a stunning visual and olfactory charm to any garden. Introduced to the western world in 1995, the R. glanduliferum exhibits impressive resilience, flowering from July to September. Despite its limited wild distribution and increasing habitat threats, this rhododendron species flourishes into an alluring, six-foot shrub over a decade, proving to be well worth the wait, and a valuable addition to your garden.