Untitled query #58254

SQL

set @cat:= "Indian_sportspeople";
SELECT 
    distinct (concat("[[:en:",page_title,"|",page_title,"]]")) Title_en
FROM
    page, langlinks
  WHERE
    ll_from = page_id and
    page_id not in (select ll_from from langlinks where ll_lang = 'te') and
    page_namespace = 0 and
    page_is_redirect=0 and
    page_id in (select cl_from from categorylinks where (cl_to = @cat
  			OR
  				cl_to IN (select page_title from page inner join categorylinks on cl_from = page_id where cl_to = @cat 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 = @cat 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 = @cat and cl_type = 'subcat' ) and cl_type = 'subcat' ) and cl_type = 'subcat' )
                                                         ))

  ORDER BY 
    page_title
SQL

Checking query status...
