Replicas browser and optimizer
This query is marked as a draft
This query has been published
This query gets you the current edit count of any editor who edited English Wikipedia on January 25th 2002 by joining the user and revision table on their common keys: user_id = rev_user.
SELECT user_name, user_registration, user_editcount, rev_timestamp FROM user JOIN revision ON user_id = rev_user WHERE rev_timestamp LIKE "20020125%" GROUP BY 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