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

SQL

SELECT REPLACE(page_title, '_', ' ') AS title,
       SUM(LENGTH(REPLACE(page_title, '_', ' '))) AS total_length,
       MAX(this_rev.rev_timestamp) AS latest_revision_timestamp,
       MAX(CAST(this_rev.rev_len AS SIGNED) - CAST(parent.rev_len AS SIGNED)) AS max_length_difference
FROM revision AS this_rev
JOIN actor ON actor_id = rev_actor
JOIN page ON page_id = rev_page
JOIN revision AS parent ON parent.rev_id = this_rev.rev_parent_id
JOIN comment ON comment_id = this_rev.rev_comment_id
JOIN change_tag ON this_rev.rev_id = ct_rev_id
JOIN change_tag_def ON ct_tag_id = ctd_id
WHERE page_namespace = 0
  AND ctd_name NOT IN ('mw-manual-revert', 'mw-undo', 'mw-rollback')
  AND actor_name = 'ԱշոտՏՆՂ'
  AND (CAST(this_rev.rev_len AS SIGNED) - CAST(parent.rev_len AS SIGNED)) > 1000
GROUP BY REPLACE(page_title, '_', ' ')
ORDER BY latest_revision_timestamp DESC;
SQL

Checking query status...
