Identifying tracks not in a playlist

Discussion about anything that might be of interest to MediaMonkey users.

Moderator: Gurus

aireq
Posts: 12
Joined: Sun Jan 07, 2007 9:15 pm

Identifying tracks not in a playlist

Post by aireq » Sun Aug 26, 2007 9:03 pm

Is there a way to identify which tracks are currently not in a playlist? I DJ CDs and either record my tracks to my computer, or purchase songs online. I want to track which tracks I've recorded to a CD. So I'm going to make a play list for each CD I create. But I want to be able to see what tracks I haven't put on a playlist and thus CD yet.

I've tried to figure out how I could get magic nodes to do this but I can't figure it out. Any one have any ideas?


Eric

nynaevelan
Posts: 5559
Joined: Wed Feb 07, 2007 11:07 pm
Location: New Jersey, USA
Contact:

Post by nynaevelan » Sun Aug 26, 2007 9:07 pm

Hi Eric:

Here is the code I use to create a Magic Node of those songs which are not in a playlist:

Songs Not In Any Playlist|SQL filter: not exists (select * from PlaylistSongs where IDSong=songs.ID)\<genre>\<artist>

Nyn
3.2x - Win7 Ultimate (Zen Touch 2 16 GB/Zen 8GB)
Link to Favorite Scripts/Skins

Join Dropbox, the online site to share your files

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

Post by Bex » Sun Aug 26, 2007 9:12 pm

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

nynaevelan
Posts: 5559
Joined: Wed Feb 07, 2007 11:07 pm
Location: New Jersey, USA
Contact:

Post by nynaevelan » Mon Aug 27, 2007 1:48 am

Sorry Bex, I hope my reply did not imply that I was the creator of the code for the node. Next time I will point the answer to the place where I found a solution.

Nyn
3.2x - Win7 Ultimate (Zen Touch 2 16 GB/Zen 8GB)
Link to Favorite Scripts/Skins

Join Dropbox, the online site to share your files

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

Post by Bex » Mon Aug 27, 2007 2:08 am

No problem at all nynaevelan! In fact, i didn't even see your post when I posted mine. :lol:
(I'm a slow poster sometimes.)
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

aireq
Posts: 12
Joined: Sun Jan 07, 2007 9:15 pm

Post by aireq » Mon Aug 27, 2007 3:04 am

Thanks, this works great.

netmatt

Re: Identifying tracks not in a playlist

Post by netmatt » Fri Aug 29, 2008 12:36 pm

This code isn't working in the latest release, or maybe just on my machine? I get a - Error executing SQL....:no such column: Songs.IdArtist (1,1)

The whole SQL script is in the ... area

netmatt

Re: Identifying tracks not in a playlist

Post by netmatt » Fri Aug 29, 2008 1:09 pm

netmatt wrote:This code isn't working in the latest release, or maybe just on my machine? I get a - Error executing SQL....:no such column: Songs.IdArtist (1,1)

The whole SQL script is in the ... area
Sorry, still works, ends up 1.3b of Magic Nodes, which comes with MM 3, does not work with MM3 !?! :-?

Got a Beta of 1.7.7, and it works fine now... :D

Post Reply