SQL
x
USE fiwiki_p;
SET @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
LIMIT 10;
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.