#/articles in CAT:LP, and #/those that are footballers - Quarry

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

Identical to queries #33441 and #33442 (except for the updated schema).

Specifically, the first query is the number of pages in the enwiki main namespace that are in [[Category:Living people]]; and the second is the number of those that transclude {{Infobox football biography}}.

For [[WT:RAQ#Proportion of biographies]] circa 12 October 2022.

SQL

SELECT COUNT(*)
FROM categorylinks
JOIN page ON page_id = cl_from
WHERE page_namespace = 0
  AND cl_to = 'Living_people';

SELECT COUNT(*)
FROM page
JOIN templatelinks ON page_id = tl_from
JOIN linktarget ON lt_id = tl_target_id
JOIN categorylinks ON page_id = cl_from
WHERE page_namespace = 0
  AND cl_to = 'Living_people'
  AND lt_namespace = 10
  AND lt_title = 'Infobox_football_biography';

​x
 
SELECT COUNT(*)FROM categorylinksJOIN page ON page_id = cl_fromWHERE page_namespace = 0  AND cl_to = 'Living_people';​SELECT COUNT(*)FROM pageJOIN templatelinks ON page_id = tl_fromJOIN linktarget ON lt_id = tl_target_idJOIN categorylinks ON page_id = cl_fromWHERE page_namespace = 0  AND cl_to = 'Living_people'  AND lt_namespace = 10  AND lt_title = 'Infobox_football_biography';

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...