Quarry

Query	Run
USE commonswiki_p; SELECT img_name, img_timestamp FROM image WHERE...	6 years ago
USE commonswiki_p; SELECT img_name, img_timestamp FROM image WHERE...	7 years ago
USE commonswiki_p; SELECT img_name, img_timestamp FROM image WHERE...	7 years ago
USE commonswiki_p; SELECT img_name, img_timestamp FROM image WHERE...	7 years ago
USE commonswiki_p; SELECT img_name, img_timestamp FROM image WHERE...	7 years ago
USE commonswiki_p; SELECT img_name, img_timestamp FROM image WHERE...	7 years ago
USE commonswiki_p; SELECT img_name, img_timestamp FROM image WHERE...	7 years ago
USE commonswiki_p; SELECT img_name, img_timestamp FROM image WHERE...	7 years ago
USE commonswiki_p; SELECT img_name, img_timestamp FROM image WHERE...	7 years ago
USE commonswiki_p; SELECT img_name, img_timestamp FROM image WHERE...	7 years ago
USE commonswiki_p; SELECT img_name, img_timestamp FROM image WHERE...	7 years ago
USE commonswiki_p; SELECT img_name, img_timestamp FROM image WHERE...	7 years ago
USE commonswiki_p; SELECT img_name, img_timestamp FROM image WHERE...	7 years ago
USE commonswiki_p; SELECT img_name, img_timestamp FROM image WHERE...	7 years ago
USE commonswiki_p; SELECT img_name, img_timestamp FROM image WHERE...	7 years ago
USE commonswiki_p; SELECT img_name, img_timestamp FROM image WHERE...	7 years ago
USE commonswiki_p; SELECT img_name, img_timestamp FROM image WHERE...	7 years ago
USE commonswiki_p; #SELECT COUNT(*), MIN(img_size), MAX(img_size),...	7 years ago
USE commonswiki_p; #SELECT COUNT(*), MIN(img_size), MAX(img_size),...	7 years ago
USE commonswiki_p; #SELECT COUNT(*), MIN(img_size), MAX(img_size),...	7 years ago
USE commonswiki_p; SELECT COUNT(*), MIN(img_size), MAX(img_size),...	7 years ago
USE commonswiki_p; SELECT COUNT(*), AVG(img_size), STDDEV_POP(img_size) FROM...	7 years ago
USE commonswiki_p; SELECT STDDEV_POP(img_size) FROM image WHERE...	7 years ago
USE commonswiki_p; SELECT COUNT(*), AVG(img_size), STDDEV_POP(img_size) FROM...	7 years ago
USE commonswiki_p; SELECT DISTINCT AVG(img_size), STDDEV_POP(img_size) FROM image;	7 years ago
USE commonswiki_p; SELECT DISTINCT AVG(img_size), STDDEV(img_size) FROM image;	7 years ago
USE commonswiki_p; SELECT DISTINCT img_media_type, img_major_mime,...	7 years ago
USE commonswiki_p; SELECT COUNT(*) FROM image WHERE img_media_type='TEXT';	7 years ago
USE commonswiki_p; SELECT COUNT(*) FROM image WHERE img_media_type='EXECUTABLE';	7 years ago
USE commonswiki_p; SELECT COUNT(*) FROM image WHERE img_media_type='ARCHIVE';	7 years ago
USE commonswiki_p; SELECT AVG(img_size) FROM image WHERE img_minor_mime='webm';	7 years ago
USE commonswiki_p; SELECT AVG(img_size) FROM image WHERE img_minor_mime='jpeg';	7 years ago
USE commonswiki_p; SELECT COUNT(*) FROM image WHERE img_minor_mime='jpeg';	7 years ago
USE commonswiki_p; SELECT img_media_type, img_major_mime, img_minor_mime,...	7 years ago
USE commonswiki_p; SELECT img_media_type, img_major_mime, img_minor_mime,...	7 years ago
USE commonswiki_p; SELECT DISTINCT img_media_type, img_major_mime,...	7 years ago
USE commonswiki_p; SELECT DISTINCT img_media_type, img_major_mime,...	7 years ago
USE commonswiki_p; SELECT DISTINCT img_media_type, img_major_mime,...	7 years ago
USE commonswiki_p; SELECT DISTINCT img_media_type, img_major_mime,...	7 years ago
SHOW TABLES FROM commonswiki_p;	7 years ago
USE commons_p; SHOW TABLES FROM commons_p;	7 years ago
USE commons_p; SHOW TABLES FROM commons_p;	7 years ago
SHOW TABLES FROM commons_p;	7 years ago