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 = '118'
group by i.id
Leucothoe axillaris, also known as Coastal Doghobble or Coast Leucothoe, is a beautiful evergreen shrub native to the southeastern United States. It boasts 2-4 feet height and 6 feet width, making it perfect for naturalizing, borders with other ericaceous plants, facer plants with taller plants, and shady bank stabilization. Its summer foliage is simple, dark green and leathery, and its fall foliage features a reddish, bronze winter color. Additionally, its white flowers bloom in axillary racemes up to 2.5 inches long. This shrub prefers moist soil and partial shade, making it perfect for gardens with cool, acidic soils. It is also an excellent treatment for itching and rheumatism. Order Leucothoe axillaris today and add a unique touch of beauty to your landscape!