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 = '700607'
group by i.id
Seeds per lb:
Min. hardiness zone:
Scarification: none required
Stratification: none required
Germination: sow seed 1/16" deep, tamp the soil, lightly mulch the seed bed.
Introducing the stunning Buddleja asiatica Dogtail, also known as the White Butterfly Bush. This deciduous shrub is native to a vast area of the East Indies, including India, China, Thailand and more. Its sweetly scented, white or pale violet flowers bloom in late winter, attracting butterflies to your garden. While not completely hardy in the UK, it can be grown against a south-facing wall in coastal areas of the south and west. Buddleja asiatica is not only an ornamental shrub, it has a variety of uses, including being a source of perfume and fodder for domesticated animals in Nepal. Add this exotic and beautiful shrub to your garden today!