USE enwiki_p;

SELECT DISTINCT frpage.page_title, frst.cl_to

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

WHERE frst.cl_to LIKE '%_births'

AND frst.cl_to REGEXP '[0-9]+'

AND frst.cl_from IN (

  SELECT DISTINCT cl_from

  FROM categorylinks AS scnd INNER JOIN page As secPage ON scnd.cl_from=secPage.page_id and secPage.page_namespace=0 and secPage.page_is_redirect = 0

WHERE scnd.cl_to LIKE '%_births'

AND scnd.cl_to REGEXP '[0-9]+'

  AND frst.cl_to <>scnd.cl_to

) order by 1

;