p_mode = [read] select s.default_album_id as ALBUM_ID, als.disc_no, als.disk_no, als.seq_no, s.SONG_NAME, s.COPYRIGHTER, s.FEATURING, s.PERFORMER, sar.*
from mx_song_artist_role sar left join maniadb.ct_song s on sar.song_id = s.song_id left join mx_album_song als on s.song_id = als.song_id
where s.default_album_id = 1072653
ORDER BY disc_no, disk_no, seq_no, sar.song_id, sar.major_b desc, role_name, sar.RANK :: maniadb.com
