Comment search recent (rd)

SQL

-- SET STATEMENT max_statement_time = 30 FOR
SELECT DISTINCT
  actor_name,
  rc_this_oldid,
  comment_text
FROM
  recentchanges_userindex AS recentchanges
  -- INNER JOIN change_tag ON recentchanges.rc_id = change_tag.ct_rc_id
  -- INNER JOIN change_tag_def ON change_tag.ct_tag_id = change_tag_def.ctd_id
  INNER JOIN comment ON recentchanges.rc_comment_id = comment.comment_id
  INNER JOIN actor_recentchanges AS actor ON recentchanges.rc_actor = actor.actor_id
WHERE
  TRUE
  AND rc_namespace = 0
  -- AND rc_namespace = 3 -- User talk
  -- AND rc_ip IS NULL
  AND rc_bot = 0
  AND actor_name IS NOT NULL
  -- AND change_tag_def.ctd_name = 'visualeditor'
  -- AND CAST(comment_text AS CHAR CHARACTER SET utf8) COLLATE UTF8_GENERAL_CI LIKE 'removed word'
  AND comment_text LIKE '/*%*/ (%)'
  AND comment_text NOT LIKE '%toollabs%'
  AND comment_text NOT LIKE '%wbsetaliases%'
  AND comment_text NOT LIKE '%wbsetdescription%'
  AND actor_name != 'Athel cb'
  -- AND rc_timestamp >= "20210420092000" -- AND rc_timestamp <= "20210428095900"
  -- AND LENGTH(comment_text) > 3
ORDER BY rc_timestamp DESC;
SQL

Checking query status...
