use hewiki_p;

select * from page

where page_namespace = 0

and exists

(select * from templatelinks

 where tl_from = page_id

 and tl_title = "ערך_יתום")

and exists

(select * from pagelinks

 where pl_title = page_title

 and pl_namespace = 0

 and pl_from_namespace = 0

 and not exists

 (select * from page

  where pl_from = page_id

  and page_is_redirect)

 and not exists

 (select * from categorylinks

  where pl_from = cl_from

  and cl_to = "פירושונים"))

and not exists

 (select * from categorylinks

  where page_id = cl_from

  and cl_to = "פירושונים")

​