Recherche par type de contenu MIME (fr)

SQL

select a.img_name from frwiki_p.image a
JOIN page ON page_id=img_page
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="wav"  AND img_major_mime="audio" AND img_minor_mime="wav"  AND img_width=0)
OR (img_ext="ogg"  AND img_major_mime="application" AND img_minor_mime="ogg" AND img_media_type="AUDIO" AND img_width=0)
OR (img_ext="ogg"  AND img_major_mime="application" AND img_minor_mime="ogg" AND img_media_type="VIDEO" AND img_width>0)
OR (img_ext="oga"  AND img_major_mime="application" AND img_minor_mime="ogg" AND img_width=0)
OR (img_ext="ogv"  AND img_major_mime="application" AND img_minor_mime="ogg" AND img_width>0)
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="video" AND img_minor_mime="webm" AND img_width>0)
)
ORDER BY 3, 2, 1
SQL

Checking query status...
