SQL was: SELECT phpfox_m2bmusic_album_song.*, phpfox_m2bmusic_singer.title AS singer_title FROM phpfox_m2bmusic_album_song LEFT JOIN phpfox_m2bmusic_song_playlist_order ON (phpfox_m2bmusic_album_song.song_id = phpfox_m2bmusic_song_playlist_order.song_id AND phpfox_m2bmusic_song_playlist_order.user_id = 0 AND phpfox_m2bmusic_song_playlist_order.album_id = 1213) LEFT JOIN phpfox_m2bmusic_singer ON (phpfox_m2bmusic_album_song.singer_id = phpfox_m2bmusic_singer.singer_id) WHERE phpfox_m2bmusic_album_song.album_id = 1213 ORDER BY value ASC