Obsolete:Tool:Query service/10
This page contains historical information. It may be outdated or unreliable.
Long audio files on Commons
| Description | list of all audio files larger than 1MB on Commons. |
|---|---|
| Assignee | Duesentrieb |
| JIRA bug | DBQ-10 |
| Source | Query service/long audio files#Query |
| Results | http://tools.wikimedia.de/~daniel/misc/commonswiki-long-audio.txt |
| Approximate run time | several hours (because there is no index in img_media_type) |
| Interval |
Query
select img_name, img_size, img_major_mime, img_minor_mime
from image
where img_media_type = "AUDIO"
and img_size > 1024*1024
This page was moved from toolserver:en:Query service/10. It's edit history can be viewed at Nova Resource:Tools/Tools/Query service/10/edithistory