Recherche par type de contenu MIME (fr)

SQL

select a.img_media_type from frwiki_p.image a
WHERE NOT (
   (img_media_type="djvu" AND img_major_mime="image" AND img_minor_mime="vnd.djvu" AND img_width>0)
OR (img_media_type="gif"  AND img_major_mime="image" AND img_minor_mime="gif"  AND img_width>0)
OR (img_media_type="jpeg" AND img_major_mime="image" AND img_minor_mime="jpeg" AND img_width>0)
OR (img_media_type="jpg"  AND img_major_mime="image" AND img_minor_mime="jpeg" AND img_width>0)
OR (img_media_type="flac" AND img_major_mime="audio" AND img_minor_mime="x-flac" AND img_width=0)
OR (img_media_type="mid"  AND img_major_mime="audio" AND img_minor_mime="midi" AND img_width=0)
OR (img_media_type="wav"  AND img_major_mime="audio" AND img_minor_mime="wav"  AND img_width=0)
OR (img_media_type="ogg"  AND img_major_mime="application" AND img_minor_mime="ogg" AND img_media_type="AUDIO" AND img_width=0)
OR (img_media_type="ogg"  AND img_major_mime="application" AND img_minor_mime="ogg" AND img_media_type="VIDEO" AND img_width>0)
OR (img_media_type="oga"  AND img_major_mime="application" AND img_minor_mime="ogg" AND img_width=0)
OR (img_media_type="ogv"  AND img_major_mime="application" AND img_minor_mime="ogg" AND img_width>0)
OR (img_media_type="pdf"  AND img_major_mime="application" AND img_minor_mime="pdf" AND img_width>0)
OR (img_media_type="png"  AND img_major_mime="image" AND img_minor_mime="png" AND img_width>0)
OR (img_media_type="svg"  AND img_major_mime="image" AND img_minor_mime="svg+xml" AND img_width>0)
OR (img_media_type="tif"  AND img_major_mime="image" AND img_minor_mime="tiff" AND img_width>0)
OR (img_media_type="tiff" AND img_major_mime="image" AND img_minor_mime="tiff" AND img_width>0)
OR (img_media_type="xcf"  AND img_major_mime="image" AND img_minor_mime="x-xcf" AND img_width>0)
OR (img_media_type="webm" AND img_major_mime="video" AND img_minor_mime="webm" AND img_width>0)
)
SQL

Checking query status...
