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 = '1276'
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
Looking for a small but stunning addition to your garden? Rhododendron carolinianum 'White,' also known as Carolina Azalea or Carolina Rhododendron, is the plant for you. This delicate, evergreen plant forms a rounded mound, often loose and open in shape. In May, it produces beautiful 3-inch flowers in variations of pink and purple, inherited from its parent strains. To grow this plant successfully, it requires acidic soil with good drainage and light shade in the North and more shade in the South. If you're looking for more information on this stunning plant, check out http://plants.usda.gov. Add Rhododendron carolinianum 'White' to your garden today and enjoy its delicate beauty for years to come.