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 = '472'
group by i.id
Discover the beauty of the Clethra acuminata, also known as the Cinnamon Clethra, Mountain Pepperbush, or Mountain Sweetpepperbush. This large shrub boasts attractive red-brown bark and white flowers in midsummer, followed by yellow-orange fall color. Native to the southeast U.S., it can reach a height of up to 6 meters and is commonly found in deciduous forests at elevations of 500-1400 meters. The acuminate leaves have teeth along the margins, and the solitary white flowers are a good source of nectar for butterflies. This plant is adaptable to shade but will bloom better with a few hours of direct sunlight. An excellent choice for small properties, it can usually be pruned into a tree form, accenting the beautiful bark. Find out more about this attractive landscape plant on our website.