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%") 
and pa.page_title not like ("%చిత్రా%") 
and pa.page_title not like ("%మూస%") 
and pa.page_title not like ("%నియోజకవ%") 
and pa.page_title not like ("%వ్యాసాలు%") 
and pa.page_title not like ("ఆంధ్ర%") 
and pa.page_title not like ("తెలంగాణ%") 
and pa.page_title NOT like ("%మహిళా%") 
and pa.page_title NOT like ("%మహిళలు") 
and pa.page_title not like ("%ప్రజలు") 
and pa.page_title not like ("%వ్యక్తులు") 
and pa.page_title not like ("%జిల్లా%")
and page_title not like ("%మండలాలు") 
and page_title not like ("%జిల్లాలు") 
and page_title not like ("%పేజీలు") 
and page_title not like ("ఈ_వార%") 
and page_title not like ("%వికీపీడియా%") 
and page_title not like ("%ఒలింపిక్%") 
and page_title  not like ("%ఒలింపిక్స్%") 
and page_title not like ("%క్రీడ%")
and page_title  not like ("%ఆట%") 
and page_title  not like ("%ఫుట్‌బాల్%") 
and page_title  not like ("%అథ్లెటిక్స్%") 
and page_title  not like ("%కప్%")
and page_title not like ("%కప్పు%") 
and page_title not like ("%క్రీడాకారులు")
and page_title  not like ("%ప్లేయర్లు")
and page_title  not like ("%క్రికెటర్లు") 
and page_title  not like ("%ఆటగాళ్ళు") 
and page_title not like ("%క్రికెట్%")
and page_title not like ("%వికీప్రాజెక్టు%")
and page_title not like ("%ప్రాజెక్టు%")
and page_title not like ("%వికీ%")
and page_title not like ("%వాడుకరులు%")
and page_title not like ("%వ్యాసము%")
-- and page_title not like ("%వికీ%")
 

order by pa.page_title
-- Limit 100
SQL

Checking query status...
