Kode
SELECT r.*, (SELECT GROUP_CONCAT(a.name SEPARATOR ', ') FROM reservation res LEFT JOIN animal_has_reservation ahr ON res.idReservation = ahr.reservation_idreservation LEFT JOIN animal a ON ahr.animal_idanimal = a.idAnimal WHERE r.idRoom = res.roomId AND (current_timestamp() BETWEEN res.startDate AND res.endDate)) AS resHunder FROM room r ORDER BY r.size DESC, r.number ASC
Noen skarpe som tar denne relativt kjapt?