Tewiki:Infobox related (have and have nots) pages

SQL

set @vargam:="ప్రజలు";
SELECT distinct page_title FROM page p1
where 
p1.page_id in (select tl_from from templatelinks, linktarget 
                      where 
                   			lt_id=tl_target_id
                   		and tl_from_namespace =0 
                      	and (lt_title like "%సమాచారపెట్టె%" or lt_title like "%Infobox%" or lt_title like "సినిమా"))
	and p1.page_is_redirect=0
	and page_id not in (select pp_page from page_props where pp_propname="disambiguation") 
	and page_namespace = 0
    and p1.page_id in (select cl_from from categorylinks
                       where cl_to=@vargam
    		or	cl_to IN (select page_title from page inner join categorylinks on cl_from = page_id where cl_to = @vargam 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 = @vargam and cl_type = 'subcat' ) 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 in (select page_title from page inner join categorylinks on cl_from = page_id where cl_to = @vargam and cl_type = 'subcat' ) and cl_type = 'subcat' ) 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 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 = @vargam and cl_type = 'subcat' ) and cl_type = 'subcat' ) and cl_type = 'subcat' ) 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 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 in (select page_title from page inner join categorylinks on cl_from = page_id where cl_to = @vargam and cl_type = 'subcat' ) and cl_type = 'subcat' ) and cl_type = 'subcat' ) and cl_type = 'subcat' ) and cl_type = 'subcat' )
  				)
order by p1.page_title
SQL

Checking query status...
