Collection of most useful/wanted Magic Nodes masks [MM2+3]

Download and get help for different MediaMonkey Addons.

Moderators: Peke, Gurus

ZvezdanD
Posts: 3097
Joined: Thu Jun 08, 2006 7:40 pm

Re: Collection of most useful/wanted Magic Nodes masks [MM2+3]

Post by ZvezdanD » Tue May 26, 2009 11:50 am

Which MM version exactly? Which version of MN script? You could turn on the "Allow editing of SQL queries", "...when expand field nodes" and "...for the Unknown node" in the Options dialog box, copy the SQL query which you get before the error message and post it here.
Magic Nodes 4.3.3 / 5.2 RegExp Find & Replace 4.4.9 / 5.2  Invert Selection/Select None 1.5.1  Export/Create Playlists for Child Nodes 4.1.1 / 5.4.1  Expand Child Nodes/Expand All 1.1.2  Event Logger 2.7  Filtered Statistics Report 1.6  Track Redirection & Synchronization 3.4.2  Restore/Synchronize Database 3.1.8 / 4.0.1  Find Currently Playing Track 1.3.2  Queue List 1.2.1  Add to Library on Play 1.0.1  Tree Report for Child Nodes 1.1.1  Update Location of Files in Database 1.4.5 / 2.3  Inherit Child Playlists 1.0.2  Add Currently Playing/Selected Track(s) to Playlist 1.1.2

MosquitoLoco
Posts: 5
Joined: Mon May 25, 2009 7:53 pm

Re: Collection of most useful/wanted Magic Nodes masks [MM2+3]

Post by MosquitoLoco » Tue May 26, 2009 12:11 pm

ZvezdanD wrote:Which MM version exactly? Which version of MN script? You could turn on the "Allow editing of SQL queries", "...when expand field nodes" and "...for the Unknown node" in the Options dialog box, copy the SQL query which you get before the error message and post it here.
MM ver: 3.0.6.1190
Magic Nodes 2.4

As for the error msg:

Code: Select all

SELECT Count(*) AS StatField0 FROM  Songs , ArtistsSongs AS AArtistsSongs, Artists AS SongArtists LEFT JOIN ArtistsSongs AS AArtistsSongs ON Songs.ID = AArtistsSongs.IDSong AND (AArtistsSongs.PersonType = 1 OR AArtistsSongs.PersonType IS NULL) LEFT JOIN Artists AS SongArtists ON AArtistsSongs.IDArtist = SongArtists.ID WHERE (Songs.ID IN (SELECT Songs.ID FROM Songs, ArtistsSongs, Artists WHERE Songs.ID = ArtistsSongs.IDSong AND (ArtistsSongs.PersonType = 1 OR ArtistsSongs.PersonType IS NULL) AND ArtistsSongs.IDArtist = Artists.ID AND Artists.Artist IN (SELECT Artists.Artist FROM Songs, ArtistsSongs, Artists WHERE Songs.ID = ArtistsSongs.IDSong AND (ArtistsSongs.PersonType = 1 OR ArtistsSongs.PersonType IS NULL) AND ArtistsSongs.IDArtist = Artists.ID GROUP BY Artists.Artist HAVING Count(*) >= 2 AND ',' || group_concat(Custom5) || ',' LIKE '%,new,%'))) AND  Songs.ID = AArtistsSongs.IDSong AND AArtistsSongs.IDArtist = SongArtists.ID AND (AArtistsSongs.PersonType = 1 OR AArtistsSongs.PersonType IS NULL) AND  NOT Songs.Custom5 <> ''
It happens when I try to expand the mask node, I get the Ambiguous column name error.

Thanks!
Mosquito

MosquitoLoco
Posts: 5
Joined: Mon May 25, 2009 7:53 pm

Re: Collection of most useful/wanted Magic Nodes masks [MM2+3]

Post by MosquitoLoco » Tue May 26, 2009 12:18 pm

Additionally, here's the screenshots I just took:

Image

That's the first error message, and then I get a second one when I hit the Cancel button:

Image

Thanks again!

ZvezdanD
Posts: 3097
Joined: Thu Jun 08, 2006 7:40 pm

