stats-videolan=> select file, sum(number)  from mirrors  where file like '%0.8.1%' group by file;
                                  file                                   |  sum   
-------------------------------------------------------------------------+--------
 vlc/0.8.1/rpm/fedora/fc3/vlc/                                           |   3455
 vlc/0.8.1/win32/vlc-0.8.1-win32.exe                                     | 647971
 vlc/0.8.1/macosx/vlc-0.8.1.dmg                                          | 104537
 vlc/0.8.1/win32/vlc-0.8.1-win32.zip                                     | 117919
(62 rows)

stats-videolan=> select address, sum(number) from mirrors  where file like '%0.8.1%' group by address;
                            address                            |  sum   
---------------------------------------------------------------+--------
 ftp://ftp2.videolan.org/pub/videolan/&                        |  25025
 ftp://videolan.cs.pu.edu.tw/Windows/VideoLAN/&                |  84638
 http://download.videolan.org/pub/videolan/&                   | 198465
 http://130.89.175.1/pub/software/videolan/&                   |  64898
 http://ftp.snt.utwente.nl/pub/software/videolan/&             | 101405
 http://www2.videolan.org/pub/videolan/&                       |   4340
 ftp://ftp.crans.org/pub/videolan/&                            |  61995
 ftp://ftp.yi.se/pub/videolan/&                                |  54339
 http://194.83.42.78/videolan/&                                | 241779
 ftp://ftp.pucpr.br/videolan/&                                 |  36992

TOTAL DOWNLOADS (3 months): 913529