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 = '700307'
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 exquisite beauty of Rhododendron floribundum, an evergreen shrub native to the mesmerizing landscapes of Guizhou, Sichuan, and Yunnan in China. Embodying the natural aesthetic of its wild woodland habitats, it flourishes at impressive altitudes spanning 4,500-9,000 ft. As an erect shrub or small tree, its awe-inspiring stature measures as tall as 6-35 ft. Adorned with elliptic-lanceolate or oblanceolate leaves, the floribundum species carries a certain majestic form characterized by leathery textures and sizes spanning 8–13 × 1.8–3.8 cm. Its allure reaches a peak with the spring bloom of magenta-rose flowers peppered with crimson flecks and a stunning blotch at the base. It requires a high organic, well-drained, acidic soil in full sun to partial shade, and to maintain its lush vitality, mulching for moisture conservation is recommended. Despite being vulnerable to pests like weevils, white fly, scale insects, caterpillars, aphids and fungus, it remains one of the most sought-after species. You can behold one of its most notable specimens within the National Trust Trelissick Garden in the UK. Embrace this unique gem in your large garden, park, or even in a container, and enhance the allure of your green space with the superlative beauty of Rhododendron floribundum.