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 like "%ఒలింపిక్%" OR page_title  like "%ఒలింపిక్స్%" OR page_title like "%క్రీడ%" 
     OR page_title  like "%ఆట%" OR page_title  like "%ఫుట్‌బాల్%" OR page_title  like "%అథ్లెటిక్స్%" 
     OR page_title  like "%కప్%" OR page_title like "%కప్పు%" or page_title like "%క్రీడాకారులు"
or page_title  like "%ప్లేయర్లు"
or  page_title  like "%క్రికెటర్లు" 
or  page_title  like "%ఆటగాళ్ళు" or page_title like "%క్రికెట్%" 
)
-- and (page_title not like "ఒలింపిక్" OR page_title not like "ఒలింపిక్స్" OR page_title not like "క్రీడ" OR page_title not like "ఆట" OR page_title not like "ఫుట్‌బాల్" OR page_title not like "అథ్లెటిక్స్" OR page_title not like "కప్" OR page_title not like "కప్పు")


order by pa.page_title
-- Limit 100
SQL

Checking query status...