Re: Collection of most useful/wanted Magic Nodes masks [MM2+3]

Post by ZvezdanD » Tue May 26, 2009 12:37 pm

You should try with MN 2.4.1 or newer. It has removed error with filters and Count(some_field) function. I also recommend using latest versions of MM, even it is still in beta.
Magic Nodes 4.3.3 / 5.2 RegExp Find & Replace 4.4.9 / 5.2  Invert Selection/Select None 1.5.1  Export/Create Playlists for Child Nodes 4.1.1 / 5.4.1  Expand Child Nodes/Expand All 1.1.2  Event Logger 2.7  Filtered Statistics Report 1.6  Track Redirection & Synchronization 3.4.2  Restore/Synchronize Database 3.1.8 / 4.0.1  Find Currently Playing Track 1.3.2  Queue List 1.2.1  Add to Library on Play 1.0.1  Tree Report for Child Nodes 1.1.1  Update Location of Files in Database 1.4.5 / 2.3  Inherit Child Playlists 1.0.2  Add Currently Playing/Selected Track(s) to Playlist 1.1.2

MosquitoLoco
Posts: 5
Joined: Mon May 25, 2009 7:53 pm

Re: Collection of most useful/wanted Magic Nodes masks [MM2+3]

Post by MosquitoLoco » Fri May 29, 2009 4:18 am

ZvezdanD wrote:You should try with MN 2.4.1 or newer. It has removed error with filters and Count(some_field) function. I also recommend using latest versions of MM, even it is still in beta.
Please excuse my absence. I updated to the current version (3.0.7.1191) Still no luck, I wonder if it has to do with any other thing like drivers?

Mosquito

ZvezdanD
Posts: 3097
Joined: Thu Jun 08, 2006 7:40 pm

Re: Collection of most useful/wanted Magic Nodes masks [MM2+3]

Post by ZvezdanD » Fri May 29, 2009 12:20 pm

MosquitoLoco wrote:I updated to the current version (3.0.7.1191) Still no luck
This is the current official version of program. The latest beta version is 3.1.0.1249 from the Beta Testing forum. However, here is not a problem with the version of the program, but with the version of the script. As I said you should download the latest Magic Nodes version (2.5).
Magic Nodes 4.3.3 / 5.2 RegExp Find & Replace 4.4.9 / 5.2  Invert Selection/Select None 1.5.1  Export/Create Playlists for Child Nodes 4.1.1 / 5.4.1  Expand Child Nodes/Expand All 1.1.2  Event Logger 2.7  Filtered Statistics Report 1.6  Track Redirection & Synchronization 3.4.2  Restore/Synchronize Database 3.1.8 / 4.0.1  Find Currently Playing Track 1.3.2  Queue List 1.2.1  Add to Library on Play 1.0.1  Tree Report for Child Nodes 1.1.1  Update Location of Files in Database 1.4.5 / 2.3  Inherit Child Playlists 1.0.2  Add Currently Playing/Selected Track(s) to Playlist 1.1.2

Prateek

Re: Collection of most useful/wanted Magic Nodes masks [MM2+3]

Post by Prateek » Thu Jul 30, 2009 5:13 am

I'm looking for a mask that can return (any) one song from each artist in a directory.
For example, if the path is D:\My Music\Rock and the folder has 3 subfolders: Metallica, Ironmaiden and Dreamtheater, which further have separate albums inside them, then I need any 3 tracks, one from each artist.

ZvezdanD
Posts: 3097
Joined: Thu Jun 08, 2006 7:40 pm

Re: Collection of most useful/wanted Magic Nodes masks [MM2+3]

Post by ZvezdanD » Thu Jul 30, 2009 11:21 am

Prateek wrote:I'm looking for a mask that can return (any) one song from each artist in a directory.
For example, if the path is D:\My Music\Rock and the folder has 3 subfolders: Metallica, Ironmaiden and Dreamtheater, which further have separate albums inside them, then I need any 3 tracks, one from each artist.
There is already predefined mask "One random Track from each Artist". If you really need to limit artists to only those which are in some folder, you should append the <Folder> criteria to the Filter qualifier using AND operator, e.g. you could add AND <Folder> LIKE 'D:\My Music\Rock\%':

