Bikoret draft - Quarry

This query is marked as a draft This query has been published by IKhitron.

SQL

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)

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...