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 

user_text = "Avivht" #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 r5.rev_timestamp > r3.rev_timestamp)

limit 1

​