processlist

select concat('KILL ',id,';') from information_schema.processlist WHERE `TIME`>100 AND INFO LIKE '%purchaseplan%';