Skip navigation.

Harold's Home

   Home
  
XML version of this site

PHP Scripts

Index
CLI fun
Mail on 404
HB-NS (NewsScript)

Downloads

Applescripts
APOD to Desktop
Dreamweaver Extensions

Stuff

Writings
Other stuff
Central Grinder

OOOk Default:

VJ stuff
VJ Tools
Bananas
Strippers
Sample Movies

News

Average playcount
Yesterday I was looking at the 25 Most Played smart playlist in iTunes and saw that these songs are all approaching 50 times.
So I was wondering: how many times has each track been played on average?

As regular readers are aware I've put my iTunes database in MySQL.

Given that, it's fairly straightforward to extract this information.

mysql> SELECT sum(playCount)/count(trackID) as average FROM phptunest_tunes;
+---------+
| average |
+---------+
|    2.18 |
+---------+
1 row in set (0.07 sec)


(This post was brought to you by the useless statistics department.)

Show all items | Read all items

About, copyright, privacy and accessibility | Mail