| 1 |
0.93 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.keycloak_id AS keycloak_id_3, t0.created_at AS created_at_4, t0.username AS username_5, t0.last_login AS last_login_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.register_id AS register_id_9, t0.keycloakGroup AS keycloakGroup_10, t0.uid AS uid_11, t0.own_room_uid AS own_room_uid_12, t0.time_zone AS time_zone_13, t0.spezial_properties AS spezial_properties_14, t0.indexer AS indexer_15, t0.second_email AS second_email_16, t0.updated_at AS updated_at_17, t0.online_status AS online_status_18, t0.accept_terms_and_conditions AS accept_terms_and_conditions_19, t0.is_sip_video_user AS is_sip_video_user_20, t0.calendly_token AS calendly_token_21, t0.calendly_org_uri AS calendly_org_uri_22, t0.calendly_user_uri AS calendly_user_uri_23, t0.calendly_sucessfully_added AS calendly_sucessfully_added_24, t0.calendly_secret AS calendly_secret_25, t0.calendly_webhook_id AS calendly_webhook_id_26, t0.my_own_room_server_id AS my_own_room_server_id_27, t28.id AS id_29, t28.ldap_host AS ldap_host_30, t28.ldap_dn AS ldap_dn_31, t28.rdn AS rdn_32, t28.ldap_number AS ldap_number_33, t28.user_id AS user_id_34, t0.profile_picture_id AS profile_picture_id_35, t0.calendly_server_id AS calendly_server_id_36 FROM fos_user t0 LEFT JOIN ldap_user_properties t28 ON t28.user_id = t0.id
SELECT t0.id AS id_1, t0.email AS email_2, t0.keycloak_id AS keycloak_id_3, t0.created_at AS created_at_4, t0.username AS username_5, t0.last_login AS last_login_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.register_id AS register_id_9, t0.keycloakGroup AS keycloakGroup_10, t0.uid AS uid_11, t0.own_room_uid AS own_room_uid_12, t0.time_zone AS time_zone_13, t0.spezial_properties AS spezial_properties_14, t0.indexer AS indexer_15, t0.second_email AS second_email_16, t0.updated_at AS updated_at_17, t0.online_status AS online_status_18, t0.accept_terms_and_conditions AS accept_terms_and_conditions_19, t0.is_sip_video_user AS is_sip_video_user_20, t0.calendly_token AS calendly_token_21, t0.calendly_org_uri AS calendly_org_uri_22, t0.calendly_user_uri AS calendly_user_uri_23, t0.calendly_sucessfully_added AS calendly_sucessfully_added_24, t0.calendly_secret AS calendly_secret_25, t0.calendly_webhook_id AS calendly_webhook_id_26, t0.my_own_room_server_id AS my_own_room_server_id_27, t28.id AS id_29, t28.ldap_host AS ldap_host_30, t28.ldap_dn AS ldap_dn_31, t28.rdn AS rdn_32, t28.ldap_number AS ldap_number_33, t28.user_id AS user_id_34, t0.profile_picture_id AS profile_picture_id_35, t0.calendly_server_id AS calendly_server_id_36 FROM fos_user t0 LEFT JOIN ldap_user_properties t28 ON t28.user_id = t0.id;
|
| 2 |
1.17 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.app_id AS app_id_3, t0.app_secret AS app_secret_4, t0.logo_url AS logo_url_5, t0.smtp_host AS smtp_host_6, t0.smtp_port AS smtp_port_7, t0.smtp_password AS smtp_password_8, t0.smtp_username AS smtp_username_9, t0.smtp_encryption AS smtp_encryption_10, t0.smtp_email AS smtp_email_11, t0.smtp_sender_name AS smtp_sender_name_12, t0.slug AS slug_13, t0.privacy_policy AS privacy_policy_14, t0.license_key AS license_key_15, t0.api_key AS api_key_16, t0.static_background_color AS static_background_color_17, t0.show_static_background_color AS show_static_background_color_18, t0.feature_enable_by_jwt AS feature_enable_by_jwt_19, t0.server_email_header AS server_email_header_20, t0.server_email_body AS server_email_body_21, t0.jwt_moderator_position AS jwt_moderator_position_22, t0.server_name AS server_name_23, t0.cors_header AS cors_header_24, t0.updated_at AS updated_at_25, t0.jigasi_api_url AS jigasi_api_url_26, t0.jigasi_number_url AS jigasi_number_url_27, t0.jigasi_prosody_domain AS jigasi_prosody_domain_28, t0.star_url AS star_url_29, t0.star_server_id AS star_server_id_30, t0.disallow_firefox AS disallow_firefox_31, t0.enforce_e2e AS enforce_e2e_32, t0.allow_ip AS allow_ip_33, t0.dynamic_branding_url AS dynamic_branding_url_34, t0.jitsi_event_sync_url AS jitsi_event_sync_url_35, t0.disable_filmstripe AS disable_filmstripe_36, t0.disable_etherpad AS disable_etherpad_37, t0.disable_whiteboard AS disable_whiteboard_38, t0.disable_chat AS disable_chat_39, t0.prefix_room_uid_with_hash AS prefix_room_uid_with_hash_40, t0.live_kit_server AS live_kit_server_41, t0.livekit_middleware_url AS livekit_middleware_url_42, t0.livekit_background_images AS livekit_background_images_43, t0.enable_recording AS enable_recording_44, t0.is_allowed_to_clone_for_autoscale AS is_allowed_to_clone_for_autoscale_45, t0.administrator_id AS administrator_id_46, t0.server_background_image_id AS server_background_image_id_47 FROM server t0
SELECT
t0.id AS id_1,
t0.url AS url_2,
t0.app_id AS app_id_3,
t0.app_secret AS app_secret_4,
t0.logo_url AS logo_url_5,
t0.smtp_host AS smtp_host_6,
t0.smtp_port AS smtp_port_7,
t0.smtp_password AS smtp_password_8,
t0.smtp_username AS smtp_username_9,
t0.smtp_encryption AS smtp_encryption_10,
t0.smtp_email AS smtp_email_11,
t0.smtp_sender_name AS smtp_sender_name_12,
t0.slug AS slug_13,
t0.privacy_policy AS privacy_policy_14,
t0.license_key AS license_key_15,
t0.api_key AS api_key_16,
t0.static_background_color AS static_background_color_17,
t0.show_static_background_color AS show_static_background_color_18,
t0.feature_enable_by_jwt AS feature_enable_by_jwt_19,
t0.server_email_header AS server_email_header_20,
t0.server_email_body AS server_email_body_21,
t0.jwt_moderator_position AS jwt_moderator_position_22,
t0.server_name AS server_name_23,
t0.cors_header AS cors_header_24,
t0.updated_at AS updated_at_25,
t0.jigasi_api_url AS jigasi_api_url_26,
t0.jigasi_number_url AS jigasi_number_url_27,
t0.jigasi_prosody_domain AS jigasi_prosody_domain_28,
t0.star_url AS star_url_29,
t0.star_server_id AS star_server_id_30,
t0.disallow_firefox AS disallow_firefox_31,
t0.enforce_e2e AS enforce_e2e_32,
t0.allow_ip AS allow_ip_33,
t0.dynamic_branding_url AS dynamic_branding_url_34,
t0.jitsi_event_sync_url AS jitsi_event_sync_url_35,
t0.disable_filmstripe AS disable_filmstripe_36,
t0.disable_etherpad AS disable_etherpad_37,
t0.disable_whiteboard AS disable_whiteboard_38,
t0.disable_chat AS disable_chat_39,
t0.prefix_room_uid_with_hash AS prefix_room_uid_with_hash_40,
t0.live_kit_server AS live_kit_server_41,
t0.livekit_middleware_url AS livekit_middleware_url_42,
t0.livekit_background_images AS livekit_background_images_43,
t0.enable_recording AS enable_recording_44,
t0.is_allowed_to_clone_for_autoscale AS is_allowed_to_clone_for_autoscale_45,
t0.administrator_id AS administrator_id_46,
t0.server_background_image_id AS server_background_image_id_47
FROM
server t0
SELECT t0.id AS id_1, t0.url AS url_2, t0.app_id AS app_id_3, t0.app_secret AS app_secret_4, t0.logo_url AS logo_url_5, t0.smtp_host AS smtp_host_6, t0.smtp_port AS smtp_port_7, t0.smtp_password AS smtp_password_8, t0.smtp_username AS smtp_username_9, t0.smtp_encryption AS smtp_encryption_10, t0.smtp_email AS smtp_email_11, t0.smtp_sender_name AS smtp_sender_name_12, t0.slug AS slug_13, t0.privacy_policy AS privacy_policy_14, t0.license_key AS license_key_15, t0.api_key AS api_key_16, t0.static_background_color AS static_background_color_17, t0.show_static_background_color AS show_static_background_color_18, t0.feature_enable_by_jwt AS feature_enable_by_jwt_19, t0.server_email_header AS server_email_header_20, t0.server_email_body AS server_email_body_21, t0.jwt_moderator_position AS jwt_moderator_position_22, t0.server_name AS server_name_23, t0.cors_header AS cors_header_24, t0.updated_at AS updated_at_25, t0.jigasi_api_url AS jigasi_api_url_26, t0.jigasi_number_url AS jigasi_number_url_27, t0.jigasi_prosody_domain AS jigasi_prosody_domain_28, t0.star_url AS star_url_29, t0.star_server_id AS star_server_id_30, t0.disallow_firefox AS disallow_firefox_31, t0.enforce_e2e AS enforce_e2e_32, t0.allow_ip AS allow_ip_33, t0.dynamic_branding_url AS dynamic_branding_url_34, t0.jitsi_event_sync_url AS jitsi_event_sync_url_35, t0.disable_filmstripe AS disable_filmstripe_36, t0.disable_etherpad AS disable_etherpad_37, t0.disable_whiteboard AS disable_whiteboard_38, t0.disable_chat AS disable_chat_39, t0.prefix_room_uid_with_hash AS prefix_room_uid_with_hash_40, t0.live_kit_server AS live_kit_server_41, t0.livekit_middleware_url AS livekit_middleware_url_42, t0.livekit_background_images AS livekit_background_images_43, t0.enable_recording AS enable_recording_44, t0.is_allowed_to_clone_for_autoscale AS is_allowed_to_clone_for_autoscale_45, t0.administrator_id AS administrator_id_46, t0.server_background_image_id AS server_background_image_id_47 FROM server t0;
|
| 3 |
1.44 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.start AS start_3, t0.enddate AS enddate_4, t0.uid AS uid_5, t0.duration AS duration_6, t0.sequence AS sequence_7, t0.uid_real AS uid_real_8, t0.only_registered_users AS only_registered_users_9, t0.agenda AS agenda_10, t0.dissallow_screenshare_global AS dissallow_screenshare_global_11, t0.dissallow_private_message AS dissallow_private_message_12, t0.public AS public_13, t0.show_room_on_joinpage AS show_room_on_joinpage_14, t0.uid_participant AS uid_participant_15, t0.uid_moderator AS uid_moderator_16, t0.max_participants AS max_participants_17, t0.schedule_meeting AS schedule_meeting_18, t0.waitinglist AS waitinglist_19, t0.repeater_removed AS repeater_removed_20, t0.persistant_room AS persistant_room_21, t0.slug AS slug_22, t0.total_open_rooms AS total_open_rooms_23, t0.total_open_rooms_open_time AS total_open_rooms_open_time_24, t0.time_zone AS time_zone_25, t0.start_utc AS start_utc_26, t0.end_date_utc AS end_date_utc_27, t0.lobby AS lobby_28, t0.start_timestamp AS start_timestamp_29, t0.end_timestamp AS end_timestamp_30, t0.host_url AS host_url_31, t0.secondary_name AS secondary_name_32, t0.allow_maybe_option AS allow_maybe_option_33, t0.max_user AS max_user_34, t0.disable_self_subscription_double_opt_in AS disable_self_subscription_double_opt_in_35, t0.calendly_uri AS calendly_uri_36, t0.server_id AS server_id_37, t38.id AS id_39, t38.url AS url_40, t38.app_id AS app_id_41, t38.app_secret AS app_secret_42, t38.logo_url AS logo_url_43, t38.smtp_host AS smtp_host_44, t38.smtp_port AS smtp_port_45, t38.smtp_password AS smtp_password_46, t38.smtp_username AS smtp_username_47, t38.smtp_encryption AS smtp_encryption_48, t38.smtp_email AS smtp_email_49, t38.smtp_sender_name AS smtp_sender_name_50, t38.slug AS slug_51, t38.privacy_policy AS privacy_policy_52, t38.license_key AS license_key_53, t38.api_key AS api_key_54, t38.static_background_color AS static_background_color_55, t38.show_static_background_color AS show_static_background_color_56, t38.feature_enable_by_jwt AS feature_enable_by_jwt_57, t38.server_email_header AS server_email_header_58, t38.server_email_body AS server_email_body_59, t38.jwt_moderator_position AS jwt_moderator_position_60, t38.server_name AS server_name_61, t38.cors_header AS cors_header_62, t38.updated_at AS updated_at_63, t38.jigasi_api_url AS jigasi_api_url_64, t38.jigasi_number_url AS jigasi_number_url_65, t38.jigasi_prosody_domain AS jigasi_prosody_domain_66, t38.star_url AS star_url_67, t38.star_server_id AS star_server_id_68, t38.disallow_firefox AS disallow_firefox_69, t38.enforce_e2e AS enforce_e2e_70, t38.allow_ip AS allow_ip_71, t38.dynamic_branding_url AS dynamic_branding_url_72, t38.jitsi_event_sync_url AS jitsi_event_sync_url_73, t38.disable_filmstripe AS disable_filmstripe_74, t38.disable_etherpad AS disable_etherpad_75, t38.disable_whiteboard AS disable_whiteboard_76, t38.disable_chat AS disable_chat_77, t38.prefix_room_uid_with_hash AS prefix_room_uid_with_hash_78, t38.live_kit_server AS live_kit_server_79, t38.livekit_middleware_url AS livekit_middleware_url_80, t38.livekit_background_images AS livekit_background_images_81, t38.enable_recording AS enable_recording_82, t38.is_allowed_to_clone_for_autoscale AS is_allowed_to_clone_for_autoscale_83, t38.administrator_id AS administrator_id_84, t38.server_background_image_id AS server_background_image_id_85, t0.moderator_id AS moderator_id_86, t0.repeater_id AS repeater_id_87, t88.id AS id_89, t88.repetation AS repetation_90, t88.repeat_until AS repeat_until_91, t88.weekday AS weekday_92, t88.weeks AS weeks_93, t88.months AS months_94, t88.days AS days_95, t88.repeat_type AS repeat_type_96, t88.repeater_days AS repeater_days_97, t88.repeater_weeks AS repeater_weeks_98, t88.repeat_montly AS repeat_montly_99, t88.repeat_yearly AS repeat_yearly_100, t88.start_date AS start_date_101, t88.repat_month_relativ_number AS repat_month_relativ_number_102, t88.repat_month_relativ_weekday AS repat_month_relativ_weekday_103, t88.repeat_yearly_relative_number AS repeat_yearly_relative_number_104, t88.repeat_yearly_relative_month AS repeat_yearly_relative_month_105, t88.repeat_yearly_relative_weekday AS repeat_yearly_relative_weekday_106, t88.repeat_monthly_relative_how_often AS repeat_monthly_relative_how_often_107, t88.repeat_yearly_relative_how_often AS repeat_yearly_relative_how_often_108, t88.uid AS uid_109, t88.prototyp_id AS prototyp_id_110, t111.id AS id_112, t111.caller_id AS caller_id_113, t111.created_at AS created_at_114, t111.room_id AS room_id_115, t0.tag_id AS tag_id_116, t0.creator_id AS creator_id_117 FROM rooms t0 INNER JOIN server t38 ON t0.server_id = t38.id LEFT JOIN `repeat` t88 ON t88.prototyp_id = t0.id LEFT JOIN caller_room t111 ON t111.room_id = t0.id
SELECT
t0.id AS id_1,
t0.name AS name_2,
t0.start AS start_3,
t0.enddate AS enddate_4,
t0.uid AS uid_5,
t0.duration AS duration_6,
t0.sequence AS sequence_7,
t0.uid_real AS uid_real_8,
t0.only_registered_users AS only_registered_users_9,
t0.agenda AS agenda_10,
t0.dissallow_screenshare_global AS dissallow_screenshare_global_11,
t0.dissallow_private_message AS dissallow_private_message_12,
t0.public AS public_13,
t0.show_room_on_joinpage AS show_room_on_joinpage_14,
t0.uid_participant AS uid_participant_15,
t0.uid_moderator AS uid_moderator_16,
t0.max_participants AS max_participants_17,
t0.schedule_meeting AS schedule_meeting_18,
t0.waitinglist AS waitinglist_19,
t0.repeater_removed AS repeater_removed_20,
t0.persistant_room AS persistant_room_21,
t0.slug AS slug_22,
t0.total_open_rooms AS total_open_rooms_23,
t0.total_open_rooms_open_time AS total_open_rooms_open_time_24,
t0.time_zone AS time_zone_25,
t0.start_utc AS start_utc_26,
t0.end_date_utc AS end_date_utc_27,
t0.lobby AS lobby_28,
t0.start_timestamp AS start_timestamp_29,
t0.end_timestamp AS end_timestamp_30,
t0.host_url AS host_url_31,
t0.secondary_name AS secondary_name_32,
t0.allow_maybe_option AS allow_maybe_option_33,
t0.max_user AS max_user_34,
t0.disable_self_subscription_double_opt_in AS disable_self_subscription_double_opt_in_35,
t0.calendly_uri AS calendly_uri_36,
t0.server_id AS server_id_37,
t38.id AS id_39,
t38.url AS url_40,
t38.app_id AS app_id_41,
t38.app_secret AS app_secret_42,
t38.logo_url AS logo_url_43,
t38.smtp_host AS smtp_host_44,
t38.smtp_port AS smtp_port_45,
t38.smtp_password AS smtp_password_46,
t38.smtp_username AS smtp_username_47,
t38.smtp_encryption AS smtp_encryption_48,
t38.smtp_email AS smtp_email_49,
t38.smtp_sender_name AS smtp_sender_name_50,
t38.slug AS slug_51,
t38.privacy_policy AS privacy_policy_52,
t38.license_key AS license_key_53,
t38.api_key AS api_key_54,
t38.static_background_color AS static_background_color_55,
t38.show_static_background_color AS show_static_background_color_56,
t38.feature_enable_by_jwt AS feature_enable_by_jwt_57,
t38.server_email_header AS server_email_header_58,
t38.server_email_body AS server_email_body_59,
t38.jwt_moderator_position AS jwt_moderator_position_60,
t38.server_name AS server_name_61,
t38.cors_header AS cors_header_62,
t38.updated_at AS updated_at_63,
t38.jigasi_api_url AS jigasi_api_url_64,
t38.jigasi_number_url AS jigasi_number_url_65,
t38.jigasi_prosody_domain AS jigasi_prosody_domain_66,
t38.star_url AS star_url_67,
t38.star_server_id AS star_server_id_68,
t38.disallow_firefox AS disallow_firefox_69,
t38.enforce_e2e AS enforce_e2e_70,
t38.allow_ip AS allow_ip_71,
t38.dynamic_branding_url AS dynamic_branding_url_72,
t38.jitsi_event_sync_url AS jitsi_event_sync_url_73,
t38.disable_filmstripe AS disable_filmstripe_74,
t38.disable_etherpad AS disable_etherpad_75,
t38.disable_whiteboard AS disable_whiteboard_76,
t38.disable_chat AS disable_chat_77,
t38.prefix_room_uid_with_hash AS prefix_room_uid_with_hash_78,
t38.live_kit_server AS live_kit_server_79,
t38.livekit_middleware_url AS livekit_middleware_url_80,
t38.livekit_background_images AS livekit_background_images_81,
t38.enable_recording AS enable_recording_82,
t38.is_allowed_to_clone_for_autoscale AS is_allowed_to_clone_for_autoscale_83,
t38.administrator_id AS administrator_id_84,
t38.server_background_image_id AS server_background_image_id_85,
t0.moderator_id AS moderator_id_86,
t0.repeater_id AS repeater_id_87,
t88.id AS id_89,
t88.repetation AS repetation_90,
t88.repeat_until AS repeat_until_91,
t88.weekday AS weekday_92,
t88.weeks AS weeks_93,
t88.months AS months_94,
t88.days AS days_95,
t88.repeat_type AS repeat_type_96,
t88.repeater_days AS repeater_days_97,
t88.repeater_weeks AS repeater_weeks_98,
t88.repeat_montly AS repeat_montly_99,
t88.repeat_yearly AS repeat_yearly_100,
t88.start_date AS start_date_101,
t88.repat_month_relativ_number AS repat_month_relativ_number_102,
t88.repat_month_relativ_weekday AS repat_month_relativ_weekday_103,
t88.repeat_yearly_relative_number AS repeat_yearly_relative_number_104,
t88.repeat_yearly_relative_month AS repeat_yearly_relative_month_105,
t88.repeat_yearly_relative_weekday AS repeat_yearly_relative_weekday_106,
t88.repeat_monthly_relative_how_often AS repeat_monthly_relative_how_often_107,
t88.repeat_yearly_relative_how_often AS repeat_yearly_relative_how_often_108,
t88.uid AS uid_109,
t88.prototyp_id AS prototyp_id_110,
t111.id AS id_112,
t111.caller_id AS caller_id_113,
t111.created_at AS created_at_114,
t111.room_id AS room_id_115,
t0.tag_id AS tag_id_116,
t0.creator_id AS creator_id_117
FROM
rooms t0
INNER JOIN server t38 ON t0.server_id = t38.id
LEFT JOIN `repeat` t88 ON t88.prototyp_id = t0.id
LEFT JOIN caller_room t111 ON t111.room_id = t0.id
SELECT t0.id AS id_1, t0.name AS name_2, t0.start AS start_3, t0.enddate AS enddate_4, t0.uid AS uid_5, t0.duration AS duration_6, t0.sequence AS sequence_7, t0.uid_real AS uid_real_8, t0.only_registered_users AS only_registered_users_9, t0.agenda AS agenda_10, t0.dissallow_screenshare_global AS dissallow_screenshare_global_11, t0.dissallow_private_message AS dissallow_private_message_12, t0.public AS public_13, t0.show_room_on_joinpage AS show_room_on_joinpage_14, t0.uid_participant AS uid_participant_15, t0.uid_moderator AS uid_moderator_16, t0.max_participants AS max_participants_17, t0.schedule_meeting AS schedule_meeting_18, t0.waitinglist AS waitinglist_19, t0.repeater_removed AS repeater_removed_20, t0.persistant_room AS persistant_room_21, t0.slug AS slug_22, t0.total_open_rooms AS total_open_rooms_23, t0.total_open_rooms_open_time AS total_open_rooms_open_time_24, t0.time_zone AS time_zone_25, t0.start_utc AS start_utc_26, t0.end_date_utc AS end_date_utc_27, t0.lobby AS lobby_28, t0.start_timestamp AS start_timestamp_29, t0.end_timestamp AS end_timestamp_30, t0.host_url AS host_url_31, t0.secondary_name AS secondary_name_32, t0.allow_maybe_option AS allow_maybe_option_33, t0.max_user AS max_user_34, t0.disable_self_subscription_double_opt_in AS disable_self_subscription_double_opt_in_35, t0.calendly_uri AS calendly_uri_36, t0.server_id AS server_id_37, t38.id AS id_39, t38.url AS url_40, t38.app_id AS app_id_41, t38.app_secret AS app_secret_42, t38.logo_url AS logo_url_43, t38.smtp_host AS smtp_host_44, t38.smtp_port AS smtp_port_45, t38.smtp_password AS smtp_password_46, t38.smtp_username AS smtp_username_47, t38.smtp_encryption AS smtp_encryption_48, t38.smtp_email AS smtp_email_49, t38.smtp_sender_name AS smtp_sender_name_50, t38.slug AS slug_51, t38.privacy_policy AS privacy_policy_52, t38.license_key AS license_key_53, t38.api_key AS api_key_54, t38.static_background_color AS static_background_color_55, t38.show_static_background_color AS show_static_background_color_56, t38.feature_enable_by_jwt AS feature_enable_by_jwt_57, t38.server_email_header AS server_email_header_58, t38.server_email_body AS server_email_body_59, t38.jwt_moderator_position AS jwt_moderator_position_60, t38.server_name AS server_name_61, t38.cors_header AS cors_header_62, t38.updated_at AS updated_at_63, t38.jigasi_api_url AS jigasi_api_url_64, t38.jigasi_number_url AS jigasi_number_url_65, t38.jigasi_prosody_domain AS jigasi_prosody_domain_66, t38.star_url AS star_url_67, t38.star_server_id AS star_server_id_68, t38.disallow_firefox AS disallow_firefox_69, t38.enforce_e2e AS enforce_e2e_70, t38.allow_ip AS allow_ip_71, t38.dynamic_branding_url AS dynamic_branding_url_72, t38.jitsi_event_sync_url AS jitsi_event_sync_url_73, t38.disable_filmstripe AS disable_filmstripe_74, t38.disable_etherpad AS disable_etherpad_75, t38.disable_whiteboard AS disable_whiteboard_76, t38.disable_chat AS disable_chat_77, t38.prefix_room_uid_with_hash AS prefix_room_uid_with_hash_78, t38.live_kit_server AS live_kit_server_79, t38.livekit_middleware_url AS livekit_middleware_url_80, t38.livekit_background_images AS livekit_background_images_81, t38.enable_recording AS enable_recording_82, t38.is_allowed_to_clone_for_autoscale AS is_allowed_to_clone_for_autoscale_83, t38.administrator_id AS administrator_id_84, t38.server_background_image_id AS server_background_image_id_85, t0.moderator_id AS moderator_id_86, t0.repeater_id AS repeater_id_87, t88.id AS id_89, t88.repetation AS repetation_90, t88.repeat_until AS repeat_until_91, t88.weekday AS weekday_92, t88.weeks AS weeks_93, t88.months AS months_94, t88.days AS days_95, t88.repeat_type AS repeat_type_96, t88.repeater_days AS repeater_days_97, t88.repeater_weeks AS repeater_weeks_98, t88.repeat_montly AS repeat_montly_99, t88.repeat_yearly AS repeat_yearly_100, t88.start_date AS start_date_101, t88.repat_month_relativ_number AS repat_month_relativ_number_102, t88.repat_month_relativ_weekday AS repat_month_relativ_weekday_103, t88.repeat_yearly_relative_number AS repeat_yearly_relative_number_104, t88.repeat_yearly_relative_month AS repeat_yearly_relative_month_105, t88.repeat_yearly_relative_weekday AS repeat_yearly_relative_weekday_106, t88.repeat_monthly_relative_how_often AS repeat_monthly_relative_how_often_107, t88.repeat_yearly_relative_how_often AS repeat_yearly_relative_how_often_108, t88.uid AS uid_109, t88.prototyp_id AS prototyp_id_110, t111.id AS id_112, t111.caller_id AS caller_id_113, t111.created_at AS created_at_114, t111.room_id AS room_id_115, t0.tag_id AS tag_id_116, t0.creator_id AS creator_id_117 FROM rooms t0 INNER JOIN server t38 ON t0.server_id = t38.id LEFT JOIN `repeat` t88 ON t88.prototyp_id = t0.id LEFT JOIN caller_room t111 ON t111.room_id = t0.id;
|