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

SQL

select distinct pa.page_title
from page pa
where pa.page_namespace =  14
and pa.page_id not in
(
select ll_from
from langlinks 
)
and pa.page_title not like ("%గ్రామాలు") 
and pa.page_title not like ("%సినిమా%") 
and pa.page_title not like ("%from%") 
and pa.page_title not like ("1%") 
and pa.page_title not like ("2%") 
and pa.page_title not like ("3%") 
and pa.page_title not like ("4%") 
and pa.page_title not like ("5%") 
and pa.page_title not like ("6%") 
and pa.page_title not like ("7%") 
and pa.page_title not like ("8%") 
and pa.page_title not like ("9%") 

order by pa.page_title
-- Limit 100

SQL

Checking query status...