Untitled query #18833

SQL

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;
SQL

Checking query status...
