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

SQL

USE commonswiki_p;

SELECT
  COUNT(*) AS LikeCount,
  SUM(CAST(img_size AS SIGNED) / (1 << 30)) 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
    WHERE cl_from = (
      SELECT page_id
      FROM page
      WHERE page_title = "Library_back_up_project"
        AND page_namespace = 14 -- Assuming the Library_back_up_project category is in the Category namespace (namespace 14)
    )
  )
  AND p.page_namespace = 6; -- Assuming file information is in the File namespace (namespace 6)

SQL

Checking query status...