Saucy recent changes

SQL

-- SET STATEMENT max_statement_time = 30 FOR
SELECT
  user_name,
  rc_this_oldid,
  comment_text
FROM
  recentchanges
  INNER JOIN change_tag AS change_tag1 ON recentchanges.rc_id = change_tag1.ct_rc_id
  INNER JOIN change_tag_def AS change_tag_def1 ON change_tag1.ct_tag_id = change_tag_def1.ctd_id
  INNER JOIN change_tag AS change_tag2 ON recentchanges.rc_id = change_tag2.ct_rc_id
  INNER JOIN change_tag_def AS change_tag_def2 ON change_tag2.ct_tag_id = change_tag_def2.ctd_id
  INNER JOIN comment ON recentchanges.rc_comment_id = comment.comment_id
  INNER JOIN actor ON recentchanges.rc_actor = actor.actor_id
  INNER JOIN user ON actor.actor_user = user.user_id
WHERE
  rc_namespace = 0
  AND rc_ip IS NULL
  AND rc_bot = 0
  AND actor_user IS NOT NULL
  AND change_tag_def1.ctd_name = 'visualeditor'
  AND change_tag_def2.ctd_name = 'removal of COI template'
LIMIT
  100;
SQL

Checking query status...
