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 = '6437'
group by i.id
Germination: requires light for germination, surface sow and keep moist
Rhododendron X bakeri Baker's Azalea, also known as Cumberland Azalea, is a compact and low-growing plant with horizontal branches. It produces striking orange to red flowers in a ball truss during the summer months but is not fragrant. The plant requires partial shade to high shade and rich, moist soil. It is hardy in zones 5b to 8b, but needs protection from the hot summer sun. Native to the eastern regions of the US, it may spread by stolons. The plant makes an excellent landscape plant in its own right and easily hybridizes with other species, producing beautiful hybrids in a broad range of colors. It has a relatively isolated natural range on the Cumberland Plateau in Kentucky south to Tennessee and the mountains of Georgia, Alabama, and North Carolina. Cumberland Azalea is most closely related to R. calendulaceum and can be distinguished from the latter by its flowering well after the leaves have expanded, eglandular pedicel and sepal margins, and usually abaxially conspicuously glaucous leaves.