Eran draft - Quarry

SQL

use hewiki_p;
select * from page inner join revision as r1 inner join user# inner join revision as r3
on page_id = 783449 and 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 r5.rev_timestamp > r3.rev_timestamp)
SQL

Checking query status...
