Eran draft - Quarry

SQL

use hewiki_p;
select * from #page 
#inner join revision as r1 
#inner join 
user inner join revision as r3
on #r1.rev_id = page_latest
#and 
user_text = "Avivht" #and
#locate(user_name, page_title) = 1
and locate("/", page_title) = length(user_name) + 1
and r3.rev_user_text = user_name
where #page_namespace = 2
#and page_title like "%/%"
#and not page_title like "%/%/%"
#and not page_title like "%טיוטה%"
#and not page_title like "%ארגז_חול%"
#and not page_title like "%ארכיון%"
#and not page_title like "%פתיח%"
#and not page_title like "%מדיניות%"
#and not page_title like "%ויקיפדיה%"
#and page_len > 1023
#and datediff(now(), r1.rev_timestamp) > 182
#and 
datediff(now(), r3.rev_timestamp) > 91
and not exists
(select * from revision as r5
 where r5.rev_user_text = user_name
 and r5.rev_timestamp > r3.rev_timestamp)
limit 1
SQL

Checking query status...
