Smallest files and largest photos on Commons

SQL

SELECT * FROM image
WHERE img_size < 50
ORDER BY img_size ASC
LIMIT 100;

SELECT * FROM image
WHERE img_size > 1000000000
AND img_name NOT LIKE "%.webm"
AND img_name NOT LIKE "%.ogv"
AND img_name NOT LIKE "%.mpg"
AND img_name NOT LIKE "%.pdf"
AND img_name NOT LIKE "%.stl"
ORDER BY img_size DESC
LIMIT 100;


SELECT *, (img_width*img_height) AS resolution FROM image
WHERE img_size > 2000000000
AND img_name NOT LIKE "%.webm"
AND img_name NOT LIKE "%.ogv"
AND img_name NOT LIKE "%.mpg"
AND img_name NOT LIKE "%.pdf"
AND img_name NOT LIKE "%.stl"
ORDER BY resolution DESC
LIMIT 100;

SQL

Checking query status...