How do I "see" the following information?

[rrfpacker]

I have a playlist, created from Magic Nodes, that shows albums with a weighted average of 3 stars or better. See below.

<Group|Name:Album Ratings|Show tracks:No>\Albums with weighted avg. track rating >= 3 stars and at least 5 rated tracks|Icon:Top level|Filter:Songs.IDAlbum In (SELECT IDAlbum FROM Songs WHERE Rating >= 0 GROUP BY IDAlbum HAVING Sum(SongLength * Rating) / Sum(SongLength) >= 60 AND Count(Rating) >= 5)|Child of:Playlists|Position:Child\<Album|Sort by:Avg(Rating)|Statistic:Count(All)>

Is there a way to run a report that would then list these albums with their particular rating? I don't even know where this information is stored (I'm going to guess in the database) and I have no idea how to retrieve it.

I think it would be cool to see the actual numerical rating for the albums in this playlist. Is it possible?

[Lowlander]

I presume it is an calculated average of track ratings and not stored. Perhaps Just List Albums can: viewtopic.php?f=2&t=11163&hilit=just+list+albums

[rrfpacker]

I presume it's calculated, also, but wouldn't MM need to store the information somewhere in order for it to be available everytime I open MM?

Just List Albums doesn't seem to be able to get the info. At least I couldnt' find it. But thank you.

[Lowlander]

It can calculated on the fly. A general rule of databases is not to store data that is redundant. As the Album Rating depends on Track Rating it is redundant and should be calculate when needed (for display).

You can also check out Custom Report although I think it is track based: viewtopic.php?f=2&t=18395&hilit=custom+report

[rrfpacker]

OK, thanks for the database lesson.

For informational purposes, if I posted this question in either of the mentioned threads (probably Custom Report), would it be a double post?

[Lowlander]

Nah, it would be a feature request for the specific addon.