https://bugzilla.wikimedia.org/show_bug.cgi?id=59263
Web browser: --- Bug ID: 59263 Summary: DBQ-10 Need a list of all full length songs on Wikimedia Commons Product: Tool Labs tools Version: unspecified Hardware: All OS: All Status: NEW Severity: minor Priority: Unprioritized Component: Database Queries Assignee: wmf.bugconver...@gmail.com Reporter: wmf.bugconver...@gmail.com Classification: Unclassified Mobile Platform: --- 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 <dan...@brightbyte.de> ------------------------------------------------------------------------------- From: Mark Pellegrini <mapellegr...@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. -- You are receiving this mail because: You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l