Finder 1 - Quarry

SQL

SET STATEMENT max_statement_time = 600 FOR
WITH ref_user (ref_user_name) AS (
    SELECT SQL_SMALL_RESULT SQL_CACHE
      @sock_master := 'AnoushkaWatson'
  ),
ref_comment (ref_comment_id) AS (
SELECT SQL_SMALL_RESULT SQL_CACHE DISTINCT
 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 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
)
SELECT
COUNT(DISTINCT actor_id)
FROM ref_comment
INNER JOIN revision_userindex AS revision ON ref_comment.ref_comment_id = revision.rev_comment_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 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
SQL

Checking query status...
