Untitled query #56614

SQL

select distinct concat("[[",p1.page_title,"]]") from tewiki_p.page p1,tewiki_p.page p2
where p1.page_title in (select ll_title from langlinks where ll_from in 
                        (select pen.page_id 
                  			from page pen 
                  			where pen.page_namespace=0 
                  			and pen.page_is_redirect=0 
                  			and pen.page_id not in 
                         (select pp_page from page_props 
                          where pp_propname ="disambiguation")
--                  			and pen.page_id in (select il_from from imagelinks)
                         and pen.page_id in 
                         (select pp_page from page_props 
                          where pp_propname in ("page_image","page_image_free"))
                         
                        )
                  			and ll_lang="te")
		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 in (select cl_from from tewiki_p.categorylinks where cl_to = 'బొమ్మలు_కావలసిన_వ్యాసాలు')

order by p1.page_title
SQL

Checking query status...
