Tewiki: All AP villages without Map in Infobox

SQL

set @dist := "ఆంధ్రప్రదేశ్";
select p1.page_title పేజీ,cl.cl_to వర్గం from page p1,categorylinks cl
where p1.page_id not in (select il_from from imagelinks where il_to ="Andhra_Pradesh_locator_map.svg")
and p1.page_namespace=0
and cl.cl_from=p1.page_id
and cl.cl_to like "%గ్రామాలు"
and p1.page_id in (select cl_from from categorylinks where (cl_to = concat(@dist,'_గ్రామాలు')
                                                                      OR cl_to IN (select page_title from page inner join categorylinks on cl_from = page_id where cl_to = concat(@dist,'_గ్రామాలు') and cl_type = 'subcat' )
                                                            OR cl_to IN (select page_title from page inner join categorylinks on cl_from = page_id where cl_to in (select page_title from page inner join categorylinks on cl_from = page_id where cl_to = concat(@dist,'_గ్రామాలు') and cl_type = 'subcat' ) and cl_type = 'subcat' )
                                                           ))
                        
order by cl.cl_to,p1.page_title
SQL

Checking query status...
