Resurrection and Reincarnation

SQL

USE fawiki_p;
SELECT page_title, page_namespace
FROM categorylinks AS frst INNER JOIN page ON frst.cl_from=page_id
WHERE frst.cl_to LIKE '%زادگان%'
AND frst.cl_to NOT LIKE '%زادگان_دهه%'
AND frst.cl_to NOT LIKE '%زادگان_سده%'
AND frst.cl_to NOT LIKE '%قمری%'
#AND frst.cl_to REGEXP '[۱-۹]'
AND (
  frst.cl_to LIKE '%۱%'
  OR frst.cl_to LIKE '%۲%'
  OR frst.cl_to LIKE '%۳%'
  OR frst.cl_to LIKE '%۴%'
  OR frst.cl_to LIKE '%۵%'
  OR frst.cl_to LIKE '%۶%'
  OR frst.cl_to LIKE '%۷%'
  OR frst.cl_to LIKE '%۸%'
  OR frst.cl_to LIKE '%۹%'
  OR frst.cl_to LIKE '%۰%'
)
AND frst.cl_from IN (
  SELECT cl_from
  FROM categorylinks AS scnd
  WHERE scnd.cl_to LIKE '%زادگان%'
  AND scnd.cl_to NOT LIKE '%زادگان_دهه%'
  AND frst.cl_to NOT LIKE '%زادگان_سده%'
  AND frst.cl_to NOT LIKE '%قمری%'
#  AND scnd.cl_to REGEXP '[۱-۹]'
  AND (
    scnd.cl_to LIKE '%۱%'
    OR scnd.cl_to LIKE '%۲%'
    OR scnd.cl_to LIKE '%۳%'
    OR scnd.cl_to LIKE '%۴%'
    OR scnd.cl_to LIKE '%۵%'
    OR scnd.cl_to LIKE '%۶%'
    OR scnd.cl_to LIKE '%۷%'
    OR scnd.cl_to LIKE '%۸%'
    OR scnd.cl_to LIKE '%۹%'
    OR scnd.cl_to LIKE '%۰%'
  )
  AND frst.cl_to <>scnd.cl_to
)
;
SQL

Checking query status...
