Replicas browser and optimizer
NYPL upload count
This query is marked as a draft
This query has been published
This count based purely on filename and uploader (me) and is a handy guide to the total size of the mass upload. It excludes uploads to the main PAS category that were not uploaded by Fæ, as there were around 1,200 already uploaded from the Finds database before the upload project started. Used at https://commons.wikimedia.org/wiki/User:Fæ/Project_list/PAS.
-- 2019 update for actor USE commonswiki_p; SELECT COUNT(img_name) AS Count, ROUND(SUM(img_size/(1<<30))) AS Size_GB, LEFT(MAX(img_timestamp),8) AS Date FROM image JOIN actor_image on actor_id = img_actor WHERE actor_name="Fæ" AND img_name LIKE '%FindID_%';
By running queries you agree to the
and you irrevocably agree to release your SQL under
All SQL code is licensed under
Checking query status...
Report a bug!
Wikimedia Cloud VPS
, written in