help with magic nodes

by **Hollowdays** » Tue Jul 03, 2007 1:42 am

thankyou Bex it works well

by **Bex** » Tue Jul 03, 2007 1:24 am

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

by **Hollowdays** » Mon Jul 02, 2007 7:50 pm

Is one of those codes for finding Duplicate songs?

by **stax76** » Sun Apr 09, 2006 8:47 am

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?

by **rshane91** » Wed Sep 21, 2005 1:31 pm

thanks a lot.

by **Bex** » Tue Sep 20, 2005 7:56 pm

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!

by **rshane91** » Tue Sep 20, 2005 11:48 am

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

Any help?

by **trixmoto** » Tue Sep 20, 2005 3:19 am

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>

by **rshane91** » Sun Sep 18, 2005 8:46 pm

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

by **rshane91** » Sat Sep 17, 2005 7:59 pm

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

help with magic nodes

Post a reply

Expand view Topic review: help with magic nodes

help with magic nodes