Replicas browser and optimizer
user triggering a filter
This query is marked as a draft
This query has been published
counting users that trigged a filter from a data until today at ptwiki and edited at the same day
use ptwiki_p; SELECT CONCAT('[[Especial:Contribuições/',afl_user_text,']]') as IP, count(rev_timestamp) as quantidade, min(rev_timestamp) as minimo, max(rev_timestamp) as maximo FROM abuse_filter_log join revision on afl_user_text = rev_user_text and left(afl_timestamp,8) = left(rev_timestamp,8) where afl_filter = 10 and afl_timestamp between 20160901000000 and 20161231000000 and afl_user=0 and rev_timestamp between 20160901000000 and 20161231000000 group by IP order by quantidade desc
By running queries you agree to the
and you irrevocably agree to release your SQL under
All SQL code is licensed under
Checking query status...
Report a bug!
Wikimedia Cloud VPS
, written in