Most wanted articles for Women in Red: B

SQL

WITH names AS (SELECT SUBSTRING_INDEX(page_title, "_", 1) AS name
      FROM categorylinks
      JOIN page ON page_id=cl_from AND page_namespace=0 AND page_title LIKE "B%"
      WHERE cl_type="page" AND cl_to="Feminine_given_names")
SELECT pl_title Target, SUM(page_title IS NULL) LinkCount
FROM pagelinks
LEFT JOIN page ON page_namespace=0 AND page_title=pl_title
JOIN names ON name=SUBSTRING_INDEX(pl_title, "_", 1)
WHERE pl_from_namespace IN (0, 10) AND pl_namespace=0 AND pl_title LIKE "B%"
AND pl_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
SQL

Checking query status...
