-- 2> /dev/null; date; echo '
USE commonswiki_p;
SELECT
  CONCAT("[[:File:", REPLACE(img_name, "_", " "), "]]") AS "File",
  img_size AS "Size",
  CONCAT(img_width, "x", img_height) AS "Resolution",
  DATE_FORMAT(img_timestamp, "%Y-%m-%d") AS "Uploaded",
  ROUND(img_size/COUNT(DISTINCT gil_wiki),1) AS "Spread"
FROM image
JOIN globalimagelinks AS gil ON gil_to=img_name
WHERE img_size BETWEEN 10*1024 AND 1000*1024
/* Use the img_media_mime index */
AND img_media_type="BITMAP" AND img_major_mime="image" AND img_minor_mime="jpeg"
/* Articles only */
AND gil_page_namespace_id = 0
GROUP BY img_name
ORDER BY ROUND(Spread, -1) ASC, img_name
LIMIT 5000;