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 = '311'
group by i.id
Germination: sow seed 1/16" deep, tamp the soil, mulch the seed bed
Looking for an attractive and ornamental plant to grow in your garden? Look no further than Buddleja davidii, commonly known as summer lilac, butterfly-bush, or orange eye. This flowering shrub is native to China and Japan and is widely used as an ornamental plant around the world. With its vigorous growth and arching habit, summer lilac can reach a height of 5m. Its honey-scented lilac to purple inflorescences are terminal panicles, and it is a perfect source of nectar for many species of butterfly. This plant comes in many named varieties, with over 180 davidii cultivars in cultivation. Though not suitable for northern or montane climates, Buddleja davidii is a popular and stunning addition to any temperate garden.