Untitled query #56341

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"))
 or p1.page_id NOT in (select il_from from imagelinks))
--      and p1.page_id in (select pp.page_id from page pp having count(pp.page_id) = (select count(tl_from) from templatelinks where tl_from=pp.page_id and tl_from in (select il_from from imagelinks) group by tl_from)) 
      and p1.page_namespace=0
      and p1.page_is_redirect=0
      and p1.page_id not in (select pp_page from page_props where pp_propname ="disambiguation")
      and p2.page_title=p1.page_title
      and p2.page_namespace=1
      and p2.page_id not in (select cl_from from categorylinks where (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' )
                                                                     )
                            )                                                         

order by p1.page_title
SQL

Checking query status...
