Fork of Reverted edits by IP by WhitePhosphorus
This query is marked as a draft This query has been published by WhitePhosphorus.

SQL

x
 
/*
SELECT COUNT(*) AS cnt FROM (
  SELECT ct_tag_id FROM change_tag
    RIGHT JOIN recentchanges
      ON rc_id = ct_rc_id
        AND ct_tag_id = 29
    JOIN actor
      ON actor_id = rc_actor
    WHERE actor_user IS NULL
      AND rc_source = "mw.edit"
    ORDER BY rc_id DESC
    LIMIT 500) t
  WHERE t.ct_tag_id IS NOT NULL;
*/
SELECT * FROM change_tag
  JOIN change_tag_def
    ON ctd_id = ct_tag_id
  RIGHT JOIN recentchanges
    ON rc_id = ct_rc_id
      AND ctd_name = "mw-reverted"
  JOIN actor
    ON actor_id = rc_actor
  WHERE actor_user IS NULL
    AND rc_source = "mw.edit"
  ORDER BY rc_id DESC
  LIMIT 500;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Checking query status...