Categories requiring temporary/permanent diffusion

(when constructed, should print number of files in each subcategory of "Category:Categories requiring temporary/permanent diffusion")

SQL

#describe commonswiki_p.category;
#describe commonswiki_p.categorylinks;
#describe commonswiki_p.page;

SELECT current_date;

# SELECT * from commonswiki_p.category where cat_title = "Categories_requiring_temporary_diffusion" limit 10;

SELECT
  CONVERT(cl_to USING utf8),
  COUNT(*)
FROM categorylinks
JOIN pagelinks ON pl_title = cl_to AND pl_namespace = 14
JOIN page AS p1 ON pl_from = p1.page_id AND p1.page_namespace IN (0, 6, 10, 12, 14, 100)
LEFT JOIN page AS p2 ON cl_to = p2.page_title AND p2.page_namespace = 14
WHERE p2.page_title = "Categories_requiring_temporary_diffusion"
GROUP BY 1 LIMIT 1000;

SQL

Checking query status...