Files with duplicate extensions

SQL

SELECT CONCAT('[[:File:', REPLACE(img_name, '_', ' '), ']]') AS FILE FROM image
WHERE LOWER(img_name) LIKE '%.png.png'
OR LOWER(img_name) LIKE '%.jpg.jpg'
OR LOWER(img_name) LIKE  '%.svg.svg'
OR img_name LIKE '%.mid.mid'
OR img_name LIKE '%.bmp.bmp'
OR LOWER(img_name) LIKE '%.gif.gif'
OR img_name LIKE '%.ogg.ogg'
OR img_name LIKE '%.png.png'
OR LOWER(img_name) LIKE '%.jpeg.jpeg'
OR img_name LIKE '%.pdf.pdf'
OR img_name LIKE '%.ogv.ogv'
OR LOWER(img_name) LIKE '%.tif.tif'
OR img_name LIKE '%.tiff.tiff'
OR img_name LIKE '%.mp3.mp3'
LIMIT 100

SQL

Checking query status...