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 = '1275'
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
The Carolina Azalea, also known as the Carolina Rhododendron or Rhododendron carolinianum, is a small and delicate plant that forms a rounded mound. Its evergreen foliage is adorned with beautiful 3" flowers in May, available in variations of pink and purple depending on the strain. To keep it healthy, ensure that it grows in acid soil with good drainage. In the United States, this plant needs light shade in the North and more shade in the South. This eye-catching Azalea can be viewed in detail at plants.usda.gov. Invest in a Carolina Rhododendron today to bring a touch of glamour to your garden.