Identifying tracks not in a playlist

Post a reply

Smilies
:D :) :( :o :-? 8) :lol: :x :P :oops: :cry: :evil: :roll: :wink:
BBCode is ON
[img] is ON
[url] is ON
Smilies are ON
Topic review
   

Expand view Topic review: Identifying tracks not in a playlist

Re: Identifying tracks not in a playlist

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

Re: Identifying tracks not in a playlist

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

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

Thanks, this works great.

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.)

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

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

http://www.mediamonkey.com/forum/viewto ... 5859#45859

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

Identifying tracks not in a playlist

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

Top