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 '%Nini_Novgorod%'
AND page_title REGEXP '√©'
GROUP BY page_title
LIMIT 1000;
SQL

Checking query status...
