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
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
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
These works, but they are slow on big collections...
BTW the first code does exactly what the "Duplicate Titles" node does.
Enjoy!
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>
Enjoy!
Try this script instead:
http://www.mediamonkey.com/forum/viewtopic.php?t=13000
http://www.mediamonkey.com/forum/viewtopic.php?t=13000
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
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