User:Ilmari Karonen/Queries/?

From Wikimedia Commons, the free media repository
Jump to navigation Jump to 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.

Retrieved from "https://commons.wikimedia.org/w/index.php?title=User:Ilmari_Karonen/Queries/%3F&oldid=102557443"