MagicNode: Complete Album with at least 4 songs? >= 2 stars?

Download and get help for different MediaMonkey Addons.

Moderators: Peke, Gurus

mmfan
Posts: 113
Joined: Mon Nov 21, 2005 4:59 pm

MagicNode: Complete Album with at least 4 songs? >= 2 stars?

Post by mmfan » Wed Nov 25, 2009 9:59 pm

Can anyone help me to make a magic node script that is: Complete Album with at least 4 songs that is greater than or equal to 2 stars ?
y8 | Miniclip | y3 | friv | ben10 |

nynaevelan
Posts: 5559
Joined: Wed Feb 07, 2007 11:07 pm
Location: New Jersey, USA
Contact:

Re: MagicNode: Complete Album with at least 4 songs? >= 2 stars?

Post by nynaevelan » Thu Nov 26, 2009 7:40 am

This is the best that I could come up with by combining two of the nodes that ZvezdanD provided and adjusting them to meet what you are looking for:

Code: Select all

Songs.IDAlbum In (SELECT IDAlbum FROM Songs WHERE Rating > 0 GROUP BY IDAlbum HAVING Avg(Rating) >= 20) AND Songs.IDAlbum IN (SELECT IDAlbum FROM Songs GROUP BY IDAlbum HAVING Count(TrackNumber) = Max(Cast(TrackNumber As integer)) AND Count(TrackNumber) > 3)
3.2x - Win7 Ultimate (Zen Touch 2 16 GB/Zen 8GB)
Link to Favorite Scripts/Skins

Join Dropbox, the online site to share your files

Big Isch
Posts: 112
Joined: Mon Mar 12, 2007 8:34 am
Location: Austria

Re: MagicNode: Complete Album with at least 4 songs? >= 2 stars?

Post by Big Isch » Mon Nov 30, 2009 4:50 am

Or did you mean this kind:

Code: Select all

Songs.IDAlbum In (SELECT IDAlbum FROM Songs WHERE Rating >= 40 GROUP BY IDAlbum HAVING Count(Rating) >= 4)

Post Reply