Reverted edits by IP

Fork of Reverted edits by IP by WhitePhosphorus

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

SQL

/*
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;

SQL

Checking query status...