List of portals by wikiproject

SQL

SELECT DISTINCT SUBSTRING(SUBSTRING_INDEX(pl_title, '/', 1) FROM 13) AS project, SUBSTRING_INDEX(page_title, '/', 1) AS portal
FROM pagelinks
JOIN page ON page_id = pl_from
WHERE pl_from_namespace = 101 /* Portal talk: */
AND pl_namespace = 4 /* Wikipedia: */
AND pl_title like "WikiProject_%" ESCAPE "%"
AND pl_title != "WikiProject_" AND pl_title != "WikiProject_Portals" AND pl_title != "WikiProject_assessment"
ORDER BY SUBSTRING(SUBSTRING_INDEX(pl_title, '/', 1) FROM 13), SUBSTRING_INDEX(page_title, '/', 1)

SQL

Checking query status...