Eran draft - Quarry

SQL

use hewiki_p;
select * from page
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 exists
(select * from revision
 where rev_id = page_latest
 and datediff(now(), rev_timestamp) > 182)
and exists
(select * from user
 where locate(user_name, page_title) = 1
 and not exists
 (select * from revision
 where rev_user_text = user_name
 and datediff(now(), rev_timestamp) < 91))
limit 5
SQL

Checking query status...
