Untitled query #6885

SQL

use ptwiki_p;

select * from (select afl_user_text , count(*) as tentativas from (select afl_var_dump, afl_user_text, afl_timestamp from abuse_filter_log where (afl_actions in ('warn','disallow') OR afl_filter = 112 ) and afl_user_text not in (select log_title from logging where log_action = 'block' and log_timestamp > (utc_timestamp() - 1000000)) group by afl_var_dump, afl_user_text, afl_timestamp) a where afl_timestamp > (utc_timestamp() - 1000000) group by afl_user_text) b where tentativas > 2 order by tentativas asc;
SQL

Checking query status...
