SELECT hotel_hot.ort_hot FROM arrangements_arr LEFT JOIN hotel_hot ON hotel_hot.id_hot = arrangements_arr.idhot_arr LEFT JOIN arrtooak_ato ON arrtooak_ato.idarr_ato = arrangements_arr.id_arr LEFT JOIN opt_agkategorie_oak ON opt_agkategorie_oak.id_oak = arrtooak_ato.idoak_ato LEFT JOIN opt_agkategorie_spr_oas ON opt_agkategorie_spr_oas.idoak_oas = opt_agkategorie_oak.id_oak WHERE arrangements_arr.idsta_arr =1 AND arrtooak_ato.idoak_ato = '2' AND arrangements_arr.idspr_arr = 1 AND arrangements_arr.ende_arr >= CURDATE() GROUP BY hotel_hot.ort_hot ORDER BY hotel_hot.ort_hot, hotel_hot.hotel_hot