USE commonswiki_p;

SELECT Concat('https://commons.wikimedia.org/wiki/File:', img_name) AS 'URL', img_name, img_size, img_width, img_height, img_media_type, img_minor_mime  FROM image 

WHERE (img_width * img_height * 3) < img_size AND img_media_type = 'BITMAP'

AND (img_height + img_width) < 8000

AND img_minor_mime != 'gif' AND img_minor_mime != 'tiff' AND img_minor_mime != 'vnd.djvu' AND img_minor_mime != 'png'

AND img_minor_mime != 'x-xcf' 

ORDER BY img_size DESC

LIMIT 1;

​

​