Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Dominic
.
Toggle Highlighting
SQL
SELECT REPLACE(cl_to, "_", " ") AS "Category", FORMAT(COUNT(img_name), 'N0') AS "File count", ROUND(SUM(img_size/(1<<30))) AS "Size (GB)" FROM page JOIN image ON page_title = img_name JOIN categorylinks ON page_id = cl_from WHERE cl_to = "Flickr_images_reviewed_by_FlickreviewR_2" OR cl_to = "PD_NASA" OR cl_to = "Files_from_NASA_with_known_IDs" OR cl_to = "Images_from_Geograph_Britain_and_Ireland" OR cl_to = "Flickr_images_reviewed_by_FlickreviewR" OR cl_to = "Images_uploaded_by_Fæ" OR cl_to = "Images_from_the_Earth_Science_and_Remote_Sensing_Unit,_Lyndon_B._Johnson_Space_Center" OR cl_to = "Media_contributed_by_the_Digital_Public_Library_of_America" OR cl_to = "Supported_by_Wikimedia_Deutschland" OR cl_to = "Scans_from_the_Internet_Archive" OR cl_to = "Books_uploaded_by_Fæ" OR cl_to = "Media_contributed_by_the_National_Archives_and_Records_Administration" OR cl_to = "Photos_uploaded_from_Flickr_by_Fæ_using_a_script" OR cl_to = "Media_contributed_by_the_National_Archives_and_Records_Administration_via_DPLA" GROUP BY(cl_to) ORDER BY(COUNT(img_name)) DESC
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
.
Checking query status...