Comment search (rd)

SQL

SET STATEMENT max_statement_time = 60 FOR
SELECT
  *
FROM
  revision_userindex AS revision
  INNER JOIN page ON revision.rev_page = page.page_id
  INNER JOIN comment_revision AS comment ON revision.rev_comment_id = comment.comment_id
  INNER JOIN actor_revision AS actor ON revision.rev_actor = actor.actor_id
WHERE
  TRUE
  AND rev_timestamp >= 20200101000000
  AND rev_minor_edit = 0
  AND page_namespace = 0
  AND page_is_redirect = 0
  AND actor_user IS NULL
  AND actor_name IS NOT NULL
  AND comment_text LIKE '/*%*/ (%)'
  AND comment_text NOT LIKE '%toollabs%'
  AND comment_text NOT LIKE '%wbsetaliases%'
  AND comment_text NOT LIKE '%wbsetdescription%'
LIMIT 1
SQL

Checking query status...
