This query is marked as a draft This query has been published by Chaduvari.

SQL

x
 
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 il_from
having count(il_from)>0
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Checking query status...