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 = '2104'
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
Introducing the stunning Pink Azalea, also known as Pinxterbloom Azalea - a deciduous shrub native to the eastern United States. This bushy and dense shrub typically grows 2-6 feet (or up to 10 feet) tall and features beautiful soft pink to white to lavender funnel-shaped flowers blooming in April just before the emergence of foliage. Its leaves are oblong to elliptic and bright green. Pink Azalea is relatively tolerant of dry sites and makes a great addition to wild shrub gardens. This shrub is especially showy in flower and is a popular horticultural plant. Don't miss out on this stunning addition to any garden.