Untitled query #74933

SQL

select p1.Page_title from page p1,page p2
where 
-- p1.page_id not in (select pp_page from page_props where pp_propname in ("page_image", "page_image_free"))
      p1.page_id not in (select il_from from imagelinks)
      and p1.page_namespace=0
      and p1.page_is_redirect=0
      and p2.page_title=p1.page_title
      and p2.page_namespace=1
      and p2.page_id in (select cl_from from categorylinks where cl_to = "Dental") 
      and p1.page_id not in (select cl_from from categorylinks where (cl_to = 'Dental'
  			OR
  				cl_to IN (select page_title from page inner join categorylinks on cl_from = page_id where cl_to = 'Dental equipment' and cl_type = 'subcat' )
  			OR
 				cl_to IN (select page_title from page inner join categorylinks on cl_from = page_id where cl_to in (select page_title from page inner join categorylinks on cl_from = page_id where cl_to in (select page_title from page inner join categorylinks on cl_from = page_id where cl_to = 'Dentistry' and cl_type = 'subcat' ) and cl_type = 'subcat' ) and cl_type = 'subcat' )
                                                                 ))
     and p1.page_id in (select cl_from from categorylinks where (cl_to = 'Dentistyla'
  			OR
  				cl_to IN (select page_title from page inner join categorylinks on cl_from = page_id where cl_to = 'Chilodontaidae' and cl_type = 'subcat' )
  			OR
  				cl_to IN (select page_title from page inner join categorylinks on cl_from = page_id where cl_to in (select page_title from page inner join categorylinks on cl_from = page_id where cl_to = 'Seguenzioidea' and cl_type = 'subcat' ) and cl_type = 'subcat' )
 			OR
 				cl_to IN (select page_title from page inner join categorylinks on cl_from = page_id where cl_to in (select page_title from page inner join categorylinks on cl_from = page_id where cl_to in (select page_title from page inner join categorylinks on cl_from = page_id where cl_to = 'Liotiidae' and cl_type = 'subcat' ) and cl_type = 'subcat' ) and cl_type = 'subcat' )
                                                                 ))

      order by p1.page_title
SQL

Checking query status...
