Last modified: 2014-01-03 15:22:58 UTC
This issue was converted from https://jira.toolserver.org/browse/DBQ-10. Summary: Need a list of all full length songs on Wikimedia Commons Issue type: Task - A task that needs to be done. Priority: Minor Status: Done Assignee: Daniel Kinzler <daniel@brightbyte.de> ------------------------------------------------------------------------------- From: Mark Pellegrini <mapellegrini@comcast.net> Date: Tue, 22 Jan 2008 03:06:42 ------------------------------------------------------------------------------- We're trying to update http://en.wikipedia.org/wiki/Wikipedia:Sound/list - a list of music available, along with links to composer, and song (it allows us to verify that those articles have media if they are available) In order to do that, we need an authoritative list to compare it to. There is some discussion of the issue here: http://commons.wikimedia.org/wiki/Commons:Village_pump#Making_a_list We need an SQL query that will list all full lengths songs on the Wikimedia commons. It should filter out smaller files (in particular, anything in http://commons.wikimedia.org/wiki/Category:Pronunciation and its subcategories) and videos.
------------------------------------------------------------------------------- From: Daniel Kinzler <daniel@brightbyte.de> Date: Wed, 23 Jan 2008 11:01:49 ------------------------------------------------------------------------------- Here's a list of all long audio files on commons: http://tools.wikimedia.de/~daniel/misc/commonswiki-long-audio.txt Many of them will however be audio-articles from Spoken Wikipedia, audio Wikinews, etc. I don't see a good way to find only music. Note we also have several melodies in MIDI format - those are not included here either. See also http://wiki.ts.wikimedia.org/view/Query_service#long_audio_files_on_commons
This bug was imported as RESOLVED. The original assignee has therefore not been set, and the original reporters/responders have not been added as CC, to prevent bugspam. If you re-open this bug, please consider adding these people to the CC list: Original assignee: daniel.kinzler@wikimedia.de CC list: mapellegrini@comcast.net, daniel.kinzler@wikimedia.de