SELECT b.band_ID AS band_id FROM   band AS b JOIN teilnahme AS t ON t.band_ID=b.band_ID JOIN wettbewerb AS w ON t.wettbewerb_ID=w.wettbewerb_ID JOIN region AS re ON w.region_ID=re.region_ID JOIN season AS s ON w.season_ID=s.season_ID LEFT JOIN auszeichnung AS au ON au.wettbewerb_ID=w.wettbewerb_ID AND au.band_ID=b.band_ID LEFT JOIN preis AS pr ON au.preis_ID=pr.preis_ID  GROUP BY b.band_ID ORDER BY b.Name, s.name, re.kurzname