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 "ఆంధ్ర%" OR pa.page_title not like "తెలంగాణ%") 
and (pa.page_title like "%మహిళా%" OR pa.page_title like "%మహిళలు") 




and (pa.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...
