| 2 | SELECT DISTINCT `Reservation`.`id`, `Reservation`.`name`, `Reservation`.`start_date`,
`Reservation`.`start_time`, `Reservation`.`finish_time`, `Reservation`.`description`,Reservation.members_only,
`Reservation`.`max_participants`, `Reservation`.`default_price`, participant_count.cnt, venues.name as venue
FROM `facility_reservations` AS `FacilityReservation`
LEFT JOIN `reservations` AS `Reservation` ON (`FacilityReservation`.`reservation_id` = `Reservation`.`id`
AND `Reservation`.`start_date` >= '2025-08-03' AND `Reservation`.`type` = 2)
LEFT JOIN `facilities` AS `Facility` ON (`FacilityReservation`.`facility_id` = `Facility`.`id`)
LEFT JOIN venues ON Facility.venue_id = venues.id
LEFT JOIN (SELECT reservation_id, COUNT(*) as cnt FROM participants GROUP BY reservation_id) participant_count ON participant_count.reservation_id = `Reservation`.`id`
WHERE `Reservation`.`id` IS NOT NULL
ORDER BY `start_date`, `start_time` | | 7 | 7 | 159 |
