Untitled query #6885

SQL

use ptwiki_p;

select afl_user_text, afl_user, count(*) as tentativas 
from (select afl_var_dump, afl_user_text, afl_user, afl_timestamp from 
      abuse_filter_log where afl_user != 0 and afl_filter not in (75,56,86,119,104,82) 
      and afl_timestamp > concat(replace(utc_date(),'-',''),'000000')-10000000  
      group by afl_var_dump, afl_user_text, afl_user, afl_timestamp ) a 
      where afl_user in (select ug_user from user_groups where ug_group in ('sysop')) 
      group by afl_user_text,afl_user order by tentativas desc;
SQL

Checking query status...
