select ps.id, substring(info,1,100)
from information_schema.processlist ps
where ps.command = 'Query'
    and ps.user = 'wikiuser'
    and ps.time between 300 and 1000000
    and ps.info is not null
    and lower(ps.info) regexp '^[[:space:]]*select'
    and not lower(ps.info) regexp 'wikiexporter'
    and not lower(ps.info) regexp 'master_pos_wait'
order by ps.time desc;