SQL
x
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;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.