Double file extensions

SQL

-- 2> /dev/null; date; echo '
/* Double file extensions
 * License: Public Domain
 * Run time: 20 minutes <SLOW_OK>
 */
USE commonswiki_p;
SELECT CONCAT("* {{/link|File:", REPLACE(REPLACE(page_title, "_", " "), "=", "&#61;"), "}}") AS Filename
FROM page
WHERE page_namespace=6 AND page_is_redirect=0
AND CONVERT(page_title USING utf8) REGEXP "\\.(djvu|gif|jpeg|jpg|flac|mid|wav|ogg|oga|ogv|pdf|png|svg|tif[^f]|tiff|xcf|webm)."
AND CONVERT(page_title USING utf8) NOT REGEXP "/|\\.webm[sh]d\\.webm$|\\.oggtheora\\.og[agv]$|\\.oggvorbis\\.ogg$"
ORDER BY
  /* .TIFFany at bottom */
  CONVERT(page_title USING utf8) REGEXP "\\.(djvu|gif|jpe?g|flac|mid|wav|og[agv]|pdf|png|svg|tiff?|xcf|webm)[^[:alpha:]]" DESC,
  /* .svg.png or .jpeg.jpg at top */
  page_title REGEXP "\\.[[:alpha:]]{3,4}\\.[[:alpha:]]{3,4}$" DESC,
  /* Separate R0012131.JPG (8332852801).jpg */
  LENGTH(page_title)>24 AND LOCATE(".", REVERSE(page_title), 6) > 16,
  /* ASCIIbetical sort */
  BINARY page_title
;-- ' | sql commonswiki_p > ~/public_html/logs/dblextension.txt; date;
SQL

Checking query status...
