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 not exists

(select * from templatelinks

 where tl_from = page_id

 and tl_title in ("הפרת_זכויות_יוצרים", "ערך_יתום"))

and not 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 not 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))))))

​