Untitled query #56191

SQL

select p.page_title, count(p.page_title) as pagecount1 from page p
where p.page_id in (select il_from from imagelinks where il_from_namespace=0)
-- and p.page_id in (select tl_from from templatelinks,page p2 where p2.page_title=tl_title and p2.page_namespace=10 and tl_from_namespace=0 and tl_namespace=10 and p2.page_id in (select il_from from imagelinks where il_from_namespace=10))
and p.page_namespace=0
and p.page_title in (select p1.page_title from page p1,templatelinks where p1.page_namespace = 1 and tl_from=page_id and tl_title = "బొమ్మ_అభ్యర్థన")
group by p.page_title
having count(p.page_title)>0
SQL

Checking query status...
