Wikipedia:WikiProject Women in Red/Redlinks/R1
update for schema change
| ← Previous revision | Revision as of 17:24, 19 April 2026 | ||
| Line 9: | Line 9: | ||
SELECT page_title, depth + 1 |
SELECT page_title, depth + 1 |
||
FROM deepcat |
FROM deepcat |
||
JOIN |
JOIN linktarget ON lt_namespace = 14 AND lt_title = subcat |
||
JOIN categorylinks ON cl_type = "subcat" AND cl_target_id = lt_id |
|||
JOIN page ON page_id = cl_from AND page_namespace = 14 AND page_title LIKE "%eminine%" |
JOIN page ON page_id = cl_from AND page_namespace = 14 AND page_title LIKE "%eminine%" |
||
WHERE depth < 4 |
WHERE depth < 4 |
||
| Line 15: | Line 16: | ||
SELECT DISTINCT SUBSTRING_INDEX(page_title, "_", 1) AS name |
SELECT DISTINCT SUBSTRING_INDEX(page_title, "_", 1) AS name |
||
FROM deepcat |
FROM deepcat |
||
JOIN |
JOIN linktarget ON lt_namespace = 14 AND lt_title = subcat |
||
JOIN categorylinks ON cl_type = "page" AND cl_target_id = lt_id |
|||
JOIN page ON page_id = cl_from AND page_namespace = 0 AND page_title BETWEEN "Ra" AND "Rm" /* If changed, needs a matching change 7 lines below */ |
JOIN page ON page_id = cl_from AND page_namespace = 0 AND page_title BETWEEN "Ra" AND "Rm" /* If changed, needs a matching change 7 lines below */ |
||
) |
) |
||
