Page 4 of 6

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

Posted: Tue Sep 02, 2008 9:43 am
by ZvezdanD
tatoosh wrote:is this only shorter and easier to understand or is there a speed advantage/disadvantage, too?
Only shorter and easier to understand. The MN script internally converts this mask to the previous one which you mentioned.

EDIT: There is one more advantage - the same mask could be used in MM2 and MM3 :wink:

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

Posted: Thu Sep 18, 2008 3:39 am
by tatoosh
i want to update some music files:
how to show tracks with no covers inside - so that i can edit them.
thx 4 helping

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

Posted: Thu Sep 18, 2008 4:58 am
by ZvezdanD
tatoosh wrote:how to show tracks with no covers inside
http://www.mediamonkey.com/forum/viewto ... 05#p166905

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

Posted: Sat Sep 27, 2008 12:45 pm
by onenonymous
Here are 90 masks for statistics including Date Added, Date Played and Date Modified with different sort by sub-nodes. To add these all quickly, just paste the entire list below into the MagicNodes.ini file within Scripts\Auto, then restart MM. You may need to also edit the MagicNodes.vbs script to increase the number of nodes from the default 100 to something higher (like 200...). Edit this line in MagicNodes.vbs:

Code: Select all

Const MasksInIniFile = 100
When you restart MM, you'll get a dialog asking you to confirm addition of the new masks.

If you don't want them all, then you can copy and paste individual masks from the list below in the usual manner rather than messing with the MagicNodes.ini file, just leave off the "MaskXX=" portion when you create the node.

This replaces the contents of MagicNodes.ini in Scripts\Auto:

Code: Select all

