User:Certes/Reports/Most-redlinked names
This table lists men beginning with Aa–Am for whom English Wikipedia lacks a biography article.
It includes titles with ten or more incoming redlinks which begin with a masculine given name and resemble a full name.
Titles linked via templates are excluded, and links from titles containing a year number are not counted.
For a similar list of women, see Wikipedia:WikiProject Women in Red/Redlinks/A1. There may be some overlap, as some given names are unisex.
{{Database report
|sql=
WITH names AS (
WITH RECURSIVE deepcat (subcat, depth) AS
(
SELECT CAST('Masculine_given_names' AS VARCHAR(256)), 0
UNION
SELECT page_title, depth + 1
FROM deepcat
JOIN categorylinks ON cl_type = "subcat" AND cl_to = subcat
JOIN page ON page_id = cl_from AND page_namespace = 14 AND page_title LIKE "%asculine%"
WHERE depth < 4
)
SELECT DISTINCT SUBSTRING_INDEX(page_title, "_", 1) AS name
FROM deepcat
JOIN categorylinks ON cl_type = "page" AND cl_to = subcat
JOIN page ON page_id = cl_from AND page_namespace = 0 AND page_title BETWEEN "A" AND "An" /* If changed, needs a matching change 7 lines below */
)
SELECT lt_title Target, SUM(Pt.page_title IS NULL) LinkCount, MIN(Pf.page_title) ExampleLink1, MAX(Pf.page_title) ExampleLink2
FROM linktarget
JOIN pagelinks ON pl_target_id=lt_id AND pl_from_namespace IN (0, 10)
LEFT JOIN page Pt ON Pt.page_namespace=0 AND Pt.page_title=lt_title
JOIN names ON name=SUBSTRING_INDEX(lt_title, "_", 1)
STRAIGHT_JOIN page Pf ON Pf.page_id=pl_from AND NOT (Pf.page_namespace=0 AND Pf.page_title REGEXP "^(.*\\D)?(19{{!}}20)\\d\\d(?!\\d)")
WHERE lt_namespace=0 AND lt_title BETWEEN "A" AND "An" /* If changed, needs a matching change 7 lines above */
AND lt_title REGEXP "^\\p{Lu}\\p{Ll}+_(\\p{Lu}(\\p{Ll}+_{{!}}\\._?))*\\p{Lu}\\p{Ll}+(_\\(.*\\))?$"
GROUP BY Target
HAVING MAX(pl_from_namespace) = 0 AND LinkCount >= 10
ORDER BY LinkCount DESC, Target
|wikilinks= 1,3,4
|excerpts=
|comments=
|interval=
|table_style=
|pagination=
|max_pages=
}}
----
{{Database report/footer|count=138|query_runtime=546.26|last_updated=01:52, 23 October 2024 (UTC)}}