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 = '1281'
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
If you're looking for a fragrant, flowering shrub to add to your garden, consider Rhododendron fortunei, or Fortune Rhododendron. This species hails from eastern China and can grow up to 20 ft in height. It has dense, evergreen foliage with oblong, leathery leaves that are 8-14.5 cm long. From April to May, it produces trusses of 6-12 white or pink flowers that are up to 3 inches across and emit a sweet fragrance. Fortune Rhododendron is the parent of many popular hybrids, including 'Loderi', and is hardy to -15°F. It is also a great understock for grafting its own hybrids and those of R. griffithianum. With its attractive foliage and showy blooms, Rhododendron fortunei is a must-have for any garden.