Replicas browser and optimizer
This query is marked as a draft
This query has been published
USE itwiki_p; SELECT user_name, max(rev_timestamp) as ultima FROM revision JOIN user ON rev_user = user_id AND rev_timestamp > '20170101000000' AND user_editcount > 5000 AND NOT user_name RLIKE '.*[Bb]ot.*' GROUP BY rev_user HAVING ultima < '20181001000000';
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