SELECT v.active,IFNULL(p.expire_tours,1) as expire_tours,v.id,v.code,v.name as name_virtualtour,v.loading_text,v.waiting_text,v.author,v.id_user,v.fb_messenger,v.show_chat,v.fb_page_id,v.logo,v.link_logo,v.password,v.background_image,v.background_image_mobile,v.auto_start,v.description,v.ga_tracking_id,u.expire_plan_date,v.start_date,v.end_date,v.start_url,v.end_url,u.id_subscription_stripe,u.status_subscription_stripe,u.id_subscription_paypal,u.status_subscription_paypal,u.id_subscription_2checkout,u.status_subscription_2checkout,u.id_subscription_paddle,u.status_subscription_paddle,v.flyin,v.meeting,v.language,v.languages_enabled,v.password_meeting,v.password_livesession,v.password_rooms_multiple,v.font_viewer,v.hfov_mobile_ratio,v.hide_loading,v.show_background,v.background_video,v.background_video_delay,v.background_video_mobile,v.background_video_delay_mobile,v.show_gallery,v.voice_commands,v.show_map_tour,v.live_session,v.show_presentation,v.show_share,v.auto_show_slider,v.grouped_list_alt,v.quality_viewer,v.external,v.external_url,v.protect_type,v.protect_remember,v.protect_send_email,v.protect_email,v.password_title,v.password_description,v.password,v.snipcart_api_key,v.form_icon,v.ui_style,v.show_dollhouse,v.dollhouse,v.dollhouse_glb,v.custom_html,v.context_info,v.presentation_type,v.presentation_video,v.ar_simulator,v.ar_camera_align,v.meta_title,v.meta_description,v.meta_image,v.zoom_to_pointer,v.loading_background_color,v.loading_text_color,v.mouse_zoom,v.show_comments,v.comments_mode,v.disqus_shortname,v.disqus_public_key,v.snipcart_currency,v.shop_type,v.woocommerce_store_url,v.woocommerce_store_cart,v.woocommerce_store_checkout,v.woocommerce_customer_key,v.woocommerce_customer_secret,v.woocommerce_modal,v.protect_mc_form,v.poweredby_type,v.poweredby_image,v.poweredby_text,v.poweredby_link,v.background_video_skip,v.background_video_skip_mobile,v.cookie_consent,v.protect_lead_params,v.intro_slider_delay,v.show_fullscreen,v.show_webvr,v.pwa_enable,v.id_room_initial,v.learning_mode,v.learning_show_modal,v.learning_show_email,v.learning_mandatory_email,v.learning_placeholder_email,v.learning_modal_title,v.learning_modal_subtitle,v.learning_modal_description,v.learning_modal_button,v.learning_modal_icon,v.learning_unlock_marker,v.learning_poi_progressive,v.learning_restore_session,v.learning_modal_color,v.learning_modal_color_text,v.learning_modal_background,v.learning_summary_title,v.learning_summary_partial_title,v.learning_summary_global_title,v.learning_summary_background,v.learning_summary_color,v.learning_summary_partial_color,v.learning_summary_global_color,v.learning_check_icon,v.learning_check_background,v.learning_check_color,v.learning_modal_button_background,v.learning_modal_button_color,v.learning_summary_style,u.email,v.show_language,IFNULL(p.n_visits_month, -1) as n_visits_month 
            FROM svt_virtualtours AS v
            JOIN svt_users AS u ON u.id=v.id_user
            LEFT JOIN svt_plans AS p ON p.id=u.id_plan
            WHERE 1=1 
            AND (v.friendly_url = ? OR v.friendly_url = ? OR v.code = ?) 
            AND (
                (v.external = 1 AND v.external_url IS NOT NULL AND v.external_url <> '')
                OR 
                EXISTS (SELECT 1 FROM svt_rooms WHERE id_virtualtour = v.id)
            ) 
            LIMIT 1;