MediaMonkey forum

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

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

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>

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

Any help?

These works, but they are slow on big collections... BTW the first code does exactly what the "Duplicate Titles" node does.

Enjoy!

thanks a lot.

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?

Is one of those codes for finding Duplicate songs?

Try this script instead:
http://www.mediamonkey.com/forum/viewtopic.php?t=13000

thankyou Bex it works well