Messages

16

MediaMonkey / Re: Custom SQL select

« on: June 12, 2017, 07:08:36 PM »

I am interested in playing songs in a specific order, and that order is manually set in the playlist.
This is not about generating XML.

17

MediaMonkey / Custom SQL select

« on: June 10, 2017, 04:32:35 PM »

Is it possible to select songs with MM plugin, so that the SQL statement uses other tables from MM?
Such as, for example:

Code: [Select]

SELECT Songs.Id, Songs.SongTitle
FROM Songs, PlayListSongs, PlayLists
WHERE Songs.Artist = 'Artist'
AND Songs.Id = PlayListSongs.IdSong
AND PlayListSongs.IdPlayList = PlayLists.IdPlayList
AND PlayLists.PlayListName = 'Playlist'
ORDER BY PlayListSongs.SongOrder