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 = '698981'
group by i.id
Germination: surface sow on peat or sphagnum moss and keep moist by misting.|requires light for germination, surface sow and keep moist
Other: spring sowing is prefered|Sterile soil should be used, care should be taken to not sow the seed too thick
If you're looking to add a showy, fragrant shrub to your garden, look no further than the Rhododendron canescens, also known as the Hoary Azalea, Honeysuckle Azalea, or Wild Azalea. This native species is a true stunner, growing up to 8 feet tall with thick, dark green leaves and clusters of pink (or rarely white) trumpet-shaped flowers that exude a sweet fragrance. What's more, it tends to form large colonies, making for an even more impressive display. Don't miss out on this Southern beauty - order your Rhododendron canescens today!