Foto di it.wiki con prefisso automatico

SQL

USE itwiki_p;
SELECT CONCAT( "# [[:File:", img_name, "]]" )
FROM image
WHERE img_name REGEXP '^CIMG.*'
OR img_name REGEXP '^DCP.*'
OR img_name REGEXP '^DSC.*'
OR img_name REGEXP '^DVC.*'
OR img_name REGEXP '^JD.*'
OR img_name REGEXP '^IMG.*'
OR img_name REGEXP '^P[0-9].*'
OR img_name REGEXP '^PIC.*'
OR img_name REGEXP '^PICT.*'
OR img_name REGEXP '^SAM.*'
OR img_name REGEXP '^SANY.*'
OR img_name REGEXP '^SDC.*'
OR img_name REGEXP '^Snapchat.*'
OR img_name REGEXP '^WhatsApp.*'
OR img_name REGEXP '^Received.*';

SQL

Checking query status...