Venue has no facilities
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 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 `testp2p`.`venues` AS `Venue` WHERE `type` IN (0, 2, 3) ORDER BY `display_order` ASC | 117 | 117 | 9 | |
| 2 | SELECT `Region`.`id`, `Region`.`name` FROM `testp2p`.`regions` AS `Region` WHERE 1 = 1 | 16 | 16 | 0 | |
| 3 | SELECT `Sport`.`id`, `Sport`.`name` FROM `testp2p`.`sports` AS `Sport` WHERE 1 = 1 | 13 | 13 | 0 |