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

USE wikidata_p;
SELECT
  rev_user_text AS user_id,
  COUNT(*) AS n_total_edits,
  COUNT(DISTINCT LEFT(rev_timestamp, 8)) AS n_days_usage
FROM revision
LEFT JOIN revision_comment_temp rct ON revision.rev_id = rct.revcomment_rev
LEFT JOIN `comment` ON rct.revcomment_comment_id = `comment`.comment_id
LEFT JOIN change_tag ON revision.rev_id = change_tag.ct_rev_id
WHERE rev_timestamp >= '20190401'
  AND NOT rev_deleted
  AND ct_tag_id = 14 -- android app edit
  AND (INSTR(rev_comment, '#suggestededit') > 0 OR INSTR(comment_text, '#suggestededit') > 0)
GROUP BY user_id
ORDER BY n_total_edits DESC, n_days_usage DESC
LIMIT 10;

SQL

Checking query status...