Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
Fork of
Active dewiki editors who started editing in 2001
by
MBq
This query is marked as a draft
This query has been published
by
MBq
.
dewiki editors who started editing in 2001 and made at least one edit in 2016 (modified from Mr. Stradivarius' query #7062)
Toggle Highlighting
SQL
USE dewiki_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
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...