Unbelievable life spans

SQL

SELECT
  page_namespace,
  page_title,
  deathyear
FROM
  (
    SELECT
      page_namespace,
      page_title AS page_title,
      CAST(SUBSTRING_INDEX(cl3.cl_to, '_', 1) AS UNSIGNED) AS deathyear
    FROM
      categorylinks AS cl1
      LEFT JOIN categorylinks AS cl2 ON cl1.cl_from = cl2.cl_from
      AND cl2.cl_to IN ('Longevity_traditions', 'Longevity_claims')
      JOIN categorylinks AS cl3 ON cl1.cl_from = cl3.cl_from
      AND cl3.cl_to REGEXP '^[0-9]+_deaths$'
      JOIN page ON page_id = cl1.cl_from
    WHERE
      cl1.cl_to = CONCAT(1801, '_births')
      AND cl2.cl_from IS NULL
  ) AS BornAndDeads
WHERE
  1801 > deathyear
  OR deathyear - 1801 > 122;
SQL

Checking query status...
