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.