Recent changes with some string in the comment

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

This query uses only recentchanges table...

use eswiki_p;
select * from revision 
where rev_comment like '%#1lib1ref%'
and rev_timestamp between 20161228000000 and 20171231000000
limit 300;

AخA
 
use eswiki_p;select * from revision where rev_comment like '%#1lib1ref%'and rev_timestamp between 20161228000000 and 20171231000000limit 300;

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.