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

This query is marked as a draft This query has been published by 維基小霸王.

https://commons.wikimedia.org/wiki/Commons:Library_back_up_project

SQL

USE commonswiki_p;

SELECT
  COUNT(*) AS LikeCount,
  SUM(CAST(img_size AS SIGNED))*0.000000000001  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 = "Books_from_NDL_digital_collection" OR cl.cl_to = "Scans_from_the_National_Archives_of_Japan_Digital_Archive")
  AND p.page_namespace = 6; -- Assuming file information is in the File namespace (namespace 6)

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...