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 locate("/", page_title) = length(user_name) + 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 datediff(now(), r3.rev_timestamp) > 91

and not exists

(select * from revision as r5

 where r5.rev_user_text = user_name

 and datediff(r5.rev_timestamp, r3.rev_timestamp) > 0)

​