Replicas browser and optimizer
This query is marked as a draft
This query has been published
use fawiki_p; select old.rev_user, user_name, count(r.rev_id) from ( select distinct rev_user from revision where rev_timestamp < '20060801000000' and rev_user <> 0 ) old join ( select distinct rev_user from revision where rev_timestamp > '20160801000000' and rev_user <> 0 ) new on old.rev_user = new.rev_user join user on old.rev_user = user_id join revision r on r.rev_user = old.rev_user group by old.rev_user, user_name
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