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 locate(user_name, page_title) = 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 not exists
(select * from revision as r5
 where r5.rev_user_text = user_name
 and datediff(now(), r5.rev_timestamp) < 91)
and not exists
(select * from revision as r8
 where r8.rev_user_text = user_name
 and r8.rev_timestamp > r3.rev_timestamp)
limit 1
SQL

Checking query status...
