Tewiki: Enwiki articles in a category (3 levels) without Tewiki link

SQL

set @cat:= "Indian_independence_activists_by_state_or_union_territory";
SELECT 
    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' )
                                                         ))

  GROUP BY
    page_id
  ORDER BY 
    ll_count desc, page_title
  LIMIT 1000
SQL

Checking query status...
