Page 6 of 6

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

Posted: Tue May 26, 2009 11:50 am
by ZvezdanD
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.

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

Posted: Tue May 26, 2009 12:11 pm
by MosquitoLoco
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

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

Posted: Tue May 26, 2009 12:18 pm
by MosquitoLoco
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!

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

Posted: Tue May 26, 2009 12:37 pm
by ZvezdanD
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.

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

Posted: Fri May 29, 2009 4:18 am
by MosquitoLoco
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

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

Posted: Fri May 29, 2009 12:20 pm
by ZvezdanD
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).

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

Posted: Thu Jul 30, 2009 5:13 am
by Prateek
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.

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

Posted: Thu Jul 30, 2009 11:21 am
by ZvezdanD
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>

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

Posted: Mon Aug 03, 2009 8:35 am
by Prateek
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 :)

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

Posted: Sun Oct 04, 2009 8:50 am
by nynaevelan
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?

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

Posted: Sun Oct 04, 2009 10:18 am
by onenonymous
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>

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

Posted: Thu Oct 15, 2009 9:07 am
by SchulA
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..

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

Posted: Thu Aug 13, 2015 5:05 am
by ScottBolton
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>