User:Ilmari Karonen/Queries/?

From Wikimedia Commons, the free media repository
Jump to: navigation, search
-- 2> /dev/null; date; echo '
/* Problematic URL characters
 * Runtime: 8 minutes <SLOW_OK>
 */
SELECT CONCAT("* [[:File:", REPLACE(REPLACE(img_name, "_", " "), "&", "&amp;"), "]]") AS ""
FROM image
WHERE img_name REGEXP "[[:cntrl:]#?\\\\/]"
ORDER BY img_timestamp
;-- ' | mysql -ch dewiki-p.userdb commonswiki_p > ~/public_html/temp/logs/badimgnames.txt; date;

File names with question marks on Commons, as of 2013-08-24.