Recent reverted ranges

This query is marked as a draft This query has been published by MarioGom.

SQL

SET STATEMENT max_statement_time = 30 FOR
SELECT 
  * -- ,
  -- rc_this_oldid,
  -- comment_text
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
WHERE
  TRUE
  AND rc_namespace = 0
  -- AND rc_namespace = 3 -- User talk
  AND rc_bot = 0
  AND change_tag_def.ctd_name = 'visualeditor'
LIMIT 10;

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 Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...