Code: Select all

<Group|Name:Random|Show tracks:No>\One random Track from each Artist in My Music folder|Icon:Top level|Filter:Songs.ID IN (SELECT (SELECT A1.IDSong FROM ArtistsSongs AS A1 WHERE A1.IDArtist = ArtistsSongs.IDArtist ORDER BY Random() LIMIT 1) FROM ArtistsSongs WHERE (ArtistsSongs.PersonType = 1 OR ArtistsSongs.PersonType IS NULL) GROUP BY ArtistsSongs.IDArtist) AND <Folder> LIKE 'D:\My Music\Rock\%'\<Artist|Trim:1>\<Artist>
Magic Nodes 4.3.3 / 5.2 RegExp Find & Replace 4.4.9 / 5.2  Invert Selection/Select None 1.5.1  Export/Create Playlists for Child Nodes 4.1.1 / 5.4.1  Expand Child Nodes/Expand All 1.1.2  Event Logger 2.7  Filtered Statistics Report 1.6  Track Redirection & Synchronization 3.4.2  Restore/Synchronize Database 3.1.8 / 4.0.1  Find Currently Playing Track 1.3.2  Queue List 1.2.1  Add to Library on Play 1.0.1  Tree Report for Child Nodes 1.1.1  Update Location of Files in Database 1.4.5 / 2.3  Inherit Child Playlists 1.0.2  Add Currently Playing/Selected Track(s) to Playlist 1.1.2

Prateek

Re: Collection of most useful/wanted Magic Nodes masks [MM2+3]

Post by Prateek » Mon Aug 03, 2009 8:35 am

Oh I'm sorry. For some reason I didn't look into that particular node at all.
Thanks a lot though, thats exactly what I wanted :)

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

Re: Collection of most useful/wanted Magic Nodes masks [MM2+3]

Post by nynaevelan » Sun Oct 04, 2009 8:50 am

Hi:

I need help constructing a mask, I looked in the nodes which ZvezdanD delivers with MN but I could not find one to change to meet my needs. I would like to construct a node which gives a list of artists who have at least 1 track that has been played 25 or more times. I only need it to list the artist once. Can someone help me?
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

onenonymous
Posts: 374
Joined: Sat Feb 02, 2008 1:09 pm
Location: Texas

Re: Collection of most useful/wanted Magic Nodes masks [MM2+3]

Post by onenonymous » Sun Oct 04, 2009 10:18 am

This isn't exaclty it - but may help until someone posts the SQL code needed...

Code: Select all

Artists sorted by total play count|Child of:Library|Position:Before|Filter:<Played> > 0\<Artist|Sort by:Sum(Played) Desc>\<Title|Sort by:Sum(Played) Desc>

SchulA
Posts: 30
Joined: Sat Jul 25, 2009 5:17 am

Re: Collection of most useful/wanted Magic Nodes masks [MM2+3]

Post by SchulA » Thu Oct 15, 2009 9:07 am

Hi,

Could anyone please help me. I´m searching for 2 Masks for Playlists which. I don´t get to work.

The first should list all Playlists (including the "automatically imported playlists) in Artist - Alphabetical order, with letter sub notes under wich the Playlists can be found.

Second one should list all imported playlists sorted by the date, they were added.

Thanks
SchulA

... an example for "playlists added in the last x days" would also be cool..

ScottBolton
Posts: 17
Joined: Fri Jul 28, 2006 8:53 am

Re: Collection of most useful/wanted Magic Nodes masks [MM2+

Post by ScottBolton » Thu Aug 13, 2015 5:05 am

Eeks! This code takes for ever to expand the different songs. Is there anything better for MM4?

Code: Select all

Tracks with same Name from different Artists|SQL Filter: Songs.SongTitle IN (SELECT SongTitle FROM Songs WHERE Length(SongTitle) > 0 GROUP BY SongTitle HAVING Count(DISTINCT Artist) > 1)\<Title|Trim:1>\<Title|Sort by:Count(All)>\<Artist>

Post Reply