User:Dispenser/Wrong Extension

From Wikimedia Commons, the free media repository
Jump to: navigation, search
-- 2> /dev/null; date; mysql -ch commonswiki.analytics.db.svc.eqiad.wmflabs commonswiki_p --html <<< '
/* MIME type mismatches file extension
 * 
 * License: Public domain
 * Run time: 14 minutes <SLOW_OK>
 */
SELECT
  CONCAT("[[:File:", REPLACE(img_name, "_", " "), "]]") AS "File",
  img_ext AS "Ext",
  CONCAT(img_major_mime, "/", img_minor_mime, IF(
       img_media_type="AUDIO" AND img_ext IN ("ogv")
    OR img_media_type="VIDEO" AND img_ext IN ("oga", "ogg", "opus")
    OR img_media_type IN ("UNKNOWN", "MULTIMEDIA", "TEXT", "EXECUTABLE", "ARCHIVE"),
    CONCAT(" (", img_media_type, ")"), "")
  ) AS "MIME",
  (SELECT COUNT(DISTINCT oi_minor_mime) FROM oldimage WHERE oi_name=img_name AND oi_minor_mime!=img_minor_mime) AS Conflicts,
  (SELECT COUNT(*) FROM globalimagelinks WHERE gil_to=img_name) AS "Global usage"
