Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
Fork of
Recently edited pages with undid edits and IP edits
by
Huji
This query is marked as a draft
This query has been published
by
Hidayatsrf
.
Toggle Highlighting
SQL
SELECT rc_namespace, rc_title, SUM( CASE WHEN ct_tag_id = 10 THEN 1 ELSE 0 END ) AS undos, SUM( CASE WHEN actor_user IS NULL THEN 1 ELSE 0 END ) AS ips FROM recentchanges JOIN actor_revision ON rc_actor = actor_id LEFT JOIN change_tag ON ct_rc_id = rc_id WHERE rc_timestamp > DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 30 DAY), '%Y%m%d000000') AND ( ct_tag_id = 10 OR actor_user IS NULL ) GROUP BY rc_namespace, rc_title HAVING undos > 1 AND ips > 1 ORDER BY undos DESC
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
.
Checking query status...