Tewiki:Articles with images but also have image request on talk pages

SQL

select p.page_title from page p,page p1
where 
p.page_id in (select il_from from imagelinks where il_to like "%_locator_map.svg")
-- p.page_id in (select il_from from imagelinks where il_from_namespace=0)
and p.page_namespace=0
and p1.page_namespace=1
and p1.page_title=p.page_title
-- 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 = "బొమ్మ_అభ్యర్థన")
 and p1.page_id in (select cl_from from categorylinks where cl_to = 'బొమ్మలు_కావలసిన_గ్రామాల_వ్యాసాలు')

SQL

Checking query status...