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 '\P{L}*\.[^.]+'
OR img_name REGEXP '\P{L}*(small|medium|large)\)?\.[^.]+';

SQL

Checking query status...