Replicas browser and optimizer
This query is marked as a draft
This query has been published
use urwiki_p; select user_id, CONCAT("[[user:",user_name,"|",user_name,"]]") AS user_name, SUM(CAST(rev.rev_len as signed)-CAST(parent.rev_len as signed)) AS byte_count, COUNT(rev.rev_id) as edit_count from user join revision rev on user_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 >= 20060101000000 and rev.rev_timestamp <= 20191231235959 and parent.rev_timestamp <= 20191231235959 group by user_name order by byte_count ASC limit 100;
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