Replicas browser and optimizer
This query is marked as a draft
This query has been published
A leaderboard of top 10 Android editors by number of title description edits *made through the Suggested Edits feature*, including the number of days those edits were made over.
SET STATEMENT max_statement_time = 120 FOR USE wikidatawiki_p; SELECT rev_user_text AS username, COUNT(*) AS n_total_edits, -- not all edits, just total Suggested Edits edits COUNT(DISTINCT LEFT(rev_timestamp, 8)) AS n_days_usage FROM revision_userindex LEFT JOIN `comment` ON revision_userindex.rev_comment_id = `comment`.comment_id LEFT JOIN change_tag ON revision_userindex.rev_id = change_tag.ct_rev_id WHERE rev_timestamp >= '20190401' AND rev_user > 0 -- not anonymous, not that there could be any using Suggested Edits AND NOT rev_deleted -- this not the same as "not reverted", unfortunately AND ct_tag_id = 14 -- tagged as android app edit AND INSTR(comment_text, '#suggestededit') > 0 -- specifically made through Suggested Edits GROUP BY username ORDER BY n_total_edits DESC, n_days_usage DESC LIMIT 10;
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