[CustomNodeMasks]
Mask1=<Group|Name:Added Statistics>\<Group|Name:Date Added>\By Title\<Date Added|Statistic:Count(All)|Sort order:Desc>\<Title>
Mask2=<Group|Name:Added Statistics>\<Group|Name:Date Added>\By Album\<Date Added|Statistic:Count(All)|Sort order:Desc>\<Album|Statistic:Count(All)>
Mask3=<Group|Name:Added Statistics>\<Group|Name:Date Added>\By Artist\<Date Added|Statistic:Count(All)|Sort order:Desc>\<Artist|Statistic:Count(All)>
Mask4=<Group|Name:Added Statistics>\<Group|Name:Date Added>\By Album Artist\<Date Added|Statistic:Count(All)|Sort order:Desc>\<Album Artist|Statistic:Count(All)>
Mask5=<Group|Name:Added Statistics>\<Group|Name:Date Added>\By Album Artist with Album\<Date Added|Statistic:Count(All)|Sort order:Desc>\<Album Artist with Album|Statistic:Count(All)>
Mask6=<Group|Name:Added Statistics>\<Group|Name:Date Added>\By Album with Album Artist\<Date Added|Statistic:Count(All)|Sort order:Desc>\<Album with Album Artist|Statistic:Count(All)>
Mask7=<Group|Name:Added Statistics>\<Group|Name:Days Since Added>\By Title\<Days Since Added|Statistic:Count(All)>\<Title>
Mask8=<Group|Name:Added Statistics>\<Group|Name:Days Since Added>\By Album\<Days Since Added|Statistic:Count(All)>\<Album|Statistic:Count(All)>
Mask9=<Group|Name:Added Statistics>\<Group|Name:Days Since Added>\By Artist\<Days Since Added|Statistic:Count(All)>\<Artist|Statistic:Count(All)>
Mask10=<Group|Name:Added Statistics>\<Group|Name:Days Since Added>\By Album Artist\<Days Since Added|Statistic:Count(All)>\<Album Artist|Statistic:Count(All)>
Mask11=<Group|Name:Added Statistics>\<Group|Name:Days Since Added>\By Album Artist with Album\<Days Since Added|Statistic:Count(All)>\<Album Artist with Album|Statistic:Count(All)>
Mask12=<Group|Name:Added Statistics>\<Group|Name:Days Since Added>\By Album with Album Artist\<Days Since Added|Statistic:Count(All)>\<Album with Album Artist|Statistic:Count(All)>
Mask13=<Group|Name:Added Statistics>\<Group|Name:Months Since Added>\By Title\<Months Since Added|Statistic:Count(All)>\<Title>
Mask14=<Group|Name:Added Statistics>\<Group|Name:Months Since Added>\By Album\<Months Since Added|Statistic:Count(All)>\<Album|Statistic:Count(All)>
Mask15=<Group|Name:Added Statistics>\<Group|Name:Months Since Added>\By Artist\<Months Since Added|Statistic:Count(All)>\<Artist|Statistic:Count(All)>
Mask16=<Group|Name:Added Statistics>\<Group|Name:Months Since Added>\By Album Artist\<Months Since Added|Statistic:Count(All)>\<Album Artist|Statistic:Count(All)>
Mask17=<Group|Name:Added Statistics>\<Group|Name:Months Since Added>\By Album Artist with Album\<Months Since Added|Statistic:Count(All)>\<Album Artist with Album|Statistic:Count(All)>
Mask18=<Group|Name:Added Statistics>\<Group|Name:Months Since Added>\By Album with Album Artist\<Months Since Added|Statistic:Count(All)>\<Album with Album Artist|Statistic:Count(All)>
Mask19=<Group|Name:Added Statistics>\<Group|Name:Weeks Since Added>\By Title\<Weeks Since Added|Statistic:Count(All)>\<Title>
Mask20=<Group|Name:Added Statistics>\<Group|Name:Weeks Since Added>\By Album\<Weeks Since Added|Statistic:Count(All)>\<Album|Statistic:Count(All)>
Mask21=<Group|Name:Added Statistics>\<Group|Name:Weeks Since Added>\By Artist\<Weeks Since Added|Statistic:Count(All)>\<Artist|Statistic:Count(All)>
Mask22=<Group|Name:Added Statistics>\<Group|Name:Weeks Since Added>\By Album Artist\<Weeks Since Added|Statistic:Count(All)>\<Album Artist|Statistic:Count(All)>
Mask23=<Group|Name:Added Statistics>\<Group|Name:Weeks Since Added>\By Album Artist with Album\<Weeks Since Added|Statistic:Count(All)>\<Album Artist with Album|Statistic:Count(All)>
Mask24=<Group|Name:Added Statistics>\<Group|Name:Weeks Since Added>\By Album with Album Artist\<Weeks Since Added|Statistic:Count(All)>\<Album with Album Artist|Statistic:Count(All)>
Mask25=<Group|Name:Added Statistics>\<Group|Name:Years Since Added>\By Title\<Years Since Added|Statistic:Count(All)>\<Title>
Mask26=<Group|Name:Added Statistics>\<Group|Name:Years Since Added>\By Album\<Years Since Added|Statistic:Count(All)>\<Album|Statistic:Count(All)>
Mask27=<Group|Name:Added Statistics>\<Group|Name:Years Since Added>\By Artist\<Years Since Added|Statistic:Count(All)>\<Artist|Statistic:Count(All)>
Mask28=<Group|Name:Added Statistics>\<Group|Name:Years Since Added>\By Album Artist\<Years Since Added|Statistic:Count(All)>\<Album Artist|Statistic:Count(All)>
Mask29=<Group|Name:Added Statistics>\<Group|Name:Years Since Added>\By Album Artist with Album\<Years Since Added|Statistic:Count(All)>\<Album Artist with Album|Statistic:Count(All)>
Mask30=<Group|Name:Added Statistics>\<Group|Name:Years Since Added>\By Album with Album Artist\<Years Since Added|Statistic:Count(All)>\<Album with Album Artist|Statistic:Count(All)>
Mask31=<Group|Name:Modified Statistics>\<Group|Name:Date Modified>\By Title\<Date Modified|Statistic:Count(All)|Sort order:Desc>\<Title>
Mask32=<Group|Name:Modified Statistics>\<Group|Name:Date Modified>\By Album\<Date Modified|Statistic:Count(All)|Sort order:Desc>\<Album|Statistic:Count(All)>
Mask33=<Group|Name:Modified Statistics>\<Group|Name:Date Modified>\By Artist\<Date Modified|Statistic:Count(All)|Sort order:Desc>\<Artist|Statistic:Count(All)>
Mask34=<Group|Name:Modified Statistics>\<Group|Name:Date Modified>\By Album Artist\<Date Modified|Statistic:Count(All)|Sort order:Desc>\<Album Artist|Statistic:Count(All)>
Mask35=<Group|Name:Modified Statistics>\<Group|Name:Date Modified>\By Album Artist with Album\<Date Modified|Statistic:Count(All)|Sort order:Desc>\<Album Artist with Album|Statistic:Count(All)>
Mask36=<Group|Name:Modified Statistics>\<Group|Name:Date Modified>\By Album with Album Artist\<Date Modified|Statistic:Count(All)|Sort order:Desc>\<Album with Album Artist|Statistic:Count(All)>
Mask37=<Group|Name:Modified Statistics>\<Group|Name:Days Since Modified>\By Title\<Days Since Modified|Statistic:Count(All)>\<Title>
Mask38=<Group|Name:Modified Statistics>\<Group|Name:Days Since Modified>\By Album\<Days Since Modified|Statistic:Count(All)>\<Album|Statistic:Count(All)>
Mask39=<Group|Name:Modified Statistics>\<Group|Name:Days Since Modified>\By Artist\<Days Since Modified|Statistic:Count(All)>\<Artist|Statistic:Count(All)>
Mask40=<Group|Name:Modified Statistics>\<Group|Name:Days Since Modified>\By Album Artist\<Days Since Modified|Statistic:Count(All)>\<Album Artist|Statistic:Count(All)>
Mask41=<Group|Name:Modified Statistics>\<Group|Name:Days Since Modified>\By Album Artist with Album\<Days Since Modified|Statistic:Count(All)>\<Album Artist with Album|Statistic:Count(All)>
Mask42=<Group|Name:Modified Statistics>\<Group|Name:Days Since Modified>\By Album with Album Artist\<Days Since Modified|Statistic:Count(All)>\<Album with Album Artist|Statistic:Count(All)>
Mask43=<Group|Name:Modified Statistics>\<Group|Name:Months Since Modified>\By Title\<Months Since Modified|Statistic:Count(All)>\<Title>
Mask44=<Group|Name:Modified Statistics>\<Group|Name:Months Since Modified>\By Album\<Months Since Modified|Statistic:Count(All)>\<Album|Statistic:Count(All)>
Mask45=<Group|Name:Modified Statistics>\<Group|Name:Months Since Modified>\By Artist\<Months Since Modified|Statistic:Count(All)>\<Artist|Statistic:Count(All)>
Mask46=<Group|Name:Modified Statistics>\<Group|Name:Months Since Modified>\By Album Artist\<Months Since Modified|Statistic:Count(All)>\<Album Artist|Statistic:Count(All)>
Mask47=<Group|Name:Modified Statistics>\<Group|Name:Months Since Modified>\By Album Artist with Album\<Months Since Modified|Statistic:Count(All)>\<Album Artist with Album|Statistic:Count(All)>
Mask48=<Group|Name:Modified Statistics>\<Group|Name:Months Since Modified>\By Album with Album Artist\<Months Since Modified|Statistic:Count(All)>\<Album with Album Artist|Statistic:Count(All)>
Mask49=<Group|Name:Modified Statistics>\<Group|Name:Weeks Since Modified>\By Title\<Weeks Since Modified|Statistic:Count(All)>\<Title>
Mask50=<Group|Name:Modified Statistics>\<Group|Name:Weeks Since Modified>\By Album\<Weeks Since Modified|Statistic:Count(All)>\<Album|Statistic:Count(All)>
Mask51=<Group|Name:Modified Statistics>\<Group|Name:Weeks Since Modified>\By Artist\<Weeks Since Modified|Statistic:Count(All)>\<Artist|Statistic:Count(All)>
Mask52=<Group|Name:Modified Statistics>\<Group|Name:Weeks Since Modified>\By Album Artist\<Weeks Since Modified|Statistic:Count(All)>\<Album Artist|Statistic:Count(All)>
Mask53=<Group|Name:Modified Statistics>\<Group|Name:Weeks Since Modified>\By Album Artist with Album\<Weeks Since Modified|Statistic:Count(All)>\<Album Artist with Album|Statistic:Count(All)>
Mask54=<Group|Name:Modified Statistics>\<Group|Name:Weeks Since Modified>\By Album with Album Artist\<Weeks Since Modified|Statistic:Count(All)>\<Album with Album Artist|Statistic:Count(All)>
Mask55=<Group|Name:Modified Statistics>\<Group|Name:Years Since Modified>\By Title\<Years Since Modified|Statistic:Count(All)>\<Title>
Mask56=<Group|Name:Modified Statistics>\<Group|Name:Years Since Modified>\By Album\<Years Since Modified|Statistic:Count(All)>\<Album|Statistic:Count(All)>
Mask57=<Group|Name:Modified Statistics>\<Group|Name:Years Since Modified>\By Artist\<Years Since Modified|Statistic:Count(All)>\<Artist|Statistic:Count(All)>
Mask58=<Group|Name:Modified Statistics>\<Group|Name:Years Since Modified>\By Album Artist\<Years Since Modified|Statistic:Count(All)>\<Album Artist|Statistic:Count(All)>
Mask59=<Group|Name:Modified Statistics>\<Group|Name:Years Since Modified>\By Album Artist with Album\<Years Since Modified|Statistic:Count(All)>\<Album Artist with Album|Statistic:Count(All)>
Mask60=<Group|Name:Modified Statistics>\<Group|Name:Years Since Modified>\By Album with Album Artist\<Years Since Modified|Statistic:Count(All)>\<Album with Album Artist|Statistic:Count(All)>
Mask61=<Group|Name:Last Played Statistics>\<Group|Name:Date Last Played>\By Title\<Date Last Played|Statistic:Count(All)|Sort order:Desc>\<Title>
Mask62=<Group|Name:Last Played Statistics>\<Group|Name:Date Last Played>\By Album\<Date Last Played|Statistic:Count(All)|Sort order:Desc>\<Album|Statistic:Count(All)>
Mask63=<Group|Name:Last Played Statistics>\<Group|Name:Date Last Played>\By Artist\<Date Last Played|Statistic:Count(All)|Sort order:Desc>\<Artist|Statistic:Count(All)>
Mask64=<Group|Name:Last Played Statistics>\<Group|Name:Date Last Played>\By Album Artist\<Date Last Played|Statistic:Count(All)|Sort order:Desc>\<Album Artist|Statistic:Count(All)>
Mask65=<Group|Name:Last Played Statistics>\<Group|Name:Date Last Played>\By Album Artist with Album\<Date Last Played|Statistic:Count(All)|Sort order:Desc>\<Album Artist with Album|Statistic:Count(All)>
Mask66=<Group|Name:Last Played Statistics>\<Group|Name:Date Last Played>\By Album with Album Artist\<Date Last Played|Statistic:Count(All)|Sort order:Desc>\<Album with Album Artist|Statistic:Count(All)>
Mask67=<Group|Name:Last Played Statistics>\<Group|Name:Days Since Last Played>\By Title\<Days Since Last Played|Statistic:Count(All)>\<Title>
Mask68=<Group|Name:Last Played Statistics>\<Group|Name:Days Since Last Played>\By Album\<Days Since Last Played|Statistic:Count(All)>\<Album|Statistic:Count(All)>
Mask69=<Group|Name:Last Played Statistics>\<Group|Name:Days Since Last Played>\By Artist\<Days Since Last Played|Statistic:Count(All)>\<Artist|Statistic:Count(All)>
Mask70=<Group|Name:Last Played Statistics>\<Group|Name:Days Since Last Played>\By Album Artist\<Days Since Last Played|Statistic:Count(All)>\<Album Artist|Statistic:Count(All)>
Mask71=<Group|Name:Last Played Statistics>\<Group|Name:Days Since Last Played>\By Album Artist with Album\<Days Since Last Played|Statistic:Count(All)>\<Album Artist with Album|Statistic:Count(All)>
Mask72=<Group|Name:Last Played Statistics>\<Group|Name:Days Since Last Played>\By Album with Album Artist\<Days Since Last Played|Statistic:Count(All)>\<Album with Album Artist|Statistic:Count(All)>
Mask73=<Group|Name:Last Played Statistics>\<Group|Name:Months Since Last Played>\By Title\<Months Since Last Played|Statistic:Count(All)>\<Title>
Mask74=<Group|Name:Last Played Statistics>\<Group|Name:Months Since Last Played>\By Album\<Months Since Last Played|Statistic:Count(All)>\<Album|Statistic:Count(All)>
Mask75=<Group|Name:Last Played Statistics>\<Group|Name:Months Since Last Played>\By Artist\<Months Since Last Played|Statistic:Count(All)>\<Artist|Statistic:Count(All)>
Mask76=<Group|Name:Last Played Statistics>\<Group|Name:Months Since Last Played>\By Album Artist\<Months Since Last Played|Statistic:Count(All)>\<Album Artist|Statistic:Count(All)>
Mask77=<Group|Name:Last Played Statistics>\<Group|Name:Months Since Last Played>\By Album Artist with Album\<Months Since Last Played|Statistic:Count(All)>\<Album Artist with Album|Statistic:Count(All)>
Mask78=<Group|Name:Last Played Statistics>\<Group|Name:Months Since Last Played>\By Album with Album Artist\<Months Since Last Played|Statistic:Count(All)>\<Album with Album Artist|Statistic:Count(All)>
Mask79=<Group|Name:Last Played Statistics>\<Group|Name:Weeks Since Last Played>\By Title\<Weeks Since Last Played|Statistic:Count(All)>\<Title>
Mask80=<Group|Name:Last Played Statistics>\<Group|Name:Weeks Since Last Played>\By Album\<Weeks Since Last Played|Statistic:Count(All)>\<Album|Statistic:Count(All)>
Mask81=<Group|Name:Last Played Statistics>\<Group|Name:Weeks Since Last Played>\By Artist\<Weeks Since Last Played|Statistic:Count(All)>\<Artist|Statistic:Count(All)>
Mask82=<Group|Name:Last Played Statistics>\<Group|Name:Weeks Since Last Played>\By Album Artist\<Weeks Since Last Played|Statistic:Count(All)>\<Album Artist|Statistic:Count(All)>
Mask83=<Group|Name:Last Played Statistics>\<Group|Name:Weeks Since Last Played>\By Album Artist with Album\<Weeks Since Last Played|Statistic:Count(All)>\<Album Artist with Album|Statistic:Count(All)>
Mask84=<Group|Name:Last Played Statistics>\<Group|Name:Weeks Since Last Played>\By Album with Album Artist\<Weeks Since Last Played|Statistic:Count(All)>\<Album with Album Artist|Statistic:Count(All)>
Mask85=<Group|Name:Last Played Statistics>\<Group|Name:Years Since Last Played>\By Title\<Years Since Last Played|Statistic:Count(All)>\<Title>
Mask86=<Group|Name:Last Played Statistics>\<Group|Name:Years Since Last Played>\By Album\<Years Since Last Played|Statistic:Count(All)>\<Album|Statistic:Count(All)>
Mask87=<Group|Name:Last Played Statistics>\<Group|Name:Years Since Last Played>\By Artist\<Years Since Last Played|Statistic:Count(All)>\<Artist|Statistic:Count(All)>
Mask88=<Group|Name:Last Played Statistics>\<Group|Name:Years Since Last Played>\By Album Artist\<Years Since Last Played|Statistic:Count(All)>\<Album Artist|Statistic:Count(All)>
Mask89=<Group|Name:Last Played Statistics>\<Group|Name:Years Since Last Played>\By Album Artist with Album\<Years Since Last Played|Statistic:Count(All)>\<Album Artist with Album|Statistic:Count(All)>
Mask90=<Group|Name:Last Played Statistics>\<Group|Name:Years Since Last Played>\By Album with Album Artist\<Years Since Last Played|Statistic:Count(All)>\<Album with Album Artist|Statistic:Count(All)>

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

