Content search

SQL

SELECT
  rc_cur_id,
  rc_title,
  MAX(rc_this_oldid) AS oldid
FROM
  (
    SELECT
      *
    FROM
      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 actor ON recentchanges.rc_actor = actor.actor_id
      INNER JOIN comment ON recentchanges.rc_comment_id = comment.comment_id
    WHERE
      rc_namespace = 0
      AND rc_ip IS NULL
      AND rc_bot = 0
      AND actor_user IS NOT NULL
      AND change_tag_def.ctd_name = 'visualeditor'
      AND comment_text LIKE '% tag%'
  ) AS q
GROUP BY
  rc_cur_id,
  rc_title
SQL

Checking query status...
