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
جار الله
.
Toggle Highlighting
SQL
USE arwiki_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
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...