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;
use commonswiki_p;
SELECT current_date;

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

SELECT
  page_title,
  cat_files,
  cat_subcats
FROM page
JOIN categorylinks
ON cl_from = page_id
JOIN category
ON cat_title = page_title
WHERE (cl_to = "Categories_requiring_temporary_diffusion"
       OR cl_to = "Categories_requiring_permanent_diffusion")
AND page_namespace = 14;

SQL

Checking query status...