Usuários editando após desautorizados por filtro por mês

SQL

use ptwiki_p;
select rev_user_text, tempo AS Última_desautorização, MAX(rev_timestamp) AS Última_edição , SUM(rev_timestamp > tempo) AS Edições_após_desautorização, log_action as bloq
FROM revision_userindex
inner JOIN (select afl_user_text as nome, max(afl_timestamp) as tempo from abuse_filter_log
            where afl_timestamp LIKE '201801%' and 
            (afl_filter = 18 or
             afl_filter = 70 or
            afl_filter = 7 or
            afl_filter = 141 or
            afl_filter = 167 or
            afl_filter = 163 or
            afl_filter = 149 or
            afl_filter = 150 or
            afl_filter = 151 or
            afl_filter = 152 or
            afl_filter = 165)
group by afl_user_text) as A
ON nome = rev_user_text
join logging on rev_user_text = log_title
where rev_timestamp LIKE '201801%'
group by rev_user_text
HAVING MAX(rev_timestamp) > tempo
SQL

Checking query status...
