The total file size under the Library Back-Up Project on Wikimedia Commons

SQL

#chatGPT

SELECT
  IFNULL(cl.cl_to, 'Total') AS Category,
  COUNT(*) AS LikeCount,
  SUM(CAST(i.img_size AS SIGNED) / POWER(10, 12)) AS TotalFileSizeTB
FROM
  page AS p
  JOIN categorylinks AS cl ON p.page_id = cl.cl_from
  JOIN image AS i ON p.page_title = i.img_name
WHERE
  cl.cl_to IN (
    SELECT page_title
    FROM categorylinks
    JOIN page ON page_id = cl_from
    WHERE (cl_to = 'Library_back_up_project' OR cl_to = 'National_Library_of_China_Category') -- Add the category for the National Library of China
      AND page_namespace = 14
  )
  AND p.page_namespace = 6
GROUP BY cl.cl_to WITH ROLLUP;

SQL

Checking query status...