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
Semi-Brace
.
Toggle Highlighting
SQL
select * from image as I -- https://commons.wikimedia.org/wiki/MediaWiki:Filename-prefix-blacklist where ( I.img_name like "CIMG%" # Casio or I.img_name like "DSC!_%" escape "!" # Nikon or I.img_name like "DSCF%" # Fuji or I.img_name like "DSCN%" # Nikon or I.img_name like "DUW%" # some mobile phones or I.img_name like "GEDC%" # GE or I.img_name like "IMG%" # generic or I.img_name like "JD%" # Jenoptik or I.img_name like "MGP%" # Pentax or I.img_name like "PICT%" # misc. or I.img_name like "Imagen%" # misc. or I.img_name like "FOTO%" # misc. or I.img_name like "DSC%" # misc. or I.img_name like "SANY%" # Sanyo or I.img_name like "SAM%" # Samsung )
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...