Living people, birth year 1900-1927 - Quarry

This query is marked as a draft This query has been published by Cryptic.

Mainspace pages in [[Category:Living people]] and at least one of [[Category:1900s births]], [[Category:1910s births]], or [[Category:1900 births]]–[[Category:1927 births]].

For [[WP:RAQ#Living people over some age]] circa 21 November 2022.

SQL

SELECT page_title, GROUP_CONCAT(DISTINCT birth.cl_to SEPARATOR ' | ')
FROM page
JOIN categorylinks AS blp ON blp.cl_from = page_id AND blp.cl_to = 'Living_people'
JOIN categorylinks AS birth ON birth.cl_from = page_id
  AND (birth.cl_to LIKE '19%'
       AND birth.cl_to RLIKE '^19([01][0-9]s?|2[0-7])_births$')
WHERE page_namespace = 0
GROUP BY page_title;

AخA
 
SELECT page_title, GROUP_CONCAT(DISTINCT birth.cl_to SEPARATOR ' | ')FROM pageJOIN categorylinks AS blp ON blp.cl_from = page_id AND blp.cl_to = 'Living_people'JOIN categorylinks AS birth ON birth.cl_from = page_id  AND (birth.cl_to LIKE '19%'       AND birth.cl_to RLIKE '^19([01][0-9]s?|2[0-7])_births$')WHERE page_namespace = 0GROUP BY page_title;

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

Checking query status...