SQL
AخA
USE fawiki_p;SELECT page_title ,cl_to FROM categorylinks join page where page_title IN (SELECT DISTINCT page_title 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) AND cl_from = page_id and (cl_to like "%زادگان%" and cl_to like "%میلادی%") and page_namespace = 0 LIMIT 10;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.