Wikipedia:WikiProject Women in Red/Redlinks/W

{{Database report

|sql=

WITH names AS (

WITH RECURSIVE deepcat (subcat, depth) AS

(

SELECT CAST('Feminine_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 "%eminine%"

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 LIKE "W%" /* 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 LIKE "W%" /* 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>=5

ORDER BY LinkCount DESC, Target

|wikilinks= 1,3,4

|excerpts=

|comments=

|interval=

|table_style=

|pagination=

|max_pages=

}}

class="wikitable sortable" style="overflow-wrap: anywhere"
scope="col" \| Target ! scope="col" \| LinkCount ! scope="col" \| ExampleLink1 ! scope="col" \| ExampleLink2
Willow Springs Speedway \| 41 \| Al Tasnady \| Willard Cantrell
Wakana Natori \| 9 \| Gingham Check \| Suzukake Nanchara
Wakako Shimazaki \| 7 \| All-Star Thanksgiving \| Wakako
Whitney A. Stone \| 7 \| Acorn Stakes \| Top Flight Stakes
Willow Creek Association \| 7 \| Amway \| Willow Creek
Wendy Becker \| 6 \| Bridget Becker \| World Senior Curling Championships
Wendy Chai \| 6 \| Anugerah Sukan Negara \| World Ranking Masters
Wendy Gorling \| 6 \| BC Entertainment Hall of Fame \| Vancouver Playhouse production history
Wilhelmina Raab \| 6 \| Boris Godunov (opera) \| Vakula the Smith
Winnie Young \| 6 \| Dolce Vita (TV programme) \| Wong Fei Hung – Master of Kung Fu
Wakako Sakai \| 5 \| Battle of Okinawa (film) \| Wakako
Wendy Currie \| 5 \| Barbara Jones-Gordon \| Superstore Monctonian Challenge
Wendy Elizabeth Cooper \| 5 \| Diploglottis alaticarpa \| Zanthoxylum rhetsa
Wendy Gifford \| 5 \| Special Branch (TV series) \| The Wednesday Play
Wendy Taylor (badminton) \| 5 \| Graham Hurrell \| Peter Jeffrey (badminton)
Whitney Ganz \| 5 \| Chip Ganassi \| Mid-Ohio Sports Car Course
Whitney Hui \| 5 \| Ghetto Justice II \| Tracy Chu
Whitney Jenkins \| 5 \| Dave Jones Mayflower Cashspiel \| Superstore Monctonian Challenge
Willa Gibbs \| 5 \| List of Ace miscellaneous letter-series single titles \| Louis XVII
Willa Paskin \| 5 \| Lesley Arfin \| Whitney (TV series)
Winifred Kersey \| 5 \| 1889 women's tennis season \| Suffolk Championships
Winnie Branson \| 5 \| Charles Duguid \| Vince Copley

class="wikitable sortable" style="overflow-wrap: anywhere"

scope="col" | Target

! scope="col" | LinkCount

! scope="col" | ExampleLink1

! scope="col" | ExampleLink2

Willow Springs Speedway

| 41

| 9