Acquisition comments

SQL

SET STATEMENT max_statement_time = 90 FOR
WITH rev_counts AS (
  SELECT
    rev_actor,
    COUNT(*) AS rev_count
  FROM
    revision_userindex AS revision
    WHERE
    TRUE
    AND rev_actor IS NOT NULL
    AND rev_actor != 0
  GROUP BY
    rev_actor
),
sus_actors AS (
  SELECT DISTINCT
  actor_id,
  actor_name
FROM
  recentchanges_userindex AS recentchanges
  INNER JOIN comment ON recentchanges.rc_comment_id = comment.comment_id
  INNER JOIN actor_recentchanges AS actor ON recentchanges.rc_actor = actor.actor_id
  INNER JOIN user ON actor.actor_user = user.user_id
  INNER JOIN rev_counts ON actor.actor_id = rev_counts.rev_actor
WHERE
  TRUE
  AND rc_type = 0
  AND rc_namespace = 0
  AND rc_bot = 0
  AND actor_user IS NOT NULL
  AND comment_text LIKE '%acquisition%'
  AND user_registration IS NOT NULL
  AND user_registration >= "20200101000000" 
)
SELECT DISTINCT
  actor_name
FROM
  sus_actors
  INNER JOIN rev_counts ON sus_actors.actor_id = rev_counts.rev_actor
WHERE
  TRUE
  AND rev_count >= 10
  AND rev_count < 1000
SQL

Checking query status...
