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