FROM (
  SELECT img_name, img_width, img_height,
    SUBSTRING_INDEX(LOWER(CONVERT(img_name USING latin1)), ".", -1) AS img_ext,
    img_media_type, img_major_mime, img_minor_mime,
    IF(img_minor_mime="ogg", SUBSTRING_INDEX(SUBSTRING_INDEX(img_metadata,
       "s:4:\"type\";s:", -1), ";", 1), "") AS img_type
  FROM image
) AS mime_ext
WHERE NOT (
   img_ext="djvu" AND img_major_mime="image" AND img_minor_mime="vnd.djvu"  AND img_width>0
OR img_ext="gif"  AND img_major_mime="image" AND img_minor_mime="gif"       AND img_width>0
OR img_ext="jpeg" AND img_major_mime="image" AND img_minor_mime="jpeg"      AND img_width>0
OR img_ext="jpg"  AND img_major_mime="image" AND img_minor_mime="jpeg"      AND img_width>0
OR img_ext="flac" AND img_major_mime="audio" AND img_minor_mime="x-flac"    AND img_width=0
OR img_ext="mid"  AND img_major_mime="audio" AND img_minor_mime="midi"      AND img_width=0
OR img_ext="mp3"  AND img_major_mime="audio" AND img_minor_mime="mpeg"      AND img_width=0
OR img_ext="wav"  AND img_major_mime="audio" AND img_minor_mime="wav"       AND img_width=0
OR img_ext="oga"  AND img_major_mime="application" AND img_minor_mime="ogg" AND img_width=0 AND img_media_type="AUDIO"
OR img_ext="ogg"  AND img_major_mime="application" AND img_minor_mime="ogg" AND img_width=0 AND img_media_type="AUDIO"
OR img_ext="ogg"  AND img_major_mime="application" AND img_minor_mime="ogg" AND img_width=0
       AND img_media_type="AUDIO" AND img_metadata="4:\"Opus\""
OR img_ext="ogg"  AND img_major_mime="application" AND img_minor_mime="ogg" AND img_width>0 AND img_media_type="VIDEO"
OR img_ext="ogv"  AND img_major_mime="application" AND img_minor_mime="ogg" AND img_width>0 AND img_media_type="VIDEO"
OR img_ext="opus" AND img_major_mime="application" AND img_minor_mime="ogg" AND img_width=0
       AND img_media_type="AUDIO" AND img_metadata="4:\"Opus\""
OR img_ext="pdf"  AND img_major_mime="application" AND img_minor_mime="pdf" AND img_width>0
OR img_ext="png"  AND img_major_mime="image" AND img_minor_mime="png"       AND img_width>0
OR img_ext="svg"  AND img_major_mime="image" AND img_minor_mime="svg+xml"   AND img_width>0
OR img_ext="tif"  AND img_major_mime="image" AND img_minor_mime="tiff"      AND img_width>0
OR img_ext="tiff" AND img_major_mime="image" AND img_minor_mime="tiff"      AND img_width>0
OR img_ext="xcf"  AND img_major_mime="image" AND img_minor_mime="x-xcf"     AND img_width>0
OR img_ext="webm" AND img_major_mime="audio" AND img_minor_mime="webm"      AND img_width=0
OR img_ext="webm" AND img_major_mime="video" AND img_minor_mime="webm"      AND img_width>0
OR img_ext="webp" AND img_major_mime="image" AND img_minor_mime="webp"      AND img_width>0
)
ORDER BY img_major_mime, img_minor_mime, 2, 1
;-- ' > ~/public_html/logs/wrongext-commonswiki.html; date
See also: Files for bots to move, Special:MediaStatistics and Commons:File types
File Ext MIME Conflicts Global usage
File:Fg019-cradle-to-cradle.oga oga application/ogg 0 2
File:Mercury-Redstone 3 - ground audio - 548-AAG.oga oga application/ogg 0 0
File:Angel and the Badman.ogg ogg application/ogg (VIDEO) 0 0
File:MR-73 depart.ogg ogg application/ogg (MULTIMEDIA) 0 0
File:A-class-of-liquid-anode-for-rechargeable-batteries-with-ultralong-cycle-life-ncomms14629-s3.ogv ogv application/ogg 0 0
File:Augmented-AMPK-activity-inhibits-cell-migration-by-phosphorylating-the-novel-substrate-Pdlim5-ncomms7137-s12.ogv ogv application/ogg 0 0
File:Bellignies - Grand Prix des Marbriers, 25 août 2015 (B34A).ogv ogv application/ogg 0 0
File:Burst-Feeding-of-Pelagia-noctiluca-ephyrae-on-Atlantic-Bluefin-Tuna-(Thunnus-thynnus)-Eggs-pone.0074721.s002.ogv ogv application/ogg 0 0
File:Different-Types-of-Door-Opening-Motions-as-Contributing-Factors-to-Containment-Failures-in-Hospital-pone.0066663.s003.ogv ogv application/ogg 0 0
File:Impact-of-Marine-Submergence-and-Season-on-Faunal-Colonization-and-Decomposition-of-Pig-Carcasses-pone.0149107.s002.ogv ogv application/ogg 0 0
File:Inflammasome-dependent-IL-1β-release-depends-upon-membrane-permeabilisation-cdd2015176x5.ogv ogv application/ogg 0 0
File:Inflammasome-dependent-IL-1β-release-depends-upon-membrane-permeabilisation-cdd2015176x6.ogv ogv application/ogg 0 0
File:Light-controlled-assembly-of-silver-nanoparticles-srep45144-s3.ogv ogv application/ogg 0 0
File:Lillers - Grand Prix de Lillers-Souvenir Bruno Comini, 6 mars 2016 (D12A).ogv ogv application/ogg 0 0
File:Metamaterial-bricks-and-quantization-of-meta-surfaces-ncomms14608-s2.ogv ogv application/ogg 0 0
File:Network-analysis-of-time-lapse-microscopy-recordings-Video1.ogv ogv application/ogg 0 0
File:Neutrophil-stunning-by-metoprolol-reduces-infarct-size-ncomms14780-s4.ogv ogv application/ogg 0 0
File:Simple-Display-System-of-Mechanical-Properties-of-Cells-and-Their-Dispersion-pone.0034305.s002.ogv ogv application/ogg 0 0
File:Speed-Dependent-Modulation-of-the-Locomotor-Behavior-in-Adult-Mice-Reveals-Attractor-and-Video1.ogv ogv application/ogg 0 0
File:Speed-Dependent-Modulation-of-the-Locomotor-Behavior-in-Adult-Mice-Reveals-Attractor-and-Video3.ogv ogv application/ogg 0 0
File:Speed-Dependent-Modulation-of-the-Locomotor-Behavior-in-Adult-Mice-Reveals-Attractor-and-Video4.ogv ogv application/ogg 0 0
File:Speed-Dependent-Modulation-of-the-Locomotor-Behavior-in-Adult-Mice-Reveals-Attractor-and-Video7.ogv ogv application/ogg 0 0
File:Sustainably-powering-wearable-electronics-solely-by-biomechanical-energy-ncomms12744-s2.ogv ogv application/ogg 0 0
File:The-AERO-System-A-3D-Like-Approach-for-Recording-Gene-Expression-Patterns-in-the-Whole-Mouse-Embryo-pone.0075754.s002.ogv ogv application/ogg 0 0
File:The-AERO-System-A-3D-Like-Approach-for-Recording-Gene-Expression-Patterns-in-the-Whole-Mouse-Embryo-pone.0075754.s006.ogv ogv application/ogg 0 0
File:Wildbienen 2017 by RaBoe.ogv ogv application/ogg 0 0
File:En-uk-autochthon.opus opus application/ogg (MULTIMEDIA) 0 0
File:Heart Monitor Beep--freesound.org.opus opus application/ogg 0 3
File:Jose Mari Goenaga (aurkezpena).opus opus application/ogg 0 3
File:RES067 Mojib Latif und das Klima.opus opus application/ogg (MULTIMEDIA) 0 3
File:Zh-yue-詐傻.opus opus application/ogg (MULTIMEDIA) 0 0
File:02重刊道藏輯要 亢集.pdf pdf application/pdf 0 0
File:2017 week 30 Daily Weather Map summary NOAA.pdf pdf application/pdf 0 0
File:2017 week 34 Daily Weather Map summary NOAA.pdf pdf application/pdf 0 0
File:Verzeichniß einiger Brüderschaften, die im katholischen Franken im Gange sind.pdf pdf application/pdf 0 6
File:乾隆大藏经 91.pdf pdf application/pdf 0 0
File:3d Printable Barnstar.stl stl application/sla 0 0
File:Asad Al-Lat.stl stl application/sla 0 2
File:Danaid NMSk 1854 (Auguste Rodin) - Nationalmuseum - 76c5c234c6074b13a94bf793c276a509.stl stl application/sla 0 0
File:Nl-OSG de Meergronden-article.ogg ogg audio/wav 0 4
File:16 días de activismo - 16 días WIKI.webm webm audio/webm 0 2
File:1988 stoerche beringung.webm webm audio/webm 0 0
File:2017-08-06 16-46-52 reconst-histo-belfort-webm.webm webm audio/webm 0 0
File:ANC Protesters on a Golden Arrow bus.webm webm audio/webm 0 0
File:Aguacero sobre Valencia, España (13 de junio de 2015).webm webm audio/webm 0 1
File:Aire du Jura - sèche-mains Dyson.webm webm audio/webm 0 0
File:Alveolar-trill-slomo.webm webm audio/webm 0 1
File:Analyse Gespräch 2007 Dortmund.webm webm audio/webm 0 1
File:Autoroute A46 - aires de Mionnay-en-Chatanay puis Mionnay-Ouest.webm webm audio/webm 0 0
File:Boxing in Mitchells Plain.webm webm audio/webm 0 0
File:Corfecastle.webm webm audio/webm 0 0
File:Craft mobile in the Karoo.webm webm audio/webm 0 0
File:David Goldfein attends Israeli Air Force change of command ceremony, August 2017 (DOD 104719379).webm webm audio/webm 0 0
File:Declaraciones del presidente de CLM. Visita del presidente de Israel (38261172021).webm webm audio/webm 0 0
File:Desmond Tutu at the Desmond and Leah Tutu Legacy Foundation.webm webm audio/webm 0 0
File:Facing Defacement - August 2017.webm webm audio/webm 0 0
File:Fire at Freie Waldorfschule Frankfurt October 2017 2.webm webm audio/webm 0 0
File:Flagpole on the Taunton Green with US and Taunton flags (video).webm webm audio/webm 0 0
File:Immerath st-lambertus demolition 2018.webm webm audio/webm 0 0
File:Judo bronze medal for Russian player in Taipei 2017 Summer Universiade (20.08.2017).webm webm audio/webm 0 2
File:Kaapse Klopse.webm webm audio/webm 0 0
File:Loxophyllum meleagris.webm webm audio/webm 0 1
File:Misbehaving 2017 visual wikitext editor.webm webm audio/webm 0 0
File:Moorburg.webm webm audio/webm 0 0
File:Nitinol engine.webm webm audio/webm 0 1
File:Ojciec Mateusz odc. 227.webm webm audio/webm 0 0
File:Pre-schoolers playing in Khayelitsha.webm webm audio/webm 0 0
File:Rolls-Royce Trent XWB-01.webm webm audio/webm 0 0
File:Rotifera.webm webm audio/webm 0 0
File:School children in Mitchells Plain.webm webm audio/webm 0 0
File:Skies over Johannesburg.webm webm audio/webm 0 0
File:Sturm in Aalen 2012.webm webm audio/webm 0 0
File:Taiwan, Tainan - Lioujia tanbo art 2017.webm webm audio/webm 0 3
File:Tame Zebra.webm webm audio/webm 0 0
File:The Riel dance.webm webm audio/webm 0 0
File:The surreptitious assault on privacy, security, and freedom.webm webm audio/webm 0 0
File:Tour of Faithful Word Baptist Church's Building (2017).webm webm audio/webm 0 2
File:Trains - Mini World Lyon.webm webm audio/webm 0 0
File:Understanding the complexity of copyleft defense.webm webm audio/webm 0 0
File:Video Dortmund 2009.webm webm audio/webm 0 0
File:Visita del presidente de Israel (37550353884).webm webm audio/webm 0 0
File:Wassertransferdruck - Vollautomatischer Tauchprozess.webm webm audio/webm 0 0
File:Wikidata Query - Query Helper - Build query from scratch.webm webm audio/webm 0 1
File:Wikipuentes VideoTutores final 16Mbps (1).webm webm audio/webm 0 1
File:Young Europan Hedgehog (2).webm webm audio/webm 0 0
File:Young Europan Hedgehog (3).webm webm audio/webm 0 0
File:Гастротриха.webm webm audio/webm 0 0
File:Движение амебы 2.webm webm audio/webm 0 1
File:Движение амебы.webm webm audio/webm 0 0
File:Десмдиевая водоросль 2.webm webm audio/webm 0 0
File:Десмдиевая водоросль.webm webm audio/webm 0 0
File:Изменение формы амебы.webm webm audio/webm 0 0
File:Инфузория туфелька 2.webm webm audio/webm 0 0
File:Инфузория туфелька.webm webm audio/webm 0 0
File:Инфузория.webm webm audio/webm 0 0
File:Малощетинковый червь (Oligochaeta).webm webm audio/webm 0 0
File:Марла ойлаш тунемына. Мультурок-влак. 5-ше урок.webm webm audio/webm 0 2
File:Шлиф гранита в поляризованном свете.webm webm audio/webm 0 0
File:Эвглена 2.webm webm audio/webm 0 0
File:Эвглена.webm webm audio/webm 0 0
File:Kanhaiya - 1.jpeg jpeg image/jpeg 0 0
File:Kanhaiya - 10.jpeg jpeg image/jpeg 0 0
File:Kanhaiya - 11.jpeg jpeg image/jpeg 0 0
File:Kanhaiya - 12.jpeg jpeg image/jpeg 0 0
File:Kanhaiya - 13.jpeg jpeg image/jpeg 0 0
File:Kanhaiya - 14.jpeg jpeg image/jpeg 0 0
File:Kanhaiya - 15.jpeg jpeg image/jpeg 0 0
File:Kanhaiya - 16.jpeg jpeg image/jpeg 0 0
File:Kanhaiya - 18.jpeg jpeg image/jpeg 0 0
File:Kanhaiya - 2.jpeg jpeg image/jpeg 0 0
File:Kanhaiya - 3.jpeg jpeg image/jpeg 0 0
File:Kanhaiya - 5.jpeg jpeg image/jpeg 0 0
File:Kanhaiya - 8.jpeg jpeg image/jpeg 0 0
File:Kanhaiya - 9.jpeg jpeg image/jpeg 0 0
File:Kanhaiya - 17.jpg jpg image/jpeg 0 0
File:Kanhaiya - 4.jpg jpg image/jpeg 0 0
File:Kanhaiya - 6.jpg jpg image/jpeg 0 0
File:Kanhaiya - 7.jpg jpg image/jpeg 0 0
File:Chicas poderosas (2).svg svg image/svg+xml 0 0
File:Gittermitden-Einheitsvektoren.svg svg image/svg+xml 0 0
File:Island county test.svg svg image/svg+xml 0 1
File:Maricopa county roads test.svg svg image/svg+xml 0 1
File:Miami-Dade County Florida Test.svg svg image/svg+xml 0 1
File:Mobile county test 101.svg svg image/svg+xml 0 1
File:Mohave County Arizona Test.svg svg image/svg+xml 0 1
File:Parque de Vallparadys 4.svg svg image/svg+xml 0 0
File:Pst-geo.svg svg image/svg+xml 0 1
File:SVG Arms - Parthon de Von.svg svg image/svg+xml 0 0
File:Sarasota Florida Test 100.svg svg image/svg+xml 0 3
File:Sarasota Florida Test.svg svg image/svg+xml 0 0
File:Stroke-dasharray chromium bug full.svg svg image/svg+xml 0 0
File:The Intercept logo.svg svg image/svg+xml 0 0
File:Сибирский вестник политики, литературы и общественной жизни 1897 № 012 (16 января).djvu djvu image/vnd.djvu 0 0
File:02d.webm webm video/webm 0 0
File:ALMA Drone.webm webm video/webm 0 0
File:Brzansko-Moraviste-20170720-12h52m-Time-Lapse.webm webm video/webm 0 0
File:Brzansko-Moraviste-Pejzazi 20170415 0157.webm webm video/webm 0 0
File:Solar Tarragona.webm webm video/webm 0 0