Commons:Database reports/Resolution upgrade needed/H

Some images are widely used across projects, often thanks to being uploaded many years ago, but are (still) at low resolutions. This page attemps to make a list of candidates for resolution upgrade, considering JPG images and number of projects using them. The size is divided by the number of usages under the assumption that quality should be proportional to importance. Last update at {{{1}}}.

sql query used

-- 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;

File	Size	Spread