Top users of Suggested Edits feature on Android

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.

SQL

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 username,
  u.user_editcount as edit_count
FROM revision_userindex
LEFT JOIN `comment` ON revision_userindex.rev_comment_id = `comment`.comment_id
LEFT JOIN `user` u ON revision_userindex.rev_actor = `user`.user_id
LEFT JOIN change_tag ON revision_userindex.rev_id = change_tag.ct_rev_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 10;

SQL

Checking query status...