2016-10-06, 15:25
not sure if any help dave, but I tried his db and with mysql they come in this order 1-17 1-17 where is on my db (which you have ) they show up 1,1 2,2 etc. on my db you can check with this
SELECT songview.*, songartistview.* FROM songview JOIN songartistview ON songartistview.idsong = songview.idsong WHERE (songview.idAlbum = 11255) AND (songview.idSong IN (SELECT song_artist.idSong FROM song_artist WHERE song_artist.idArtist = 87 AND song_artist.idRole = 1 ) OR songview.idSong IN (SELECT song.idSong FROM song JOIN album_artist ON song.idAlbum=album_artist.idAlbum WHERE album_artist.idArtist = 87))
SELECT songview.*, songartistview.* FROM songview JOIN songartistview ON songartistview.idsong = songview.idsong WHERE (songview.idAlbum = 11255) AND (songview.idSong IN (SELECT song_artist.idSong FROM song_artist WHERE song_artist.idArtist = 87 AND song_artist.idRole = 1 ) OR songview.idSong IN (SELECT song.idSong FROM song JOIN album_artist ON song.idAlbum=album_artist.idAlbum WHERE album_artist.idArtist = 87))