Posted: Sat Sep 27, 2008 12:50 pm
by nynaevelan
HeHeHe I am going to have to "steal" some of these for My Custom Nodes. :wink: :o :D

Nyn

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

Posted: Sun Sep 28, 2008 9:52 am
by Tylast
What would the mask be if I just wanted to show everything in a particular folder on my computer. I'm trying this, but it shows nothing.

Code: Select all

*New Tracks|Filter:<Path> Like ':\Users\Tylast\Desktop\Downloads\'

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

Posted: Sun Sep 28, 2008 11:13 am
by onenonymous
Show tracks with comment field filled from iTunes with something like:
00000143 00000145 00000995 00000D96 00029827 00029827 000063E8 0000764E 00029827 00029827

I'm sure there's a better way to do this, as it will show anything with exactly 89 characters - but it works for me :-?. Combine this with RegExp Find & Replace, and it's easy to clean the garbage...

Code: Select all

Tracks with iTunes Comment|Filter:Length(Trim(Comment))=89\<Comment>

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

Posted: Sun Sep 28, 2008 12:29 pm
by trixmoto
Tylast wrote:What would the mask be if I just wanted to show everything in a particular folder on my computer. I'm trying this, but it shows nothing.

Code: Select all

*New Tracks|Filter:<Path> Like ':\Users\Tylast\Desktop\Downloads\'
This needs to be: *New Tracks|Filter:<Path> Like ':\Users\Tylast\Desktop\Downloads\%'

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

