Untitled query #51131

SQL

SELECT REPLACE(dplacat.cl_to,"_", " ") as "Category", COUNT(dplacat.cl_from) AS "Links"
FROM commonswiki_p.page P
 JOIN commonswiki_p.categorylinks dplacat ON P.page_id = dplacat.cl_from
 WHERE dplacat.cl_to = "Media_contributed_by_the_Digital_Public_Library_of_America"
  AND P.page_namespace = 6
  
SELECT REPLACE(dplacat.cl_to,"_", " ") as "Category", COUNT(dplacat.cl_from) AS "Links"
FROM commonswiki_p.page P
 JOIN commonswiki_p.categorylinks dplacat ON P.page_id = dplacat.cl_from
 WHERE dplacat.cl_to = "Media_contributed_by_Digital_Commonwealth"
  AND P.page_namespace = 6
SQL

Checking query status...
