Acquisition comments

SQL

SET STATEMENT max_statement_time = 90 FOR
SELECT
  actor_name,
  -- COUNT(*) AS c
  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
  INNER JOIN user ON actor.actor_user = user.user_id
WHERE
  TRUE
  AND rc_type = 0
  -- AND rc_namespace = 0
  -- AND rc_ip IS NULL
  AND rc_bot = 0
  AND actor_user IS NOT NULL
  -- AND actor_user IS NULL
  AND change_tag_def.ctd_name = 'visualeditor'
  AND (
	FALSE
    OR comment_text IN ('Added new career information', 'Added new Career section', 'Add new info & citation', 'Add new info & citations',
                       'Added new info & citations', 'Added new info & citation', 'Added more references, info and subheadings', 'Added new citations and subheadings',
                       'Added net worth', 'Updated net worth', 'Updated net worth 2021 figure', 'Copyedit & infobox')
  )
  AND rc_timestamp >= '20210901000000'
  AND user_registration IS NOT NULL
  AND user_registration >= "20210101000000" 
-- GROUP BY actor_name
-- ORDER BY COUNT(*) DESC;
ORDER BY rc_timestamp DESC
SQL

Checking query status...
