Enwiki Pages with many Indic wikipedia links but without Te link

SQL

USE hiwiki_p;

SELECT 
    concat("[[:en:",page_title,"|",page_title,"]]") title_en,  count(*) ll_count
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...