help with magic nodes

Download and get help for different MediaMonkey for Windows 4 Addons.

Moderators: Peke, Gurus

rshane91
Posts: 18
Joined: Tue Aug 23, 2005 2:16 pm

help with magic nodes

Post by rshane91 »

Looking for a little help with Magic Nodes.

First -- I want to be able to show songs that have the same <artist> and <title> as another song in the library. Basically a way to show duplicate songs (by the same artist).

I tried to use the "|min tracks:2" but can't figure out how to get it to treat <artist> AND <title> together when it does the compare.

Any ideas?

Second -- I would like to do the same thing as above but only for songs that have <composer> = "IPOD".

This is so i can have duplicated in my library if the same song appeared on 2 different albums -- but ensure that one is tagged to sync to my IPOD. I use <composer> = "IPOD" for the files i want to sync to the ipod.

Any help is greatly appreciated.

thanks
rshane91
Posts: 18
Joined: Tue Aug 23, 2005 2:16 pm

Post by rshane91 »

ok -- i got it to work in Microsoft access using the Media Monkey database.

SELECT [Songs]![IDArtist] & " - " & [Songs]![SongTitle] AS Expr1, Count([Songs]![IDArtist] & " - " & [Songs]![SongTitle]) AS Expr2
FROM Songs
WHERE (((Songs.Author) Like "*IPOD*"))
GROUP BY [Songs]![IDArtist] & " - " & [Songs]![SongTitle]
HAVING (((Count([Songs]![IDArtist] & " - " & [Songs]![SongTitle]))>2));


Any idea how do i move it to magic nodes -- or to do duplicate the functionality in magic nodes?

thanks
trixmoto
Posts: 10024
Joined: Fri Aug 26, 2005 3:28 am
Location: Hull, UK
Contact:

Post by trixmoto »

I'm not good with SQL and fairly new to Magic Nodes, but don't you just create a node like this:

Duplicates|SQL filter:_yourSQL_\<artist>
rshane91
Posts: 18
Joined: Tue Aug 23, 2005 2:16 pm

Post by rshane91 »

i tried but it didn't work. Maybe it's a syntax issue.

Any help?
Bex
Posts: 6316
Joined: Fri May 21, 2004 5:44 am
Location: Sweden

Post by Bex »

These works, but they are slow on big collections...

Code: Select all

Dups|SQL filter: IDArtist&SongTitle IN (SELECT IDArtist&SongTitle FROM Songs GROUP BY IDArtist&SongTitle HAVING Count(Songs.ID)>1)\<Artist>

Code: Select all

DupsIPOD|SQL filter: IDArtist&SongTitle IN (SELECT IDArtist&SongTitle FROM Songs WHERE Songs.Author Like '%IPOD%' GROUP BY IDArtist&SongTitle HAVING Count(Songs.ID)>1)\<Artist>
BTW the first code does exactly what the "Duplicate Titles" node does.

Enjoy!
rshane91
Posts: 18
Joined: Tue Aug 23, 2005 2:16 pm

Post by rshane91 »

thanks a lot. :)
stax76
Posts: 176
Joined: Sun Mar 12, 2006 6:45 am

Post by stax76 »

Whould it be possible having two nodes, one for duplicates that have a different file path and one for duplicates that have identical file path?
Hollowdays

Post by Hollowdays »

Is one of those codes for finding Duplicate songs?
Bex
Posts: 6316
Joined: Fri May 21, 2004 5:44 am
Location: Sweden

Post by Bex »

Advanced Duplicate Find & Fix Find More From Same - Custom Search. | Transfer PlayStat & Copy-Paste Tags/AlbumArt between any tracks.
Tagging Inconsistencies Do you think you have your tags in order? Think again...
Play History & Stats Node Like having your Last-FM account stored locally, but more advanced.
Case & Leading Zero Fixer Works on filenames too!

All My Scripts
Hollowdays
Posts: 2
Joined: Mon Jul 02, 2007 7:53 pm

Post by Hollowdays »

thankyou Bex it works well
Post Reply