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
from page pa
inner join langlinks ll on ll.ll_from = pa.page_id
where pa.page_namespace = 0 
and pa.page_title like 'A%'/* 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 
  where ll.ll_lang = "ta"
)
and pa.page_id not in 
(
select ll_from
from langlinks 
  where ll.ll_lang = "te"
)
order by pa.page_title

SQL

Checking query status...