Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Wargo
.
Toggle Highlighting
SQL
USE plwiki_p; /* SELECT CONCAT("#") as number, actor_user AS user_id, CONCAT("[[user:",actor_name,"|",actor_name,"]]") AS user_name, SUM(CAST(rev.rev_len as signed)-CAST(parent.rev_len as signed)) AS byte_count FROM actor JOIN revision rev ON actor_id = rev.rev_actor JOIN revision parent ON rev.rev_parent_id = parent.rev_id JOIN page ON page_id = parent.rev_page WHERE page_namespace = 0 AND rev.rev_timestamp <= 20191231235959 AND parent.rev_timestamp <= 20191231235959 AND rev.rev_timestamp >= 20190101000000 AND parent.rev_timestamp >= 20190101000000 AND actor_user IS NOT NULL GROUP BY actor_name ORDER BY byte_count DESC LIMIT 500; */ /* SELECT CONCAT("#") AS number, actor_user AS user_id, CONCAT("[[user:",actor_name,"|",actor_name,"]]") AS user_name, COUNT(rev_id) AS user_editcount FROM actor INNER JOIN revision ON revision.rev_actor = actor.actor_id JOIN page ON page.page_id = revision.rev_page WHERE page_is_redirect = 0 AND rev_parent_id = 0 AND page_namespace = 0 AND rev_timestamp <= 20191231235959 AND actor_user IS NOT NULL GROUP BY actor_name ORDER BY user_editcount DESC LIMIT 1000; */ SELECT CONCAT("#") AS number, actor_user, CONCAT("[[user:",actor_name,"|",actor_name,"]]") AS rev_user_text, SUM(CASE WHEN rev_timestamp BETWEEN 20190701000000 AND 20191231235959 THEN 1 ELSE 0 END) AS recent_user_editcount, user_editcount /*SUM(CASE WHEN rev_timestamp BETWEEN 20010101000000 AND 20171231235959 THEN 1 ELSE 0 END) AS overall_user_editcount*/ FROM revision JOIN actor ON rev_actor=actor_id JOIN user ON user.user_id = actor.actor_user JOIN page ON rev_page=page_id WHERE page_namespace = 0 AND actor_user IS NOT NULL GROUP BY actor_id ORDER BY recent_user_editcount DESC LIMIT 500; SELECT CONCAT("#") AS number, actor_user, CONCAT("[[user:",actor_name,"|",actor_name,"]]") AS rev_user_text, SUM(CASE WHEN rev_timestamp BETWEEN 20190101000000 AND 20191231235959 THEN 1 ELSE 0 END) AS recent_user_editcount, user_editcount /*SUM(CASE WHEN rev_timestamp BETWEEN 20010101000000 AND 20171231235959 THEN 1 ELSE 0 END) AS overall_user_editcount*/ FROM revision JOIN actor ON rev_actor=actor_id JOIN user ON user.user_id = actor.actor_user JOIN page ON rev_page=page_id WHERE page_namespace = 0 AND actor_user IS NOT NULL GROUP BY actor_id ORDER BY recent_user_editcount DESC LIMIT 500; select * from actor limit 3;
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...