User:Astronautics~enwiki/weirdmedia

This is a list of "weird" media files on en.wikipedia.org as of today: silsor 01:55, Oct 15, 2004 (UTC)

SELECT * FROM image WHERE img_name NOT LIKE "%.png" AND img_name NOT LIKE "%.PNG" AND img_name NOT LIKE "%.jpg" AND img_name NOT LIKE "%.JPG" AND img_name NOT LIKE "%.ogg" AND img_name NOT LIKE "%.OGG" AND img_name NOT LIKE "%.txt" AND img_name NOT LIKE "%.TXT" AND img_name NOT LIKE "%.mp3" AND img_name NOT LIKE "%.MP3" AND img_name NOT LIKE "%.jpeg" AND img_name NOT LIKE "%.JPEG" AND img_name NOT LIKE "%.html" AND img_name NOT LIKE "%.HTML" AND img_name NOT LIKE "%.gif" AND img_name NOT LIKE "%.GIF" AND img_name NOT LIKE "%.svg" AND img_name NOT LIKE "%.SVG" AND img_name NOT LIKE "%.mid" AND img_name NOT LIKE "%.MID" AND img_name NOT LIKE "%.bmp" AND img_name NOT LIKE "%.BMP" AND img_name NOT LIKE "%.htm" AND img_name NOT LIKE "%.HTM" AND img_name NOT LIKE "%.wav" AND img_name NOT LIKE "%.WAV" AND img_name NOT LIKE "%.mng" AND img_name NOT LIKE "%.MNG" ORDER BY img_timestamp LIMIT 200

 sed -e "s/ \(.*\)<\/td>/  \<\/td>/" 