Fork of Untitled query #61709 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 join linktarget
 where pl_target_id = lt_id
 and page_title = lt_title
 and lt_namespace = 0)
and not exists
(select * from pagelinks join linktarget
 where pl_target_id = lt_id
 and page_title = lt_title
 and lt_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...