Untitled query #1320

SQL

USE fawiki_p;
SELECT page_title, catfa.facats ,cl_to FROM categorylinks join page LEFT JOIN 
(SELECT DISTINCT page_title as fatitle, cl_to as facats FROM categorylinks join page WHERE cl_from = page_id and  
(cl_to like "%اهل_ایران%" or 
cl_to like "%اهل_تهران%" or 
cl_to like "%اهل_شیراز%" or 
cl_to like "%اهل_اصفهان%" or 
cl_to like "%اهل_سمنان%" or 
cl_to like "%اهل_قم%" or 
cl_to like "%اهل_کرج%" or 
cl_to like "%اهل_یزد%" or 
cl_to like "%اهل_دامغان%" or 
cl_to like "%اهل_کرمان%" or 
cl_to like "%اهل_بوشهر%" or 
cl_to like "%اهل_اهواز%" or 
cl_to like "%اهل_بم%" or 
cl_to like "%اهل_همدان%" or 
cl_to like "%اهل_نیشابور%" or 
cl_to like "%اهل_مشهد%" or 
cl_to like "%اهل_تبریز%" or 
cl_to like "%اهل_ارومیه%" or 
cl_to like "%اهل_خرمشهر%" or 
cl_to like "%اهل_زاهدان%" or 
cl_to like "%اهل_ساری%" or 
cl_to like "%اهل_قزوین%" or 
cl_to like "%اهل_رشت%" or 
cl_to like "%اهل_لار%" or 
cl_to like "%اهل_زابل%" or 
cl_to like "%اهل_بابل%") and page_namespace = 0) AS catfa
ON page_title = catfa.fatitle WHERE cl_from = page_id and  (cl_to like "%زادگان%" and cl_to like "%میلادی%") and page_namespace = 0;
SQL

Checking query status...
