Fork of Untitled query #61704 by IKhitron
This query is marked as a draft This query has been published by IKhitron.

SQL

​x
 
select replace(page_title, '_', ' ') as title from page
where page_namespace = 0
and not page_is_redirect
and not exists
(select * from templatelinks join linktarget
 where tl_target_id = lt_id
 and tl_from = page_id
 and lt_title in ('פירושונים', 'ערך_יתום'))
and exists
(select * from pagelinks
 where page_title = pl_title
 and pl_namespace = 0)
and not exists
(select * from pagelinks
 where page_title = pl_title
 and pl_namespace = 0
 and pl_from_namespace = 0)
order by title asc
​
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
All SQL code is licensed under CC0 License.

Checking query status...