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 LIKE '%-rhus%'
  OR page_title LIKE '%hellebk%'
  OR page_title LIKE '%Helsingr%'
  OR page_title LIKE '%helsingr%'
  OR page_title LIKE '%hjstrup%'
  OR page_title LIKE '%hjrring%'
  OR page_title LIKE '%hng-tllse%'
  OR page_title LIKE '%hornbk%'
  OR page_title LIKE '%Kbenhavn%'
  OR page_title LIKE '%kbenhavn%'
  OR page_title LIKE '%Linkping%'
  OR page_title LIKE 'Nrum%'
  OR page_title LIKE '%-nrum%'
  OR page_title LIKE '%Ringkbing%'
  OR page_title LIKE '%ringkbing%'
  OR page_title LIKE 'Sjs-%'
  OR page_title LIKE '%thyborn%'
  OR page_title LIKE '%Gttingen%'
  OR page_title LIKE '%Dsseldorf%'
    )*/
#AND (page_title REGEXP '\&..?2.\;'
#  OR page_title REGEXP 'ï¿½'
#  OR page_title REGEXP '¾[ËÆ]')
AND 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 '(ƒÄ|ƒÅ|ƒí|ƒì|ƒ™|ƒ´|≈å|≈ç|≈™|≈´)'
GROUP BY page_title
LIMIT 1000;
SQL

Checking query status...
