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_from=cl_from AND page_namespace=0
      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 "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, Target
SQL

Checking query status...
