Fiwiki bad diffs

This query is marked as a draft This query has been published by Zache.

Detetected using "rv" tag added by bot. 
Timeframe 30 days.

SQL

use fiwiki_p;
SET @datelimit =  DATE_FORMAT(NOW() - INTERVAL 30 day,'%Y%m%d%H%i%s');
SELECT
  page_title, 
  r1.rev_page, 
  r1.rev_id, 
  r1.rev_timestamp,  
  concat("https://fi.wikipedia.org/w/index.php?diff=", r1.rev_parent_id , "&oldid=", r1.rev_id ) AS url 
FROM 
  page, 
  revision AS r1, 
  tag_summary
WHERE 
  ts_rev_id=r1.rev_id 
  AND r1.rev_timestamp > @datelimit 
  AND ts_tags LIKE "%rv%" 
  AND page_id=r1.rev_page 
  AND page_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.

SQL

Checking query status...