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)

​