Fork of Content search by MarioGom
This query is marked as a draft This query has been published by Blablubbs.

SQL

AخA
 
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 comment_text LIKE '%[sS]entence correction%'
  ) AS q
GROUP BY
  rc_cur_id,
  rc_title
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query
All SQL code is licensed under CC0 License.

Checking query status...