English title without Tamil equivalent

SQL

SELECT
  page_title, cl_from
FROM page
JOIN
(SELECT
   cl_to,
   cl_from
 FROM categorylinks
 LEFT JOIN page
 ON cl_to = page_title
 AND page_namespace = 14
 WHERE page_title IS NULL) AS cattmp
ON cattmp.cl_from = page_id
WHERE page_namespace = 0 


#select * from categorylinks where cl_type = "page"
#Select * from page RIGHT JOIN categorylinks on  page_title = cl_to where cl_to = "side_puck"
#Select page_title from page join categorylinks ON page_id = rev_page join where page_namespace = 0 and page_is_redirect =0 and  page_id  in (SELECT cl_from FROM categorylinks) Order by page_touched
LIMIT 10
#Select count(page_title) from page 
#where page_title REGEXP ".+[A-Za-z ].+" and page_namespace=0 and page_title not in (SELECT ll_title FROM langlinks where ll_lang="ta")
#Total 8418902
#Total 6987406
#Total 5863496
#LIMIT 100;
SQL

Checking query status...
