Most wanted articles for Women in Red: B

SQL

SELECT pl_title Target, SUM(Pr.page_title IS NULL) LinkCount
FROM pagelinks
LEFT JOIN page Pr ON Pr.page_namespace=0 AND Pr.page_title=pl_title
JOIN page Pn ON Pn.page_namespace=0 AND Pr.page_title=SUBSTRING_INDEX(pl_title, "_", 1)
JOIN categorylinks ON cl_from=Pn.page_id AND cl_type="page" AND cl_to="Feminine_given_names"
WHERE pl_from_namespace IN (0, 10) AND pl_namespace=0 AND pl_title LIKE "Ba%" AND pl_title REGEXP "^\\p{Lu}\\p{Ll}+(_\\p{Lu}\\p{Ll}+)+(_\(.*\))?$"
GROUP BY Target
HAVING MAX(pl_from_namespace) = 0 AND LinkCount>=10
ORDER BY LinkCount DESC
/*

SELECT pl_title Target, SUM(page_title IS NULL) LinkCount
FROM categorylinks
WHERE cl_to="Feminine_given_names" AND cl_type="page"
JOIN page Pn ON Pn.page_id=cl_from AND Pn.page_namespace=0 AND page_title LIKE "B%"
JOIN pagelinks ON pl_from_namespace IN (0, 10) AND pl_namespace=0
 AND pl_title LIKE "B%" AND pl_title REGEXP CONCAT(pl_title,"^\\p{Lu}\\p{Ll}+(_\\p{Lu}\\p{Ll}+)+(_\(.*\))?$"
LEFT JOIN page ON page_namespace=0 AND page_title=pl_title
WHERE pl_from_namespace IN (0, 10) AND pl_namespace=0 AND pl_title LIKE "Ba%" AND pl_title REGEXP "^\\p{Lu}\\p{Ll}+(_\\p{Lu}\\p{Ll}+)+(_\(.*\))?$"
GROUP BY Target
HAVING MAX(pl_from_namespace) = 0 AND LinkCount>=10
ORDER BY LinkCount DESC
Category:Feminine given names*/
SQL

Checking query status...
