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 REGEXP '(‚Äô|‚Äì|‚Äú|‚Äù|‚Äî)'
#AND page_title REGEXP '(√Ä|√Å|√Ç|√É|√Ñ|√Ö|√Ü|√á|√à|√â|√ä|√ã|√å|√ç|√é|√è|√ê|√ë|√í|√ì|√î|√ï|√ñ|√ó|√ò|√ô|√ö|√õ|√ú|√ù|√û|√ü)' #MacRoman (U+00C0 - U+00DF)
#AND page_title REGEXP '(√†|√°|√¢|√£|√§|√•|√¶|√ß|√®|√©|√™|√´|√¨|√≠|√Æ|√Ø|√∞|√±|√≤|√≥|√¥|√µ|√∂|√∑|√∏|√π|√∫|√ª|√º|√Ω|√æ|√ø)' #MacRoman (U+00E0 - U+00FF)
GROUP BY page_title
LIMIT 1000;
SQL

Checking query status...
