Category talk:TIFF files affected by MediaWiki restrictions

From Wikimedia Commons, the free media repository
Jump to navigation Jump to search
-- 2> /dev/null; date; echo '
SELECT /* Runtime: 5 min <SLOW_OK> */
  CONCAT("* [[:File:", REPLACE(img_name, "_", " "), "]]") AS "File"
FROM image
LEFT JOIN page ON page_namespace=6 AND page_title=img_name
LEFT JOIN categorylinks ON cl_from=page_id AND cl_to="TIFF_files_affected_by_MediaWiki_restrictions"
WHERE img_media_type="BITMAP"
AND img_major_mime="image" AND img_minor_mime="tiff"
AND img_width*img_height > 50e6
AND cl_from IS NULL
;-- ' | mysql -ch dewiki-p.userdb commonswiki_p; date

Which shows 182 files are missing from this category. —Dispenser (talk) 03:50, 1 October 2013 (UTC)[reply]