Replicas browser and optimizer
Top users of Suggested Edits feature on Android
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_actor, COUNT(*) AS n_total_edits, -- not all edits, just total Suggested Edits edits COUNT(DISTINCT LEFT(rev_timestamp, 8)) AS n_days_usage, u.user_name as user_name, u.user_editcount as edit_count, a.actor_name as username 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 Left JOIN actor a ON revision_userindex.rev_actor = a.actor_id LEFT JOIN `user` u ON a.actor_user = u.user_id WHERE rev_timestamp >= '20190401' 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 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