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 inner join revision as r1
on page_id = rev_page
where exists
(select * from templatelinks
 where tl_from = page_id
 and tl_title = "בעבודה")
and page_namespace in (4, 10, 11)
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) > 100
SQL

Checking query status...
