Eran draft - Quarry

SQL

use hewiki_p;
select * from page inner join revision_userindex inner join user as u1
on rev_id = page_latest
and locate(user_name, page_title) = 1
and locate("/", page_title) = length(user_name) + 1
where page_namespace = 2
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(), rev_timestamp) > 182
and not exists
(select * from user_daily_contribs as udc
 where udc.user_id = u1.user_id
 and datediff(now(), day) > 91)
SQL

Checking query status...
