use hewiki_p;

select page_id, page_namespace as ns, page_title, page_latest, rev_id, rev_user, rev_user_text, rev_timestamp

from page inner join revision as r1

where 

page_namespace in (1, 100, 118)

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 exists

(select * from user

 on rev_user = user_id)

​