Count of enwiki pages which have tawiki link but not tewiki link

SQL

use enwiki_p;

select concat("# [[:en:", pa.page_title, "|", pa.page_title, "]]") as wl, count(*) as n
from page pa
inner join langlinks ll on ll.ll_from = pa.page_id
where pa.page_namespace = 0 /* and
pa.page_title in 
(
select pt.page_title
from page pt
inner join categorylinks cl on cl.cl_from = pt.page_id
where pt.page_namespace = 1 and cl.cl_to = "WikiProject_Croatia_articles"
) */ and
pa.page_id in 
(
select ll_from
from langlinks 
group by ll_from
having count(*) >= 100
)
group by pa.page_id, pa.page_title
having count(case when ll.ll_lang = "te" then 1 end) = 0
order by n desc
limit 100;

SQL

Checking query status...