Start a new topic
Implemented

Extend statistics: Ratings

Track-Ratings:

SELECT Rating, COUNT(Rating_ID) AS count FROM `tblrating` WHERE 1 GROUP BY Rating ORDER BY Rating ASC


Artist-Ratings:

SELECT Rating, COUNT(ArtistRating_ID) AS count FROM `tblartistrating` WHERE 1 GROUP BY Rating ORDER BY Rating ASC

 

Release-Ratings:

SELECT Rating, COUNT(AlbumRating_ID) AS count FROM `tblalbumrating` WHERE 1 GROUP BY Rating ORDER BY Rating ASC

 

Label-Ratings:

Right now, there's no tbllabelrating, but it would be cool to get this. ;-)


Maybe suppress all not rated items using "WHERE Rating != 0 AND Rating IS NOT NULL" instead of "WHERE 1"...

1 Comment

All ratings except label ratings (which cannot be implemented now) is implemented in helium_12.0.14145.0.exe

Login or Signup to post a comment