Enwiki Pages with many Indic wikipedia links but without Te link

SQL

USE enwiki_p;

SELECT 
    count(*) ll_count, 
    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_id in (select ll_from from langlinks where ll_lang = 'ta') and
    page_id in (select ll_from from langlinks where ll_lang = 'hi') and
    page_id in (select ll_from from langlinks where ll_lang = 'bn') and
    page_id in (select ll_from from langlinks where ll_lang = 'ml') and
    page_id in (select ll_from from langlinks where ll_lang = 'mr') and
    page_id in (select ll_from from langlinks where ll_lang = 'pa') and
    page_id in (select ll_from from langlinks where ll_lang = 'kn') and
    page_namespace = 0
  GROUP BY
    page_id
  ORDER BY 
    ll_count desc, page_title
  LIMIT 1000
SQL

Checking query status...
