use hewiki_p;

select * from categorylinks join page

on cl_from = page_id

and cl_to = "ערכים_מומלצים"

where exists

(select * from pagelinks

 where cl_from = pl_from

 and exists

 (select * from categorylinks as cl1

  where cl1.cl_from = pl_title

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

and not exists

(select * from categorylinks as cl2

 where cl2.cl_from = page_id

 and cl2.cl_to = "ערכים_מומלצים_שנבדקו")

and not cl_from in (3906, 91645)

​