Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
DannyS712
.
Should be renamed
Toggle Highlighting
SQL
#USE itwiki_p; SELECT CONCAT("File:", img_name) 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' 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 50
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...