Posted: Sun Sep 28, 2008 1:41 pm
by Tylast
Working perfectly! Ohhh how I love MM & the MM community. Trix...you rock! :wink:

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

Posted: Sun Sep 28, 2008 1:52 pm
by ZvezdanD
onenonymous wrote:Combine this with RegExp Find & Replace, and it's easy to clean the garbage...
Find what:

Code: Select all

([0-9A-F]{8} ){9}[0-9A-F]{8}
With the Keep matched command it gives same result as Magic Nodes. :)

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

Posted: Fri Oct 17, 2008 11:28 pm
by itsmigel
Hello! I create this mask:

Code: Select all

My Genres|Icon:Top level\<custom 1|Statistic:Count(Items)>\<genre|Statistic:Count(Items)>\<Artist|Statistic:Count(Items)>\<Album|Statistic:Count(Items)>
It looks so:
My Genres->Rock (12 genres)->Hard Rock (36 artist)->Led Zeppelin (7 albums)->Houses Of The Holy (8).
How to do, that was the amount of artists represented in the second field, but not genres? That it was so:
My Genres->Rock (124 artist)->Hard Rock (36 artist)->Led Zeppelin (7 albums)->Houses Of The Holy (8).

I am sorry for my bad English, if that.

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

Posted: Sat Oct 18, 2008 8:43 am
by ZvezdanD
itsmigel wrote:How to do, that was the amount of artists represented in the second field, but not genres?
Sorry, this is not currently possible. Count(Items) could return only number of items from the first previous level, not from the second previous level.

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

