Files with duplicate extensions

SQL

#USE commonswiki_p;
SELECT CONCAT('[[:File:', REPLACE(img_name, '_', ' '), ']]') AS FILE FROM image
WHERE img_name LIKE '%.png.png'
OR img_name LIKE '%.PNG.PNG'
OR img_name LIKE '%.jpg.jpg'
OR img_name LIKE '%.Jpg.Jpg'
OR img_name LIKE '%.JPG.JPG'
OR img_name LIKE '%.svg.svg'
OR img_name LIKE '%.SVG.SVG'
OR img_name LIKE '%.mid.mid'
OR img_name LIKE '%.MID.MID'
OR img_name LIKE '%.bmp.bmp'
OR img_name LIKE '%.gif.gif'
OR img_name LIKE '%.GIF.GIF'
OR img_name LIKE '%.ogg.ogg'
OR img_name LIKE '%.png.png'
OR img_name LIKE '%.jpeg.jpeg'
OR img_name LIKE '%.Jpeg.Jpeg'
OR img_name LIKE '%.JPEG.JPEG'
OR img_name LIKE '%.pdf.pdf'
OR img_name LIKE '%.ogv.ogv'
OR img_name LIKE '%.tif.tif'
OR img_name LIKE '%.TIF.TIF'
OR img_name LIKE '%.tiff.tiff'
OR img_name LIKE '%.mp3.mp3'
OR img_name LIKE '%.webp.webp'
OR img_name LIKE '%.webm.webm'
OR img_name LIKE '%.wav.wav'
LIMIT 500
SQL

Checking query status...
