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 = '1284'
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 unique and rare addition to your garden? Introducing the Rhododendron prunifolium, also known as the Plumleaf Azalea. This wild azalea is native to Georgia and Alabama, growing naturally along streams. With its stunning apricot or orange-red flowers that bloom in July and August, this deciduous species is a truly gorgeous sight to behold. Its leaves can reach up to five inches in length, and the long stamens add to its overall beauty.
Rhododendron prunifolium is one of the rarest azaleas found in the Eastern United States, and it grows only in a select few counties along the Georgia-Alabama border in the Chattahoochee River Valley. To see this beauty in the wild, visit Providence Canyon, which is one of the most popular places to view the Plumleaf Azalea.
This breathtaking shrub is sure to be a standout in your garden with its unique and uncommon beauty. If you're looking to diversify your garden with a plant you won't find everywhere, the Rhododendron prunifolium is just what you need.