PAS upload count

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.

SQL

-- 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_%';

AخA
 
-- 2019 update for actorUSE 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_actorWHERE actor_name="Fæ"    AND img_name LIKE '%FindID_%';

SQL

Checking query status...