This script is good - but how do I turn it into a auto-playlist?

SELECT IDPlaylist, PlaylistName FROM Playlists WHERE PlaylistName = 'playlistname goes here'

SELECT ThePlaylistIdHere, Songs.ID FROM songs WHERE bla bla bla

INSERT INTO Playlists (IDPlaylist, IDSong) SELECT ThePlaylistIdHere, Songs.ID FROM songs WHERE bla bla bla

DELETE FROM Playlists WHERE IDPlaylist = ThePlaylistIdHere

You can use [url=http://www.mediamonkey.com/forum/viewtopic.php?t=24841%20]Bex's SQL Viewer[/url] script for this. Here are some examples he gave me for something else, but they should get you started on your way.

[code]
SELECT IDPlaylist, PlaylistName FROM Playlists WHERE PlaylistName = 'playlistname goes here'[/code]

Note the id for future use.

Construct your sql which finds the songs you want to put in the playlists.
When you then want to add the songs to your playlist you need to construct the SELECT-statement like this:

[code]
SELECT ThePlaylistIdHere, Songs.ID FROM songs WHERE bla bla bla[/code]

To actually add the songs do like this:

[code]
INSERT INTO Playlists (IDPlaylist, IDSong) SELECT ThePlaylistIdHere, Songs.ID FROM songs WHERE bla bla bla[/code]

To remove the songs from your playlist before you add new ones, either do it manually in MM or run this sql:

[code]
DELETE FROM Playlists WHERE IDPlaylist = ThePlaylistIdHere[/code]

Nyn

I would like to create a playlist contains songs from albums I haven't listed to in my collection since I migrated to Media Monkey.

I can obtain a list fairly easily using Microsoft Access and ODBC with this query:
SELECT TOP 100 Albums.Artist, Albums.Album, Songs.ID, Songs.TrackNumber, Songs.SongTitle, Songs.SongPath, Songs.Year
FROM Songs INNER JOIN Albums ON Songs.IDAlbum = Albums.ID
WHERE (((Exists (SELECT 'X' FROM Songs WHERE Albums.ID=Songs.IDAlbum and LastTimePlayed>0))=False));


Is there are way to create a playlist from an SQL query?