Replicas browser and optimizer
This query is marked as a draft
This query has been published
A list of editors who made at least one edit in 2001 and at least one edit after 1 January 2016. Some of those editors are marked as having registered after 2001, but they all have edits from 2001 in their contributions.
USE enwiki_p; SELECT user_id, user_name, CAST(user_registration AS DATE) AS registration_date, user_editcount AS edit_count, COUNT(*) AS edits_in_2016 FROM user INNER JOIN revision AS r1 ON user_id = r1.rev_user AND r1.rev_timestamp >= '20160000000000' AND user_id IN (SELECT DISTINCT r2.rev_user FROM revision AS r2 WHERE r2.rev_timestamp < '20020000000000') GROUP BY user_id ORDER BY registration_date, user_id;
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