Untitled query #86176

SQL

SELECT
	p2s.cl_to AS parent_cat,
    SUM(sc.cat_files) AS total_cat_files,
    SUM(sc.cat_subcats) AS total_cat_subcats,
    SUM(sc.cat_pages - sc.cat_files - sc.cat_subcats) AS total_cat_actual_pages
FROM categorylinks p2s
  JOIN page s ON (p2s.cl_from = s.page_id)
  JOIN category sc ON (sc.cat_title = s.page_title)
WHERE p2s.cl_to IN (
  'Photographs_by_F-number'
  'Photographs_by_ISO_speed_rating',
  'Photographs_by_aspect_ratio',
  'Photographs_by_exposure_time',
  'Photographs_by_lens_focal_length'
)
AND s.page_namespace = 14 -- category
GROUP BY p2s.cl_to
SQL

Checking query status...
