Untitled query #50182

SQL

use hewiki_p;
select replace(page_title, "_", " ") from page as p1
where page_namespace = 0
and page_is_redirect = 0
and not exists
(select * from page_props
 where pp_page = page_id
 and pp_propname = "disambiguation")
and not exists
(select * from categorylinks
 where cl_from = page_id
 and cl_to = "פירושונים")
and exists
(select * from templatelinks
 where tl_from = page_id
 and tl_title = "ערך_יתום")
and not exists
(select * from templatelinks
 where tl_from = page_id
 and tl_title = "הפרת_זכויות_יוצרים")
and exists
(select * from pagelinks
 where pl_namespace = 0
 and pl_title = page_title
 and pl_from_namespace = 0
 and not exists
 (select * from page_props
 where pp_page = pl_from
 and pp_propname = "disambiguation")
 and exists
 (select * from page as p3
  where not p1.page_id = p3.page_id
  and p3.page_id = pl_from
  and (p3.page_is_redirect = 0
  or (p3.page_is_redirect = 1
  and exists
  (select * from pagelinks as pl3
 where pl3.pl_namespace = 0
 and pl3.pl_title = p3.page_title
 and pl3.pl_from_namespace = 0
 and exists
 (select * from page_props
 where pp_page = pl3.pl_from
 and pp_propname = "disambiguation")
 and exists
 (select * from page as p5
  where not p3.page_id = p5.page_id
  and p5.page_id = pl3.pl_from
  and p5.page_is_redirect = 0))))))
SQL

Checking query status...
