| 1 | 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 `type` IN (0, 2, 3) ORDER BY `display_order` ASC | | 101 | 101 | 34 |
