Bikoret draft - Quarry

SQL

use hewiki_p;
select rev_timestamp, page_namespace as ns, page_title, page_id, page_latest, rev_id, rev_user, rev_user_text
from page as p1 inner join revision as r1
where page_id in
(select p3.page_id from page as p3
 where p3.page_namespace in (0, 1, 100, 118)
 and p3.page_id < 1175761)
and exists
(select * from templatelinks
 where tl_from = page_id
 and tl_title = "בעבודה")
and page_id = rev_page
and not exists
(select * from revision as r3
 where page_id = r3.rev_page
 and r3.rev_timestamp > r1.rev_timestamp
 and not exists
(select * from user_groups
 where r3.rev_user = ug_user
 and ug_group = "bot"))
and not exists
(select * from user_groups
 where rev_user = ug_user
 and ug_group = "bot")
and datediff(now(), rev_timestamp) > 1000
SQL

Checking query status...
