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 = '1536'
group by i.id
Bring the beauty of the New England landscape to your garden with Symphyotrichum nova-angliae, also known as the New England Aster. This large and showy flowering plant is a herbaceous perennial that grows over 6 feet in height. Its hairy, clasping leaves are densely arranged on its stout stems, and bright, rose-purple flowers with orange-yellow centers bloom profusely at the tips of the leafy branches. The flower color varies from lavender and blue to white, and a pink variety of this species is sometimes grown commercially. Native to almost every area in North America east of the Rocky Mountains, the New England Aster is a must-have for any garden looking to add a splash of color and showiness to its landscape. Get yours today and see why this magnificent plant has become a popular choice among gardeners. Learn more at USDA.gov.