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 = '2437'
group by i.id
Sweet William - Dianthus barbatus 'Single Mix' is a vibrant and ornamental plant is native to the mountains of southern Europe, with a variety even found in Russia and China. Sweet William is easy to grow and prefers a rich well-drained soil in a sunny position, although it can succeed in most soils, including dry ones. The flowers are highly attractive to butterflies and moths with a strong clove-like scent, making it a great addition to any garden. While it is a perennial species, it is best treated as a biennial in the garden as it degenerates after its second year. These plants self-sow freely when grown in a suitable environment adding to their charm. Add a pop of color and fragrance to your garden with the Sweet William - order now and watch it grow!