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 = '919'
group by i.id
Introducing the stunning Oxydendrum arboreum, also known as the Lily of the Valley Tree, Sorrel Tree, or Sourwood. This native American tree features shiny, dark green leaves that turn red, yellow, and purple in the fall and boasts fragrant urn-shaped flowers in drooping clusters. Its habit varies, with some having a rounded crown atop a tall stem while others are rather short or even shrubby. The Sourwood is most common in the lower chain of the Appalachian Mountains and frequently seen as a component of oak-heath forests. Its wood is heavy, hard, attractive, and very close-grained, making it suitable for panelling, tool handles, bearings, and more. In addition to its ornamental value, the Sourwood is renowned for its nectar and honey production. This tree is a perfect addition to any lawn or park, with late blooming and stunning autumnal coloring. So why not bring some native beauty to your space with the enchanting Oxydendrum arboreum?