https://www.mediamonkey.com/wiki/api.php?action=feedcontributions&feedformat=atom&user=CriggumsMediaMonkey Wiki - User contributions [en]2026-05-06T03:52:27ZUser contributionsMediaWiki 1.41.4https://www.mediamonkey.com/wiki/index.php?title=Talk:PlaylistSongs_table&diff=12063Talk:PlaylistSongs table2026-03-15T15:33:12Z<p>Criggums: Song ID attributes in PlaylistSongs not correctly described on this wiki page?</p>
<hr />
<div>I believe the descriptions for IDSong and IDPlaylistSong have been swapped in this documentation.<br />
<br />
This query gives the expected result of listing all songs on playlist #22 in order last played:<br />
<br />
SELECT ID, Artist, SongTitle, LastTimePlayed <br />
FROM Songs <br />
JOIN PlaylistSongs <br />
ON Songs.ID=PlaylistSongs.IDSong <br />
WHERE PlaylistSongs.IDPLaylist=22 <br />
ORDER BY LastTimePlayed<br />
<br />
Whereas this query returns no rows:<br />
<br />
SELECT ID, Artist, SongTitle, LastTimePlayed <br />
FROM Songs <br />
JOIN PlaylistSongs <br />
ON Songs.ID=PlaylistSongs.IDPlaylistSong <br />
WHERE PlaylistSongs.IDPLaylist=22 ORDER BY LastTimePlayed</div>Criggums