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

​