Untitled query #4833

SQL

use hewiki_p;
select count(*) 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 datediff(now(),
(select max(day) from user_daily_contribs as udc
 where udc.user_id = u1.user_id)) > 91
SQL

Checking query status...
