My 1000+ contributions (-reverts, disambig, hotcat, catsuggest)

SQL

WITH RevertIds AS
  (SELECT rev_id AS revert_rev_id
   FROM revision
   JOIN change_tag ON rev_id = ct_rev_id
   JOIN change_tag_def ON ct_tag_id = ctd_id
   WHERE ctd_name IN ('mw-manual-revert',
                      'mw-undo',
                      'mw-rollback') )
SELECT DISTINCT REPLACE(page_title, '_', ' ') AS title,
                SUM(ABS(CAST(this_rev.rev_len AS SIGNED) - COALESCE(CAST(parent.rev_len AS SIGNED), 0))) AS total_length,
                MAX(this_rev.rev_timestamp) AS latest_revision_timestamp
FROM revision AS this_rev
JOIN actor ON actor_id = rev_actor
JOIN page ON page_id = rev_page
JOIN comment ON comment_id = this_rev.rev_comment_id
LEFT JOIN revision AS parent ON parent.rev_id = this_rev.rev_parent_id
WHERE page_namespace = 0
  AND NOT EXISTS
    (SELECT 1
     FROM RevertIds
     WHERE revert_rev_id = this_rev.rev_id)
  AND actor_name = 'ԱշոտՏՆՂ'
  AND page_title NOT LIKE '%_(այլ_կիրառումներ)'
  AND comment_text NOT LIKE 'Հետ է շրջվում%'
  AND comment_text NOT LIKE 'catSuggest-ով%'
  AND (CAST(this_rev.rev_len AS SIGNED) - COALESCE(CAST(parent.rev_len AS SIGNED), 0)) > 0
GROUP BY REPLACE(page_title, '_', ' ')
HAVING total_length > 1000
ORDER BY latest_revision_timestamp DESC;
SQL

Checking query status...
