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 > 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 resolution DESC
LIMIT 100;

SELECT *, (img_width*img_height) AS resolution FROM image
WHERE 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"
AND img_name NOT LIKE "%.svg"
AND (img_width*img_height) > 2000000000
ORDER BY (img_width*img_height) DESC
LIMIT 100;
SQL

Checking query status...
