SELECT albumview.*,albumartistview.*   FROM albumview   LEFT JOIN albumartistview ON albumview.idAlbum = albumartistview.idAlbum   WHERE albumview.idAlbum = 2604   ORDER BY albumartistview.iOrder
