Untitled query #63785

SQL

set @dist := "ప్రకాశం_జిల్లా";
select p1.page_title,cl.cl_to from page p1
where p1.page_title like "%పల్లె"
and p1.page_namespace=0
and p1.page_is_redirect =0
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' )
                                                           ))
                        
order by p1.page_title
SQL

Checking query status...
