Finder 1 - Quarry

SQL

SET STATEMENT max_statement_time = 600 FOR
WITH ref_user (ref_user_name) AS (
    SELECT SQL_SMALL_RESULT
      @sock_master := 'AnoushkaWatson'
  ),
ref_comment (ref_comment_id) AS (
SELECT DISTINCT SQL_SMALL_RESULT
 rev_comment_id
FROM
  ref_user
  INNER JOIN actor_revision AS actor ON ref_user.ref_user_name = actor.actor_name
  INNER JOIN revision_userindex AS revision ON actor.actor_id = revision.rev_actor
  INNER JOIN page ON revision.rev_page = page.page_id
  INNER JOIN comment_revision AS comment ON revision.rev_comment_id = comment.comment_id
WHERE
  TRUE
  AND comment_text != ''
  AND comment_text NOT LIKE '%*/'
  AND LENGTH(comment_text) < 200
  AND page_namespace IN (0, 18)
)
SELECT
actor_name,
COUNT(DISTINCT rev_comment_id)
FROM ref_comment
INNER JOIN revision_userindex AS revision ON ref_comment.ref_comment_id = revision.rev_comment_id
INNER JOIN page ON revision.rev_page = page.page_id
INNER JOIN actor_revision AS actor ON revision.rev_actor = actor.actor_id
INNER JOIN user ON actor.actor_user = user.user_id
WHERE
  TRUE
  AND rev_timestamp >= '20220501000000'
  AND page_namespace IN (0, 18)
  AND actor_user IS NOT NULL
  AND user_registration >= '20190101000000'
  AND user_editcount >= 10
  AND user_editcount < 5000
  AND user_id IS NOT NULL
-- LIMIT 10
GROUP BY actor_id
HAVING COUNT(DISTINCT rev_comment_id) > 1
ORDER BY COUNT(DISTINCT rev_comment_id) DESC
SQL

Checking query status...
