Book a Session : Pay2Play™

Squash

Tennis

Click on a date

Legend

Available

Special Rate

Reserved

Members Only

Class / Event

Booked

Guest Booking

Your Bookings

Choose a court & time slot for Waipukurau Lawn Tennis & Squash Club

Continue

(default) 25 queries took 96 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT COUNT(*) AS `count` FROM `pay2playtest`.`venues` AS `Venue` WHERE `Venue`.`id` = 85	1	1	0
2	SELECT `Venue`.`id`, `Venue`.`name`, `Venue`.`skip_booking_system`, `Venue`.`max_bookable_slots`, `Venue`.`min_bookable_slots`, `Venue`.`refresh_bookable_slots`, `Venue`.`cost`, `Venue`.`type`, `Venue`.`contact_tracing`, `Venue`.`timezone` FROM `pay2playtest`.`venues` AS `Venue` WHERE `Venue`.`id` = 85 LIMIT 1	1	1	0
3	SELECT `Facility`.`id`, `Facility`.`name`, `Facility`.`slot_duration_mins`, `Facility`.`daily_start_time`, `Facility`.`daily_end_time`, `Facility`.`venue_id`, `Facility`.`facility_type_id` FROM `pay2playtest`.`facilities` AS `Facility` WHERE `hidden` = 0 AND `Facility`.`venue_id` = (85)	12	12	5
4	SELECT `FacilityType`.`id`, `FacilityType`.`name`, `FacilityType`.`created`, `FacilityType`.`modified` FROM `pay2playtest`.`facility_types` AS `FacilityType` WHERE `FacilityType`.`id` = 1	1	1	0
5	SELECT `FacilityType`.`id`, `FacilityType`.`name`, `FacilityType`.`created`, `FacilityType`.`modified` FROM `pay2playtest`.`facility_types` AS `FacilityType` WHERE `FacilityType`.`id` = 1	1	1	0
6	SELECT `FacilityType`.`id`, `FacilityType`.`name`, `FacilityType`.`created`, `FacilityType`.`modified` FROM `pay2playtest`.`facility_types` AS `FacilityType` WHERE `FacilityType`.`id` = 1	1	1	0
7	SELECT `FacilityType`.`id`, `FacilityType`.`name`, `FacilityType`.`created`, `FacilityType`.`modified` FROM `pay2playtest`.`facility_types` AS `FacilityType` WHERE `FacilityType`.`id` = 2	1	1	0
8	SELECT `FacilityType`.`id`, `FacilityType`.`name`, `FacilityType`.`created`, `FacilityType`.`modified` FROM `pay2playtest`.`facility_types` AS `FacilityType` WHERE `FacilityType`.`id` = 2	1	1	0
9	SELECT `FacilityType`.`id`, `FacilityType`.`name`, `FacilityType`.`created`, `FacilityType`.`modified` FROM `pay2playtest`.`facility_types` AS `FacilityType` WHERE `FacilityType`.`id` = 2	1	1	0
10	SELECT `FacilityType`.`id`, `FacilityType`.`name`, `FacilityType`.`created`, `FacilityType`.`modified` FROM `pay2playtest`.`facility_types` AS `FacilityType` WHERE `FacilityType`.`id` = 2	1	1	0
11	SELECT `FacilityType`.`id`, `FacilityType`.`name`, `FacilityType`.`created`, `FacilityType`.`modified` FROM `pay2playtest`.`facility_types` AS `FacilityType` WHERE `FacilityType`.`id` = 2	1	1	0
12	SELECT `FacilityType`.`id`, `FacilityType`.`name`, `FacilityType`.`created`, `FacilityType`.`modified` FROM `pay2playtest`.`facility_types` AS `FacilityType` WHERE `FacilityType`.`id` = 2	1	1	0
13	SELECT `FacilityType`.`id`, `FacilityType`.`name`, `FacilityType`.`created`, `FacilityType`.`modified` FROM `pay2playtest`.`facility_types` AS `FacilityType` WHERE `FacilityType`.`id` = 2	1	1	0
14	SELECT `FacilityType`.`id`, `FacilityType`.`name`, `FacilityType`.`created`, `FacilityType`.`modified` FROM `pay2playtest`.`facility_types` AS `FacilityType` WHERE `FacilityType`.`id` = 2	1	1	0
15	SELECT `FacilityType`.`id`, `FacilityType`.`name`, `FacilityType`.`created`, `FacilityType`.`modified` FROM `pay2playtest`.`facility_types` AS `FacilityType` WHERE `FacilityType`.`id` = 2	1	1	0
16	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`, `Sport`.`id`, `Sport`.`name`, `Region`.`id`, `Region`.`name` FROM `pay2playtest`.`venues` AS `Venue` LEFT JOIN `pay2playtest`.`sports` AS `Sport` ON (`Venue`.`sport_id` = `Sport`.`id`) LEFT JOIN `pay2playtest`.`regions` AS `Region` ON (`Venue`.`region_id` = `Region`.`id`) WHERE `Venue`.`id` = 85 LIMIT 1	1	1	1
17	SELECT `Membership`.`id`, `Membership`.`valid_till`, `Membership`.`suspended`, `Membership`.`club_admin`, `Membership`.`reservation_admin`, `Membership`.`user_id`, `Membership`.`venue_id`, `Membership`.`security_code`, `Membership`.`membership_number`, `Membership`.`multi_select`, `Membership`.`membership_category_id`, `Membership`.`parent_id`, `Membership`.`student_id`, `Membership`.`card_number`, `Membership`.`accepted_terms`, `Membership`.`accepted_terms_timestamp`, `Membership`.`created`, `Membership`.`modified`, `Membership`.`renewal_approval_date`, `Membership`.`notes` FROM `pay2playtest`.`memberships` AS `Membership` WHERE `Membership`.`venue_id` = (85)	513	513	5
18	SELECT `Facility`.`id`, `Facility`.`name`, `Facility`.`description`, `Facility`.`slot_duration_mins`, `Facility`.`daily_start_time`, `Facility`.`daily_end_time`, `Facility`.`venue_id`, `Facility`.`default_price`, `Facility`.`sponsor_logo`, `Facility`.`facility_type_id`, `Facility`.`lights_pre_start_sec`, `Facility`.`lights_post_finish_sec`, `Facility`.`lights_darken`, `Facility`.`email`, `Facility`.`controller_ip`, `Facility`.`guest_start_time`, `Facility`.`guest_end_time`, `Facility`.`created`, `Facility`.`modified`, `Facility`.`hidden` FROM `pay2playtest`.`facilities` AS `Facility` WHERE `Facility`.`venue_id` = (85)	12	12	1
19	SELECT `Event`.`id`, `Event`.`name`, `Event`.`start_time`, `Event`.`finish_time`, `Event`.`start_date`, `Event`.`finish_date`, `Event`.`entry_cut_off`, `Event`.`description`, `Event`.`interval`, `Event`.`recurring_id`, `Event`.`type`, `Event`.`max_participants`, `Event`.`participant_count`, `Event`.`default_price`, `Event`.`sponsor_logo`, `Event`.`members_only`, `Event`.`txn_id`, `Event`.`created`, `Event`.`modified`, `Event`.`hold_doors`, `Event`.`venue_id` FROM `pay2playtest`.`reservations` AS `Event` WHERE `Event`.`venue_id` = (85)	152	152	72
20	SELECT `Voucher`.`id`, `Voucher`.`venue_id`, `Voucher`.`discount`, `Voucher`.`amount`, `Voucher`.`expires`, `Voucher`.`max_use`, `Voucher`.`use_count`, `Voucher`.`created`, `Voucher`.`modified`, `Voucher`.`name`, `Voucher`.`code` FROM `pay2playtest`.`vouchers` AS `Voucher` WHERE `Voucher`.`venue_id` = (85)	3	3	7
21	SELECT `MembershipCategory`.`id`, `MembershipCategory`.`venue_id`, `MembershipCategory`.`name`, `MembershipCategory`.`renewal_period_months`, `MembershipCategory`.`advanced_warning_days`, `MembershipCategory`.`cost`, `MembershipCategory`.`group_type`, `MembershipCategory`.`created`, `MembershipCategory`.`modified`, `MembershipCategory`.`recurring_billing`, `MembershipCategory`.`hide_from_public`, `MembershipCategory`.`casual_membership`, `MembershipCategory`.`renewal_requires_confirmation` FROM `pay2playtest`.`membership_categories` AS `MembershipCategory` WHERE `MembershipCategory`.`venue_id` = (85)	13	13	1
22	SELECT `TimeCode`.`id`, `TimeCode`.`venue_id`, `TimeCode`.`date_to`, `TimeCode`.`time_to`, `TimeCode`.`code`, `TimeCode`.`created`, `TimeCode`.`modified` FROM `pay2playtest`.`time_codes` AS `TimeCode` WHERE `TimeCode`.`date_to` >= CURDATE() AND `TimeCode`.`venue_id` = (85) ORDER BY `TimeCode`.`date_to` ASC	0	0	0
23	SELECT `Door`.`id`, `Door`.`venue_id`, `Door`.`name`, `Door`.`identifier`, `Door`.`last_contact`, `Door`.`created`, `Door`.`software_version`, `Door`.`ip`, `Door`.`door_key`, `Door`.`controller_id`, `Door`.`controller_door_id` FROM `pay2playtest`.`doors` AS `Door` WHERE `Door`.`venue_id` = (85)	2	2	0
24	SELECT `Tag`.`id`, `Tag`.`venue_id`, `Tag`.`name`, `Tag`.`created` FROM `pay2playtest`.`tags` AS `Tag` WHERE `Tag`.`venue_id` = (85)	22	22	1
25	SELECT `EmailTemplate`.`id`, `EmailTemplate`.`name`, `EmailTemplate`.`content`, `EmailTemplate`.`venue_id`, `EmailTemplate`.`created`, `EmailTemplate`.`modified` FROM `pay2playtest`.`email_templates` AS `EmailTemplate` WHERE `EmailTemplate`.`venue_id` = (85)	22	22	3