Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Zache
.
log_action 'approve', 'approve2' is Flagged revs manually approved edits
Toggle Highlighting
SQL
USE fiwiki_p; SEkT @datelimit = DATE_FORMAT(NOW() - INTERVAL 30 day,'%Y%m%d%H%i%s'); SELECT log_title, r1.rev_page, r1.rev_id, r2.rev_id, concat("https://fi.wikipedia.org/w/index.php?diff=", r2.rev_id , "&oldid=", r1.rev_id ) AS diff FROM logging_userindex, revision AS r1, revision AS r2 WHERE log_action IN ('approve', 'approve2') AND log_params LIKE concat("%i:0;i:", r1.rev_id, ";%") AND log_params LIKE concat("%i:1;i:", r2.rev_id, ";%") AND r1.rev_page=r2.rev_page AND log_page=r1.rev_page AND r1.rev_id > r2.rev_id AND log_timestamp > @datelimit AND log_namespace=0;
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...