Wikipedia:WikiProject Women in Red/Redlinks/I: Difference between revisions
Encountered error in updating database report: web triggered, overwriting rest of page as end template not found |
m Update query to work around removal of useful columns from pagelinks table (via WP:JWB) |
||
| Line 18: | Line 18: | ||
JOIN page ON page_id = cl_from AND page_namespace = 0 AND page_title LIKE "I%" /* If changed, needs a matching change 7 lines below */ |
JOIN page ON page_id = cl_from AND page_namespace = 0 AND page_title LIKE "I%" /* If changed, needs a matching change 7 lines below */ |
||
) |
) |
||
SELECT |
SELECT lt_title Target, SUM(Pt.page_title IS NULL) LinkCount, MIN(Pf.page_title) ExampleLink1, MAX(Pf.page_title) ExampleLink2 |
||
FROM |
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= |
LEFT JOIN page Pt ON Pt.page_namespace=0 AND Pt.page_title=lt_title |
||
JOIN names ON name=SUBSTRING_INDEX( |
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)") |
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 |
WHERE lt_namespace=0 AND lt_title LIKE "I%" /* If changed, needs a matching change 7 lines above */ |
||
AND |
AND lt_title REGEXP "^\\p{Lu}\\p{Ll}+_(\\p{Lu}(\\p{Ll}+_{{!}}\\._?))*\\p{Lu}\\p{Ll}+(_\\(.*\\))?$" |
||
GROUP BY Target |
GROUP BY Target |
||
HAVING MAX(pl_from_namespace) = 0 AND LinkCount>=5 |
HAVING MAX(pl_from_namespace) = 0 AND LinkCount>=5 |
||
Latest revision as of 16:45, 9 July 2024
|
| |
|
Welcome to WikiProject Women in Red (WiR). Our objective is to turn red links into blue ones. Our scope is women's biographies, women's works, and women's issues, broadly construed. This list of red links is intended to serve as a basis for creating new articles on the English Wikipedia. Please note however that the red links on this list may well not be suitable as the basis for an article. All new articles must satisfy Wikipedia's notability criteria with reliable independent sources. |
|
- This table lists women beginning with I for whom English Wikipedia lacks a biography article.
- It includes titles with five or more incoming redlinks which begin with a feminine 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 further details, see Wikipedia:WikiProject Women in Red/Redlist index#Alphabetical.
- It was generated by SDZeroBot using {{Database report}} for WikiProject Women in Red.
- The list is not refreshed automatically. Clicking the link on the right requests a bot to do so.
This table is generated by querying the database replica by a bot.
Edits made within the table area will be removed on the next update!
[SQL Error: ER_BAD_FIELD_ERROR: Unknown column 'pl_title' in 'field list' – Consider using Quarry to to test your SQL.]