1
1.65 ms
SELECT t0 . id AS id_1 , t0 . domain AS domain_2 , t0 . hash AS hash_3 , t0 . title AS title_4 , t0 . is_active AS is_active_5 , t0 . action_number AS action_number_6 , t0 . from_source AS from_source_7 , t0 . portal_css AS portal_css_8 , t0 . portal_head_scripts AS portal_head_scripts_9 , t0 . portal_start_body_scripts AS portal_start_body_scripts_10 , t0 . portal_body_scripts AS portal_body_scripts_11 , t0 . robots_txt AS robots_txt_12 , t0 . cart_additional_info AS cart_additional_info_13 , t0 . portal_number_sb AS portal_number_sb_14 , t0 . leading_color1 AS leading_color1_15 , t0 . leading_color2 AS leading_color2_16 , t0 . leading_color3 AS leading_color3_17 , t0 . logo AS logo_18 , t0 . contact_mail AS contact_mail_19 , t0 . registration_additional_content AS registration_additional_content_20 , t0 . login_additional_content AS login_additional_content_21 , t0 . created_at AS created_at_22 , t0 . updated_at AS updated_at_23 , t0 . is_uniqskills_portal AS is_uniqskills_portal_24 , t0 . is_netflix_portal AS is_netflix_portal_25 , t0 . is_presale AS is_presale_26 , t0 . is_simple_price AS is_simple_price_27 , t0 . redirect_after_login AS redirect_after_login_28 , t0 . message_after_login AS message_after_login_29 , t0 . message_time_after_login AS message_time_after_login_30 , t0 . device_auth_needed AS device_auth_needed_31 , t0 . sender AS sender_32 , t0 . is_cms_portal AS is_cms_portal_33 , t0 . multi_access_from_max_user AS multi_access_from_max_user_34 , t0 . enable_new_basket AS enable_new_basket_35 , t0 . price_after_free_postage_cost AS price_after_free_postage_cost_36 , t0 . price_after_free_postage_cost_type AS price_after_free_postage_cost_type_37 , t0 . gtm AS gtm_38 , t0 . password_additional_content AS password_additional_content_39 , t0 . leading_color4 AS leading_color4_40 , t0 . userbar_color AS userbar_color_41 , t0 . is_bookcase_visible_in_userbar AS is_bookcase_visible_in_userbar_42 , t0 . is_shelf_visible_in_userbar AS is_shelf_visible_in_userbar_43 , t0 . userbar_html AS userbar_html_44 , t0 . display_userbar2 AS display_userbar2_45 , t0 . test_price_after_free_postage_cost AS test_price_after_free_postage_cost_46 , t0 . test_userbar_html AS test_userbar_html_47 , t0 . lifetime_access AS lifetime_access_48 , t0 . fb_pixel_id AS fb_pixel_id_49 , t0 . fb_pixel_access_token AS fb_pixel_access_token_50 , t0 . hide_field_position AS hide_field_position_51 , t0 . redirecting_to_focus AS redirecting_to_focus_52 , t0 . show_gross_price AS show_gross_price_53 , t0 . cs_mail AS cs_mail_54 , t0 . is_phone_required AS is_phone_required_55 , t0 . webe_mid_number AS webe_mid_number_56 , t0 . use_fb_pixel_in_iframe AS use_fb_pixel_in_iframe_57 , t0 . is_payment_before_confirmation AS is_payment_before_confirmation_58 , t0 . payment_reward AS payment_reward_59 , t0 . payment_reward_content AS payment_reward_content_60 , t0 . payment_reward_deadline AS payment_reward_deadline_61 , t0 . cart_template AS cart_template_62 , t0 . use_cache_in_access AS use_cache_in_access_63 , t0 . order_confirmation_additional_content AS order_confirmation_additional_content_64 , t0 . additional_content_for_mail AS additional_content_for_mail_65 , t0 . matomo_site_id AS matomo_site_id_66 , t0 . positions_order AS positions_order_67 , t0 . email_settings_id AS email_settings_id_68 , t0 . order_type_id AS order_type_id_69 , t70 . id AS id_71 , t70 . ord_tran_prefix AS ord_tran_prefix_72 , t70 . is_default AS is_default_73 , t70 . use_sb AS use_sb_74 , t70 . use_recaptcha_in_order AS use_recaptcha_in_order_75 , t70 . hide_catalog AS hide_catalog_76 , t70 . hide_nip_in_orders AS hide_nip_in_orders_77 , t70 . show_only_regulations AS show_only_regulations_78 , t70 . send_order_welcome_mail_only AS send_order_welcome_mail_only_79 , t70 . facebook_event_type AS facebook_event_type_80 , t70 . footer_copyright AS footer_copyright_81 , t70 . contact_form_recipient AS contact_form_recipient_82 , t70 . text_contact_thank_you AS text_contact_thank_you_83 , t70 . text_footer_cooperator_headers AS text_footer_cooperator_headers_84 , t70 . text_acceptance_regulations AS text_acceptance_regulations_85 , t70 . text_voucher_regulations AS text_voucher_regulations_86 , t70 . text_consent_processing_personal_data AS text_consent_processing_personal_data_87 , t70 . created_at AS created_at_88 , t70 . updated_at AS updated_at_89 , t70 . portal_settings_id AS portal_settings_id_90 , t0 . virtual_currency_id AS virtual_currency_id_91 , t0 . default_payment_system_id AS default_payment_system_id_92 , t0 . default_cart_client_type_id AS default_cart_client_type_id_93 , t94 . id AS id_95 , t94 . is_active AS is_active_96 , t94 . poll_link AS poll_link_97 , t94 . editorial_email AS editorial_email_98 , t94 . portal_settings_id AS portal_settings_id_99 , t94 . email_template_id AS email_template_id_100 FROM portal_settings t0 LEFT JOIN fm_company_settings t70 ON t70 . portal_settings_id = t0 . id LEFT JOIN onboarding_settings t94 ON t94 . portal_settings_id = t0 . id WHERE t0 . hash = ? LIMIT 1
Parameters :
[
"42231b0ff8a4775b3089cbe1746f32 "
]
SELECT
t0 . id AS id_1 ,
t0 . domain AS domain_2 ,
t0 . hash AS hash_3 ,
t0 . title AS title_4 ,
t0 . is_active AS is_active_5 ,
t0 . action_number AS action_number_6 ,
t0 . from_source AS from_source_7 ,
t0 . portal_css AS portal_css_8 ,
t0 . portal_head_scripts AS portal_head_scripts_9 ,
t0 . portal_start_body_scripts AS portal_start_body_scripts_10 ,
t0 . portal_body_scripts AS portal_body_scripts_11 ,
t0 . robots_txt AS robots_txt_12 ,
t0 . cart_additional_info AS cart_additional_info_13 ,
t0 . portal_number_sb AS portal_number_sb_14 ,
t0 . leading_color1 AS leading_color1_15 ,
t0 . leading_color2 AS leading_color2_16 ,
t0 . leading_color3 AS leading_color3_17 ,
t0 . logo AS logo_18 ,
t0 . contact_mail AS contact_mail_19 ,
t0 . registration_additional_content AS registration_additional_content_20 ,
t0 . login_additional_content AS login_additional_content_21 ,
t0 . created_at AS created_at_22 ,
t0 . updated_at AS updated_at_23 ,
t0 . is_uniqskills_portal AS is_uniqskills_portal_24 ,
t0 . is_netflix_portal AS is_netflix_portal_25 ,
t0 . is_presale AS is_presale_26 ,
t0 . is_simple_price AS is_simple_price_27 ,
t0 . redirect_after_login AS redirect_after_login_28 ,
t0 . message_after_login AS message_after_login_29 ,
t0 . message_time_after_login AS message_time_after_login_30 ,
t0 . device_auth_needed AS device_auth_needed_31 ,
t0 . sender AS sender_32 ,
t0 . is_cms_portal AS is_cms_portal_33 ,
t0 . multi_access_from_max_user AS multi_access_from_max_user_34 ,
t0 . enable_new_basket AS enable_new_basket_35 ,
t0 . price_after_free_postage_cost AS price_after_free_postage_cost_36 ,
t0 . price_after_free_postage_cost_type AS price_after_free_postage_cost_type_37 ,
t0 . gtm AS gtm_38 ,
t0 . password_additional_content AS password_additional_content_39 ,
t0 . leading_color4 AS leading_color4_40 ,
t0 . userbar_color AS userbar_color_41 ,
t0 . is_bookcase_visible_in_userbar AS is_bookcase_visible_in_userbar_42 ,
t0 . is_shelf_visible_in_userbar AS is_shelf_visible_in_userbar_43 ,
t0 . userbar_html AS userbar_html_44 ,
t0 . display_userbar2 AS display_userbar2_45 ,
t0 . test_price_after_free_postage_cost AS test_price_after_free_postage_cost_46 ,
t0 . test_userbar_html AS test_userbar_html_47 ,
t0 . lifetime_access AS lifetime_access_48 ,
t0 . fb_pixel_id AS fb_pixel_id_49 ,
t0 . fb_pixel_access_token AS fb_pixel_access_token_50 ,
t0 . hide_field_position AS hide_field_position_51 ,
t0 . redirecting_to_focus AS redirecting_to_focus_52 ,
t0 . show_gross_price AS show_gross_price_53 ,
t0 . cs_mail AS cs_mail_54 ,
t0 . is_phone_required AS is_phone_required_55 ,
t0 . webe_mid_number AS webe_mid_number_56 ,
t0 . use_fb_pixel_in_iframe AS use_fb_pixel_in_iframe_57 ,
t0 . is_payment_before_confirmation AS is_payment_before_confirmation_58 ,
t0 . payment_reward AS payment_reward_59 ,
t0 . payment_reward_content AS payment_reward_content_60 ,
t0 . payment_reward_deadline AS payment_reward_deadline_61 ,
t0 . cart_template AS cart_template_62 ,
t0 . use_cache_in_access AS use_cache_in_access_63 ,
t0 . order_confirmation_additional_content AS order_confirmation_additional_content_64 ,
t0 . additional_content_for_mail AS additional_content_for_mail_65 ,
t0 . matomo_site_id AS matomo_site_id_66 ,
t0 . positions_order AS positions_order_67 ,
t0 . email_settings_id AS email_settings_id_68 ,
t0 . order_type_id AS order_type_id_69 ,
t70 . id AS id_71 ,
t70 . ord_tran_prefix AS ord_tran_prefix_72 ,
t70 . is_default AS is_default_73 ,
t70 . use_sb AS use_sb_74 ,
t70 . use_recaptcha_in_order AS use_recaptcha_in_order_75 ,
t70 . hide_catalog AS hide_catalog_76 ,
t70 . hide_nip_in_orders AS hide_nip_in_orders_77 ,
t70 . show_only_regulations AS show_only_regulations_78 ,
t70 . send_order_welcome_mail_only AS send_order_welcome_mail_only_79 ,
t70 . facebook_event_type AS facebook_event_type_80 ,
t70 . footer_copyright AS footer_copyright_81 ,
t70 . contact_form_recipient AS contact_form_recipient_82 ,
t70 . text_contact_thank_you AS text_contact_thank_you_83 ,
t70 . text_footer_cooperator_headers AS text_footer_cooperator_headers_84 ,
t70 . text_acceptance_regulations AS text_acceptance_regulations_85 ,
t70 . text_voucher_regulations AS text_voucher_regulations_86 ,
t70 . text_consent_processing_personal_data AS text_consent_processing_personal_data_87 ,
t70 . created_at AS created_at_88 ,
t70 . updated_at AS updated_at_89 ,
t70 . portal_settings_id AS portal_settings_id_90 ,
t0 . virtual_currency_id AS virtual_currency_id_91 ,
t0 . default_payment_system_id AS default_payment_system_id_92 ,
t0 . default_cart_client_type_id AS default_cart_client_type_id_93 ,
t94 . id AS id_95 ,
t94 . is_active AS is_active_96 ,
t94 . poll_link AS poll_link_97 ,
t94 . editorial_email AS editorial_email_98 ,
t94 . portal_settings_id AS portal_settings_id_99 ,
t94 . email_template_id AS email_template_id_100
FROM
portal_settings t0
LEFT JOIN fm_company_settings t70 ON t70 . portal_settings_id = t0 . id
LEFT JOIN onboarding_settings t94 ON t94 . portal_settings_id = t0 . id
WHERE
t0 . hash = ?
LIMIT
1
Copy
SELECT t0 . id AS id_1 , t0 . domain AS domain_2 , t0 . hash AS hash_3 , t0 . title AS title_4 , t0 . is_active AS is_active_5 , t0 . action_number AS action_number_6 , t0 . from_source AS from_source_7 , t0 . portal_css AS portal_css_8 , t0 . portal_head_scripts AS portal_head_scripts_9 , t0 . portal_start_body_scripts AS portal_start_body_scripts_10 , t0 . portal_body_scripts AS portal_body_scripts_11 , t0 . robots_txt AS robots_txt_12 , t0 . cart_additional_info AS cart_additional_info_13 , t0 . portal_number_sb AS portal_number_sb_14 , t0 . leading_color1 AS leading_color1_15 , t0 . leading_color2 AS leading_color2_16 , t0 . leading_color3 AS leading_color3_17 , t0 . logo AS logo_18 , t0 . contact_mail AS contact_mail_19 , t0 . registration_additional_content AS registration_additional_content_20 , t0 . login_additional_content AS login_additional_content_21 , t0 . created_at AS created_at_22 , t0 . updated_at AS updated_at_23 , t0 . is_uniqskills_portal AS is_uniqskills_portal_24 , t0 . is_netflix_portal AS is_netflix_portal_25 , t0 . is_presale AS is_presale_26 , t0 . is_simple_price AS is_simple_price_27 , t0 . redirect_after_login AS redirect_after_login_28 , t0 . message_after_login AS message_after_login_29 , t0 . message_time_after_login AS message_time_after_login_30 , t0 . device_auth_needed AS device_auth_needed_31 , t0 . sender AS sender_32 , t0 . is_cms_portal AS is_cms_portal_33 , t0 . multi_access_from_max_user AS multi_access_from_max_user_34 , t0 . enable_new_basket AS enable_new_basket_35 , t0 . price_after_free_postage_cost AS price_after_free_postage_cost_36 , t0 . price_after_free_postage_cost_type AS price_after_free_postage_cost_type_37 , t0 . gtm AS gtm_38 , t0 . password_additional_content AS password_additional_content_39 , t0 . leading_color4 AS leading_color4_40 , t0 . userbar_color AS userbar_color_41 , t0 . is_bookcase_visible_in_userbar AS is_bookcase_visible_in_userbar_42 , t0 . is_shelf_visible_in_userbar AS is_shelf_visible_in_userbar_43 , t0 . userbar_html AS userbar_html_44 , t0 . display_userbar2 AS display_userbar2_45 , t0 . test_price_after_free_postage_cost AS test_price_after_free_postage_cost_46 , t0 . test_userbar_html AS test_userbar_html_47 , t0 . lifetime_access AS lifetime_access_48 , t0 . fb_pixel_id AS fb_pixel_id_49 , t0 . fb_pixel_access_token AS fb_pixel_access_token_50 , t0 . hide_field_position AS hide_field_position_51 , t0 . redirecting_to_focus AS redirecting_to_focus_52 , t0 . show_gross_price AS show_gross_price_53 , t0 . cs_mail AS cs_mail_54 , t0 . is_phone_required AS is_phone_required_55 , t0 . webe_mid_number AS webe_mid_number_56 , t0 . use_fb_pixel_in_iframe AS use_fb_pixel_in_iframe_57 , t0 . is_payment_before_confirmation AS is_payment_before_confirmation_58 , t0 . payment_reward AS payment_reward_59 , t0 . payment_reward_content AS payment_reward_content_60 , t0 . payment_reward_deadline AS payment_reward_deadline_61 , t0 . cart_template AS cart_template_62 , t0 . use_cache_in_access AS use_cache_in_access_63 , t0 . order_confirmation_additional_content AS order_confirmation_additional_content_64 , t0 . additional_content_for_mail AS additional_content_for_mail_65 , t0 . matomo_site_id AS matomo_site_id_66 , t0 . positions_order AS positions_order_67 , t0 . email_settings_id AS email_settings_id_68 , t0 . order_type_id AS order_type_id_69 , t70 . id AS id_71 , t70 . ord_tran_prefix AS ord_tran_prefix_72 , t70 . is_default AS is_default_73 , t70 . use_sb AS use_sb_74 , t70 . use_recaptcha_in_order AS use_recaptcha_in_order_75 , t70 . hide_catalog AS hide_catalog_76 , t70 . hide_nip_in_orders AS hide_nip_in_orders_77 , t70 . show_only_regulations AS show_only_regulations_78 , t70 . send_order_welcome_mail_only AS send_order_welcome_mail_only_79 , t70 . facebook_event_type AS facebook_event_type_80 , t70 . footer_copyright AS footer_copyright_81 , t70 . contact_form_recipient AS contact_form_recipient_82 , t70 . text_contact_thank_you AS text_contact_thank_you_83 , t70 . text_footer_cooperator_headers AS text_footer_cooperator_headers_84 , t70 . text_acceptance_regulations AS text_acceptance_regulations_85 , t70 . text_voucher_regulations AS text_voucher_regulations_86 , t70 . text_consent_processing_personal_data AS text_consent_processing_personal_data_87 , t70 . created_at AS created_at_88 , t70 . updated_at AS updated_at_89 , t70 . portal_settings_id AS portal_settings_id_90 , t0 . virtual_currency_id AS virtual_currency_id_91 , t0 . default_payment_system_id AS default_payment_system_id_92 , t0 . default_cart_client_type_id AS default_cart_client_type_id_93 , t94 . id AS id_95 , t94 . is_active AS is_active_96 , t94 . poll_link AS poll_link_97 , t94 . editorial_email AS editorial_email_98 , t94 . portal_settings_id AS portal_settings_id_99 , t94 . email_template_id AS email_template_id_100 FROM portal_settings t0 LEFT JOIN fm_company_settings t70 ON t70 . portal_settings_id = t0 . id LEFT JOIN onboarding_settings t94 ON t94 . portal_settings_id = t0 . id WHERE t0 . hash = '42231b0ff8a4775b3089cbe1746f32' LIMIT 1 ;
Copy
3
1.79 ms
SELECT t0 . id AS id_1 , t0 . domain AS domain_2 , t0 . hash AS hash_3 , t0 . title AS title_4 , t0 . is_active AS is_active_5 , t0 . action_number AS action_number_6 , t0 . from_source AS from_source_7 , t0 . portal_css AS portal_css_8 , t0 . portal_head_scripts AS portal_head_scripts_9 , t0 . portal_start_body_scripts AS portal_start_body_scripts_10 , t0 . portal_body_scripts AS portal_body_scripts_11 , t0 . robots_txt AS robots_txt_12 , t0 . cart_additional_info AS cart_additional_info_13 , t0 . portal_number_sb AS portal_number_sb_14 , t0 . leading_color1 AS leading_color1_15 , t0 . leading_color2 AS leading_color2_16 , t0 . leading_color3 AS leading_color3_17 , t0 . logo AS logo_18 , t0 . contact_mail AS contact_mail_19 , t0 . registration_additional_content AS registration_additional_content_20 , t0 . login_additional_content AS login_additional_content_21 , t0 . created_at AS created_at_22 , t0 . updated_at AS updated_at_23 , t0 . is_uniqskills_portal AS is_uniqskills_portal_24 , t0 . is_netflix_portal AS is_netflix_portal_25 , t0 . is_presale AS is_presale_26 , t0 . is_simple_price AS is_simple_price_27 , t0 . redirect_after_login AS redirect_after_login_28 , t0 . message_after_login AS message_after_login_29 , t0 . message_time_after_login AS message_time_after_login_30 , t0 . device_auth_needed AS device_auth_needed_31 , t0 . sender AS sender_32 , t0 . is_cms_portal AS is_cms_portal_33 , t0 . multi_access_from_max_user AS multi_access_from_max_user_34 , t0 . enable_new_basket AS enable_new_basket_35 , t0 . price_after_free_postage_cost AS price_after_free_postage_cost_36 , t0 . price_after_free_postage_cost_type AS price_after_free_postage_cost_type_37 , t0 . gtm AS gtm_38 , t0 . password_additional_content AS password_additional_content_39 , t0 . leading_color4 AS leading_color4_40 , t0 . userbar_color AS userbar_color_41 , t0 . is_bookcase_visible_in_userbar AS is_bookcase_visible_in_userbar_42 , t0 . is_shelf_visible_in_userbar AS is_shelf_visible_in_userbar_43 , t0 . userbar_html AS userbar_html_44 , t0 . display_userbar2 AS display_userbar2_45 , t0 . test_price_after_free_postage_cost AS test_price_after_free_postage_cost_46 , t0 . test_userbar_html AS test_userbar_html_47 , t0 . lifetime_access AS lifetime_access_48 , t0 . fb_pixel_id AS fb_pixel_id_49 , t0 . fb_pixel_access_token AS fb_pixel_access_token_50 , t0 . hide_field_position AS hide_field_position_51 , t0 . redirecting_to_focus AS redirecting_to_focus_52 , t0 . show_gross_price AS show_gross_price_53 , t0 . cs_mail AS cs_mail_54 , t0 . is_phone_required AS is_phone_required_55 , t0 . webe_mid_number AS webe_mid_number_56 , t0 . use_fb_pixel_in_iframe AS use_fb_pixel_in_iframe_57 , t0 . is_payment_before_confirmation AS is_payment_before_confirmation_58 , t0 . payment_reward AS payment_reward_59 , t0 . payment_reward_content AS payment_reward_content_60 , t0 . payment_reward_deadline AS payment_reward_deadline_61 , t0 . cart_template AS cart_template_62 , t0 . use_cache_in_access AS use_cache_in_access_63 , t0 . order_confirmation_additional_content AS order_confirmation_additional_content_64 , t0 . additional_content_for_mail AS additional_content_for_mail_65 , t0 . matomo_site_id AS matomo_site_id_66 , t0 . positions_order AS positions_order_67 , t0 . email_settings_id AS email_settings_id_68 , t0 . order_type_id AS order_type_id_69 , t70 . id AS id_71 , t70 . ord_tran_prefix AS ord_tran_prefix_72 , t70 . is_default AS is_default_73 , t70 . use_sb AS use_sb_74 , t70 . use_recaptcha_in_order AS use_recaptcha_in_order_75 , t70 . hide_catalog AS hide_catalog_76 , t70 . hide_nip_in_orders AS hide_nip_in_orders_77 , t70 . show_only_regulations AS show_only_regulations_78 , t70 . send_order_welcome_mail_only AS send_order_welcome_mail_only_79 , t70 . facebook_event_type AS facebook_event_type_80 , t70 . footer_copyright AS footer_copyright_81 , t70 . contact_form_recipient AS contact_form_recipient_82 , t70 . text_contact_thank_you AS text_contact_thank_you_83 , t70 . text_footer_cooperator_headers AS text_footer_cooperator_headers_84 , t70 . text_acceptance_regulations AS text_acceptance_regulations_85 , t70 . text_voucher_regulations AS text_voucher_regulations_86 , t70 . text_consent_processing_personal_data AS text_consent_processing_personal_data_87 , t70 . created_at AS created_at_88 , t70 . updated_at AS updated_at_89 , t70 . portal_settings_id AS portal_settings_id_90 , t0 . virtual_currency_id AS virtual_currency_id_91 , t0 . default_payment_system_id AS default_payment_system_id_92 , t0 . default_cart_client_type_id AS default_cart_client_type_id_93 , t94 . id AS id_95 , t94 . is_active AS is_active_96 , t94 . poll_link AS poll_link_97 , t94 . editorial_email AS editorial_email_98 , t94 . portal_settings_id AS portal_settings_id_99 , t94 . email_template_id AS email_template_id_100 FROM portal_settings t0 LEFT JOIN fm_company_settings t70 ON t70 . portal_settings_id = t0 . id LEFT JOIN onboarding_settings t94 ON t94 . portal_settings_id = t0 . id WHERE t0 . hash = ? LIMIT 1
Parameters :
[
"42231b0ff8a4775b3089cbe1746f32 "
]
SELECT
t0 . id AS id_1 ,
t0 . domain AS domain_2 ,
t0 . hash AS hash_3 ,
t0 . title AS title_4 ,
t0 . is_active AS is_active_5 ,
t0 . action_number AS action_number_6 ,
t0 . from_source AS from_source_7 ,
t0 . portal_css AS portal_css_8 ,
t0 . portal_head_scripts AS portal_head_scripts_9 ,
t0 . portal_start_body_scripts AS portal_start_body_scripts_10 ,
t0 . portal_body_scripts AS portal_body_scripts_11 ,
t0 . robots_txt AS robots_txt_12 ,
t0 . cart_additional_info AS cart_additional_info_13 ,
t0 . portal_number_sb AS portal_number_sb_14 ,
t0 . leading_color1 AS leading_color1_15 ,
t0 . leading_color2 AS leading_color2_16 ,
t0 . leading_color3 AS leading_color3_17 ,
t0 . logo AS logo_18 ,
t0 . contact_mail AS contact_mail_19 ,
t0 . registration_additional_content AS registration_additional_content_20 ,
t0 . login_additional_content AS login_additional_content_21 ,
t0 . created_at AS created_at_22 ,
t0 . updated_at AS updated_at_23 ,
t0 . is_uniqskills_portal AS is_uniqskills_portal_24 ,
t0 . is_netflix_portal AS is_netflix_portal_25 ,
t0 . is_presale AS is_presale_26 ,
t0 . is_simple_price AS is_simple_price_27 ,
t0 . redirect_after_login AS redirect_after_login_28 ,
t0 . message_after_login AS message_after_login_29 ,
t0 . message_time_after_login AS message_time_after_login_30 ,
t0 . device_auth_needed AS device_auth_needed_31 ,
t0 . sender AS sender_32 ,
t0 . is_cms_portal AS is_cms_portal_33 ,
t0 . multi_access_from_max_user AS multi_access_from_max_user_34 ,
t0 . enable_new_basket AS enable_new_basket_35 ,
t0 . price_after_free_postage_cost AS price_after_free_postage_cost_36 ,
t0 . price_after_free_postage_cost_type AS price_after_free_postage_cost_type_37 ,
t0 . gtm AS gtm_38 ,
t0 . password_additional_content AS password_additional_content_39 ,
t0 . leading_color4 AS leading_color4_40 ,
t0 . userbar_color AS userbar_color_41 ,
t0 . is_bookcase_visible_in_userbar AS is_bookcase_visible_in_userbar_42 ,
t0 . is_shelf_visible_in_userbar AS is_shelf_visible_in_userbar_43 ,
t0 . userbar_html AS userbar_html_44 ,
t0 . display_userbar2 AS display_userbar2_45 ,
t0 . test_price_after_free_postage_cost AS test_price_after_free_postage_cost_46 ,
t0 . test_userbar_html AS test_userbar_html_47 ,
t0 . lifetime_access AS lifetime_access_48 ,
t0 . fb_pixel_id AS fb_pixel_id_49 ,
t0 . fb_pixel_access_token AS fb_pixel_access_token_50 ,
t0 . hide_field_position AS hide_field_position_51 ,
t0 . redirecting_to_focus AS redirecting_to_focus_52 ,
t0 . show_gross_price AS show_gross_price_53 ,
t0 . cs_mail AS cs_mail_54 ,
t0 . is_phone_required AS is_phone_required_55 ,
t0 . webe_mid_number AS webe_mid_number_56 ,
t0 . use_fb_pixel_in_iframe AS use_fb_pixel_in_iframe_57 ,
t0 . is_payment_before_confirmation AS is_payment_before_confirmation_58 ,
t0 . payment_reward AS payment_reward_59 ,
t0 . payment_reward_content AS payment_reward_content_60 ,
t0 . payment_reward_deadline AS payment_reward_deadline_61 ,
t0 . cart_template AS cart_template_62 ,
t0 . use_cache_in_access AS use_cache_in_access_63 ,
t0 . order_confirmation_additional_content AS order_confirmation_additional_content_64 ,
t0 . additional_content_for_mail AS additional_content_for_mail_65 ,
t0 . matomo_site_id AS matomo_site_id_66 ,
t0 . positions_order AS positions_order_67 ,
t0 . email_settings_id AS email_settings_id_68 ,
t0 . order_type_id AS order_type_id_69 ,
t70 . id AS id_71 ,
t70 . ord_tran_prefix AS ord_tran_prefix_72 ,
t70 . is_default AS is_default_73 ,
t70 . use_sb AS use_sb_74 ,
t70 . use_recaptcha_in_order AS use_recaptcha_in_order_75 ,
t70 . hide_catalog AS hide_catalog_76 ,
t70 . hide_nip_in_orders AS hide_nip_in_orders_77 ,
t70 . show_only_regulations AS show_only_regulations_78 ,
t70 . send_order_welcome_mail_only AS send_order_welcome_mail_only_79 ,
t70 . facebook_event_type AS facebook_event_type_80 ,
t70 . footer_copyright AS footer_copyright_81 ,
t70 . contact_form_recipient AS contact_form_recipient_82 ,
t70 . text_contact_thank_you AS text_contact_thank_you_83 ,
t70 . text_footer_cooperator_headers AS text_footer_cooperator_headers_84 ,
t70 . text_acceptance_regulations AS text_acceptance_regulations_85 ,
t70 . text_voucher_regulations AS text_voucher_regulations_86 ,
t70 . text_consent_processing_personal_data AS text_consent_processing_personal_data_87 ,
t70 . created_at AS created_at_88 ,
t70 . updated_at AS updated_at_89 ,
t70 . portal_settings_id AS portal_settings_id_90 ,
t0 . virtual_currency_id AS virtual_currency_id_91 ,
t0 . default_payment_system_id AS default_payment_system_id_92 ,
t0 . default_cart_client_type_id AS default_cart_client_type_id_93 ,
t94 . id AS id_95 ,
t94 . is_active AS is_active_96 ,
t94 . poll_link AS poll_link_97 ,
t94 . editorial_email AS editorial_email_98 ,
t94 . portal_settings_id AS portal_settings_id_99 ,
t94 . email_template_id AS email_template_id_100
FROM
portal_settings t0
LEFT JOIN fm_company_settings t70 ON t70 . portal_settings_id = t0 . id
LEFT JOIN onboarding_settings t94 ON t94 . portal_settings_id = t0 . id
WHERE
t0 . hash = ?
LIMIT
1
Copy
SELECT t0 . id AS id_1 , t0 . domain AS domain_2 , t0 . hash AS hash_3 , t0 . title AS title_4 , t0 . is_active AS is_active_5 , t0 . action_number AS action_number_6 , t0 . from_source AS from_source_7 , t0 . portal_css AS portal_css_8 , t0 . portal_head_scripts AS portal_head_scripts_9 , t0 . portal_start_body_scripts AS portal_start_body_scripts_10 , t0 . portal_body_scripts AS portal_body_scripts_11 , t0 . robots_txt AS robots_txt_12 , t0 . cart_additional_info AS cart_additional_info_13 , t0 . portal_number_sb AS portal_number_sb_14 , t0 . leading_color1 AS leading_color1_15 , t0 . leading_color2 AS leading_color2_16 , t0 . leading_color3 AS leading_color3_17 , t0 . logo AS logo_18 , t0 . contact_mail AS contact_mail_19 , t0 . registration_additional_content AS registration_additional_content_20 , t0 . login_additional_content AS login_additional_content_21 , t0 . created_at AS created_at_22 , t0 . updated_at AS updated_at_23 , t0 . is_uniqskills_portal AS is_uniqskills_portal_24 , t0 . is_netflix_portal AS is_netflix_portal_25 , t0 . is_presale AS is_presale_26 , t0 . is_simple_price AS is_simple_price_27 , t0 . redirect_after_login AS redirect_after_login_28 , t0 . message_after_login AS message_after_login_29 , t0 . message_time_after_login AS message_time_after_login_30 , t0 . device_auth_needed AS device_auth_needed_31 , t0 . sender AS sender_32 , t0 . is_cms_portal AS is_cms_portal_33 , t0 . multi_access_from_max_user AS multi_access_from_max_user_34 , t0 . enable_new_basket AS enable_new_basket_35 , t0 . price_after_free_postage_cost AS price_after_free_postage_cost_36 , t0 . price_after_free_postage_cost_type AS price_after_free_postage_cost_type_37 , t0 . gtm AS gtm_38 , t0 . password_additional_content AS password_additional_content_39 , t0 . leading_color4 AS leading_color4_40 , t0 . userbar_color AS userbar_color_41 , t0 . is_bookcase_visible_in_userbar AS is_bookcase_visible_in_userbar_42 , t0 . is_shelf_visible_in_userbar AS is_shelf_visible_in_userbar_43 , t0 . userbar_html AS userbar_html_44 , t0 . display_userbar2 AS display_userbar2_45 , t0 . test_price_after_free_postage_cost AS test_price_after_free_postage_cost_46 , t0 . test_userbar_html AS test_userbar_html_47 , t0 . lifetime_access AS lifetime_access_48 , t0 . fb_pixel_id AS fb_pixel_id_49 , t0 . fb_pixel_access_token AS fb_pixel_access_token_50 , t0 . hide_field_position AS hide_field_position_51 , t0 . redirecting_to_focus AS redirecting_to_focus_52 , t0 . show_gross_price AS show_gross_price_53 , t0 . cs_mail AS cs_mail_54 , t0 . is_phone_required AS is_phone_required_55 , t0 . webe_mid_number AS webe_mid_number_56 , t0 . use_fb_pixel_in_iframe AS use_fb_pixel_in_iframe_57 , t0 . is_payment_before_confirmation AS is_payment_before_confirmation_58 , t0 . payment_reward AS payment_reward_59 , t0 . payment_reward_content AS payment_reward_content_60 , t0 . payment_reward_deadline AS payment_reward_deadline_61 , t0 . cart_template AS cart_template_62 , t0 . use_cache_in_access AS use_cache_in_access_63 , t0 . order_confirmation_additional_content AS order_confirmation_additional_content_64 , t0 . additional_content_for_mail AS additional_content_for_mail_65 , t0 . matomo_site_id AS matomo_site_id_66 , t0 . positions_order AS positions_order_67 , t0 . email_settings_id AS email_settings_id_68 , t0 . order_type_id AS order_type_id_69 , t70 . id AS id_71 , t70 . ord_tran_prefix AS ord_tran_prefix_72 , t70 . is_default AS is_default_73 , t70 . use_sb AS use_sb_74 , t70 . use_recaptcha_in_order AS use_recaptcha_in_order_75 , t70 . hide_catalog AS hide_catalog_76 , t70 . hide_nip_in_orders AS hide_nip_in_orders_77 , t70 . show_only_regulations AS show_only_regulations_78 , t70 . send_order_welcome_mail_only AS send_order_welcome_mail_only_79 , t70 . facebook_event_type AS facebook_event_type_80 , t70 . footer_copyright AS footer_copyright_81 , t70 . contact_form_recipient AS contact_form_recipient_82 , t70 . text_contact_thank_you AS text_contact_thank_you_83 , t70 . text_footer_cooperator_headers AS text_footer_cooperator_headers_84 , t70 . text_acceptance_regulations AS text_acceptance_regulations_85 , t70 . text_voucher_regulations AS text_voucher_regulations_86 , t70 . text_consent_processing_personal_data AS text_consent_processing_personal_data_87 , t70 . created_at AS created_at_88 , t70 . updated_at AS updated_at_89 , t70 . portal_settings_id AS portal_settings_id_90 , t0 . virtual_currency_id AS virtual_currency_id_91 , t0 . default_payment_system_id AS default_payment_system_id_92 , t0 . default_cart_client_type_id AS default_cart_client_type_id_93 , t94 . id AS id_95 , t94 . is_active AS is_active_96 , t94 . poll_link AS poll_link_97 , t94 . editorial_email AS editorial_email_98 , t94 . portal_settings_id AS portal_settings_id_99 , t94 . email_template_id AS email_template_id_100 FROM portal_settings t0 LEFT JOIN fm_company_settings t70 ON t70 . portal_settings_id = t0 . id LEFT JOIN onboarding_settings t94 ON t94 . portal_settings_id = t0 . id WHERE t0 . hash = '42231b0ff8a4775b3089cbe1746f32' LIMIT 1 ;
Copy