vandal - Quarry

SQL

/*USE eswiki_p;
select * from revision join page on rev_page = page_id and page_namespace = 8
where rev_timestamp > 20100809003006
and rev_comment like "%wgTitle%"*/#title=Ra%C3%BAl_Gonz%C3%A1lez
USE rowiki_p;
select *
#concat("https://ro.wikipedia.org/w/index.php?curid=",rev_page,"&diff=",rev_id,"&oldid=",rev_parent_id) as link, page_title, rev_comment, rev_user_text, rev_timestamp, rev_minor_edit, page_len 
#page_title, rev_comment, rev_user_text, rev_timestamp, rev_minor_edit, page_len
from revision join page on rev_page = page_id and page_namespace = 0 and rev_deleted = 0
where rev_timestamp > 20140809003006 /*and rev_user is null*/
and rev_comment like "%ortografi%" or rev_comment like "%gramatic%"
limit 10
SQL

Checking query status...
