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  like "%క్రీడాకారులు" 
OR page_title  like "%ప్లేయర్లు"
or page_title  like "%క్రికెటర్లు" 
or page_title  like "%ఆటగాళ్ళు") 


order by pa.page_title
-- Limit 100
SQL

Checking query status...
