USE fawiki_p;

SELECT DISTINCT concat('#[[',page_title,']]'), frst.cl_to

FROM categorylinks AS frst INNER JOIN page ON frst.cl_from=page_id and page_namespace=0

WHERE frst.cl_to LIKE 'زادگان%'

AND frst.cl_to NOT LIKE '%قمری%'

AND frst.cl_to NOT LIKE '%میلادی%'

AND frst.cl_to REGEXP '[۰۱۲۳۴۵۶۷۸۹]+'

AND frst.cl_from IN (

  SELECT cl_from

  FROM categorylinks AS scnd

  WHERE scnd.cl_to LIKE 'زادگان%'

  AND scnd.cl_to NOT LIKE '%قمری%'

  AND scnd.cl_to NOT LIKE '%میلادی%'

  AND scnd.cl_to REGEXP '[۰۱۲۳۴۵۶۷۸۹]+'

  AND frst.cl_to <>scnd.cl_to

) order by 1

;