| 1 |
0.58 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.sub_domain AS sub_domain_3, t0.organisation_id AS organisation_id_4, t0.smscredit AS smscredit_5, t0.ai_token_credit AS ai_token_credit_6, t0.last_daily_token_date AS last_daily_token_date_7, t0.ai_seconds_credit AS ai_seconds_credit_8, t0.daily_ai_token_credit AS daily_ai_token_credit_9, t0.booking_btn_name AS booking_btn_name_10, t0.booking_btn_clr AS booking_btn_clr_11, t0.booking_btn_bg_clr AS booking_btn_bg_clr_12, t0.inner_color AS inner_color_13, t0.outer_color AS outer_color_14, t0.patient_ref_prefix AS patient_ref_prefix_15, t0.email AS email_16, t0.verified_email AS verified_email_17, t0.web_site AS web_site_18, t0.phone AS phone_19, t0.contact_name AS contact_name_20, t0.description AS description_21, t0.widget_settings AS widget_settings_22, t0.sms_number AS sms_number_23, t0.sms_status AS sms_status_24, t0.timezone AS timezone_25, t0.reminder_header AS reminder_header_26, t0.reminder_footer AS reminder_footer_27, t0.reminder_recall_text AS reminder_recall_text_28, t0.google_token AS google_token_29, t0.google_id AS google_id_30, t0.topic_arn AS topic_arn_31, t0.pm_pin AS pm_pin_32, t0.auto_email_reply_address AS auto_email_reply_address_33, t0.pm_patient_message AS pm_patient_message_34, t0.pm_clinic_intro AS pm_clinic_intro_35, t0.auto_renew_subscription AS auto_renew_subscription_36, t0.subscription_expiry AS subscription_expiry_37, t0.email_reminder AS email_reminder_38, t0.email_new AS email_new_39, t0.sms_new AS sms_new_40, t0.sms_reminder AS sms_reminder_41, t0.when_answered_hide_where_did_you_hear_about_us AS when_answered_hide_where_did_you_hear_about_us_42, t0.calendar_start_day AS calendar_start_day_43, t0.calendar_end_day AS calendar_end_day_44, t0.appointment_default_time AS appointment_default_time_45, t0.appointment_slot_duration AS appointment_slot_duration_46, t0.appointment_default_view AS appointment_default_view_47, t0.private_mode_calendar AS private_mode_calendar_48, t0.clinic_representative AS clinic_representative_49, t0.data_protection_officer AS data_protection_officer_50, t0.company_registration_number AS company_registration_number_51, t0.email_to_withdraw AS email_to_withdraw_52, t0.period_stored_data AS period_stored_data_53, t0.survey_email_text AS survey_email_text_54, t0.post_apt_form_email_text AS post_apt_form_email_text_55, t0.export_in_progress AS export_in_progress_56, t0.vat_number AS vat_number_57, t0.enabled_vat AS enabled_vat_58, t0.patient_list_display_pair AS patient_list_display_pair_59, t0.stripe_refresh_token AS stripe_refresh_token_60, t0.stripe_publishable_key AS stripe_publishable_key_61, t0.stripe_account_id AS stripe_account_id_62, t0.shared_all_patients AS shared_all_patients_63, t0.currency AS currency_64, t0.patient_info_to_document_header AS patient_info_to_document_header_65, t0.t_and_c AS t_and_c_66, t0.declaration AS declaration_67, t0.treatment_plan_tand_c AS treatment_plan_tand_c_68, t0.traffic_light AS traffic_light_69, t0.booking_required_fields AS booking_required_fields_70, t0.double_booking AS double_booking_71, t0.required_confirmation AS required_confirmation_72, t0.fixed_discount_amount AS fixed_discount_amount_73, t0.required_questionnaires AS required_questionnaires_74, t0.patient_required_fields AS patient_required_fields_75, t0.prospect_required_fields AS prospect_required_fields_76, t0.enabled_postcode AS enabled_postcode_77, t0.enabled_chronoscan AS enabled_chronoscan_78, t0.postcode_api_key AS postcode_api_key_79, t0.enabled_prospect_web_form AS enabled_prospect_web_form_80, t0.payment_sense AS payment_sense_81, t0.xero_tenant_id AS xero_tenant_id_82, t0.reduce_stock AS reduce_stock_83, t0.patient_questionnaire AS patient_questionnaire_84, t0.xero_bank_account AS xero_bank_account_85, t0.is_new_clinic AS is_new_clinic_86, t0.marketing_expert AS marketing_expert_87, t0.clinic_survey_email_text AS clinic_survey_email_text_88, t0.trial_end_date AS trial_end_date_89, t0.shared_patient_date AS shared_patient_date_90, t0.feature_custom_website_amount AS feature_custom_website_amount_91, t0.feature_ad_amount AS feature_ad_amount_92, t0.feature_message_amount AS feature_message_amount_93, t0.feature_template_amount AS feature_template_amount_94, t0.is_template_user_only AS is_template_user_only_95, t0.new_user AS new_user_96, t0.template_subscription_end_date AS template_subscription_end_date_97, t0.onboarding_status AS onboarding_status_98, t0.address1 AS address1_99, t0.address2 AS address2_100, t0.town AS town_101, t0.state AS state_102, t0.country AS country_103, t0.postcode AS postcode_104, t0.created_at AS created_at_105, t0.updated_at AS updated_at_106, t0.logo_id AS logo_id_107, t108.id AS id_109, t108.s3key AS s3key_110, t108.name_file AS name_file_111, t108.url AS url_112, t108.type AS type_113, t108.created_at AS created_at_114, t108.updated_at AS updated_at_115, t0.background_id AS background_id_116, t117.id AS id_118, t117.s3key AS s3key_119, t117.name_file AS name_file_120, t117.url AS url_121, t117.type AS type_122, t117.created_at AS created_at_123, t117.updated_at AS updated_at_124, t125.id AS id_126, t125.creditor AS creditor_127, t125.mandate AS mandate_128, t125.customer AS customer_129, t125.customer_bank_account AS customer_bank_account_130, t125.created_at AS created_at_131, t125.updated_at AS updated_at_132, t125.clinic_id AS clinic_id_133, t134.id AS id_135, t134.sid AS sid_136, t134.token AS token_137, t134.number_from AS number_from_138, t134.clinic_id AS clinic_id_139, t0.organisation_id AS organisation_id_140, t141.id AS id_142, t141.enabled AS enabled_143, t141.time_required_for_booking AS time_required_for_booking_144, t141.time_required_for_cancellation AS time_required_for_cancellation_145, t141.take_payment_for_new_patients AS take_payment_for_new_patients_146, t141.take_payment_for_existing_patients AS take_payment_for_existing_patients_147, t141.type AS type_148, t141.hide_full_price AS hide_full_price_149, t141.terms AS terms_150, t141.clinic_id AS clinic_id_151, t152.id AS id_153, t152.server AS server_154, t152.file_location AS file_location_155, t152.username AS username_156, t152.password AS password_157, t152.email AS email_158, t152.clinic_id AS clinic_id_159, t160.id AS id_161, t160.theme AS theme_162, t160.max_embed_width AS max_embed_width_163, t160.primary_interface_colour AS primary_interface_colour_164, t160.secondary_interface_colour AS secondary_interface_colour_165, t160.primary_font_colour AS primary_font_colour_166, t160.secondary_font_colour AS secondary_font_colour_167, t160.background_colour AS background_colour_168, t160.widget_hash AS widget_hash_169, t160.created_at AS created_at_170, t160.updated_at AS updated_at_171, t160.clinic_id AS clinic_id_172, t160.custom_css_id AS custom_css_id_173, t174.id AS id_175, t174.confirmation_text AS confirmation_text_176, t174.treatment_info AS treatment_info_177, t174.clinic_id AS clinic_id_178, t179.id AS id_180, t179.api_key AS api_key_181, t179.list_id AS list_id_182, t179.sync AS sync_183, t179.sync_date AS sync_date_184, t179.pro AS pro_185, t179.created_at AS created_at_186, t179.updated_at AS updated_at_187, t179.clinic_id AS clinic_id_188, t0.promo_code_id AS promo_code_id_189, t0.price_tier_id AS price_tier_id_190, t0.xero_sync_job_id AS xero_sync_job_id_191 FROM clinics t0 LEFT JOIN media t108 ON t0.logo_id = t108.id LEFT JOIN media t117 ON t0.background_id = t117.id LEFT JOIN gocardless_customer t125 ON t125.clinic_id = t0.id LEFT JOIN twilio t134 ON t134.clinic_id = t0.id LEFT JOIN setting_online_booking t141 ON t141.clinic_id = t0.id LEFT JOIN setting_chronoscan t152 ON t152.clinic_id = t0.id LEFT JOIN widget_online_booking t160 ON t160.clinic_id = t0.id LEFT JOIN email_setting_online_booking t174 ON t174.clinic_id = t0.id LEFT JOIN mail_chimp_config t179 ON t179.clinic_id = t0.id WHERE t0.sub_domain = ? LIMIT 1
Parameters: [
"tvgrlcpanel"
]
SELECT
t0.id AS id_1,
t0.name AS name_2,
t0.sub_domain AS sub_domain_3,
t0.organisation_id AS organisation_id_4,
t0.smscredit AS smscredit_5,
t0.ai_token_credit AS ai_token_credit_6,
t0.last_daily_token_date AS last_daily_token_date_7,
t0.ai_seconds_credit AS ai_seconds_credit_8,
t0.daily_ai_token_credit AS daily_ai_token_credit_9,
t0.booking_btn_name AS booking_btn_name_10,
t0.booking_btn_clr AS booking_btn_clr_11,
t0.booking_btn_bg_clr AS booking_btn_bg_clr_12,
t0.inner_color AS inner_color_13,
t0.outer_color AS outer_color_14,
t0.patient_ref_prefix AS patient_ref_prefix_15,
t0.email AS email_16,
t0.verified_email AS verified_email_17,
t0.web_site AS web_site_18,
t0.phone AS phone_19,
t0.contact_name AS contact_name_20,
t0.description AS description_21,
t0.widget_settings AS widget_settings_22,
t0.sms_number AS sms_number_23,
t0.sms_status AS sms_status_24,
t0.timezone AS timezone_25,
t0.reminder_header AS reminder_header_26,
t0.reminder_footer AS reminder_footer_27,
t0.reminder_recall_text AS reminder_recall_text_28,
t0.google_token AS google_token_29,
t0.google_id AS google_id_30,
t0.topic_arn AS topic_arn_31,
t0.pm_pin AS pm_pin_32,
t0.auto_email_reply_address AS auto_email_reply_address_33,
t0.pm_patient_message AS pm_patient_message_34,
t0.pm_clinic_intro AS pm_clinic_intro_35,
t0.auto_renew_subscription AS auto_renew_subscription_36,
t0.subscription_expiry AS subscription_expiry_37,
t0.email_reminder AS email_reminder_38,
t0.email_new AS email_new_39,
t0.sms_new AS sms_new_40,
t0.sms_reminder AS sms_reminder_41,
t0.when_answered_hide_where_did_you_hear_about_us AS when_answered_hide_where_did_you_hear_about_us_42,
t0.calendar_start_day AS calendar_start_day_43,
t0.calendar_end_day AS calendar_end_day_44,
t0.appointment_default_time AS appointment_default_time_45,
t0.appointment_slot_duration AS appointment_slot_duration_46,
t0.appointment_default_view AS appointment_default_view_47,
t0.private_mode_calendar AS private_mode_calendar_48,
t0.clinic_representative AS clinic_representative_49,
t0.data_protection_officer AS data_protection_officer_50,
t0.company_registration_number AS company_registration_number_51,
t0.email_to_withdraw AS email_to_withdraw_52,
t0.period_stored_data AS period_stored_data_53,
t0.survey_email_text AS survey_email_text_54,
t0.post_apt_form_email_text AS post_apt_form_email_text_55,
t0.export_in_progress AS export_in_progress_56,
t0.vat_number AS vat_number_57,
t0.enabled_vat AS enabled_vat_58,
t0.patient_list_display_pair AS patient_list_display_pair_59,
t0.stripe_refresh_token AS stripe_refresh_token_60,
t0.stripe_publishable_key AS stripe_publishable_key_61,
t0.stripe_account_id AS stripe_account_id_62,
t0.shared_all_patients AS shared_all_patients_63,
t0.currency AS currency_64,
t0.patient_info_to_document_header AS patient_info_to_document_header_65,
t0.t_and_c AS t_and_c_66,
t0.declaration AS declaration_67,
t0.treatment_plan_tand_c AS treatment_plan_tand_c_68,
t0.traffic_light AS traffic_light_69,
t0.booking_required_fields AS booking_required_fields_70,
t0.double_booking AS double_booking_71,
t0.required_confirmation AS required_confirmation_72,
t0.fixed_discount_amount AS fixed_discount_amount_73,
t0.required_questionnaires AS required_questionnaires_74,
t0.patient_required_fields AS patient_required_fields_75,
t0.prospect_required_fields AS prospect_required_fields_76,
t0.enabled_postcode AS enabled_postcode_77,
t0.enabled_chronoscan AS enabled_chronoscan_78,
t0.postcode_api_key AS postcode_api_key_79,
t0.enabled_prospect_web_form AS enabled_prospect_web_form_80,
t0.payment_sense AS payment_sense_81,
t0.xero_tenant_id AS xero_tenant_id_82,
t0.reduce_stock AS reduce_stock_83,
t0.patient_questionnaire AS patient_questionnaire_84,
t0.xero_bank_account AS xero_bank_account_85,
t0.is_new_clinic AS is_new_clinic_86,
t0.marketing_expert AS marketing_expert_87,
t0.clinic_survey_email_text AS clinic_survey_email_text_88,
t0.trial_end_date AS trial_end_date_89,
t0.shared_patient_date AS shared_patient_date_90,
t0.feature_custom_website_amount AS feature_custom_website_amount_91,
t0.feature_ad_amount AS feature_ad_amount_92,
t0.feature_message_amount AS feature_message_amount_93,
t0.feature_template_amount AS feature_template_amount_94,
t0.is_template_user_only AS is_template_user_only_95,
t0.new_user AS new_user_96,
t0.template_subscription_end_date AS template_subscription_end_date_97,
t0.onboarding_status AS onboarding_status_98,
t0.address1 AS address1_99,
t0.address2 AS address2_100,
t0.town AS town_101,
t0.state AS state_102,
t0.country AS country_103,
t0.postcode AS postcode_104,
t0.created_at AS created_at_105,
t0.updated_at AS updated_at_106,
t0.logo_id AS logo_id_107,
t108.id AS id_109,
t108.s3key AS s3key_110,
t108.name_file AS name_file_111,
t108.url AS url_112,
t108.type AS type_113,
t108.created_at AS created_at_114,
t108.updated_at AS updated_at_115,
t0.background_id AS background_id_116,
t117.id AS id_118,
t117.s3key AS s3key_119,
t117.name_file AS name_file_120,
t117.url AS url_121,
t117.type AS type_122,
t117.created_at AS created_at_123,
t117.updated_at AS updated_at_124,
t125.id AS id_126,
t125.creditor AS creditor_127,
t125.mandate AS mandate_128,
t125.customer AS customer_129,
t125.customer_bank_account AS customer_bank_account_130,
t125.created_at AS created_at_131,
t125.updated_at AS updated_at_132,
t125.clinic_id AS clinic_id_133,
t134.id AS id_135,
t134.sid AS sid_136,
t134.token AS token_137,
t134.number_from AS number_from_138,
t134.clinic_id AS clinic_id_139,
t0.organisation_id AS organisation_id_140,
t141.id AS id_142,
t141.enabled AS enabled_143,
t141.time_required_for_booking AS time_required_for_booking_144,
t141.time_required_for_cancellation AS time_required_for_cancellation_145,
t141.take_payment_for_new_patients AS take_payment_for_new_patients_146,
t141.take_payment_for_existing_patients AS take_payment_for_existing_patients_147,
t141.type AS type_148,
t141.hide_full_price AS hide_full_price_149,
t141.terms AS terms_150,
t141.clinic_id AS clinic_id_151,
t152.id AS id_153,
t152.server AS server_154,
t152.file_location AS file_location_155,
t152.username AS username_156,
t152.password AS password_157,
t152.email AS email_158,
t152.clinic_id AS clinic_id_159,
t160.id AS id_161,
t160.theme AS theme_162,
t160.max_embed_width AS max_embed_width_163,
t160.primary_interface_colour AS primary_interface_colour_164,
t160.secondary_interface_colour AS secondary_interface_colour_165,
t160.primary_font_colour AS primary_font_colour_166,
t160.secondary_font_colour AS secondary_font_colour_167,
t160.background_colour AS background_colour_168,
t160.widget_hash AS widget_hash_169,
t160.created_at AS created_at_170,
t160.updated_at AS updated_at_171,
t160.clinic_id AS clinic_id_172,
t160.custom_css_id AS custom_css_id_173,
t174.id AS id_175,
t174.confirmation_text AS confirmation_text_176,
t174.treatment_info AS treatment_info_177,
t174.clinic_id AS clinic_id_178,
t179.id AS id_180,
t179.api_key AS api_key_181,
t179.list_id AS list_id_182,
t179.sync AS sync_183,
t179.sync_date AS sync_date_184,
t179.pro AS pro_185,
t179.created_at AS created_at_186,
t179.updated_at AS updated_at_187,
t179.clinic_id AS clinic_id_188,
t0.promo_code_id AS promo_code_id_189,
t0.price_tier_id AS price_tier_id_190,
t0.xero_sync_job_id AS xero_sync_job_id_191
FROM
clinics t0
LEFT JOIN media t108 ON t0.logo_id = t108.id
LEFT JOIN media t117 ON t0.background_id = t117.id
LEFT JOIN gocardless_customer t125 ON t125.clinic_id = t0.id
LEFT JOIN twilio t134 ON t134.clinic_id = t0.id
LEFT JOIN setting_online_booking t141 ON t141.clinic_id = t0.id
LEFT JOIN setting_chronoscan t152 ON t152.clinic_id = t0.id
LEFT JOIN widget_online_booking t160 ON t160.clinic_id = t0.id
LEFT JOIN email_setting_online_booking t174 ON t174.clinic_id = t0.id
LEFT JOIN mail_chimp_config t179 ON t179.clinic_id = t0.id
WHERE
t0.sub_domain = ?
LIMIT
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.sub_domain AS sub_domain_3, t0.organisation_id AS organisation_id_4, t0.smscredit AS smscredit_5, t0.ai_token_credit AS ai_token_credit_6, t0.last_daily_token_date AS last_daily_token_date_7, t0.ai_seconds_credit AS ai_seconds_credit_8, t0.daily_ai_token_credit AS daily_ai_token_credit_9, t0.booking_btn_name AS booking_btn_name_10, t0.booking_btn_clr AS booking_btn_clr_11, t0.booking_btn_bg_clr AS booking_btn_bg_clr_12, t0.inner_color AS inner_color_13, t0.outer_color AS outer_color_14, t0.patient_ref_prefix AS patient_ref_prefix_15, t0.email AS email_16, t0.verified_email AS verified_email_17, t0.web_site AS web_site_18, t0.phone AS phone_19, t0.contact_name AS contact_name_20, t0.description AS description_21, t0.widget_settings AS widget_settings_22, t0.sms_number AS sms_number_23, t0.sms_status AS sms_status_24, t0.timezone AS timezone_25, t0.reminder_header AS reminder_header_26, t0.reminder_footer AS reminder_footer_27, t0.reminder_recall_text AS reminder_recall_text_28, t0.google_token AS google_token_29, t0.google_id AS google_id_30, t0.topic_arn AS topic_arn_31, t0.pm_pin AS pm_pin_32, t0.auto_email_reply_address AS auto_email_reply_address_33, t0.pm_patient_message AS pm_patient_message_34, t0.pm_clinic_intro AS pm_clinic_intro_35, t0.auto_renew_subscription AS auto_renew_subscription_36, t0.subscription_expiry AS subscription_expiry_37, t0.email_reminder AS email_reminder_38, t0.email_new AS email_new_39, t0.sms_new AS sms_new_40, t0.sms_reminder AS sms_reminder_41, t0.when_answered_hide_where_did_you_hear_about_us AS when_answered_hide_where_did_you_hear_about_us_42, t0.calendar_start_day AS calendar_start_day_43, t0.calendar_end_day AS calendar_end_day_44, t0.appointment_default_time AS appointment_default_time_45, t0.appointment_slot_duration AS appointment_slot_duration_46, t0.appointment_default_view AS appointment_default_view_47, t0.private_mode_calendar AS private_mode_calendar_48, t0.clinic_representative AS clinic_representative_49, t0.data_protection_officer AS data_protection_officer_50, t0.company_registration_number AS company_registration_number_51, t0.email_to_withdraw AS email_to_withdraw_52, t0.period_stored_data AS period_stored_data_53, t0.survey_email_text AS survey_email_text_54, t0.post_apt_form_email_text AS post_apt_form_email_text_55, t0.export_in_progress AS export_in_progress_56, t0.vat_number AS vat_number_57, t0.enabled_vat AS enabled_vat_58, t0.patient_list_display_pair AS patient_list_display_pair_59, t0.stripe_refresh_token AS stripe_refresh_token_60, t0.stripe_publishable_key AS stripe_publishable_key_61, t0.stripe_account_id AS stripe_account_id_62, t0.shared_all_patients AS shared_all_patients_63, t0.currency AS currency_64, t0.patient_info_to_document_header AS patient_info_to_document_header_65, t0.t_and_c AS t_and_c_66, t0.declaration AS declaration_67, t0.treatment_plan_tand_c AS treatment_plan_tand_c_68, t0.traffic_light AS traffic_light_69, t0.booking_required_fields AS booking_required_fields_70, t0.double_booking AS double_booking_71, t0.required_confirmation AS required_confirmation_72, t0.fixed_discount_amount AS fixed_discount_amount_73, t0.required_questionnaires AS required_questionnaires_74, t0.patient_required_fields AS patient_required_fields_75, t0.prospect_required_fields AS prospect_required_fields_76, t0.enabled_postcode AS enabled_postcode_77, t0.enabled_chronoscan AS enabled_chronoscan_78, t0.postcode_api_key AS postcode_api_key_79, t0.enabled_prospect_web_form AS enabled_prospect_web_form_80, t0.payment_sense AS payment_sense_81, t0.xero_tenant_id AS xero_tenant_id_82, t0.reduce_stock AS reduce_stock_83, t0.patient_questionnaire AS patient_questionnaire_84, t0.xero_bank_account AS xero_bank_account_85, t0.is_new_clinic AS is_new_clinic_86, t0.marketing_expert AS marketing_expert_87, t0.clinic_survey_email_text AS clinic_survey_email_text_88, t0.trial_end_date AS trial_end_date_89, t0.shared_patient_date AS shared_patient_date_90, t0.feature_custom_website_amount AS feature_custom_website_amount_91, t0.feature_ad_amount AS feature_ad_amount_92, t0.feature_message_amount AS feature_message_amount_93, t0.feature_template_amount AS feature_template_amount_94, t0.is_template_user_only AS is_template_user_only_95, t0.new_user AS new_user_96, t0.template_subscription_end_date AS template_subscription_end_date_97, t0.onboarding_status AS onboarding_status_98, t0.address1 AS address1_99, t0.address2 AS address2_100, t0.town AS town_101, t0.state AS state_102, t0.country AS country_103, t0.postcode AS postcode_104, t0.created_at AS created_at_105, t0.updated_at AS updated_at_106, t0.logo_id AS logo_id_107, t108.id AS id_109, t108.s3key AS s3key_110, t108.name_file AS name_file_111, t108.url AS url_112, t108.type AS type_113, t108.created_at AS created_at_114, t108.updated_at AS updated_at_115, t0.background_id AS background_id_116, t117.id AS id_118, t117.s3key AS s3key_119, t117.name_file AS name_file_120, t117.url AS url_121, t117.type AS type_122, t117.created_at AS created_at_123, t117.updated_at AS updated_at_124, t125.id AS id_126, t125.creditor AS creditor_127, t125.mandate AS mandate_128, t125.customer AS customer_129, t125.customer_bank_account AS customer_bank_account_130, t125.created_at AS created_at_131, t125.updated_at AS updated_at_132, t125.clinic_id AS clinic_id_133, t134.id AS id_135, t134.sid AS sid_136, t134.token AS token_137, t134.number_from AS number_from_138, t134.clinic_id AS clinic_id_139, t0.organisation_id AS organisation_id_140, t141.id AS id_142, t141.enabled AS enabled_143, t141.time_required_for_booking AS time_required_for_booking_144, t141.time_required_for_cancellation AS time_required_for_cancellation_145, t141.take_payment_for_new_patients AS take_payment_for_new_patients_146, t141.take_payment_for_existing_patients AS take_payment_for_existing_patients_147, t141.type AS type_148, t141.hide_full_price AS hide_full_price_149, t141.terms AS terms_150, t141.clinic_id AS clinic_id_151, t152.id AS id_153, t152.server AS server_154, t152.file_location AS file_location_155, t152.username AS username_156, t152.password AS password_157, t152.email AS email_158, t152.clinic_id AS clinic_id_159, t160.id AS id_161, t160.theme AS theme_162, t160.max_embed_width AS max_embed_width_163, t160.primary_interface_colour AS primary_interface_colour_164, t160.secondary_interface_colour AS secondary_interface_colour_165, t160.primary_font_colour AS primary_font_colour_166, t160.secondary_font_colour AS secondary_font_colour_167, t160.background_colour AS background_colour_168, t160.widget_hash AS widget_hash_169, t160.created_at AS created_at_170, t160.updated_at AS updated_at_171, t160.clinic_id AS clinic_id_172, t160.custom_css_id AS custom_css_id_173, t174.id AS id_175, t174.confirmation_text AS confirmation_text_176, t174.treatment_info AS treatment_info_177, t174.clinic_id AS clinic_id_178, t179.id AS id_180, t179.api_key AS api_key_181, t179.list_id AS list_id_182, t179.sync AS sync_183, t179.sync_date AS sync_date_184, t179.pro AS pro_185, t179.created_at AS created_at_186, t179.updated_at AS updated_at_187, t179.clinic_id AS clinic_id_188, t0.promo_code_id AS promo_code_id_189, t0.price_tier_id AS price_tier_id_190, t0.xero_sync_job_id AS xero_sync_job_id_191 FROM clinics t0 LEFT JOIN media t108 ON t0.logo_id = t108.id LEFT JOIN media t117 ON t0.background_id = t117.id LEFT JOIN gocardless_customer t125 ON t125.clinic_id = t0.id LEFT JOIN twilio t134 ON t134.clinic_id = t0.id LEFT JOIN setting_online_booking t141 ON t141.clinic_id = t0.id LEFT JOIN setting_chronoscan t152 ON t152.clinic_id = t0.id LEFT JOIN widget_online_booking t160 ON t160.clinic_id = t0.id LEFT JOIN email_setting_online_booking t174 ON t174.clinic_id = t0.id LEFT JOIN mail_chimp_config t179 ON t179.clinic_id = t0.id WHERE t0.sub_domain = 'tvgrlcpanel' LIMIT 1;
|