vandal - Quarry

SQL

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 and rev_user = 0
where rev_timestamp >= 20151001000006/**/
and (rev_comment like "%ortografi%" or rev_comment like "%gramatic%" 
or rev_comment like "%orecta%" or rev_comment like "%orectur%" or rev_comment like "%just%")
order by rev_timestamp desc
#limit 70
SQL

Checking query status...
