1
9.17 ms
SELECT u0_ . id AS id_0 , u0_ . username AS username_1 , u0_ . email AS email_2 , u0_ . first_name AS first_name_3 , u0_ . last_name AS last_name_4 , u0_ . full_name AS full_name_5 , u0_ . password AS password_6 , u0_ . booking_btn_name AS booking_btn_name_7 , u0_ . booking_btn_clr AS booking_btn_clr_8 , u0_ . booking_btn_bg_clr AS booking_btn_bg_clr_9 , u0_ . inner_color AS inner_color_10 , u0_ . outer_color AS outer_color_11 , u0_ . background_img AS background_img_12 , u0_ . profile_img AS profile_img_13 , u0_ . role AS role_14 , u0_ . enabled AS enabled_15 , u0_ . locked AS locked_16 , u0_ . visible AS visible_17 , u0_ . is_disengaged AS is_disengaged_18 , u0_ . otp AS otp_19 , u0_ . otp_sent_at AS otp_sent_at_20 , u0_ . last_otp_verified AS last_otp_verified_21 , u0_ . imap_setting AS imap_setting_22 , u0_ . country_code AS country_code_23 , u0_ . phone AS phone_24 , u0_ . practitioner_commission AS practitioner_commission_25 , u0_ . coordinator_commission AS coordinator_commission_26 , u0_ . course_commission AS course_commission_27 , u0_ . membership_commission AS membership_commission_28 , u0_ . product_commission AS product_commission_29 , u0_ . token AS token_30 , u0_ . access_all_calendars AS access_all_calendars_31 , u0_ . current_auth_token AS current_auth_token_32 , u0_ . last_auth_time AS last_auth_time_33 , u0_ . hash AS hash_34 , u0_ . fcm_token AS fcm_token_35 , u0_ . hx_change_token AS hx_change_token_36 , u0_ . login_from AS login_from_37 , u0_ . ever_login_in_v3 AS ever_login_in_v3_38 , u0_ . permissions AS permissions_39 , u0_ . clinic_id AS clinic_id_40 , u0_ . fp_promoter_id AS fp_promoter_id_41 , u0_ . referral_link AS referral_link_42 , u0_ . fp_tracking_id AS fp_tracking_id_43 , u0_ . receive_special_offer_email AS receive_special_offer_email_44 , u0_ . receive_special_offer_sms AS receive_special_offer_sms_45 , u0_ . deleted_at AS deleted_at_46 , u0_ . created_at AS created_at_47 , u0_ . updated_at AS updated_at_48 , u0_ . stripe_customer_id AS stripe_customer_id_49 , u0_ . stripe_customer_id AS stripe_customer_id_50 , u0_ . status AS status_51 , u0_ . birthday AS birthday_52 , u0_ . country_code_alt AS country_code_alt_53 , u0_ . secondary_phone AS secondary_phone_54 , u0_ . next_kin AS next_kin_55 , u0_ . next_kin_phone AS next_kin_phone_56 , u0_ . description AS description_57 , u0_ . glogau_scale AS glogau_scale_58 , u0_ . fitzpatrick_scale AS fitzpatrick_scale_59 , u0_ . gender AS gender_60 , u0_ . receive_special_offer_push AS receive_special_offer_push_61 , u0_ . receive_reminder_email AS receive_reminder_email_62 , u0_ . receive_reminder_sms AS receive_reminder_sms_63 , u0_ . receive_reminder_push AS receive_reminder_push_64 , u0_ . parent_user_id AS parent_user_id_65 , u0_ . account_type AS account_type_66 , u0_ . terms_accepted AS terms_accepted_67 , u0_ . terms_accepted_patient_mode AS terms_accepted_patient_mode_68 , u0_ . referral AS referral_69 , u0_ . export_in_progress AS export_in_progress_70 , u0_ . occupation AS occupation_71 , u0_ . number_nhs AS number_nhs_72 , u0_ . gp_name AS gp_name_73 , u0_ . contact_gp AS contact_gp_74 , u0_ . gp_address1 AS gp_address1_75 , u0_ . gp_address2 AS gp_address2_76 , u0_ . gp_town AS gp_town_77 , u0_ . gp_county AS gp_county_78 , u0_ . gp_post_code AS gp_post_code_79 , u0_ . gp_country AS gp_country_80 , u0_ . ref AS ref_81 , u0_ . chronoscan_code AS chronoscan_code_82 , u0_ . ethnicity AS ethnicity_83 , u0_ . height AS height_84 , u0_ . weight AS weight_85 , u0_ . passport AS passport_86 , u0_ . reference_number AS reference_number_87 , u0_ . photo_consent AS photo_consent_88 , u0_ . all_marketing AS all_marketing_89 , u0_ . in_clinic_marketing AS in_clinic_marketing_90 , u0_ . in_consultation AS in_consultation_91 , u0_ . interested_in AS interested_in_92 , u0_ . consultation_type AS consultation_type_93 , u0_ . google_click_id AS google_click_id_94 , u0_ . campaign_name AS campaign_name_95 , u0_ . campaign_source AS campaign_source_96 , u0_ . campaign_medium AS campaign_medium_97 , u0_ . campaign_term AS campaign_term_98 , u0_ . campaign_content AS campaign_content_99 , u0_ . marketing_source AS marketing_source_100 , u0_ . author AS author_101 , u0_ . address1 AS address1_102 , u0_ . address2 AS address2_103 , u0_ . town AS town_104 , u0_ . state AS state_105 , u0_ . country AS country_106 , u0_ . postcode AS postcode_107 , u0_ . qualification AS qualification_108 , u0_ . summary AS summary_109 , u0_ . deleted AS deleted_110 , u0_ . calendar_color AS calendar_color_111 , u0_ . calendar_order_number AS calendar_order_number_112 , u0_ . calendar_id AS calendar_id_113 , u0_ . position AS position_114 , u0_ . online_booking_availability AS online_booking_availability_115 , u0_ . title AS title_116 , u0_ . email_verify AS email_verify_117 , u0_ . hash_user_short_url AS hash_user_short_url_118 , u0_ . licence_number AS licence_number_119 , u0_ . stripe_customer_id AS stripe_customer_id_120 , u0_ . is_online AS is_online_121 , u0_ . last_call_time AS last_call_time_122 , u0_ . hide_report_menus AS hide_report_menus_123 , u0_ . type AS type_124 , u0_ . media_id AS media_id_125 , u0_ . device_id AS device_id_126 , u0_ . created_by_id AS created_by_id_127 , u0_ . organisation_id AS organisation_id_128 , u0_ . current_clinic_id AS current_clinic_id_129 , u0_ . parent_id AS parent_id_130 , u0_ . active_photo_id AS active_photo_id_131 , u0_ . bar_code_image_id AS bar_code_image_id_132 , u0_ . clinic_id AS clinic_id_133 , u0_ . prospect_id AS prospect_id_134 , u0_ . clinic_id AS clinic_id_135 , u0_ . i_calendar_id AS i_calendar_id_136 FROM user u0_ LEFT JOIN device d1_ ON u0_ . device_id = d1_ . id WHERE (d1_ . token = ? AND d1_ . expired_at > ? AND d1_ . logout_by_reason_of_license < > 1 ) AND u0_ . type IN ('admin' , 'admin_support' , 'super_clinic_admin' , 'patient' , 'clinic_user' ) LIMIT 1
Parameters :
[
"demo "
"2026-07-06 19:57:36 "
]
SELECT
u0_ . id AS id_0 ,
u0_ . username AS username_1 ,
u0_ . email AS email_2 ,
u0_ . first_name AS first_name_3 ,
u0_ . last_name AS last_name_4 ,
u0_ . full_name AS full_name_5 ,
u0_ . password AS password_6 ,
u0_ . booking_btn_name AS booking_btn_name_7 ,
u0_ . booking_btn_clr AS booking_btn_clr_8 ,
u0_ . booking_btn_bg_clr AS booking_btn_bg_clr_9 ,
u0_ . inner_color AS inner_color_10 ,
u0_ . outer_color AS outer_color_11 ,
u0_ . background_img AS background_img_12 ,
u0_ . profile_img AS profile_img_13 ,
u0_ . role AS role_14 ,
u0_ . enabled AS enabled_15 ,
u0_ . locked AS locked_16 ,
u0_ . visible AS visible_17 ,
u0_ . is_disengaged AS is_disengaged_18 ,
u0_ . otp AS otp_19 ,
u0_ . otp_sent_at AS otp_sent_at_20 ,
u0_ . last_otp_verified AS last_otp_verified_21 ,
u0_ . imap_setting AS imap_setting_22 ,
u0_ . country_code AS country_code_23 ,
u0_ . phone AS phone_24 ,
u0_ . practitioner_commission AS practitioner_commission_25 ,
u0_ . coordinator_commission AS coordinator_commission_26 ,
u0_ . course_commission AS course_commission_27 ,
u0_ . membership_commission AS membership_commission_28 ,
u0_ . product_commission AS product_commission_29 ,
u0_ . token AS token_30 ,
u0_ . access_all_calendars AS access_all_calendars_31 ,
u0_ . current_auth_token AS current_auth_token_32 ,
u0_ . last_auth_time AS last_auth_time_33 ,
u0_ . hash AS hash_34 ,
u0_ . fcm_token AS fcm_token_35 ,
u0_ . hx_change_token AS hx_change_token_36 ,
u0_ . login_from AS login_from_37 ,
u0_ . ever_login_in_v3 AS ever_login_in_v3_38 ,
u0_ . permissions AS permissions_39 ,
u0_ . clinic_id AS clinic_id_40 ,
u0_ . fp_promoter_id AS fp_promoter_id_41 ,
u0_ . referral_link AS referral_link_42 ,
u0_ . fp_tracking_id AS fp_tracking_id_43 ,
u0_ . receive_special_offer_email AS receive_special_offer_email_44 ,
u0_ . receive_special_offer_sms AS receive_special_offer_sms_45 ,
u0_ . deleted_at AS deleted_at_46 ,
u0_ . created_at AS created_at_47 ,
u0_ . updated_at AS updated_at_48 ,
u0_ . stripe_customer_id AS stripe_customer_id_49 ,
u0_ . stripe_customer_id AS stripe_customer_id_50 ,
u0_ . status AS status_51 ,
u0_ . birthday AS birthday_52 ,
u0_ . country_code_alt AS country_code_alt_53 ,
u0_ . secondary_phone AS secondary_phone_54 ,
u0_ . next_kin AS next_kin_55 ,
u0_ . next_kin_phone AS next_kin_phone_56 ,
u0_ . description AS description_57 ,
u0_ . glogau_scale AS glogau_scale_58 ,
u0_ . fitzpatrick_scale AS fitzpatrick_scale_59 ,
u0_ . gender AS gender_60 ,
u0_ . receive_special_offer_push AS receive_special_offer_push_61 ,
u0_ . receive_reminder_email AS receive_reminder_email_62 ,
u0_ . receive_reminder_sms AS receive_reminder_sms_63 ,
u0_ . receive_reminder_push AS receive_reminder_push_64 ,
u0_ . parent_user_id AS parent_user_id_65 ,
u0_ . account_type AS account_type_66 ,
u0_ . terms_accepted AS terms_accepted_67 ,
u0_ . terms_accepted_patient_mode AS terms_accepted_patient_mode_68 ,
u0_ . referral AS referral_69 ,
u0_ . export_in_progress AS export_in_progress_70 ,
u0_ . occupation AS occupation_71 ,
u0_ . number_nhs AS number_nhs_72 ,
u0_ . gp_name AS gp_name_73 ,
u0_ . contact_gp AS contact_gp_74 ,
u0_ . gp_address1 AS gp_address1_75 ,
u0_ . gp_address2 AS gp_address2_76 ,
u0_ . gp_town AS gp_town_77 ,
u0_ . gp_county AS gp_county_78 ,
u0_ . gp_post_code AS gp_post_code_79 ,
u0_ . gp_country AS gp_country_80 ,
u0_ . ref AS ref_81 ,
u0_ . chronoscan_code AS chronoscan_code_82 ,
u0_ . ethnicity AS ethnicity_83 ,
u0_ . height AS height_84 ,
u0_ . weight AS weight_85 ,
u0_ . passport AS passport_86 ,
u0_ . reference_number AS reference_number_87 ,
u0_ . photo_consent AS photo_consent_88 ,
u0_ . all_marketing AS all_marketing_89 ,
u0_ . in_clinic_marketing AS in_clinic_marketing_90 ,
u0_ . in_consultation AS in_consultation_91 ,
u0_ . interested_in AS interested_in_92 ,
u0_ . consultation_type AS consultation_type_93 ,
u0_ . google_click_id AS google_click_id_94 ,
u0_ . campaign_name AS campaign_name_95 ,
u0_ . campaign_source AS campaign_source_96 ,
u0_ . campaign_medium AS campaign_medium_97 ,
u0_ . campaign_term AS campaign_term_98 ,
u0_ . campaign_content AS campaign_content_99 ,
u0_ . marketing_source AS marketing_source_100 ,
u0_ . author AS author_101 ,
u0_ . address1 AS address1_102 ,
u0_ . address2 AS address2_103 ,
u0_ . town AS town_104 ,
u0_ . state AS state_105 ,
u0_ . country AS country_106 ,
u0_ . postcode AS postcode_107 ,
u0_ . qualification AS qualification_108 ,
u0_ . summary AS summary_109 ,
u0_ . deleted AS deleted_110 ,
u0_ . calendar_color AS calendar_color_111 ,
u0_ . calendar_order_number AS calendar_order_number_112 ,
u0_ . calendar_id AS calendar_id_113 ,
u0_ . position AS position_114 ,
u0_ . online_booking_availability AS online_booking_availability_115 ,
u0_ . title AS title_116 ,
u0_ . email_verify AS email_verify_117 ,
u0_ . hash_user_short_url AS hash_user_short_url_118 ,
u0_ . licence_number AS licence_number_119 ,
u0_ . stripe_customer_id AS stripe_customer_id_120 ,
u0_ . is_online AS is_online_121 ,
u0_ . last_call_time AS last_call_time_122 ,
u0_ . hide_report_menus AS hide_report_menus_123 ,
u0_ . type AS type_124 ,
u0_ . media_id AS media_id_125 ,
u0_ . device_id AS device_id_126 ,
u0_ . created_by_id AS created_by_id_127 ,
u0_ . organisation_id AS organisation_id_128 ,
u0_ . current_clinic_id AS current_clinic_id_129 ,
u0_ . parent_id AS parent_id_130 ,
u0_ . active_photo_id AS active_photo_id_131 ,
u0_ . bar_code_image_id AS bar_code_image_id_132 ,
u0_ . clinic_id AS clinic_id_133 ,
u0_ . prospect_id AS prospect_id_134 ,
u0_ . clinic_id AS clinic_id_135 ,
u0_ . i_calendar_id AS i_calendar_id_136
FROM
user u0_
LEFT JOIN device d1_ ON u0_ . device_id = d1_ . id
WHERE
(
d1_ . token = ?
AND d1_ . expired_at > ?
AND d1_ . logout_by_reason_of_license < > 1
)
AND u0_ . type IN (
'admin' , 'admin_support' , 'super_clinic_admin' ,
'patient' , 'clinic_user'
)
LIMIT
1 Copy
SELECT u0_ . id AS id_0 , u0_ . username AS username_1 , u0_ . email AS email_2 , u0_ . first_name AS first_name_3 , u0_ . last_name AS last_name_4 , u0_ . full_name AS full_name_5 , u0_ . password AS password_6 , u0_ . booking_btn_name AS booking_btn_name_7 , u0_ . booking_btn_clr AS booking_btn_clr_8 , u0_ . booking_btn_bg_clr AS booking_btn_bg_clr_9 , u0_ . inner_color AS inner_color_10 , u0_ . outer_color AS outer_color_11 , u0_ . background_img AS background_img_12 , u0_ . profile_img AS profile_img_13 , u0_ . role AS role_14 , u0_ . enabled AS enabled_15 , u0_ . locked AS locked_16 , u0_ . visible AS visible_17 , u0_ . is_disengaged AS is_disengaged_18 , u0_ . otp AS otp_19 , u0_ . otp_sent_at AS otp_sent_at_20 , u0_ . last_otp_verified AS last_otp_verified_21 , u0_ . imap_setting AS imap_setting_22 , u0_ . country_code AS country_code_23 , u0_ . phone AS phone_24 , u0_ . practitioner_commission AS practitioner_commission_25 , u0_ . coordinator_commission AS coordinator_commission_26 , u0_ . course_commission AS course_commission_27 , u0_ . membership_commission AS membership_commission_28 , u0_ . product_commission AS product_commission_29 , u0_ . token AS token_30 , u0_ . access_all_calendars AS access_all_calendars_31 , u0_ . current_auth_token AS current_auth_token_32 , u0_ . last_auth_time AS last_auth_time_33 , u0_ . hash AS hash_34 , u0_ . fcm_token AS fcm_token_35 , u0_ . hx_change_token AS hx_change_token_36 , u0_ . login_from AS login_from_37 , u0_ . ever_login_in_v3 AS ever_login_in_v3_38 , u0_ . permissions AS permissions_39 , u0_ . clinic_id AS clinic_id_40 , u0_ . fp_promoter_id AS fp_promoter_id_41 , u0_ . referral_link AS referral_link_42 , u0_ . fp_tracking_id AS fp_tracking_id_43 , u0_ . receive_special_offer_email AS receive_special_offer_email_44 , u0_ . receive_special_offer_sms AS receive_special_offer_sms_45 , u0_ . deleted_at AS deleted_at_46 , u0_ . created_at AS created_at_47 , u0_ . updated_at AS updated_at_48 , u0_ . stripe_customer_id AS stripe_customer_id_49 , u0_ . stripe_customer_id AS stripe_customer_id_50 , u0_ . status AS status_51 , u0_ . birthday AS birthday_52 , u0_ . country_code_alt AS country_code_alt_53 , u0_ . secondary_phone AS secondary_phone_54 , u0_ . next_kin AS next_kin_55 , u0_ . next_kin_phone AS next_kin_phone_56 , u0_ . description AS description_57 , u0_ . glogau_scale AS glogau_scale_58 , u0_ . fitzpatrick_scale AS fitzpatrick_scale_59 , u0_ . gender AS gender_60 , u0_ . receive_special_offer_push AS receive_special_offer_push_61 , u0_ . receive_reminder_email AS receive_reminder_email_62 , u0_ . receive_reminder_sms AS receive_reminder_sms_63 , u0_ . receive_reminder_push AS receive_reminder_push_64 , u0_ . parent_user_id AS parent_user_id_65 , u0_ . account_type AS account_type_66 , u0_ . terms_accepted AS terms_accepted_67 , u0_ . terms_accepted_patient_mode AS terms_accepted_patient_mode_68 , u0_ . referral AS referral_69 , u0_ . export_in_progress AS export_in_progress_70 , u0_ . occupation AS occupation_71 , u0_ . number_nhs AS number_nhs_72 , u0_ . gp_name AS gp_name_73 , u0_ . contact_gp AS contact_gp_74 , u0_ . gp_address1 AS gp_address1_75 , u0_ . gp_address2 AS gp_address2_76 , u0_ . gp_town AS gp_town_77 , u0_ . gp_county AS gp_county_78 , u0_ . gp_post_code AS gp_post_code_79 , u0_ . gp_country AS gp_country_80 , u0_ . ref AS ref_81 , u0_ . chronoscan_code AS chronoscan_code_82 , u0_ . ethnicity AS ethnicity_83 , u0_ . height AS height_84 , u0_ . weight AS weight_85 , u0_ . passport AS passport_86 , u0_ . reference_number AS reference_number_87 , u0_ . photo_consent AS photo_consent_88 , u0_ . all_marketing AS all_marketing_89 , u0_ . in_clinic_marketing AS in_clinic_marketing_90 , u0_ . in_consultation AS in_consultation_91 , u0_ . interested_in AS interested_in_92 , u0_ . consultation_type AS consultation_type_93 , u0_ . google_click_id AS google_click_id_94 , u0_ . campaign_name AS campaign_name_95 , u0_ . campaign_source AS campaign_source_96 , u0_ . campaign_medium AS campaign_medium_97 , u0_ . campaign_term AS campaign_term_98 , u0_ . campaign_content AS campaign_content_99 , u0_ . marketing_source AS marketing_source_100 , u0_ . author AS author_101 , u0_ . address1 AS address1_102 , u0_ . address2 AS address2_103 , u0_ . town AS town_104 , u0_ . state AS state_105 , u0_ . country AS country_106 , u0_ . postcode AS postcode_107 , u0_ . qualification AS qualification_108 , u0_ . summary AS summary_109 , u0_ . deleted AS deleted_110 , u0_ . calendar_color AS calendar_color_111 , u0_ . calendar_order_number AS calendar_order_number_112 , u0_ . calendar_id AS calendar_id_113 , u0_ . position AS position_114 , u0_ . online_booking_availability AS online_booking_availability_115 , u0_ . title AS title_116 , u0_ . email_verify AS email_verify_117 , u0_ . hash_user_short_url AS hash_user_short_url_118 , u0_ . licence_number AS licence_number_119 , u0_ . stripe_customer_id AS stripe_customer_id_120 , u0_ . is_online AS is_online_121 , u0_ . last_call_time AS last_call_time_122 , u0_ . hide_report_menus AS hide_report_menus_123 , u0_ . type AS type_124 , u0_ . media_id AS media_id_125 , u0_ . device_id AS device_id_126 , u0_ . created_by_id AS created_by_id_127 , u0_ . organisation_id AS organisation_id_128 , u0_ . current_clinic_id AS current_clinic_id_129 , u0_ . parent_id AS parent_id_130 , u0_ . active_photo_id AS active_photo_id_131 , u0_ . bar_code_image_id AS bar_code_image_id_132 , u0_ . clinic_id AS clinic_id_133 , u0_ . prospect_id AS prospect_id_134 , u0_ . clinic_id AS clinic_id_135 , u0_ . i_calendar_id AS i_calendar_id_136 FROM user u0_ LEFT JOIN device d1_ ON u0_ . device_id = d1_ . id WHERE (d1_ . token = 'demo' AND d1_ . expired_at > '2026-07-06 19:57:36' AND d1_ . logout_by_reason_of_license < > 1 ) AND u0_ . type IN ('admin' , 'admin_support' , 'super_clinic_admin' , 'patient' , 'clinic_user' ) LIMIT 1 ; Copy
2
6.74 ms
SELECT u0_ . id AS id_0 , u0_ . username AS username_1 , u0_ . email AS email_2 , u0_ . first_name AS first_name_3 , u0_ . last_name AS last_name_4 , u0_ . full_name AS full_name_5 , u0_ . password AS password_6 , u0_ . booking_btn_name AS booking_btn_name_7 , u0_ . booking_btn_clr AS booking_btn_clr_8 , u0_ . booking_btn_bg_clr AS booking_btn_bg_clr_9 , u0_ . inner_color AS inner_color_10 , u0_ . outer_color AS outer_color_11 , u0_ . background_img AS background_img_12 , u0_ . profile_img AS profile_img_13 , u0_ . role AS role_14 , u0_ . enabled AS enabled_15 , u0_ . locked AS locked_16 , u0_ . visible AS visible_17 , u0_ . is_disengaged AS is_disengaged_18 , u0_ . otp AS otp_19 , u0_ . otp_sent_at AS otp_sent_at_20 , u0_ . last_otp_verified AS last_otp_verified_21 , u0_ . imap_setting AS imap_setting_22 , u0_ . country_code AS country_code_23 , u0_ . phone AS phone_24 , u0_ . practitioner_commission AS practitioner_commission_25 , u0_ . coordinator_commission AS coordinator_commission_26 , u0_ . course_commission AS course_commission_27 , u0_ . membership_commission AS membership_commission_28 , u0_ . product_commission AS product_commission_29 , u0_ . token AS token_30 , u0_ . access_all_calendars AS access_all_calendars_31 , u0_ . current_auth_token AS current_auth_token_32 , u0_ . last_auth_time AS last_auth_time_33 , u0_ . hash AS hash_34 , u0_ . fcm_token AS fcm_token_35 , u0_ . hx_change_token AS hx_change_token_36 , u0_ . login_from AS login_from_37 , u0_ . ever_login_in_v3 AS ever_login_in_v3_38 , u0_ . permissions AS permissions_39 , u0_ . clinic_id AS clinic_id_40 , u0_ . fp_promoter_id AS fp_promoter_id_41 , u0_ . referral_link AS referral_link_42 , u0_ . fp_tracking_id AS fp_tracking_id_43 , u0_ . receive_special_offer_email AS receive_special_offer_email_44 , u0_ . receive_special_offer_sms AS receive_special_offer_sms_45 , u0_ . deleted_at AS deleted_at_46 , u0_ . created_at AS created_at_47 , u0_ . updated_at AS updated_at_48 , u0_ . stripe_customer_id AS stripe_customer_id_49 , u0_ . stripe_customer_id AS stripe_customer_id_50 , u0_ . status AS status_51 , u0_ . birthday AS birthday_52 , u0_ . country_code_alt AS country_code_alt_53 , u0_ . secondary_phone AS secondary_phone_54 , u0_ . next_kin AS next_kin_55 , u0_ . next_kin_phone AS next_kin_phone_56 , u0_ . description AS description_57 , u0_ . glogau_scale AS glogau_scale_58 , u0_ . fitzpatrick_scale AS fitzpatrick_scale_59 , u0_ . gender AS gender_60 , u0_ . receive_special_offer_push AS receive_special_offer_push_61 , u0_ . receive_reminder_email AS receive_reminder_email_62 , u0_ . receive_reminder_sms AS receive_reminder_sms_63 , u0_ . receive_reminder_push AS receive_reminder_push_64 , u0_ . parent_user_id AS parent_user_id_65 , u0_ . account_type AS account_type_66 , u0_ . terms_accepted AS terms_accepted_67 , u0_ . terms_accepted_patient_mode AS terms_accepted_patient_mode_68 , u0_ . referral AS referral_69 , u0_ . export_in_progress AS export_in_progress_70 , u0_ . occupation AS occupation_71 , u0_ . number_nhs AS number_nhs_72 , u0_ . gp_name AS gp_name_73 , u0_ . contact_gp AS contact_gp_74 , u0_ . gp_address1 AS gp_address1_75 , u0_ . gp_address2 AS gp_address2_76 , u0_ . gp_town AS gp_town_77 , u0_ . gp_county AS gp_county_78 , u0_ . gp_post_code AS gp_post_code_79 , u0_ . gp_country AS gp_country_80 , u0_ . ref AS ref_81 , u0_ . chronoscan_code AS chronoscan_code_82 , u0_ . ethnicity AS ethnicity_83 , u0_ . height AS height_84 , u0_ . weight AS weight_85 , u0_ . passport AS passport_86 , u0_ . reference_number AS reference_number_87 , u0_ . photo_consent AS photo_consent_88 , u0_ . all_marketing AS all_marketing_89 , u0_ . in_clinic_marketing AS in_clinic_marketing_90 , u0_ . in_consultation AS in_consultation_91 , u0_ . interested_in AS interested_in_92 , u0_ . consultation_type AS consultation_type_93 , u0_ . google_click_id AS google_click_id_94 , u0_ . campaign_name AS campaign_name_95 , u0_ . campaign_source AS campaign_source_96 , u0_ . campaign_medium AS campaign_medium_97 , u0_ . campaign_term AS campaign_term_98 , u0_ . campaign_content AS campaign_content_99 , u0_ . marketing_source AS marketing_source_100 , u0_ . author AS author_101 , u0_ . address1 AS address1_102 , u0_ . address2 AS address2_103 , u0_ . town AS town_104 , u0_ . state AS state_105 , u0_ . country AS country_106 , u0_ . postcode AS postcode_107 , u0_ . qualification AS qualification_108 , u0_ . summary AS summary_109 , u0_ . deleted AS deleted_110 , u0_ . calendar_color AS calendar_color_111 , u0_ . calendar_order_number AS calendar_order_number_112 , u0_ . calendar_id AS calendar_id_113 , u0_ . position AS position_114 , u0_ . online_booking_availability AS online_booking_availability_115 , u0_ . title AS title_116 , u0_ . email_verify AS email_verify_117 , u0_ . hash_user_short_url AS hash_user_short_url_118 , u0_ . licence_number AS licence_number_119 , u0_ . stripe_customer_id AS stripe_customer_id_120 , u0_ . is_online AS is_online_121 , u0_ . last_call_time AS last_call_time_122 , u0_ . hide_report_menus AS hide_report_menus_123 , u0_ . type AS type_124 , u0_ . media_id AS media_id_125 , u0_ . device_id AS device_id_126 , u0_ . created_by_id AS created_by_id_127 , u0_ . organisation_id AS organisation_id_128 , u0_ . current_clinic_id AS current_clinic_id_129 , u0_ . parent_id AS parent_id_130 , u0_ . active_photo_id AS active_photo_id_131 , u0_ . bar_code_image_id AS bar_code_image_id_132 , u0_ . clinic_id AS clinic_id_133 , u0_ . prospect_id AS prospect_id_134 , u0_ . clinic_id AS clinic_id_135 , u0_ . i_calendar_id AS i_calendar_id_136 FROM user u0_ WHERE (u0_ . username = ? ) AND u0_ . type IN ('admin' , 'admin_support' , 'super_clinic_admin' , 'patient' , 'clinic_user' ) LIMIT 1
SELECT
u0_ . id AS id_0 ,
u0_ . username AS username_1 ,
u0_ . email AS email_2 ,
u0_ . first_name AS first_name_3 ,
u0_ . last_name AS last_name_4 ,
u0_ . full_name AS full_name_5 ,
u0_ . password AS password_6 ,
u0_ . booking_btn_name AS booking_btn_name_7 ,
u0_ . booking_btn_clr AS booking_btn_clr_8 ,
u0_ . booking_btn_bg_clr AS booking_btn_bg_clr_9 ,
u0_ . inner_color AS inner_color_10 ,
u0_ . outer_color AS outer_color_11 ,
u0_ . background_img AS background_img_12 ,
u0_ . profile_img AS profile_img_13 ,
u0_ . role AS role_14 ,
u0_ . enabled AS enabled_15 ,
u0_ . locked AS locked_16 ,
u0_ . visible AS visible_17 ,
u0_ . is_disengaged AS is_disengaged_18 ,
u0_ . otp AS otp_19 ,
u0_ . otp_sent_at AS otp_sent_at_20 ,
u0_ . last_otp_verified AS last_otp_verified_21 ,
u0_ . imap_setting AS imap_setting_22 ,
u0_ . country_code AS country_code_23 ,
u0_ . phone AS phone_24 ,
u0_ . practitioner_commission AS practitioner_commission_25 ,
u0_ . coordinator_commission AS coordinator_commission_26 ,
u0_ . course_commission AS course_commission_27 ,
u0_ . membership_commission AS membership_commission_28 ,
u0_ . product_commission AS product_commission_29 ,
u0_ . token AS token_30 ,
u0_ . access_all_calendars AS access_all_calendars_31 ,
u0_ . current_auth_token AS current_auth_token_32 ,
u0_ . last_auth_time AS last_auth_time_33 ,
u0_ . hash AS hash_34 ,
u0_ . fcm_token AS fcm_token_35 ,
u0_ . hx_change_token AS hx_change_token_36 ,
u0_ . login_from AS login_from_37 ,
u0_ . ever_login_in_v3 AS ever_login_in_v3_38 ,
u0_ . permissions AS permissions_39 ,
u0_ . clinic_id AS clinic_id_40 ,
u0_ . fp_promoter_id AS fp_promoter_id_41 ,
u0_ . referral_link AS referral_link_42 ,
u0_ . fp_tracking_id AS fp_tracking_id_43 ,
u0_ . receive_special_offer_email AS receive_special_offer_email_44 ,
u0_ . receive_special_offer_sms AS receive_special_offer_sms_45 ,
u0_ . deleted_at AS deleted_at_46 ,
u0_ . created_at AS created_at_47 ,
u0_ . updated_at AS updated_at_48 ,
u0_ . stripe_customer_id AS stripe_customer_id_49 ,
u0_ . stripe_customer_id AS stripe_customer_id_50 ,
u0_ . status AS status_51 ,
u0_ . birthday AS birthday_52 ,
u0_ . country_code_alt AS country_code_alt_53 ,
u0_ . secondary_phone AS secondary_phone_54 ,
u0_ . next_kin AS next_kin_55 ,
u0_ . next_kin_phone AS next_kin_phone_56 ,
u0_ . description AS description_57 ,
u0_ . glogau_scale AS glogau_scale_58 ,
u0_ . fitzpatrick_scale AS fitzpatrick_scale_59 ,
u0_ . gender AS gender_60 ,
u0_ . receive_special_offer_push AS receive_special_offer_push_61 ,
u0_ . receive_reminder_email AS receive_reminder_email_62 ,
u0_ . receive_reminder_sms AS receive_reminder_sms_63 ,
u0_ . receive_reminder_push AS receive_reminder_push_64 ,
u0_ . parent_user_id AS parent_user_id_65 ,
u0_ . account_type AS account_type_66 ,
u0_ . terms_accepted AS terms_accepted_67 ,
u0_ . terms_accepted_patient_mode AS terms_accepted_patient_mode_68 ,
u0_ . referral AS referral_69 ,
u0_ . export_in_progress AS export_in_progress_70 ,
u0_ . occupation AS occupation_71 ,
u0_ . number_nhs AS number_nhs_72 ,
u0_ . gp_name AS gp_name_73 ,
u0_ . contact_gp AS contact_gp_74 ,
u0_ . gp_address1 AS gp_address1_75 ,
u0_ . gp_address2 AS gp_address2_76 ,
u0_ . gp_town AS gp_town_77 ,
u0_ . gp_county AS gp_county_78 ,
u0_ . gp_post_code AS gp_post_code_79 ,
u0_ . gp_country AS gp_country_80 ,
u0_ . ref AS ref_81 ,
u0_ . chronoscan_code AS chronoscan_code_82 ,
u0_ . ethnicity AS ethnicity_83 ,
u0_ . height AS height_84 ,
u0_ . weight AS weight_85 ,
u0_ . passport AS passport_86 ,
u0_ . reference_number AS reference_number_87 ,
u0_ . photo_consent AS photo_consent_88 ,
u0_ . all_marketing AS all_marketing_89 ,
u0_ . in_clinic_marketing AS in_clinic_marketing_90 ,
u0_ . in_consultation AS in_consultation_91 ,
u0_ . interested_in AS interested_in_92 ,
u0_ . consultation_type AS consultation_type_93 ,
u0_ . google_click_id AS google_click_id_94 ,
u0_ . campaign_name AS campaign_name_95 ,
u0_ . campaign_source AS campaign_source_96 ,
u0_ . campaign_medium AS campaign_medium_97 ,
u0_ . campaign_term AS campaign_term_98 ,
u0_ . campaign_content AS campaign_content_99 ,
u0_ . marketing_source AS marketing_source_100 ,
u0_ . author AS author_101 ,
u0_ . address1 AS address1_102 ,
u0_ . address2 AS address2_103 ,
u0_ . town AS town_104 ,
u0_ . state AS state_105 ,
u0_ . country AS country_106 ,
u0_ . postcode AS postcode_107 ,
u0_ . qualification AS qualification_108 ,
u0_ . summary AS summary_109 ,
u0_ . deleted AS deleted_110 ,
u0_ . calendar_color AS calendar_color_111 ,
u0_ . calendar_order_number AS calendar_order_number_112 ,
u0_ . calendar_id AS calendar_id_113 ,
u0_ . position AS position_114 ,
u0_ . online_booking_availability AS online_booking_availability_115 ,
u0_ . title AS title_116 ,
u0_ . email_verify AS email_verify_117 ,
u0_ . hash_user_short_url AS hash_user_short_url_118 ,
u0_ . licence_number AS licence_number_119 ,
u0_ . stripe_customer_id AS stripe_customer_id_120 ,
u0_ . is_online AS is_online_121 ,
u0_ . last_call_time AS last_call_time_122 ,
u0_ . hide_report_menus AS hide_report_menus_123 ,
u0_ . type AS type_124 ,
u0_ . media_id AS media_id_125 ,
u0_ . device_id AS device_id_126 ,
u0_ . created_by_id AS created_by_id_127 ,
u0_ . organisation_id AS organisation_id_128 ,
u0_ . current_clinic_id AS current_clinic_id_129 ,
u0_ . parent_id AS parent_id_130 ,
u0_ . active_photo_id AS active_photo_id_131 ,
u0_ . bar_code_image_id AS bar_code_image_id_132 ,
u0_ . clinic_id AS clinic_id_133 ,
u0_ . prospect_id AS prospect_id_134 ,
u0_ . clinic_id AS clinic_id_135 ,
u0_ . i_calendar_id AS i_calendar_id_136
FROM
user u0_
WHERE
(u0_ . username = ? )
AND u0_ . type IN (
'admin' , 'admin_support' , 'super_clinic_admin' ,
'patient' , 'clinic_user'
)
LIMIT
1 Copy
SELECT u0_ . id AS id_0 , u0_ . username AS username_1 , u0_ . email AS email_2 , u0_ . first_name AS first_name_3 , u0_ . last_name AS last_name_4 , u0_ . full_name AS full_name_5 , u0_ . password AS password_6 , u0_ . booking_btn_name AS booking_btn_name_7 , u0_ . booking_btn_clr AS booking_btn_clr_8 , u0_ . booking_btn_bg_clr AS booking_btn_bg_clr_9 , u0_ . inner_color AS inner_color_10 , u0_ . outer_color AS outer_color_11 , u0_ . background_img AS background_img_12 , u0_ . profile_img AS profile_img_13 , u0_ . role AS role_14 , u0_ . enabled AS enabled_15 , u0_ . locked AS locked_16 , u0_ . visible AS visible_17 , u0_ . is_disengaged AS is_disengaged_18 , u0_ . otp AS otp_19 , u0_ . otp_sent_at AS otp_sent_at_20 , u0_ . last_otp_verified AS last_otp_verified_21 , u0_ . imap_setting AS imap_setting_22 , u0_ . country_code AS country_code_23 , u0_ . phone AS phone_24 , u0_ . practitioner_commission AS practitioner_commission_25 , u0_ . coordinator_commission AS coordinator_commission_26 , u0_ . course_commission AS course_commission_27 , u0_ . membership_commission AS membership_commission_28 , u0_ . product_commission AS product_commission_29 , u0_ . token AS token_30 , u0_ . access_all_calendars AS access_all_calendars_31 , u0_ . current_auth_token AS current_auth_token_32 , u0_ . last_auth_time AS last_auth_time_33 , u0_ . hash AS hash_34 , u0_ . fcm_token AS fcm_token_35 , u0_ . hx_change_token AS hx_change_token_36 , u0_ . login_from AS login_from_37 , u0_ . ever_login_in_v3 AS ever_login_in_v3_38 , u0_ . permissions AS permissions_39 , u0_ . clinic_id AS clinic_id_40 , u0_ . fp_promoter_id AS fp_promoter_id_41 , u0_ . referral_link AS referral_link_42 , u0_ . fp_tracking_id AS fp_tracking_id_43 , u0_ . receive_special_offer_email AS receive_special_offer_email_44 , u0_ . receive_special_offer_sms AS receive_special_offer_sms_45 , u0_ . deleted_at AS deleted_at_46 , u0_ . created_at AS created_at_47 , u0_ . updated_at AS updated_at_48 , u0_ . stripe_customer_id AS stripe_customer_id_49 , u0_ . stripe_customer_id AS stripe_customer_id_50 , u0_ . status AS status_51 , u0_ . birthday AS birthday_52 , u0_ . country_code_alt AS country_code_alt_53 , u0_ . secondary_phone AS secondary_phone_54 , u0_ . next_kin AS next_kin_55 , u0_ . next_kin_phone AS next_kin_phone_56 , u0_ . description AS description_57 , u0_ . glogau_scale AS glogau_scale_58 , u0_ . fitzpatrick_scale AS fitzpatrick_scale_59 , u0_ . gender AS gender_60 , u0_ . receive_special_offer_push AS receive_special_offer_push_61 , u0_ . receive_reminder_email AS receive_reminder_email_62 , u0_ . receive_reminder_sms AS receive_reminder_sms_63 , u0_ . receive_reminder_push AS receive_reminder_push_64 , u0_ . parent_user_id AS parent_user_id_65 , u0_ . account_type AS account_type_66 , u0_ . terms_accepted AS terms_accepted_67 , u0_ . terms_accepted_patient_mode AS terms_accepted_patient_mode_68 , u0_ . referral AS referral_69 , u0_ . export_in_progress AS export_in_progress_70 , u0_ . occupation AS occupation_71 , u0_ . number_nhs AS number_nhs_72 , u0_ . gp_name AS gp_name_73 , u0_ . contact_gp AS contact_gp_74 , u0_ . gp_address1 AS gp_address1_75 , u0_ . gp_address2 AS gp_address2_76 , u0_ . gp_town AS gp_town_77 , u0_ . gp_county AS gp_county_78 , u0_ . gp_post_code AS gp_post_code_79 , u0_ . gp_country AS gp_country_80 , u0_ . ref AS ref_81 , u0_ . chronoscan_code AS chronoscan_code_82 , u0_ . ethnicity AS ethnicity_83 , u0_ . height AS height_84 , u0_ . weight AS weight_85 , u0_ . passport AS passport_86 , u0_ . reference_number AS reference_number_87 , u0_ . photo_consent AS photo_consent_88 , u0_ . all_marketing AS all_marketing_89 , u0_ . in_clinic_marketing AS in_clinic_marketing_90 , u0_ . in_consultation AS in_consultation_91 , u0_ . interested_in AS interested_in_92 , u0_ . consultation_type AS consultation_type_93 , u0_ . google_click_id AS google_click_id_94 , u0_ . campaign_name AS campaign_name_95 , u0_ . campaign_source AS campaign_source_96 , u0_ . campaign_medium AS campaign_medium_97 , u0_ . campaign_term AS campaign_term_98 , u0_ . campaign_content AS campaign_content_99 , u0_ . marketing_source AS marketing_source_100 , u0_ . author AS author_101 , u0_ . address1 AS address1_102 , u0_ . address2 AS address2_103 , u0_ . town AS town_104 , u0_ . state AS state_105 , u0_ . country AS country_106 , u0_ . postcode AS postcode_107 , u0_ . qualification AS qualification_108 , u0_ . summary AS summary_109 , u0_ . deleted AS deleted_110 , u0_ . calendar_color AS calendar_color_111 , u0_ . calendar_order_number AS calendar_order_number_112 , u0_ . calendar_id AS calendar_id_113 , u0_ . position AS position_114 , u0_ . online_booking_availability AS online_booking_availability_115 , u0_ . title AS title_116 , u0_ . email_verify AS email_verify_117 , u0_ . hash_user_short_url AS hash_user_short_url_118 , u0_ . licence_number AS licence_number_119 , u0_ . stripe_customer_id AS stripe_customer_id_120 , u0_ . is_online AS is_online_121 , u0_ . last_call_time AS last_call_time_122 , u0_ . hide_report_menus AS hide_report_menus_123 , u0_ . type AS type_124 , u0_ . media_id AS media_id_125 , u0_ . device_id AS device_id_126 , u0_ . created_by_id AS created_by_id_127 , u0_ . organisation_id AS organisation_id_128 , u0_ . current_clinic_id AS current_clinic_id_129 , u0_ . parent_id AS parent_id_130 , u0_ . active_photo_id AS active_photo_id_131 , u0_ . bar_code_image_id AS bar_code_image_id_132 , u0_ . clinic_id AS clinic_id_133 , u0_ . prospect_id AS prospect_id_134 , u0_ . clinic_id AS clinic_id_135 , u0_ . i_calendar_id AS i_calendar_id_136 FROM user u0_ WHERE (u0_ . username = 'demo' ) AND u0_ . type IN ('admin' , 'admin_support' , 'super_clinic_admin' , 'patient' , 'clinic_user' ) LIMIT 1 ; Copy
8
24.50 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 . background_img AS background_img_15 , t0 . profile_img AS profile_img_16 , t0 . meeting_price AS meeting_price_17 , t0 . meeting_price_type AS meeting_price_type_18 , t0 . show_in_public_profile AS show_in_public_profile_19 , t0 . patient_ref_prefix AS patient_ref_prefix_20 , t0 . email AS email_21 , t0 . verified_email AS verified_email_22 , t0 . web_site AS web_site_23 , t0 . phone AS phone_24 , t0 . contact_name AS contact_name_25 , t0 . description AS description_26 , t0 . widget_settings AS widget_settings_27 , t0 . sms_number AS sms_number_28 , t0 . sms_status AS sms_status_29 , t0 . timezone AS timezone_30 , t0 . reminder_header AS reminder_header_31 , t0 . reminder_footer AS reminder_footer_32 , t0 . reminder_recall_text AS reminder_recall_text_33 , t0 . google_token AS google_token_34 , t0 . google_id AS google_id_35 , t0 . topic_arn AS topic_arn_36 , t0 . pm_pin AS pm_pin_37 , t0 . auto_email_reply_address AS auto_email_reply_address_38 , t0 . pm_patient_message AS pm_patient_message_39 , t0 . pm_clinic_intro AS pm_clinic_intro_40 , t0 . auto_renew_subscription AS auto_renew_subscription_41 , t0 . subscription_expiry AS subscription_expiry_42 , t0 . email_reminder AS email_reminder_43 , t0 . email_new AS email_new_44 , t0 . sms_new AS sms_new_45 , t0 . sms_reminder AS sms_reminder_46 , t0 . when_answered_hide_where_did_you_hear_about_us AS when_answered_hide_where_did_you_hear_about_us_47 , t0 . calendar_start_day AS calendar_start_day_48 , t0 . calendar_end_day AS calendar_end_day_49 , t0 . appointment_default_time AS appointment_default_time_50 , t0 . appointment_slot_duration AS appointment_slot_duration_51 , t0 . appointment_default_view AS appointment_default_view_52 , t0 . private_mode_calendar AS private_mode_calendar_53 , t0 . clinic_representative AS clinic_representative_54 , t0 . data_protection_officer AS data_protection_officer_55 , t0 . company_registration_number AS company_registration_number_56 , t0 . email_to_withdraw AS email_to_withdraw_57 , t0 . period_stored_data AS period_stored_data_58 , t0 . survey_email_text AS survey_email_text_59 , t0 . post_apt_form_email_text AS post_apt_form_email_text_60 , t0 . export_in_progress AS export_in_progress_61 , t0 . vat_number AS vat_number_62 , t0 . enabled_vat AS enabled_vat_63 , t0 . patient_list_display_pair AS patient_list_display_pair_64 , t0 . stripe_refresh_token AS stripe_refresh_token_65 , t0 . stripe_publishable_key AS stripe_publishable_key_66 , t0 . stripe_account_id AS stripe_account_id_67 , t0 . shared_all_patients AS shared_all_patients_68 , t0 . currency AS currency_69 , t0 . patient_info_to_document_header AS patient_info_to_document_header_70 , t0 . t_and_c AS t_and_c_71 , t0 . declaration AS declaration_72 , t0 . treatment_plan_tand_c AS treatment_plan_tand_c_73 , t0 . traffic_light AS traffic_light_74 , t0 . booking_required_fields AS booking_required_fields_75 , t0 . double_booking AS double_booking_76 , t0 . required_confirmation AS required_confirmation_77 , t0 . fixed_discount_amount AS fixed_discount_amount_78 , t0 . required_questionnaires AS required_questionnaires_79 , t0 . patient_required_fields AS patient_required_fields_80 , t0 . prospect_required_fields AS prospect_required_fields_81 , t0 . enabled_postcode AS enabled_postcode_82 , t0 . enabled_chronoscan AS enabled_chronoscan_83 , t0 . postcode_api_key AS postcode_api_key_84 , t0 . enabled_prospect_web_form AS enabled_prospect_web_form_85 , t0 . payment_sense AS payment_sense_86 , t0 . xero_tenant_id AS xero_tenant_id_87 , t0 . reduce_stock AS reduce_stock_88 , t0 . patient_questionnaire AS patient_questionnaire_89 , t0 . xero_bank_account AS xero_bank_account_90 , t0 . is_new_clinic AS is_new_clinic_91 , t0 . marketing_expert AS marketing_expert_92 , t0 . clinic_survey_email_text AS clinic_survey_email_text_93 , t0 . trial_end_date AS trial_end_date_94 , t0 . shared_patient_date AS shared_patient_date_95 , t0 . feature_custom_website_amount AS feature_custom_website_amount_96 , t0 . feature_ad_amount AS feature_ad_amount_97 , t0 . feature_message_amount AS feature_message_amount_98 , t0 . feature_template_amount AS feature_template_amount_99 , t0 . is_template_user_only AS is_template_user_only_100 , t0 . new_user AS new_user_101 , t0 . template_subscription_end_date AS template_subscription_end_date_102 , t0 . onboarding_status AS onboarding_status_103 , t0 . address1 AS address1_104 , t0 . address2 AS address2_105 , t0 . town AS town_106 , t0 . state AS state_107 , t0 . country AS country_108 , t0 . postcode AS postcode_109 , t0 . created_at AS created_at_110 , t0 . updated_at AS updated_at_111 , t0 . logo_id AS logo_id_112 , t113 . id AS id_114 , t113 . s3key AS s3key_115 , t113 . name_file AS name_file_116 , t113 . url AS url_117 , t113 . type AS type_118 , t113 . created_at AS created_at_119 , t113 . updated_at AS updated_at_120 , t0 . background_id AS background_id_121 , t122 . id AS id_123 , t122 . s3key AS s3key_124 , t122 . name_file AS name_file_125 , t122 . url AS url_126 , t122 . type AS type_127 , t122 . created_at AS created_at_128 , t122 . updated_at AS updated_at_129 , t130 . id AS id_131 , t130 . creditor AS creditor_132 , t130 . mandate AS mandate_133 , t130 . customer AS customer_134 , t130 . customer_bank_account AS customer_bank_account_135 , t130 . created_at AS created_at_136 , t130 . updated_at AS updated_at_137 , t130 . clinic_id AS clinic_id_138 , t139 . id AS id_140 , t139 . sid AS sid_141 , t139 . token AS token_142 , t139 . number_from AS number_from_143 , t139 . clinic_id AS clinic_id_144 , t0 . organisation_id AS organisation_id_145 , t146 . id AS id_147 , t146 . enabled AS enabled_148 , t146 . time_required_for_booking AS time_required_for_booking_149 , t146 . time_required_for_cancellation AS time_required_for_cancellation_150 , t146 . take_payment_for_new_patients AS take_payment_for_new_patients_151 , t146 . take_payment_for_existing_patients AS take_payment_for_existing_patients_152 , t146 . type AS type_153 , t146 . hide_full_price AS hide_full_price_154 , t146 . terms AS terms_155 , t146 . clinic_id AS clinic_id_156 , t157 . id AS id_158 , t157 . server AS server_159 , t157 . file_location AS file_location_160 , t157 . username AS username_161 , t157 . password AS password_162 , t157 . email AS email_163 , t157 . clinic_id AS clinic_id_164 , t165 . id AS id_166 , t165 . theme AS theme_167 , t165 . max_embed_width AS max_embed_width_168 , t165 . primary_interface_colour AS primary_interface_colour_169 , t165 . secondary_interface_colour AS secondary_interface_colour_170 , t165 . primary_font_colour AS primary_font_colour_171 , t165 . secondary_font_colour AS secondary_font_colour_172 , t165 . background_colour AS background_colour_173 , t165 . widget_hash AS widget_hash_174 , t165 . created_at AS created_at_175 , t165 . updated_at AS updated_at_176 , t165 . clinic_id AS clinic_id_177 , t165 . custom_css_id AS custom_css_id_178 , t179 . id AS id_180 , t179 . confirmation_text AS confirmation_text_181 , t179 . treatment_info AS treatment_info_182 , t179 . clinic_id AS clinic_id_183 , t184 . id AS id_185 , t184 . api_key AS api_key_186 , t184 . list_id AS list_id_187 , t184 . sync AS sync_188 , t184 . sync_date AS sync_date_189 , t184 . pro AS pro_190 , t184 . created_at AS created_at_191 , t184 . updated_at AS updated_at_192 , t184 . clinic_id AS clinic_id_193 , t0 . promo_code_id AS promo_code_id_194 , t0 . price_tier_id AS price_tier_id_195 , t0 . xero_sync_job_id AS xero_sync_job_id_196 FROM clinics t0 LEFT JOIN media t113 ON t0 . logo_id = t113 . id LEFT JOIN media t122 ON t0 . background_id = t122 . id LEFT JOIN gocardless_customer t130 ON t130 . clinic_id = t0 . id LEFT JOIN twilio t139 ON t139 . clinic_id = t0 . id LEFT JOIN setting_online_booking t146 ON t146 . clinic_id = t0 . id LEFT JOIN setting_chronoscan t157 ON t157 . clinic_id = t0 . id LEFT JOIN widget_online_booking t165 ON t165 . clinic_id = t0 . id LEFT JOIN email_setting_online_booking t179 ON t179 . clinic_id = t0 . id LEFT JOIN mail_chimp_config t184 ON t184 . clinic_id = t0 . id WHERE t0 . organisation_id = ?
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 . background_img AS background_img_15 ,
t0 . profile_img AS profile_img_16 ,
t0 . meeting_price AS meeting_price_17 ,
t0 . meeting_price_type AS meeting_price_type_18 ,
t0 . show_in_public_profile AS show_in_public_profile_19 ,
t0 . patient_ref_prefix AS patient_ref_prefix_20 ,
t0 . email AS email_21 ,
t0 . verified_email AS verified_email_22 ,
t0 . web_site AS web_site_23 ,
t0 . phone AS phone_24 ,
t0 . contact_name AS contact_name_25 ,
t0 . description AS description_26 ,
t0 . widget_settings AS widget_settings_27 ,
t0 . sms_number AS sms_number_28 ,
t0 . sms_status AS sms_status_29 ,
t0 . timezone AS timezone_30 ,
t0 . reminder_header AS reminder_header_31 ,
t0 . reminder_footer AS reminder_footer_32 ,
t0 . reminder_recall_text AS reminder_recall_text_33 ,
t0 . google_token AS google_token_34 ,
t0 . google_id AS google_id_35 ,
t0 . topic_arn AS topic_arn_36 ,
t0 . pm_pin AS pm_pin_37 ,
t0 . auto_email_reply_address AS auto_email_reply_address_38 ,
t0 . pm_patient_message AS pm_patient_message_39 ,
t0 . pm_clinic_intro AS pm_clinic_intro_40 ,
t0 . auto_renew_subscription AS auto_renew_subscription_41 ,
t0 . subscription_expiry AS subscription_expiry_42 ,
t0 . email_reminder AS email_reminder_43 ,
t0 . email_new AS email_new_44 ,
t0 . sms_new AS sms_new_45 ,
t0 . sms_reminder AS sms_reminder_46 ,
t0 . when_answered_hide_where_did_you_hear_about_us AS when_answered_hide_where_did_you_hear_about_us_47 ,
t0 . calendar_start_day AS calendar_start_day_48 ,
t0 . calendar_end_day AS calendar_end_day_49 ,
t0 . appointment_default_time AS appointment_default_time_50 ,
t0 . appointment_slot_duration AS appointment_slot_duration_51 ,
t0 . appointment_default_view AS appointment_default_view_52 ,
t0 . private_mode_calendar AS private_mode_calendar_53 ,
t0 . clinic_representative AS clinic_representative_54 ,
t0 . data_protection_officer AS data_protection_officer_55 ,
t0 . company_registration_number AS company_registration_number_56 ,
t0 . email_to_withdraw AS email_to_withdraw_57 ,
t0 . period_stored_data AS period_stored_data_58 ,
t0 . survey_email_text AS survey_email_text_59 ,
t0 . post_apt_form_email_text AS post_apt_form_email_text_60 ,
t0 . export_in_progress AS export_in_progress_61 ,
t0 . vat_number AS vat_number_62 ,
t0 . enabled_vat AS enabled_vat_63 ,
t0 . patient_list_display_pair AS patient_list_display_pair_64 ,
t0 . stripe_refresh_token AS stripe_refresh_token_65 ,
t0 . stripe_publishable_key AS stripe_publishable_key_66 ,
t0 . stripe_account_id AS stripe_account_id_67 ,
t0 . shared_all_patients AS shared_all_patients_68 ,
t0 . currency AS currency_69 ,
t0 . patient_info_to_document_header AS patient_info_to_document_header_70 ,
t0 . t_and_c AS t_and_c_71 ,
t0 . declaration AS declaration_72 ,
t0 . treatment_plan_tand_c AS treatment_plan_tand_c_73 ,
t0 . traffic_light AS traffic_light_74 ,
t0 . booking_required_fields AS booking_required_fields_75 ,
t0 . double_booking AS double_booking_76 ,
t0 . required_confirmation AS required_confirmation_77 ,
t0 . fixed_discount_amount AS fixed_discount_amount_78 ,
t0 . required_questionnaires AS required_questionnaires_79 ,
t0 . patient_required_fields AS patient_required_fields_80 ,
t0 . prospect_required_fields AS prospect_required_fields_81 ,
t0 . enabled_postcode AS enabled_postcode_82 ,
t0 . enabled_chronoscan AS enabled_chronoscan_83 ,
t0 . postcode_api_key AS postcode_api_key_84 ,
t0 . enabled_prospect_web_form AS enabled_prospect_web_form_85 ,
t0 . payment_sense AS payment_sense_86 ,
t0 . xero_tenant_id AS xero_tenant_id_87 ,
t0 . reduce_stock AS reduce_stock_88 ,
t0 . patient_questionnaire AS patient_questionnaire_89 ,
t0 . xero_bank_account AS xero_bank_account_90 ,
t0 . is_new_clinic AS is_new_clinic_91 ,
t0 . marketing_expert AS marketing_expert_92 ,
t0 . clinic_survey_email_text AS clinic_survey_email_text_93 ,
t0 . trial_end_date AS trial_end_date_94 ,
t0 . shared_patient_date AS shared_patient_date_95 ,
t0 . feature_custom_website_amount AS feature_custom_website_amount_96 ,
t0 . feature_ad_amount AS feature_ad_amount_97 ,
t0 . feature_message_amount AS feature_message_amount_98 ,
t0 . feature_template_amount AS feature_template_amount_99 ,
t0 . is_template_user_only AS is_template_user_only_100 ,
t0 . new_user AS new_user_101 ,
t0 . template_subscription_end_date AS template_subscription_end_date_102 ,
t0 . onboarding_status AS onboarding_status_103 ,
t0 . address1 AS address1_104 ,
t0 . address2 AS address2_105 ,
t0 . town AS town_106 ,
t0 . state AS state_107 ,
t0 . country AS country_108 ,
t0 . postcode AS postcode_109 ,
t0 . created_at AS created_at_110 ,
t0 . updated_at AS updated_at_111 ,
t0 . logo_id AS logo_id_112 ,
t113 . id AS id_114 ,
t113 . s3key AS s3key_115 ,
t113 . name_file AS name_file_116 ,
t113 . url AS url_117 ,
t113 . type AS type_118 ,
t113 . created_at AS created_at_119 ,
t113 . updated_at AS updated_at_120 ,
t0 . background_id AS background_id_121 ,
t122 . id AS id_123 ,
t122 . s3key AS s3key_124 ,
t122 . name_file AS name_file_125 ,
t122 . url AS url_126 ,
t122 . type AS type_127 ,
t122 . created_at AS created_at_128 ,
t122 . updated_at AS updated_at_129 ,
t130 . id AS id_131 ,
t130 . creditor AS creditor_132 ,
t130 . mandate AS mandate_133 ,
t130 . customer AS customer_134 ,
t130 . customer_bank_account AS customer_bank_account_135 ,
t130 . created_at AS created_at_136 ,
t130 . updated_at AS updated_at_137 ,
t130 . clinic_id AS clinic_id_138 ,
t139 . id AS id_140 ,
t139 . sid AS sid_141 ,
t139 . token AS token_142 ,
t139 . number_from AS number_from_143 ,
t139 . clinic_id AS clinic_id_144 ,
t0 . organisation_id AS organisation_id_145 ,
t146 . id AS id_147 ,
t146 . enabled AS enabled_148 ,
t146 . time_required_for_booking AS time_required_for_booking_149 ,
t146 . time_required_for_cancellation AS time_required_for_cancellation_150 ,
t146 . take_payment_for_new_patients AS take_payment_for_new_patients_151 ,
t146 . take_payment_for_existing_patients AS take_payment_for_existing_patients_152 ,
t146 . type AS type_153 ,
t146 . hide_full_price AS hide_full_price_154 ,
t146 . terms AS terms_155 ,
t146 . clinic_id AS clinic_id_156 ,
t157 . id AS id_158 ,
t157 . server AS server_159 ,
t157 . file_location AS file_location_160 ,
t157 . username AS username_161 ,
t157 . password AS password_162 ,
t157 . email AS email_163 ,
t157 . clinic_id AS clinic_id_164 ,
t165 . id AS id_166 ,
t165 . theme AS theme_167 ,
t165 . max_embed_width AS max_embed_width_168 ,
t165 . primary_interface_colour AS primary_interface_colour_169 ,
t165 . secondary_interface_colour AS secondary_interface_colour_170 ,
t165 . primary_font_colour AS primary_font_colour_171 ,
t165 . secondary_font_colour AS secondary_font_colour_172 ,
t165 . background_colour AS background_colour_173 ,
t165 . widget_hash AS widget_hash_174 ,
t165 . created_at AS created_at_175 ,
t165 . updated_at AS updated_at_176 ,
t165 . clinic_id AS clinic_id_177 ,
t165 . custom_css_id AS custom_css_id_178 ,
t179 . id AS id_180 ,
t179 . confirmation_text AS confirmation_text_181 ,
t179 . treatment_info AS treatment_info_182 ,
t179 . clinic_id AS clinic_id_183 ,
t184 . id AS id_185 ,
t184 . api_key AS api_key_186 ,
t184 . list_id AS list_id_187 ,
t184 . sync AS sync_188 ,
t184 . sync_date AS sync_date_189 ,
t184 . pro AS pro_190 ,
t184 . created_at AS created_at_191 ,
t184 . updated_at AS updated_at_192 ,
t184 . clinic_id AS clinic_id_193 ,
t0 . promo_code_id AS promo_code_id_194 ,
t0 . price_tier_id AS price_tier_id_195 ,
t0 . xero_sync_job_id AS xero_sync_job_id_196
FROM
clinics t0
LEFT JOIN media t113 ON t0 . logo_id = t113 . id
LEFT JOIN media t122 ON t0 . background_id = t122 . id
LEFT JOIN gocardless_customer t130 ON t130 . clinic_id = t0 . id
LEFT JOIN twilio t139 ON t139 . clinic_id = t0 . id
LEFT JOIN setting_online_booking t146 ON t146 . clinic_id = t0 . id
LEFT JOIN setting_chronoscan t157 ON t157 . clinic_id = t0 . id
LEFT JOIN widget_online_booking t165 ON t165 . clinic_id = t0 . id
LEFT JOIN email_setting_online_booking t179 ON t179 . clinic_id = t0 . id
LEFT JOIN mail_chimp_config t184 ON t184 . clinic_id = t0 . id
WHERE
t0 . organisation_id = ? Copy
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 . background_img AS background_img_15 , t0 . profile_img AS profile_img_16 , t0 . meeting_price AS meeting_price_17 , t0 . meeting_price_type AS meeting_price_type_18 , t0 . show_in_public_profile AS show_in_public_profile_19 , t0 . patient_ref_prefix AS patient_ref_prefix_20 , t0 . email AS email_21 , t0 . verified_email AS verified_email_22 , t0 . web_site AS web_site_23 , t0 . phone AS phone_24 , t0 . contact_name AS contact_name_25 , t0 . description AS description_26 , t0 . widget_settings AS widget_settings_27 , t0 . sms_number AS sms_number_28 , t0 . sms_status AS sms_status_29 , t0 . timezone AS timezone_30 , t0 . reminder_header AS reminder_header_31 , t0 . reminder_footer AS reminder_footer_32 , t0 . reminder_recall_text AS reminder_recall_text_33 , t0 . google_token AS google_token_34 , t0 . google_id AS google_id_35 , t0 . topic_arn AS topic_arn_36 , t0 . pm_pin AS pm_pin_37 , t0 . auto_email_reply_address AS auto_email_reply_address_38 , t0 . pm_patient_message AS pm_patient_message_39 , t0 . pm_clinic_intro AS pm_clinic_intro_40 , t0 . auto_renew_subscription AS auto_renew_subscription_41 , t0 . subscription_expiry AS subscription_expiry_42 , t0 . email_reminder AS email_reminder_43 , t0 . email_new AS email_new_44 , t0 . sms_new AS sms_new_45 , t0 . sms_reminder AS sms_reminder_46 , t0 . when_answered_hide_where_did_you_hear_about_us AS when_answered_hide_where_did_you_hear_about_us_47 , t0 . calendar_start_day AS calendar_start_day_48 , t0 . calendar_end_day AS calendar_end_day_49 , t0 . appointment_default_time AS appointment_default_time_50 , t0 . appointment_slot_duration AS appointment_slot_duration_51 , t0 . appointment_default_view AS appointment_default_view_52 , t0 . private_mode_calendar AS private_mode_calendar_53 , t0 . clinic_representative AS clinic_representative_54 , t0 . data_protection_officer AS data_protection_officer_55 , t0 . company_registration_number AS company_registration_number_56 , t0 . email_to_withdraw AS email_to_withdraw_57 , t0 . period_stored_data AS period_stored_data_58 , t0 . survey_email_text AS survey_email_text_59 , t0 . post_apt_form_email_text AS post_apt_form_email_text_60 , t0 . export_in_progress AS export_in_progress_61 , t0 . vat_number AS vat_number_62 , t0 . enabled_vat AS enabled_vat_63 , t0 . patient_list_display_pair AS patient_list_display_pair_64 , t0 . stripe_refresh_token AS stripe_refresh_token_65 , t0 . stripe_publishable_key AS stripe_publishable_key_66 , t0 . stripe_account_id AS stripe_account_id_67 , t0 . shared_all_patients AS shared_all_patients_68 , t0 . currency AS currency_69 , t0 . patient_info_to_document_header AS patient_info_to_document_header_70 , t0 . t_and_c AS t_and_c_71 , t0 . declaration AS declaration_72 , t0 . treatment_plan_tand_c AS treatment_plan_tand_c_73 , t0 . traffic_light AS traffic_light_74 , t0 . booking_required_fields AS booking_required_fields_75 , t0 . double_booking AS double_booking_76 , t0 . required_confirmation AS required_confirmation_77 , t0 . fixed_discount_amount AS fixed_discount_amount_78 , t0 . required_questionnaires AS required_questionnaires_79 , t0 . patient_required_fields AS patient_required_fields_80 , t0 . prospect_required_fields AS prospect_required_fields_81 , t0 . enabled_postcode AS enabled_postcode_82 , t0 . enabled_chronoscan AS enabled_chronoscan_83 , t0 . postcode_api_key AS postcode_api_key_84 , t0 . enabled_prospect_web_form AS enabled_prospect_web_form_85 , t0 . payment_sense AS payment_sense_86 , t0 . xero_tenant_id AS xero_tenant_id_87 , t0 . reduce_stock AS reduce_stock_88 , t0 . patient_questionnaire AS patient_questionnaire_89 , t0 . xero_bank_account AS xero_bank_account_90 , t0 . is_new_clinic AS is_new_clinic_91 , t0 . marketing_expert AS marketing_expert_92 , t0 . clinic_survey_email_text AS clinic_survey_email_text_93 , t0 . trial_end_date AS trial_end_date_94 , t0 . shared_patient_date AS shared_patient_date_95 , t0 . feature_custom_website_amount AS feature_custom_website_amount_96 , t0 . feature_ad_amount AS feature_ad_amount_97 , t0 . feature_message_amount AS feature_message_amount_98 , t0 . feature_template_amount AS feature_template_amount_99 , t0 . is_template_user_only AS is_template_user_only_100 , t0 . new_user AS new_user_101 , t0 . template_subscription_end_date AS template_subscription_end_date_102 , t0 . onboarding_status AS onboarding_status_103 , t0 . address1 AS address1_104 , t0 . address2 AS address2_105 , t0 . town AS town_106 , t0 . state AS state_107 , t0 . country AS country_108 , t0 . postcode AS postcode_109 , t0 . created_at AS created_at_110 , t0 . updated_at AS updated_at_111 , t0 . logo_id AS logo_id_112 , t113 . id AS id_114 , t113 . s3key AS s3key_115 , t113 . name_file AS name_file_116 , t113 . url AS url_117 , t113 . type AS type_118 , t113 . created_at AS created_at_119 , t113 . updated_at AS updated_at_120 , t0 . background_id AS background_id_121 , t122 . id AS id_123 , t122 . s3key AS s3key_124 , t122 . name_file AS name_file_125 , t122 . url AS url_126 , t122 . type AS type_127 , t122 . created_at AS created_at_128 , t122 . updated_at AS updated_at_129 , t130 . id AS id_131 , t130 . creditor AS creditor_132 , t130 . mandate AS mandate_133 , t130 . customer AS customer_134 , t130 . customer_bank_account AS customer_bank_account_135 , t130 . created_at AS created_at_136 , t130 . updated_at AS updated_at_137 , t130 . clinic_id AS clinic_id_138 , t139 . id AS id_140 , t139 . sid AS sid_141 , t139 . token AS token_142 , t139 . number_from AS number_from_143 , t139 . clinic_id AS clinic_id_144 , t0 . organisation_id AS organisation_id_145 , t146 . id AS id_147 , t146 . enabled AS enabled_148 , t146 . time_required_for_booking AS time_required_for_booking_149 , t146 . time_required_for_cancellation AS time_required_for_cancellation_150 , t146 . take_payment_for_new_patients AS take_payment_for_new_patients_151 , t146 . take_payment_for_existing_patients AS take_payment_for_existing_patients_152 , t146 . type AS type_153 , t146 . hide_full_price AS hide_full_price_154 , t146 . terms AS terms_155 , t146 . clinic_id AS clinic_id_156 , t157 . id AS id_158 , t157 . server AS server_159 , t157 . file_location AS file_location_160 , t157 . username AS username_161 , t157 . password AS password_162 , t157 . email AS email_163 , t157 . clinic_id AS clinic_id_164 , t165 . id AS id_166 , t165 . theme AS theme_167 , t165 . max_embed_width AS max_embed_width_168 , t165 . primary_interface_colour AS primary_interface_colour_169 , t165 . secondary_interface_colour AS secondary_interface_colour_170 , t165 . primary_font_colour AS primary_font_colour_171 , t165 . secondary_font_colour AS secondary_font_colour_172 , t165 . background_colour AS background_colour_173 , t165 . widget_hash AS widget_hash_174 , t165 . created_at AS created_at_175 , t165 . updated_at AS updated_at_176 , t165 . clinic_id AS clinic_id_177 , t165 . custom_css_id AS custom_css_id_178 , t179 . id AS id_180 , t179 . confirmation_text AS confirmation_text_181 , t179 . treatment_info AS treatment_info_182 , t179 . clinic_id AS clinic_id_183 , t184 . id AS id_185 , t184 . api_key AS api_key_186 , t184 . list_id AS list_id_187 , t184 . sync AS sync_188 , t184 . sync_date AS sync_date_189 , t184 . pro AS pro_190 , t184 . created_at AS created_at_191 , t184 . updated_at AS updated_at_192 , t184 . clinic_id AS clinic_id_193 , t0 . promo_code_id AS promo_code_id_194 , t0 . price_tier_id AS price_tier_id_195 , t0 . xero_sync_job_id AS xero_sync_job_id_196 FROM clinics t0 LEFT JOIN media t113 ON t0 . logo_id = t113 . id LEFT JOIN media t122 ON t0 . background_id = t122 . id LEFT JOIN gocardless_customer t130 ON t130 . clinic_id = t0 . id LEFT JOIN twilio t139 ON t139 . clinic_id = t0 . id LEFT JOIN setting_online_booking t146 ON t146 . clinic_id = t0 . id LEFT JOIN setting_chronoscan t157 ON t157 . clinic_id = t0 . id LEFT JOIN widget_online_booking t165 ON t165 . clinic_id = t0 . id LEFT JOIN email_setting_online_booking t179 ON t179 . clinic_id = t0 . id LEFT JOIN mail_chimp_config t184 ON t184 . clinic_id = t0 . id WHERE t0 . organisation_id = 3 ; Copy