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_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;

SQL

Checking query status...