search

avuserow / amp

Acoustics Media Player - network jukebox
Other
26 stars 5 forks source link

Statistics Page #35

Closed avuserow closed 14 years ago

avuserow commented 14 years ago

We want to show statistics, including:

Top songs Total number of songs

avuserow commented 14 years ago

Cool queries:

select artist, count(songs.artist) from songs, history where songs.song_id = history.song_id and history.who = "akreher2" group by artist order by count(songs.artist);

select title, count(songs.song_id) from songs, history where songs.song_id = history.song_id group by songs.song_id order by count(songs.song_id);

avuserow commented 14 years ago

hey, we have a simple stats page. Done.