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

Plaats een reactie

Smilies
:D :) :( :o :-? 8) :lol: :x :P :oops: :cry: :evil: :roll: :wink:
BBCode staat AAN
[img] staat AAN
[url] staat AAN
Smilies staan AAN
Voorafgaande berichten
   

Weergave uitklappen Voorafgaande berichten: Collection of most useful/wanted Magic Nodes masks [MM2+3]

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

door ScottBolton » do aug 13, 2015 5:05 am

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

Code: Selecteer alles

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>

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

door SchulA » do okt 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..

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

door onenonymous » zo okt 04, 2009 10:18 am

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

Code: Selecteer alles

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]

door nynaevelan » zo okt 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?

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

door Prateek » ma 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 :)

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

door ZvezdanD » do jul 30, 2009 11:21 am

Prateek schreef: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: Selecteer alles

<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]

door Prateek » do 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.

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

door ZvezdanD » vr mei 29, 2009 12:20 pm

MosquitoLoco schreef: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]

door MosquitoLoco » vr mei 29, 2009 4:18 am

ZvezdanD schreef: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]

door ZvezdanD » di mei 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.

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

door MosquitoLoco » di mei 26, 2009 12:18 pm

Additionally, here's the screenshots I just took:

Afbeelding

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

Afbeelding

Thanks again!

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

door MosquitoLoco » di mei 26, 2009 12:11 pm

ZvezdanD schreef: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: Selecteer alles

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]

door ZvezdanD » di mei 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.

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

door MosquitoLoco » di mei 26, 2009 11:20 am

ZvezdanD schreef: You could try this:

Code: Selecteer alles

CUS5xARTxALB|Filter: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,%'))\<Custom 5|Sort by:Count(Artist) Desc|Statistic:Count(Tracks)>\<Artist|Sort order:Desc|Sort by:Count(Album) Desc|Statistic:Count(Tracks)>\<Album|Sort order:Desc|Sort by:Count(Tracks) Desc>
Thanks a lot ZvezdanD,

I got a SQL error though:

Code: Selecteer alles

ambiguous column name: SongArtists.ID (1, 1)
BTW, I am using MM3.

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

door ZvezdanD » di mei 26, 2009 10:16 am

MosquitoLoco schreef:I am thinking of a mask that shows me only the nodes of artists that have 2 or more tracks, and at least one of the tracks is labeled "new" in the CUSTOM5 field
You could try this:

Code: Selecteer alles

CUS5xARTxALB|Filter: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,%'))\<Custom 5|Sort by:Count(Artist) Desc|Statistic:Count(Tracks)>\<Artist|Sort order:Desc|Sort by:Count(Album) Desc|Statistic:Count(Tracks)>\<Album|Sort order:Desc|Sort by:Count(Tracks) Desc>

Omhoog