file names to be fixed on Commons

SQL

USE commonswiki_p;
SELECT CONCAT ('# [[:File:', REPLACE (page_title,'_',' '), ']]') AS files FROM page
WHERE page_namespace = 6
AND page_is_redirect = 0
#AND (page_title REGEXP '\&..?2.\;'
#  OR page_title REGEXP 'ï¿½'
#  OR page_title REGEXP '¾[ËÆ]')
#AND (page_title REGEXP '[AEIOUNYaeiouny]¦' #OR page_title LIKE '%+ƒ%')
#AND page_title REGEXP '(√Ä|√Å|√Ç|√É|√Ñ|√Ö|√Ü|√á|√à|√â|√ä|√ã|√å|√ç|√é|√è|√ê|√ë|√í|√ì|√î|√ï|√ñ|√ó|√ò|√ô|√ö|√õ|√ú|√ù|√û|√ü)' #MacRoman (U+00C0 - U+00DF)
#AND page_title REGEXP '(√†|√°|√¢|√£|√§|√•|√¶|√ß|√®|√©|√™|√´|√¨|√≠|√Æ|√Ø|√∞|√±|√≤|√≥|√¥|√µ|√∂|√∑|√∏|√π|√∫|√ª|√º|√Ω|√æ|√ø)' #MacRoman (U+00E0 - U+00FF)
#AND page_title REGEXP '(‚Äê|‚Äë|‚Äí|‚Äì|‚Äî|‚Äï|‚Äñ|‚Äó|‚Äò|‚Äô|‚Äö|‚Äõ|‚Äú|‚Äù|‚Äû|‚Äü)' #MacRoman (U+2010 - U+201F)
#AND page_title REGEXP '(√[Ä-ø]|‚Ä[ê-ü]|ƒ[Ä-è])' #?
#AND page_title REGEXP '(?:ƒÄ|ƒÅ|ƒí|ƒì|ƒ™|ƒ´|≈å|≈ç|≈™|≈´)'
AND page_title LIKE '%&_lig;%'
GROUP BY page_title
LIMIT 500;
SQL

Checking query status...
