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 DISTINCT
  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 IN ("Categories_requiring_temporary_diffusion",
                "Categories_requiring_permanent_diffusion_to_zero",
                "Categories_requiring_permanent_diffusion")
AND cat_files > 0
AND page_namespace = 14;

SQL

Checking query status...