| 2 | SELECT `Venue`.`id`, `Venue`.`name`, `Venue`.`address`, `Venue`.`phone`, `Venue`.`cost`, `Venue`.`google_map_link`, `Venue`.`terms`, `Venue`.`honesty_box`, `Venue`.`notes`, `Venue`.`booking_notes`, `Venue`.`image`, `Venue`.`allow_multi_slot_bookings`, `Venue`.`sport_id`, `Venue`.`region_id`, `Venue`.`type`, `Venue`.`clubscol`, `Venue`.`lock_identifier`, `Venue`.`lock_key`, `Venue`.`skip_booking_system`, `Venue`.`email`, `Venue`.`system_notification_email`, `Venue`.`logo`, `Venue`.`display_order`, `Venue`.`email_membership_reminders`, `Venue`.`accept_membership_payments`, `Venue`.`auto_renewal_reminder`, `Venue`.`uses_time_codes`, `Venue`.`booking_requires_confirmation`, `Venue`.`booking_window_days`, `Venue`.`min_bookable_slots`, `Venue`.`max_bookable_slots`, `Venue`.`refresh_bookable_slots`, `Venue`.`cancellation_buffer`, `Venue`.`lock_offline_notification`, `Venue`.`opponent_price`, `Venue`.`terms_url`, `Venue`.`email_members_bookings`, `Venue`.`contact_tracing`, `Venue`.`last_updated`, `Venue`.`timezone`, `Venue`.`google_map_email_link`, `Venue`.`push_notification_type`, `Venue`.`ftp_user`, `Venue`.`ftp_password`, `Venue`.`ftp_address`, `Venue`.`helloclub_key`, `Venue`.`pxpay_user`, `Venue`.`pxpay_key`, `Venue`.`pxpay_email`, `Venue`.`pxpost_user`, `Venue`.`pxpost_pass`, `Venue`.`player_count` FROM `pay2playtest`.`venues` AS `Venue` WHERE `Venue`.`id` = 72 ORDER BY `Venue`.`name` ASC LIMIT 1 | | 1 | 1 | 1 |
| 3 | 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-06-14' 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 AND `Facility`.`venue_id` = 72
ORDER BY `start_date`, `start_time` | | 2 | 2 | 100 |
