Events : Pay2Play™

Filter

Available Events for Pettigrew Green Arena

Select Venue

Action Sports & Leisure

Albany Tennis Park

Alexandra Squash Club

Ascot Hub

Avon Hub

Badminton - Coaching

Badminton Canterbury

Badminton Southland

Badminton Whanganui

Belfast Tennis Club

Bucklands Beach Tennis Club

Burwood Park Tennis Club

Cambridge Netball Centre

Cambridge Racquets Club

Canoe Polo Hawkes Bay

Cashmere Tennis Club

Central Districts Cricket

Chatham Island Squash Club

Clutch Coaching

Cornwall Cricket Club

Cricket Whanganui Indoor Centre

Dean Remihana

Demo Tennis & Squash Club

Devonport Squash Club

Dink Pickleball at Cashmere Club

DWC Westland Sports Hub

Eastern Canopy

Eastern Hub

Eastlink Sports

Eskview Tennis Club

Geyser City Squash Club

Gisborne Equestrian

Golflands Pickleball

Grafton United Cricket Club

Greendale Tennis Club

Hastings NZDA Club Rooms

Hastings Tennis & Squash Club

Hautapu Sports Club

Havelock North Squash Club

Hawera Tennis & Squash Club

Hawke's Bay Tennis & Squash

Hawkes Bay Squash Rackets Club

Hereworth School

Herne Bay Rackets Club

HH Badminton

Huntly Squash Club

Kashif Shuja

Lakes Squash Rotorua

Linwood Squash Club

Luke Donovan Tennis Coaching

Lynmore Tennis Club

Lyttelton Recreation Centre

Manawatu Cricket

Manurewa Tennis Club

Meeanee Indoor Sports Centre

Napier Tech Indoor Cricket Centre

Netball North Harbour

Nga Puna Wai Tennis

Ngaruawahia Squash Club

Northland Cricket Indoor Centre

NZ Badminton Test Venue

Onemana Community Pools

Otago Boys Tennis Dome

Otago Sports

Otago Squash Club

Palmerston Squash Club

Pettigrew Green Arena

Phil (Chook) Drummond

Private Venue

Pukeko Centre

Putaruru Squash Club

Queenstown Squash Club

Queenstown Tennis Club

Rakaia Squash Club

Rangitikei Squash Club

Ricardo Stanley Squash

Rotorua Badminton

Rotorua Hockey

Royal Oak Racquets Club

Saxton Indoor Community Centre

School Demonstration site

Scotts College

Seddon Park Indoor Cricket Nets

Shirley Tennis Club

Sir Richard Hadlee Sports Centre

Spreydon Tennis Club

Springvale Stadium

Squash HQ

Surf City Squash Club

Sydenham Indoor Centre

Taupo Squash Club

Temuka Squash Club

Tennis Canterbury Masters

Test Venue

University of Otago Squash Club

Upper Hutt Tennis Club

Volley South

Waikato Indoor Tennis Centre

Waikato Tennis Centre - Outdoor

Waikato University Cricket Nets

Waipukurau Lawn Tennis & Squash Club

Wairoa Athletic Squash Club

Weedons Cricket Club

Westend Community Tennis

Whakatane Hockey

Whanganui Table Tennis

Wilding Park Tennis Centre

YMCA Masterton

Zhu Badminton Centre

All Venues

Show entries

Search:

ID	Name	Start Date	Finish Date	Description	Spaces	Price
Loading...

Showing 0 to 0 of 0 entries

(default) 11 queries took 105 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT `Venue`.`id`, `Venue`.`name` FROM `pay2playtest`.`venues` AS `Venue` WHERE 1 = 1 ORDER BY `Venue`.`name` ASC	109	109	5
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`, `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` = 122 ORDER BY `Venue`.`name` ASC LIMIT 1	1	1	1
3	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` = (122)	1	1	1
4	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` = (122)	3	3	11
5	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` = (122)	2	2	74
6	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` = (122)	0	0	8
7	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` = (122)	2	2	1
8	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` = (122) ORDER BY `TimeCode`.`date_to` ASC	0	0	0
9	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` = (122)	0	0	0
10	SELECT `Tag`.`id`, `Tag`.`venue_id`, `Tag`.`name`, `Tag`.`created` FROM `pay2playtest`.`tags` AS `Tag` WHERE `Tag`.`venue_id` = (122)	0	0	1
11	SELECT `EmailTemplate`.`id`, `EmailTemplate`.`name`, `EmailTemplate`.`content`, `EmailTemplate`.`venue_id`, `EmailTemplate`.`created`, `EmailTemplate`.`modified` FROM `pay2playtest`.`email_templates` AS `EmailTemplate` WHERE `EmailTemplate`.`venue_id` = (122)	0	0	3