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 = '1400'
group by i.id
Germination: surface sow and keep moist, tamp the soil, requires light for germination
Looking for a shrub that attracts butterflies and other nectar-feeding insects? Consider Spiraea tomentosa, also known as Steeplebush, Hardhack, or Meadowsweet. This vigorous plant can grow up to four feet high and prefers moist to wet soil and full sun. It blooms in the summer with narrow, pyramid-shaped clusters of tiny purple flowers. The plant also has a dense white-woolly tomentum which covers its stem and the underside of its leaves. Not only is this plant attractive to wildlife, but it is also noted for its medicinal properties, including astringent properties. It is hardy in zones 4 to 6 and can be found natively in the northeastern United States and Canada. Try growing Spiraea tomentosa to add color, wildlife, and potential health benefits to your garden.