Unbelievable life spans (minimal)

A minimal fix for [[Wikipedia:Database reports/Unbelievable life spans/Configuration]] so it works again.  In pseudo-diff format: removed lines are headed with "--", added lines with "/*++*/".  Uses @param (with '1494' as example data) in place of the usual ? placeholder.

For [[WT:Database reports#Wikipedia:Database reports/Unbelievable life spans]] circa 25 March 2026.  See also query 103644.

SQL

SET @param = '1494';

SELECT
  page_namespace,
  page_title,
  deathyear
FROM
  (
    SELECT
      page_namespace,
      page_title AS page_title,
      CAST(SUBSTRING_INDEX(lt3.lt_title, '_', 1) AS UNSIGNED) AS deathyear
    FROM
      categorylinks AS cl1
      JOIN linktarget AS lt1 ON cl1.cl_target_id = lt1.lt_id
--    LEFT JOIN categorylinks AS cl2 ON cl1.cl_from = cl2.cl_from
--    LEFT JOIN linktarget AS lt2 ON cl2.cl_target_id = lt2.lt_id
--      AND lt2.lt_namespace = 14
--      AND lt2.lt_title IN ('Longevity_traditions', 'Longevity_claims')
      JOIN categorylinks AS cl3 ON cl1.cl_from = cl3.cl_from
      JOIN linktarget AS lt3 ON cl3.cl_target_id = lt3.lt_id
        AND lt3.lt_namespace = 14
        AND lt3.lt_title REGEXP '^[0-9]+_deaths$'
      JOIN page ON page_id = cl1.cl_from
    WHERE
      lt1.lt_namespace = 14
      AND lt1.lt_title = CONCAT(@param, '_births')
--    AND cl2.cl_from IS NULL
/*++*/AND NOT EXISTS
/*++*/(
/*++*/  SELECT 1
/*++*/  FROM categorylinks AS cl2
/*++*/  JOIN linktarget AS lt2 ON cl2.cl_target_id = lt2.lt_id
/*++*/    AND lt2.lt_namespace = 14
/*++*/    AND lt2.lt_title IN ('Longevity_traditions', 'Longevity_claims')
/*++*/  WHERE cl1.cl_from = cl2.cl_from
/*++*/)
  ) AS BornAndDeads
WHERE
  @param > deathyear
  OR deathyear - @param > 122;

SQL

Checking query status...