SELECT `r`.`room_id` as `room_id`, `r`.`number` as `number`, `r`.`price` as `price`, `r`.`bedrooms` as `bedrooms`, `r`.`single_beds` as `single_beds`, `r`.`double_beds` as `double_beds`, `c`.`safe` as `safe`, `c`.`minibar` as `minibar`, `c`.`jacuzzi` as `jacuzzi`, `c`.`cabelTV` as `cabelTV`, `c`.`fiberInternet` as `fiberInternet`, `c`.`additional_personnel` as `additional_personnel`
FROM `rooms` as `r`
JOIN `class` as `c` ON `r`.`class_id` = `c`.`id`
JOIN `reservations` as `res` ON `res`.`room_id` = `r`.`room_id`
WHERE `res`.`from` >= '2015-06-24' OR `res`.`until` <= '2015-06-07' AND `r`.`price` <= '500' AND `c`.`safe` >= '0' AND `c`.`minibar` >= '0' AND `c`.`jacuzzi` >= '0' AND `c`.`cabelTV` >= '0' AND `c`.`fiberInternet` >= '0' AND `c`.`additional_personnel` >= '0' ORDER BY `r`.`price` ASC