NLC Count - Quarry

Count the number of files and the total sizes of collections uploaded to Commons from NLC as listed at [[c:Commons:Library_back_up_project]].

SQL

# DESCRIBE page;
select substring(img_name, 4,3) as db, count(*), sum(img_size) from image where img_actor = 26878372 and img_name LIKE "NLC%" group by db;
select "NLC Total" as "#", count(*), sum(img_size) from image where img_actor = 26878372 and img_name LIKE "NLC%";
select "WZLib Total" as "#", count(*), sum(img_size) from image where img_actor = 26878372 and img_name LIKE "WZLib-%";
select "ZJLib Total" as "#", count(*), sum(img_size) from image where img_actor = 26878372 and img_name LIKE "ZJLib-%";
select "Bot Total" as "#", count(*), sum(img_size) from image where img_actor = 26878372;
select "Commons Total" as "#", count(*), sum(img_size) from image;

SQL

Checking query status...