Posted: Tue Nov 04, 2008 11:26 am
by Brouwerik
Hey,

Can someone please help me to create a magic node to find duplicates? I'm currentle using the

Code: Select all

Duplicate Check|child of:files to edit|position:last child|SQL Filter: Songs.SongTitle || '@#$' || Songs.Artist IN (SELECT SongTitle || '@#$' || Artist FROM Songs WHERE Length(SongTitle) > 0 GROUP BY SongTitle, Artist HAVING Count(*) > 1 AND Count(DISTINCT Artist) = 1)\<Title|Trim:1>\<Title>\<Artist>
I want the node to only show tracks with the same Artist, Title AND Custom 3
Custom 3 is named 'Version' in my database and I have a lot of tracks with same name and artist but a different version like "remix", "live" or "demo", so they're not really duplicates

Thanx in advance

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

Posted: Tue Nov 04, 2008 3:07 pm
by ZvezdanD
Brouwerik wrote:I want the node to only show tracks with the same Artist, Title AND Custom 3
Maybe you could try this:

Code: Select all

Duplicate Check|child of:files to edit|position:last child|SQL Filter: Songs.SongTitle || '@#$' || Songs.Artist || '@#$' || Songs.Custom3 IN (SELECT SongTitle || '@#$' || Artist || '@#$' || Custom3 FROM Songs WHERE Length(SongTitle) > 0 GROUP BY SongTitle, Artist, Custom3 HAVING Count(*) > 1 AND Count(DISTINCT Artist) = 1 AND Count(DISTINCT Custom3) = 1)\<Title|Trim:1>\<Title>\<Artist>

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

Posted: Wed Nov 05, 2008 1:13 am
by Brouwerik
Thanx alot ZvezdanD! That works great :D