jawp: File names that blacklisted on commons

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
)
limit 10
SQL

Checking query status...
