| 1 |
5.87 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.booking_btn_name AS booking_btn_name_6, t0.booking_btn_clr AS booking_btn_clr_7, t0.booking_btn_bg_clr AS booking_btn_bg_clr_8, t0.inner_color AS inner_color_9, t0.outer_color AS outer_color_10, t0.background_img AS background_img_11, t0.profile_img AS profile_img_12, t0.meeting_price AS meeting_price_13, t0.meeting_price_type AS meeting_price_type_14, t0.show_in_public_profile AS show_in_public_profile_15, t0.patient_ref_prefix AS patient_ref_prefix_16, t0.email AS email_17, t0.verified_email AS verified_email_18, t0.web_site AS web_site_19, t0.phone AS phone_20, t0.contact_name AS contact_name_21, t0.description AS description_22, t0.widget_settings AS widget_settings_23, t0.sms_number AS sms_number_24, t0.sms_status AS sms_status_25, t0.timezone AS timezone_26, t0.reminder_header AS reminder_header_27, t0.reminder_footer AS reminder_footer_28, t0.reminder_recall_text AS reminder_recall_text_29, t0.google_token AS google_token_30, t0.google_id AS google_id_31, t0.topic_arn AS topic_arn_32, t0.pm_pin AS pm_pin_33, t0.auto_email_reply_address AS auto_email_reply_address_34, t0.pm_patient_message AS pm_patient_message_35, t0.pm_clinic_intro AS pm_clinic_intro_36, t0.auto_renew_subscription AS auto_renew_subscription_37, t0.subscription_expiry AS subscription_expiry_38, t0.email_reminder AS email_reminder_39, t0.email_new AS email_new_40, t0.sms_new AS sms_new_41, t0.sms_reminder AS sms_reminder_42, t0.when_answered_hide_where_did_you_hear_about_us AS when_answered_hide_where_did_you_hear_about_us_43, t0.calendar_start_day AS calendar_start_day_44, t0.calendar_end_day AS calendar_end_day_45, t0.appointment_default_time AS appointment_default_time_46, t0.appointment_slot_duration AS appointment_slot_duration_47, t0.appointment_default_view AS appointment_default_view_48, t0.private_mode_calendar AS private_mode_calendar_49, t0.clinic_representative AS clinic_representative_50, t0.data_protection_officer AS data_protection_officer_51, t0.company_registration_number AS company_registration_number_52, t0.email_to_withdraw AS email_to_withdraw_53, t0.period_stored_data AS period_stored_data_54, t0.survey_email_text AS survey_email_text_55, t0.post_apt_form_email_text AS post_apt_form_email_text_56, t0.export_in_progress AS export_in_progress_57, t0.vat_number AS vat_number_58, t0.enabled_vat AS enabled_vat_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.address1 AS address1_94, t0.address2 AS address2_95, t0.town AS town_96, t0.state AS state_97, t0.country AS country_98, t0.postcode AS postcode_99, t0.created_at AS created_at_100, t0.updated_at AS updated_at_101, t0.logo_id AS logo_id_102, t103.id AS id_104, t103.s3key AS s3key_105, t103.name_file AS name_file_106, t103.url AS url_107, t103.type AS type_108, t103.created_at AS created_at_109, t103.updated_at AS updated_at_110, t0.background_id AS background_id_111, t112.id AS id_113, t112.s3key AS s3key_114, t112.name_file AS name_file_115, t112.url AS url_116, t112.type AS type_117, t112.created_at AS created_at_118, t112.updated_at AS updated_at_119, t120.id AS id_121, t120.creditor AS creditor_122, t120.mandate AS mandate_123, t120.customer AS customer_124, t120.customer_bank_account AS customer_bank_account_125, t120.created_at AS created_at_126, t120.updated_at AS updated_at_127, t120.clinic_id AS clinic_id_128, t129.id AS id_130, t129.sid AS sid_131, t129.token AS token_132, t129.number_from AS number_from_133, t129.clinic_id AS clinic_id_134, t0.organisation_id AS organisation_id_135, t136.id AS id_137, t136.enabled AS enabled_138, t136.time_required_for_booking AS time_required_for_booking_139, t136.time_required_for_cancellation AS time_required_for_cancellation_140, t136.take_payment_for_new_patients AS take_payment_for_new_patients_141, t136.take_payment_for_existing_patients AS take_payment_for_existing_patients_142, t136.type AS type_143, t136.hide_full_price AS hide_full_price_144, t136.terms AS terms_145, t136.clinic_id AS clinic_id_146, t147.id AS id_148, t147.server AS server_149, t147.file_location AS file_location_150, t147.username AS username_151, t147.password AS password_152, t147.email AS email_153, t147.clinic_id AS clinic_id_154, t155.id AS id_156, t155.theme AS theme_157, t155.max_embed_width AS max_embed_width_158, t155.primary_interface_colour AS primary_interface_colour_159, t155.secondary_interface_colour AS secondary_interface_colour_160, t155.primary_font_colour AS primary_font_colour_161, t155.secondary_font_colour AS secondary_font_colour_162, t155.background_colour AS background_colour_163, t155.widget_hash AS widget_hash_164, t155.created_at AS created_at_165, t155.updated_at AS updated_at_166, t155.clinic_id AS clinic_id_167, t155.custom_css_id AS custom_css_id_168, t169.id AS id_170, t169.confirmation_text AS confirmation_text_171, t169.treatment_info AS treatment_info_172, t169.clinic_id AS clinic_id_173, t174.id AS id_175, t174.api_key AS api_key_176, t174.list_id AS list_id_177, t174.sync AS sync_178, t174.sync_date AS sync_date_179, t174.pro AS pro_180, t174.created_at AS created_at_181, t174.updated_at AS updated_at_182, t174.clinic_id AS clinic_id_183, t0.promo_code_id AS promo_code_id_184, t0.price_tier_id AS price_tier_id_185, t0.xero_sync_job_id AS xero_sync_job_id_186 FROM clinics t0 LEFT JOIN media t103 ON t0.logo_id = t103.id LEFT JOIN media t112 ON t0.background_id = t112.id LEFT JOIN gocardless_customer t120 ON t120.clinic_id = t0.id LEFT JOIN twilio t129 ON t129.clinic_id = t0.id LEFT JOIN setting_online_booking t136 ON t136.clinic_id = t0.id LEFT JOIN setting_chronoscan t147 ON t147.clinic_id = t0.id LEFT JOIN widget_online_booking t155 ON t155.clinic_id = t0.id LEFT JOIN email_setting_online_booking t169 ON t169.clinic_id = t0.id LEFT JOIN mail_chimp_config t174 ON t174.clinic_id = t0.id WHERE t0.sub_domain = ? LIMIT 1
Parameters: [
"143110167125"
]
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.booking_btn_name AS booking_btn_name_6,
t0.booking_btn_clr AS booking_btn_clr_7,
t0.booking_btn_bg_clr AS booking_btn_bg_clr_8,
t0.inner_color AS inner_color_9,
t0.outer_color AS outer_color_10,
t0.background_img AS background_img_11,
t0.profile_img AS profile_img_12,
t0.meeting_price AS meeting_price_13,
t0.meeting_price_type AS meeting_price_type_14,
t0.show_in_public_profile AS show_in_public_profile_15,
t0.patient_ref_prefix AS patient_ref_prefix_16,
t0.email AS email_17,
t0.verified_email AS verified_email_18,
t0.web_site AS web_site_19,
t0.phone AS phone_20,
t0.contact_name AS contact_name_21,
t0.description AS description_22,
t0.widget_settings AS widget_settings_23,
t0.sms_number AS sms_number_24,
t0.sms_status AS sms_status_25,
t0.timezone AS timezone_26,
t0.reminder_header AS reminder_header_27,
t0.reminder_footer AS reminder_footer_28,
t0.reminder_recall_text AS reminder_recall_text_29,
t0.google_token AS google_token_30,
t0.google_id AS google_id_31,
t0.topic_arn AS topic_arn_32,
t0.pm_pin AS pm_pin_33,
t0.auto_email_reply_address AS auto_email_reply_address_34,
t0.pm_patient_message AS pm_patient_message_35,
t0.pm_clinic_intro AS pm_clinic_intro_36,
t0.auto_renew_subscription AS auto_renew_subscription_37,
t0.subscription_expiry AS subscription_expiry_38,
t0.email_reminder AS email_reminder_39,
t0.email_new AS email_new_40,
t0.sms_new AS sms_new_41,
t0.sms_reminder AS sms_reminder_42,
t0.when_answered_hide_where_did_you_hear_about_us AS when_answered_hide_where_did_you_hear_about_us_43,
t0.calendar_start_day AS calendar_start_day_44,
t0.calendar_end_day AS calendar_end_day_45,
t0.appointment_default_time AS appointment_default_time_46,
t0.appointment_slot_duration AS appointment_slot_duration_47,
t0.appointment_default_view AS appointment_default_view_48,
t0.private_mode_calendar AS private_mode_calendar_49,
t0.clinic_representative AS clinic_representative_50,
t0.data_protection_officer AS data_protection_officer_51,
t0.company_registration_number AS company_registration_number_52,
t0.email_to_withdraw AS email_to_withdraw_53,
t0.period_stored_data AS period_stored_data_54,
t0.survey_email_text AS survey_email_text_55,
t0.post_apt_form_email_text AS post_apt_form_email_text_56,
t0.export_in_progress AS export_in_progress_57,
t0.vat_number AS vat_number_58,
t0.enabled_vat AS enabled_vat_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.address1 AS address1_94,
t0.address2 AS address2_95,
t0.town AS town_96,
t0.state AS state_97,
t0.country AS country_98,
t0.postcode AS postcode_99,
t0.created_at AS created_at_100,
t0.updated_at AS updated_at_101,
t0.logo_id AS logo_id_102,
t103.id AS id_104,
t103.s3key AS s3key_105,
t103.name_file AS name_file_106,
t103.url AS url_107,
t103.type AS type_108,
t103.created_at AS created_at_109,
t103.updated_at AS updated_at_110,
t0.background_id AS background_id_111,
t112.id AS id_113,
t112.s3key AS s3key_114,
t112.name_file AS name_file_115,
t112.url AS url_116,
t112.type AS type_117,
t112.created_at AS created_at_118,
t112.updated_at AS updated_at_119,
t120.id AS id_121,
t120.creditor AS creditor_122,
t120.mandate AS mandate_123,
t120.customer AS customer_124,
t120.customer_bank_account AS customer_bank_account_125,
t120.created_at AS created_at_126,
t120.updated_at AS updated_at_127,
t120.clinic_id AS clinic_id_128,
t129.id AS id_130,
t129.sid AS sid_131,
t129.token AS token_132,
t129.number_from AS number_from_133,
t129.clinic_id AS clinic_id_134,
t0.organisation_id AS organisation_id_135,
t136.id AS id_137,
t136.enabled AS enabled_138,
t136.time_required_for_booking AS time_required_for_booking_139,
t136.time_required_for_cancellation AS time_required_for_cancellation_140,
t136.take_payment_for_new_patients AS take_payment_for_new_patients_141,
t136.take_payment_for_existing_patients AS take_payment_for_existing_patients_142,
t136.type AS type_143,
t136.hide_full_price AS hide_full_price_144,
t136.terms AS terms_145,
t136.clinic_id AS clinic_id_146,
t147.id AS id_148,
t147.server AS server_149,
t147.file_location AS file_location_150,
t147.username AS username_151,
t147.password AS password_152,
t147.email AS email_153,
t147.clinic_id AS clinic_id_154,
t155.id AS id_156,
t155.theme AS theme_157,
t155.max_embed_width AS max_embed_width_158,
t155.primary_interface_colour AS primary_interface_colour_159,
t155.secondary_interface_colour AS secondary_interface_colour_160,
t155.primary_font_colour AS primary_font_colour_161,
t155.secondary_font_colour AS secondary_font_colour_162,
t155.background_colour AS background_colour_163,
t155.widget_hash AS widget_hash_164,
t155.created_at AS created_at_165,
t155.updated_at AS updated_at_166,
t155.clinic_id AS clinic_id_167,
t155.custom_css_id AS custom_css_id_168,
t169.id AS id_170,
t169.confirmation_text AS confirmation_text_171,
t169.treatment_info AS treatment_info_172,
t169.clinic_id AS clinic_id_173,
t174.id AS id_175,
t174.api_key AS api_key_176,
t174.list_id AS list_id_177,
t174.sync AS sync_178,
t174.sync_date AS sync_date_179,
t174.pro AS pro_180,
t174.created_at AS created_at_181,
t174.updated_at AS updated_at_182,
t174.clinic_id AS clinic_id_183,
t0.promo_code_id AS promo_code_id_184,
t0.price_tier_id AS price_tier_id_185,
t0.xero_sync_job_id AS xero_sync_job_id_186
FROM
clinics t0
LEFT JOIN media t103 ON t0.logo_id = t103.id
LEFT JOIN media t112 ON t0.background_id = t112.id
LEFT JOIN gocardless_customer t120 ON t120.clinic_id = t0.id
LEFT JOIN twilio t129 ON t129.clinic_id = t0.id
LEFT JOIN setting_online_booking t136 ON t136.clinic_id = t0.id
LEFT JOIN setting_chronoscan t147 ON t147.clinic_id = t0.id
LEFT JOIN widget_online_booking t155 ON t155.clinic_id = t0.id
LEFT JOIN email_setting_online_booking t169 ON t169.clinic_id = t0.id
LEFT JOIN mail_chimp_config t174 ON t174.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.booking_btn_name AS booking_btn_name_6, t0.booking_btn_clr AS booking_btn_clr_7, t0.booking_btn_bg_clr AS booking_btn_bg_clr_8, t0.inner_color AS inner_color_9, t0.outer_color AS outer_color_10, t0.background_img AS background_img_11, t0.profile_img AS profile_img_12, t0.meeting_price AS meeting_price_13, t0.meeting_price_type AS meeting_price_type_14, t0.show_in_public_profile AS show_in_public_profile_15, t0.patient_ref_prefix AS patient_ref_prefix_16, t0.email AS email_17, t0.verified_email AS verified_email_18, t0.web_site AS web_site_19, t0.phone AS phone_20, t0.contact_name AS contact_name_21, t0.description AS description_22, t0.widget_settings AS widget_settings_23, t0.sms_number AS sms_number_24, t0.sms_status AS sms_status_25, t0.timezone AS timezone_26, t0.reminder_header AS reminder_header_27, t0.reminder_footer AS reminder_footer_28, t0.reminder_recall_text AS reminder_recall_text_29, t0.google_token AS google_token_30, t0.google_id AS google_id_31, t0.topic_arn AS topic_arn_32, t0.pm_pin AS pm_pin_33, t0.auto_email_reply_address AS auto_email_reply_address_34, t0.pm_patient_message AS pm_patient_message_35, t0.pm_clinic_intro AS pm_clinic_intro_36, t0.auto_renew_subscription AS auto_renew_subscription_37, t0.subscription_expiry AS subscription_expiry_38, t0.email_reminder AS email_reminder_39, t0.email_new AS email_new_40, t0.sms_new AS sms_new_41, t0.sms_reminder AS sms_reminder_42, t0.when_answered_hide_where_did_you_hear_about_us AS when_answered_hide_where_did_you_hear_about_us_43, t0.calendar_start_day AS calendar_start_day_44, t0.calendar_end_day AS calendar_end_day_45, t0.appointment_default_time AS appointment_default_time_46, t0.appointment_slot_duration AS appointment_slot_duration_47, t0.appointment_default_view AS appointment_default_view_48, t0.private_mode_calendar AS private_mode_calendar_49, t0.clinic_representative AS clinic_representative_50, t0.data_protection_officer AS data_protection_officer_51, t0.company_registration_number AS company_registration_number_52, t0.email_to_withdraw AS email_to_withdraw_53, t0.period_stored_data AS period_stored_data_54, t0.survey_email_text AS survey_email_text_55, t0.post_apt_form_email_text AS post_apt_form_email_text_56, t0.export_in_progress AS export_in_progress_57, t0.vat_number AS vat_number_58, t0.enabled_vat AS enabled_vat_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.address1 AS address1_94, t0.address2 AS address2_95, t0.town AS town_96, t0.state AS state_97, t0.country AS country_98, t0.postcode AS postcode_99, t0.created_at AS created_at_100, t0.updated_at AS updated_at_101, t0.logo_id AS logo_id_102, t103.id AS id_104, t103.s3key AS s3key_105, t103.name_file AS name_file_106, t103.url AS url_107, t103.type AS type_108, t103.created_at AS created_at_109, t103.updated_at AS updated_at_110, t0.background_id AS background_id_111, t112.id AS id_113, t112.s3key AS s3key_114, t112.name_file AS name_file_115, t112.url AS url_116, t112.type AS type_117, t112.created_at AS created_at_118, t112.updated_at AS updated_at_119, t120.id AS id_121, t120.creditor AS creditor_122, t120.mandate AS mandate_123, t120.customer AS customer_124, t120.customer_bank_account AS customer_bank_account_125, t120.created_at AS created_at_126, t120.updated_at AS updated_at_127, t120.clinic_id AS clinic_id_128, t129.id AS id_130, t129.sid AS sid_131, t129.token AS token_132, t129.number_from AS number_from_133, t129.clinic_id AS clinic_id_134, t0.organisation_id AS organisation_id_135, t136.id AS id_137, t136.enabled AS enabled_138, t136.time_required_for_booking AS time_required_for_booking_139, t136.time_required_for_cancellation AS time_required_for_cancellation_140, t136.take_payment_for_new_patients AS take_payment_for_new_patients_141, t136.take_payment_for_existing_patients AS take_payment_for_existing_patients_142, t136.type AS type_143, t136.hide_full_price AS hide_full_price_144, t136.terms AS terms_145, t136.clinic_id AS clinic_id_146, t147.id AS id_148, t147.server AS server_149, t147.file_location AS file_location_150, t147.username AS username_151, t147.password AS password_152, t147.email AS email_153, t147.clinic_id AS clinic_id_154, t155.id AS id_156, t155.theme AS theme_157, t155.max_embed_width AS max_embed_width_158, t155.primary_interface_colour AS primary_interface_colour_159, t155.secondary_interface_colour AS secondary_interface_colour_160, t155.primary_font_colour AS primary_font_colour_161, t155.secondary_font_colour AS secondary_font_colour_162, t155.background_colour AS background_colour_163, t155.widget_hash AS widget_hash_164, t155.created_at AS created_at_165, t155.updated_at AS updated_at_166, t155.clinic_id AS clinic_id_167, t155.custom_css_id AS custom_css_id_168, t169.id AS id_170, t169.confirmation_text AS confirmation_text_171, t169.treatment_info AS treatment_info_172, t169.clinic_id AS clinic_id_173, t174.id AS id_175, t174.api_key AS api_key_176, t174.list_id AS list_id_177, t174.sync AS sync_178, t174.sync_date AS sync_date_179, t174.pro AS pro_180, t174.created_at AS created_at_181, t174.updated_at AS updated_at_182, t174.clinic_id AS clinic_id_183, t0.promo_code_id AS promo_code_id_184, t0.price_tier_id AS price_tier_id_185, t0.xero_sync_job_id AS xero_sync_job_id_186 FROM clinics t0 LEFT JOIN media t103 ON t0.logo_id = t103.id LEFT JOIN media t112 ON t0.background_id = t112.id LEFT JOIN gocardless_customer t120 ON t120.clinic_id = t0.id LEFT JOIN twilio t129 ON t129.clinic_id = t0.id LEFT JOIN setting_online_booking t136 ON t136.clinic_id = t0.id LEFT JOIN setting_chronoscan t147 ON t147.clinic_id = t0.id LEFT JOIN widget_online_booking t155 ON t155.clinic_id = t0.id LEFT JOIN email_setting_online_booking t169 ON t169.clinic_id = t0.id LEFT JOIN mail_chimp_config t174 ON t174.clinic_id = t0.id WHERE t0.sub_domain = '143110167125' LIMIT 1;
|