Tewiki:pages without images

SQL

SELECT page_title
FROM page p, categorylinks
WHERE
    cl_from=page_id
    and not exists (select il_from
                from imagelinks 
                where il_from = p.page_id
                )
    and page_namespace=0
    and page_is_redirect=0
    and page_id not in (select pp_page from page_props where pp_propname="disambiguation")
    and  (cl_to = 'ఆంధ్రప్రదేశ్_గ్రామాలు'
  OR
  cl_to IN (select page_title from page inner join categorylinks on cl_from = page_id where cl_to = 'ఆంధ్రప్రదేశ్_గ్రామాలు' 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 = 'ఆంధ్రప్రదేశ్_గ్రామాలు' 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 = 'ఆంధ్రప్రదేశ్_గ్రామాలు' and cl_type = 'subcat' ) and cl_type = 'subcat' ) and cl_type = 'subcat' )
  )
    
  order by page_title
SQL

Checking query status...
