| 1 |
0.62 ms |
SELECT t0.id AS id_1, t0.actief AS actief_2, t0.show_profile_photo AS show_profile_photo_3, t0.is_active AS is_active_4, t0.personalized_fin_plan AS personalized_fin_plan_5, t0.api_key AS api_key_6, t0.is_expert_complete AS is_expert_complete_7, t0.is_expert_send AS is_expert_send_8, t0.created_date AS created_date_9, t0.demo_warning AS demo_warning_10, t0.receive_financier_email AS receive_financier_email_11, t0.organisatie_id AS organisatie_id_12, t0.rol_id AS rol_id_13, t0.user_id AS user_id_14 FROM 00_client t0 WHERE t0.id = ? LIMIT 1
SELECT t0.id AS id_1, t0.actief AS actief_2, t0.show_profile_photo AS show_profile_photo_3, t0.is_active AS is_active_4, t0.personalized_fin_plan AS personalized_fin_plan_5, t0.api_key AS api_key_6, t0.is_expert_complete AS is_expert_complete_7, t0.is_expert_send AS is_expert_send_8, t0.created_date AS created_date_9, t0.demo_warning AS demo_warning_10, t0.receive_financier_email AS receive_financier_email_11, t0.organisatie_id AS organisatie_id_12, t0.rol_id AS rol_id_13, t0.user_id AS user_id_14 FROM 00_client t0 WHERE t0.id = 0 LIMIT 1;
|
| 2 |
1.51 ms |
SELECT t0.id AS id_1, t0.naam AS naam_2, t0.aangemaakt AS aangemaakt_3, t0.laatste_update AS laatste_update_4, t0.is_deleted AS is_deleted_5, t0.is_demo AS is_demo_6, t0.is_ignored AS is_ignored_7, t0.is_test AS is_test_8, t0.is_ondernemer_aanvraag AS is_ondernemer_aanvraag_9, t0.status_cat_id AS status_cat_id_10, t0.status_modified_at AS status_modified_at_11, t0.request_type_id AS request_type_id_12, t0.closed_reason_id AS closed_reason_id_13, t0.stopped_reason_id AS stopped_reason_id_14, t0.closed_text AS closed_text_15, t0.percent_complete AS percent_complete_16, t0.klaar_datum AS klaar_datum_17, t0.verstuurd_datum AS verstuurd_datum_18, t0.closed_date AS closed_date_19, t0.total_requirement AS total_requirement_20, t0.real_estate_type_id AS real_estate_type_id_21, t0.leadgenerator_repayment AS leadgenerator_repayment_22, t0.financed_reason_id AS financed_reason_id_23, t0.action_date AS action_date_24, t0.funding_request_id AS funding_request_id_25, t0.track_version AS track_version_26, t0.origin AS origin_27, t0.webhook_url AS webhook_url_28, t0.yupal_url AS yupal_url_29, t0.starting_fee AS starting_fee_30, t0.closing_fee AS closing_fee_31, t0.cancellation_fee AS cancellation_fee_32, t0.edit_at_financier AS edit_at_financier_33, t0.client_id AS client_id_34, t0.customer_id AS customer_id_35, t0.leadgenerator_id AS leadgenerator_id_36, t37.id AS id_38, t37.aanvraag_id AS aanvraag_id_39, t40.id AS id_41, t40.totaal_checked AS totaal_checked_42, t40.aanvraag_id AS aanvraag_id_43, t44.id AS id_45, t44.has_financial_position AS has_financial_position_46, t44.complete AS complete_47, t44.has_financial_company AS has_financial_company_48, t44.aanvraag_id AS aanvraag_id_49, t50.id AS id_51, t50.complete AS complete_52, t50.aanvraag_id AS aanvraag_id_53, t54.id AS id_55, t54.complete AS complete_56, t54.aanvraag_id AS aanvraag_id_57, t58.id AS id_59, t58.complete AS complete_60, t58.aanvraag_id AS aanvraag_id_61, t62.id AS id_63, t62.aanvraag_id AS aanvraag_id_64, t65.id AS id_66, t65.has_introductie AS has_introductie_67, t65.show_one_table AS show_one_table_68, t65.introductie_tekst AS introductie_tekst_69, t65.has_samenvatting AS has_samenvatting_70, t65.samenvatting_tekst AS samenvatting_tekst_71, t65.has_conclusie AS has_conclusie_72, t65.conclusie_tekst AS conclusie_tekst_73, t65.subtitle AS subtitle_74, t65.under_responsibility_of AS under_responsibility_of_75, t65.aanvraag_id AS aanvraag_id_76, t77.id AS id_78, t77.quick_scan_type_id AS quick_scan_type_id_79, t77.name AS name_80, t77.email AS email_81, t77.phone AS phone_82, t77.company_name AS company_name_83, t77.website AS website_84, t77.comment_entrepreneur AS comment_entrepreneur_85, t77.goal_id AS goal_id_86, t77.real_estate_type_id AS real_estate_type_id_87, t77.refinancing_type_id AS refinancing_type_id_88, t77.acquisition_sum AS acquisition_sum_89, t77.transaction_costs AS transaction_costs_90, t77.takeover_other_costs AS takeover_other_costs_91, t77.investment AS investment_92, t77.refinance_existing_loans AS refinance_existing_loans_93, t77.liquidities_to_be_withdrawn AS liquidities_to_be_withdrawn_94, t77.buyers_costs AS buyers_costs_95, t77.construction_costs AS construction_costs_96, t77.vat AS vat_97, t77.other_costs AS other_costs_98, t77.own_contribution AS own_contribution_99, t77.financing_requirement AS financing_requirement_100, t77.substantiation_financing_requirement AS substantiation_financing_requirement_101, t77.is_active AS is_active_102, t77.is_send AS is_send_103, t77.result AS result_104, t77.property_postal_code AS property_postal_code_105, t77.property_house_number AS property_house_number_106, t77.property_house_number_addition AS property_house_number_addition_107, t77.property_street AS property_street_108, t77.property_city AS property_city_109, t77.property_energy_label_id AS property_energy_label_id_110, t77.property_rental_income AS property_rental_income_111, t77.property_value AS property_value_112, t77.property_data_unknown AS property_data_unknown_113, t77.country_cat_id AS country_cat_id_114, t77.customer_id AS customer_id_115, t77.client_id AS client_id_116, t77.cap_request_id AS cap_request_id_117 FROM 00_aanvraag t0 LEFT JOIN 01_juristruct t37 ON t37.aanvraag_id = t0.id LEFT JOIN 02_financiering t40 ON t40.aanvraag_id = t0.id LEFT JOIN 03_financieel t44 ON t44.aanvraag_id = t0.id LEFT JOIN 04_activiteiten t50 ON t50.aanvraag_id = t0.id LEFT JOIN 05_markt t54 ON t54.aanvraag_id = t0.id LEFT JOIN 06_team t58 ON t58.aanvraag_id = t0.id LEFT JOIN 11_fin_over t62 ON t62.aanvraag_id = t0.id LEFT JOIN 12_financing_plan t65 ON t65.aanvraag_id = t0.id LEFT JOIN 00_quick_scan t77 ON t77.cap_request_id = t0.id WHERE t0.id = ? LIMIT 1
SELECT
t0.id AS id_1,
t0.naam AS naam_2,
t0.aangemaakt AS aangemaakt_3,
t0.laatste_update AS laatste_update_4,
t0.is_deleted AS is_deleted_5,
t0.is_demo AS is_demo_6,
t0.is_ignored AS is_ignored_7,
t0.is_test AS is_test_8,
t0.is_ondernemer_aanvraag AS is_ondernemer_aanvraag_9,
t0.status_cat_id AS status_cat_id_10,
t0.status_modified_at AS status_modified_at_11,
t0.request_type_id AS request_type_id_12,
t0.closed_reason_id AS closed_reason_id_13,
t0.stopped_reason_id AS stopped_reason_id_14,
t0.closed_text AS closed_text_15,
t0.percent_complete AS percent_complete_16,
t0.klaar_datum AS klaar_datum_17,
t0.verstuurd_datum AS verstuurd_datum_18,
t0.closed_date AS closed_date_19,
t0.total_requirement AS total_requirement_20,
t0.real_estate_type_id AS real_estate_type_id_21,
t0.leadgenerator_repayment AS leadgenerator_repayment_22,
t0.financed_reason_id AS financed_reason_id_23,
t0.action_date AS action_date_24,
t0.funding_request_id AS funding_request_id_25,
t0.track_version AS track_version_26,
t0.origin AS origin_27,
t0.webhook_url AS webhook_url_28,
t0.yupal_url AS yupal_url_29,
t0.starting_fee AS starting_fee_30,
t0.closing_fee AS closing_fee_31,
t0.cancellation_fee AS cancellation_fee_32,
t0.edit_at_financier AS edit_at_financier_33,
t0.client_id AS client_id_34,
t0.customer_id AS customer_id_35,
t0.leadgenerator_id AS leadgenerator_id_36,
t37.id AS id_38,
t37.aanvraag_id AS aanvraag_id_39,
t40.id AS id_41,
t40.totaal_checked AS totaal_checked_42,
t40.aanvraag_id AS aanvraag_id_43,
t44.id AS id_45,
t44.has_financial_position AS has_financial_position_46,
t44.complete AS complete_47,
t44.has_financial_company AS has_financial_company_48,
t44.aanvraag_id AS aanvraag_id_49,
t50.id AS id_51,
t50.complete AS complete_52,
t50.aanvraag_id AS aanvraag_id_53,
t54.id AS id_55,
t54.complete AS complete_56,
t54.aanvraag_id AS aanvraag_id_57,
t58.id AS id_59,
t58.complete AS complete_60,
t58.aanvraag_id AS aanvraag_id_61,
t62.id AS id_63,
t62.aanvraag_id AS aanvraag_id_64,
t65.id AS id_66,
t65.has_introductie AS has_introductie_67,
t65.show_one_table AS show_one_table_68,
t65.introductie_tekst AS introductie_tekst_69,
t65.has_samenvatting AS has_samenvatting_70,
t65.samenvatting_tekst AS samenvatting_tekst_71,
t65.has_conclusie AS has_conclusie_72,
t65.conclusie_tekst AS conclusie_tekst_73,
t65.subtitle AS subtitle_74,
t65.under_responsibility_of AS under_responsibility_of_75,
t65.aanvraag_id AS aanvraag_id_76,
t77.id AS id_78,
t77.quick_scan_type_id AS quick_scan_type_id_79,
t77.name AS name_80,
t77.email AS email_81,
t77.phone AS phone_82,
t77.company_name AS company_name_83,
t77.website AS website_84,
t77.comment_entrepreneur AS comment_entrepreneur_85,
t77.goal_id AS goal_id_86,
t77.real_estate_type_id AS real_estate_type_id_87,
t77.refinancing_type_id AS refinancing_type_id_88,
t77.acquisition_sum AS acquisition_sum_89,
t77.transaction_costs AS transaction_costs_90,
t77.takeover_other_costs AS takeover_other_costs_91,
t77.investment AS investment_92,
t77.refinance_existing_loans AS refinance_existing_loans_93,
t77.liquidities_to_be_withdrawn AS liquidities_to_be_withdrawn_94,
t77.buyers_costs AS buyers_costs_95,
t77.construction_costs AS construction_costs_96,
t77.vat AS vat_97,
t77.other_costs AS other_costs_98,
t77.own_contribution AS own_contribution_99,
t77.financing_requirement AS financing_requirement_100,
t77.substantiation_financing_requirement AS substantiation_financing_requirement_101,
t77.is_active AS is_active_102,
t77.is_send AS is_send_103,
t77.result AS result_104,
t77.property_postal_code AS property_postal_code_105,
t77.property_house_number AS property_house_number_106,
t77.property_house_number_addition AS property_house_number_addition_107,
t77.property_street AS property_street_108,
t77.property_city AS property_city_109,
t77.property_energy_label_id AS property_energy_label_id_110,
t77.property_rental_income AS property_rental_income_111,
t77.property_value AS property_value_112,
t77.property_data_unknown AS property_data_unknown_113,
t77.country_cat_id AS country_cat_id_114,
t77.customer_id AS customer_id_115,
t77.client_id AS client_id_116,
t77.cap_request_id AS cap_request_id_117
FROM
00_aanvraag t0
LEFT JOIN 01_juristruct t37 ON t37.aanvraag_id = t0.id
LEFT JOIN 02_financiering t40 ON t40.aanvraag_id = t0.id
LEFT JOIN 03_financieel t44 ON t44.aanvraag_id = t0.id
LEFT JOIN 04_activiteiten t50 ON t50.aanvraag_id = t0.id
LEFT JOIN 05_markt t54 ON t54.aanvraag_id = t0.id
LEFT JOIN 06_team t58 ON t58.aanvraag_id = t0.id
LEFT JOIN 11_fin_over t62 ON t62.aanvraag_id = t0.id
LEFT JOIN 12_financing_plan t65 ON t65.aanvraag_id = t0.id
LEFT JOIN 00_quick_scan t77 ON t77.cap_request_id = t0.id
WHERE
t0.id = ?
LIMIT
1
SELECT t0.id AS id_1, t0.naam AS naam_2, t0.aangemaakt AS aangemaakt_3, t0.laatste_update AS laatste_update_4, t0.is_deleted AS is_deleted_5, t0.is_demo AS is_demo_6, t0.is_ignored AS is_ignored_7, t0.is_test AS is_test_8, t0.is_ondernemer_aanvraag AS is_ondernemer_aanvraag_9, t0.status_cat_id AS status_cat_id_10, t0.status_modified_at AS status_modified_at_11, t0.request_type_id AS request_type_id_12, t0.closed_reason_id AS closed_reason_id_13, t0.stopped_reason_id AS stopped_reason_id_14, t0.closed_text AS closed_text_15, t0.percent_complete AS percent_complete_16, t0.klaar_datum AS klaar_datum_17, t0.verstuurd_datum AS verstuurd_datum_18, t0.closed_date AS closed_date_19, t0.total_requirement AS total_requirement_20, t0.real_estate_type_id AS real_estate_type_id_21, t0.leadgenerator_repayment AS leadgenerator_repayment_22, t0.financed_reason_id AS financed_reason_id_23, t0.action_date AS action_date_24, t0.funding_request_id AS funding_request_id_25, t0.track_version AS track_version_26, t0.origin AS origin_27, t0.webhook_url AS webhook_url_28, t0.yupal_url AS yupal_url_29, t0.starting_fee AS starting_fee_30, t0.closing_fee AS closing_fee_31, t0.cancellation_fee AS cancellation_fee_32, t0.edit_at_financier AS edit_at_financier_33, t0.client_id AS client_id_34, t0.customer_id AS customer_id_35, t0.leadgenerator_id AS leadgenerator_id_36, t37.id AS id_38, t37.aanvraag_id AS aanvraag_id_39, t40.id AS id_41, t40.totaal_checked AS totaal_checked_42, t40.aanvraag_id AS aanvraag_id_43, t44.id AS id_45, t44.has_financial_position AS has_financial_position_46, t44.complete AS complete_47, t44.has_financial_company AS has_financial_company_48, t44.aanvraag_id AS aanvraag_id_49, t50.id AS id_51, t50.complete AS complete_52, t50.aanvraag_id AS aanvraag_id_53, t54.id AS id_55, t54.complete AS complete_56, t54.aanvraag_id AS aanvraag_id_57, t58.id AS id_59, t58.complete AS complete_60, t58.aanvraag_id AS aanvraag_id_61, t62.id AS id_63, t62.aanvraag_id AS aanvraag_id_64, t65.id AS id_66, t65.has_introductie AS has_introductie_67, t65.show_one_table AS show_one_table_68, t65.introductie_tekst AS introductie_tekst_69, t65.has_samenvatting AS has_samenvatting_70, t65.samenvatting_tekst AS samenvatting_tekst_71, t65.has_conclusie AS has_conclusie_72, t65.conclusie_tekst AS conclusie_tekst_73, t65.subtitle AS subtitle_74, t65.under_responsibility_of AS under_responsibility_of_75, t65.aanvraag_id AS aanvraag_id_76, t77.id AS id_78, t77.quick_scan_type_id AS quick_scan_type_id_79, t77.name AS name_80, t77.email AS email_81, t77.phone AS phone_82, t77.company_name AS company_name_83, t77.website AS website_84, t77.comment_entrepreneur AS comment_entrepreneur_85, t77.goal_id AS goal_id_86, t77.real_estate_type_id AS real_estate_type_id_87, t77.refinancing_type_id AS refinancing_type_id_88, t77.acquisition_sum AS acquisition_sum_89, t77.transaction_costs AS transaction_costs_90, t77.takeover_other_costs AS takeover_other_costs_91, t77.investment AS investment_92, t77.refinance_existing_loans AS refinance_existing_loans_93, t77.liquidities_to_be_withdrawn AS liquidities_to_be_withdrawn_94, t77.buyers_costs AS buyers_costs_95, t77.construction_costs AS construction_costs_96, t77.vat AS vat_97, t77.other_costs AS other_costs_98, t77.own_contribution AS own_contribution_99, t77.financing_requirement AS financing_requirement_100, t77.substantiation_financing_requirement AS substantiation_financing_requirement_101, t77.is_active AS is_active_102, t77.is_send AS is_send_103, t77.result AS result_104, t77.property_postal_code AS property_postal_code_105, t77.property_house_number AS property_house_number_106, t77.property_house_number_addition AS property_house_number_addition_107, t77.property_street AS property_street_108, t77.property_city AS property_city_109, t77.property_energy_label_id AS property_energy_label_id_110, t77.property_rental_income AS property_rental_income_111, t77.property_value AS property_value_112, t77.property_data_unknown AS property_data_unknown_113, t77.country_cat_id AS country_cat_id_114, t77.customer_id AS customer_id_115, t77.client_id AS client_id_116, t77.cap_request_id AS cap_request_id_117 FROM 00_aanvraag t0 LEFT JOIN 01_juristruct t37 ON t37.aanvraag_id = t0.id LEFT JOIN 02_financiering t40 ON t40.aanvraag_id = t0.id LEFT JOIN 03_financieel t44 ON t44.aanvraag_id = t0.id LEFT JOIN 04_activiteiten t50 ON t50.aanvraag_id = t0.id LEFT JOIN 05_markt t54 ON t54.aanvraag_id = t0.id LEFT JOIN 06_team t58 ON t58.aanvraag_id = t0.id LEFT JOIN 11_fin_over t62 ON t62.aanvraag_id = t0.id LEFT JOIN 12_financing_plan t65 ON t65.aanvraag_id = t0.id LEFT JOIN 00_quick_scan t77 ON t77.cap_request_id = t0.id WHERE t0.id = 0 LIMIT 1;
|
| 3 |
0.72 ms |
SELECT t0.id AS id_1, t0.actief AS actief_2, t0.show_profile_photo AS show_profile_photo_3, t0.is_active AS is_active_4, t0.personalized_fin_plan AS personalized_fin_plan_5, t0.api_key AS api_key_6, t0.is_expert_complete AS is_expert_complete_7, t0.is_expert_send AS is_expert_send_8, t0.created_date AS created_date_9, t0.demo_warning AS demo_warning_10, t0.receive_financier_email AS receive_financier_email_11, t0.organisatie_id AS organisatie_id_12, t0.rol_id AS rol_id_13, t0.user_id AS user_id_14 FROM 00_client t0 WHERE t0.id = ? LIMIT 1
SELECT t0.id AS id_1, t0.actief AS actief_2, t0.show_profile_photo AS show_profile_photo_3, t0.is_active AS is_active_4, t0.personalized_fin_plan AS personalized_fin_plan_5, t0.api_key AS api_key_6, t0.is_expert_complete AS is_expert_complete_7, t0.is_expert_send AS is_expert_send_8, t0.created_date AS created_date_9, t0.demo_warning AS demo_warning_10, t0.receive_financier_email AS receive_financier_email_11, t0.organisatie_id AS organisatie_id_12, t0.rol_id AS rol_id_13, t0.user_id AS user_id_14 FROM 00_client t0 WHERE t0.id = 1120 LIMIT 1;
|
| 4 |
0.95 ms |
SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.voornaam AS voornaam_4, t0.voorletters AS voorletters_5, t0.tussenvoegsels AS tussenvoegsels_6, t0.achternaam AS achternaam_7, t0.geslacht AS geslacht_8, t0.email AS email_9, t0.telefoon AS telefoon_10, t0.actief AS actief_11, t0.roles AS roles_12, t0.privacy_policy AS privacy_policy_13, t0.last_login AS last_login_14, t0.last_pass_change AS last_pass_change_15, t0.street AS street_16, t0.house_number AS house_number_17, t0.house_number_addition AS house_number_addition_18, t0.postal_code AS postal_code_19, t0.city AS city_20, t0.locale AS locale_21, t0.attempts AS attempts_22, t0.locked AS locked_23, t0.two_factor_code AS two_factor_code_24, t0.reset_two_factor AS reset_two_factor_25, t0.is_active AS is_active_26, t0.sso_email AS sso_email_27, t0.account_activation_status_id AS account_activation_status_id_28, t0.left_menu_state AS left_menu_state_29, t0.right_menu_state AS right_menu_state_30, t0.created_at AS created_at_31, t0.send_welcome_email AS send_welcome_email_32 FROM 00_user t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.voornaam AS voornaam_4, t0.voorletters AS voorletters_5, t0.tussenvoegsels AS tussenvoegsels_6, t0.achternaam AS achternaam_7, t0.geslacht AS geslacht_8, t0.email AS email_9, t0.telefoon AS telefoon_10, t0.actief AS actief_11, t0.roles AS roles_12, t0.privacy_policy AS privacy_policy_13, t0.last_login AS last_login_14, t0.last_pass_change AS last_pass_change_15, t0.street AS street_16, t0.house_number AS house_number_17, t0.house_number_addition AS house_number_addition_18, t0.postal_code AS postal_code_19, t0.city AS city_20, t0.locale AS locale_21, t0.attempts AS attempts_22, t0.locked AS locked_23, t0.two_factor_code AS two_factor_code_24, t0.reset_two_factor AS reset_two_factor_25, t0.is_active AS is_active_26, t0.sso_email AS sso_email_27, t0.account_activation_status_id AS account_activation_status_id_28, t0.left_menu_state AS left_menu_state_29, t0.right_menu_state AS right_menu_state_30, t0.created_at AS created_at_31, t0.send_welcome_email AS send_welcome_email_32 FROM 00_user t0 WHERE t0.id = 1120;
|
| 5 |
1.37 ms |
SELECT t0.id AS id_1, t0.naam AS naam_2, t0.display_name AS display_name_3, t0.ident AS ident_4, t0.website AS website_5, t0.logo AS logo_6, t0.verdien_model_cat_id AS verdien_model_cat_id_7, t0.actief AS actief_8, t0.domain_string AS domain_string_9, t0.disclaimer AS disclaimer_10, t0.fin_gast_email AS fin_gast_email_11, t0.gast_email_to_self AS gast_email_to_self_12, t0.korte_flow_available AS korte_flow_available_13, t0.is_single_sign_on AS is_single_sign_on_14, t0.show_financial_import_export AS show_financial_import_export_15, t0.street AS street_16, t0.house_number AS house_number_17, t0.house_number_addition AS house_number_addition_18, t0.postal_code AS postal_code_19, t0.city AS city_20, t0.capsearch_globals AS capsearch_globals_21, t0.is_expert_complete AS is_expert_complete_22, t0.lg_google_analytics_id AS lg_google_analytics_id_23, t0.lg_show_lenders AS lg_show_lenders_24, t0.lg_show_carousel AS lg_show_carousel_25, t0.lg_show_powered_by AS lg_show_powered_by_26, t0.is_expert_send AS is_expert_send_27, t0.show_contract_and_billing AS show_contract_and_billing_28, t0.kvk_nummer AS kvk_nummer_29, t0.not_in_kvk AS not_in_kvk_30, t0.use_two_factor AS use_two_factor_31, t0.client_email_exclude_string AS client_email_exclude_string_32, t0.policy_text AS policy_text_33, t0.created_at AS created_at_34, t0.is_active AS is_active_35, t0.code AS code_36, t0.exact_relation_code AS exact_relation_code_37, t0.license_model_id AS license_model_id_38, t0.capsearch_as_financier AS capsearch_as_financier_39, t0.financier_portal_url AS financier_portal_url_40, t0.master_organisatie_id AS master_organisatie_id_41, t0.korte_flow_client_id AS korte_flow_client_id_42, t43.id AS id_44, t43.organization_name AS organization_name_45, t43.postal_code AS postal_code_46, t43.house_number AS house_number_47, t43.house_number_addition AS house_number_addition_48, t43.street AS street_49, t43.city AS city_50, t43.kvk_number AS kvk_number_51, t43.not_in_kvk AS not_in_kvk_52, t43.gender AS gender_53, t43.first_name AS first_name_54, t43.middle_name AS middle_name_55, t43.last_name AS last_name_56, t43.email AS email_57, t43.organization_id AS organization_id_58, t59.id AS id_60, t59.start_date AS start_date_61, t59.end_date AS end_date_62, t59.number_users AS number_users_63, t59.show_conditions_financier AS show_conditions_financier_64, t59.show_conditions_capsearch1 AS show_conditions_capsearch1_65, t59.show_conditions_capsearch2 AS show_conditions_capsearch2_66, t59.organisatie_id AS organisatie_id_67, t59.contract_model_id AS contract_model_id_68, t69.id AS id_70, t69.main_color AS main_color_71, t69.main_color_text AS main_color_text_72, t69.second_main_color AS second_main_color_73, t69.second_main_color_text AS second_main_color_text_74, t69.third_main_color AS third_main_color_75, t69.third_main_color_text AS third_main_color_text_76, t69.background_color AS background_color_77, t69.line_color AS line_color_78, t69.menu_active_item_color AS menu_active_item_color_79, t69.menu_line_color AS menu_line_color_80, t69.menu_nav_bar_text_color AS menu_nav_bar_text_color_81, t69.menu_nav_bar_color AS menu_nav_bar_color_82, t69.menu_nav_bar_line_color AS menu_nav_bar_line_color_83, t69.btn_border_width AS btn_border_width_84, t69.btn_border_radius AS btn_border_radius_85, t69.table_header_color AS table_header_color_86, t69.table_header_text_color AS table_header_text_color_87, t69.table_total_color AS table_total_color_88, t69.table_total_text_color AS table_total_text_color_89, t69.prog_bar_color AS prog_bar_color_90, t69.prog_bar_ball_color AS prog_bar_ball_color_91, t69.prog_bar_item_background_color AS prog_bar_item_background_color_92, t69.prog_bar_item_background_color_active AS prog_bar_item_background_color_active_93, t69.prog_bar_item_background_color_completed AS prog_bar_item_background_color_completed_94, t69.prog_bar_item_text_color AS prog_bar_item_text_color_95, t69.prog_bar_item_text_color_active AS prog_bar_item_text_color_active_96, t69.prog_bar_item_text_color_completed AS prog_bar_item_text_color_completed_97, t69.vertical_menu_background AS vertical_menu_background_98, t69.vertical_menu_text_color AS vertical_menu_text_color_99, t69.vertical_menu_background_color_active AS vertical_menu_background_color_active_100, t69.vertical_menu_text_color_active AS vertical_menu_text_color_active_101, t69.use_logo AS use_logo_102, t69.use_in_inter_app AS use_in_inter_app_103, t69.use_in_onder_app AS use_in_onder_app_104, t69.use_in_lgapp AS use_in_lgapp_105, t69.use_custom_font AS use_custom_font_106, t69.organization_id AS organization_id_107, t0.leadgenerator_id AS leadgenerator_id_108, t0.country_cat_id AS country_cat_id_109 FROM 00_organisatie t0 LEFT JOIN 00_billing_info t43 ON t43.organization_id = t0.id LEFT JOIN 00_organisatie_contract t59 ON t59.organisatie_id = t0.id LEFT JOIN 00_style_custom t69 ON t69.organization_id = t0.id WHERE t0.ident = ? LIMIT 1
Parameters: [
"capsearch"
]
SELECT
t0.id AS id_1,
t0.naam AS naam_2,
t0.display_name AS display_name_3,
t0.ident AS ident_4,
t0.website AS website_5,
t0.logo AS logo_6,
t0.verdien_model_cat_id AS verdien_model_cat_id_7,
t0.actief AS actief_8,
t0.domain_string AS domain_string_9,
t0.disclaimer AS disclaimer_10,
t0.fin_gast_email AS fin_gast_email_11,
t0.gast_email_to_self AS gast_email_to_self_12,
t0.korte_flow_available AS korte_flow_available_13,
t0.is_single_sign_on AS is_single_sign_on_14,
t0.show_financial_import_export AS show_financial_import_export_15,
t0.street AS street_16,
t0.house_number AS house_number_17,
t0.house_number_addition AS house_number_addition_18,
t0.postal_code AS postal_code_19,
t0.city AS city_20,
t0.capsearch_globals AS capsearch_globals_21,
t0.is_expert_complete AS is_expert_complete_22,
t0.lg_google_analytics_id AS lg_google_analytics_id_23,
t0.lg_show_lenders AS lg_show_lenders_24,
t0.lg_show_carousel AS lg_show_carousel_25,
t0.lg_show_powered_by AS lg_show_powered_by_26,
t0.is_expert_send AS is_expert_send_27,
t0.show_contract_and_billing AS show_contract_and_billing_28,
t0.kvk_nummer AS kvk_nummer_29,
t0.not_in_kvk AS not_in_kvk_30,
t0.use_two_factor AS use_two_factor_31,
t0.client_email_exclude_string AS client_email_exclude_string_32,
t0.policy_text AS policy_text_33,
t0.created_at AS created_at_34,
t0.is_active AS is_active_35,
t0.code AS code_36,
t0.exact_relation_code AS exact_relation_code_37,
t0.license_model_id AS license_model_id_38,
t0.capsearch_as_financier AS capsearch_as_financier_39,
t0.financier_portal_url AS financier_portal_url_40,
t0.master_organisatie_id AS master_organisatie_id_41,
t0.korte_flow_client_id AS korte_flow_client_id_42,
t43.id AS id_44,
t43.organization_name AS organization_name_45,
t43.postal_code AS postal_code_46,
t43.house_number AS house_number_47,
t43.house_number_addition AS house_number_addition_48,
t43.street AS street_49,
t43.city AS city_50,
t43.kvk_number AS kvk_number_51,
t43.not_in_kvk AS not_in_kvk_52,
t43.gender AS gender_53,
t43.first_name AS first_name_54,
t43.middle_name AS middle_name_55,
t43.last_name AS last_name_56,
t43.email AS email_57,
t43.organization_id AS organization_id_58,
t59.id AS id_60,
t59.start_date AS start_date_61,
t59.end_date AS end_date_62,
t59.number_users AS number_users_63,
t59.show_conditions_financier AS show_conditions_financier_64,
t59.show_conditions_capsearch1 AS show_conditions_capsearch1_65,
t59.show_conditions_capsearch2 AS show_conditions_capsearch2_66,
t59.organisatie_id AS organisatie_id_67,
t59.contract_model_id AS contract_model_id_68,
t69.id AS id_70,
t69.main_color AS main_color_71,
t69.main_color_text AS main_color_text_72,
t69.second_main_color AS second_main_color_73,
t69.second_main_color_text AS second_main_color_text_74,
t69.third_main_color AS third_main_color_75,
t69.third_main_color_text AS third_main_color_text_76,
t69.background_color AS background_color_77,
t69.line_color AS line_color_78,
t69.menu_active_item_color AS menu_active_item_color_79,
t69.menu_line_color AS menu_line_color_80,
t69.menu_nav_bar_text_color AS menu_nav_bar_text_color_81,
t69.menu_nav_bar_color AS menu_nav_bar_color_82,
t69.menu_nav_bar_line_color AS menu_nav_bar_line_color_83,
t69.btn_border_width AS btn_border_width_84,
t69.btn_border_radius AS btn_border_radius_85,
t69.table_header_color AS table_header_color_86,
t69.table_header_text_color AS table_header_text_color_87,
t69.table_total_color AS table_total_color_88,
t69.table_total_text_color AS table_total_text_color_89,
t69.prog_bar_color AS prog_bar_color_90,
t69.prog_bar_ball_color AS prog_bar_ball_color_91,
t69.prog_bar_item_background_color AS prog_bar_item_background_color_92,
t69.prog_bar_item_background_color_active AS prog_bar_item_background_color_active_93,
t69.prog_bar_item_background_color_completed AS prog_bar_item_background_color_completed_94,
t69.prog_bar_item_text_color AS prog_bar_item_text_color_95,
t69.prog_bar_item_text_color_active AS prog_bar_item_text_color_active_96,
t69.prog_bar_item_text_color_completed AS prog_bar_item_text_color_completed_97,
t69.vertical_menu_background AS vertical_menu_background_98,
t69.vertical_menu_text_color AS vertical_menu_text_color_99,
t69.vertical_menu_background_color_active AS vertical_menu_background_color_active_100,
t69.vertical_menu_text_color_active AS vertical_menu_text_color_active_101,
t69.use_logo AS use_logo_102,
t69.use_in_inter_app AS use_in_inter_app_103,
t69.use_in_onder_app AS use_in_onder_app_104,
t69.use_in_lgapp AS use_in_lgapp_105,
t69.use_custom_font AS use_custom_font_106,
t69.organization_id AS organization_id_107,
t0.leadgenerator_id AS leadgenerator_id_108,
t0.country_cat_id AS country_cat_id_109
FROM
00_organisatie t0
LEFT JOIN 00_billing_info t43 ON t43.organization_id = t0.id
LEFT JOIN 00_organisatie_contract t59 ON t59.organisatie_id = t0.id
LEFT JOIN 00_style_custom t69 ON t69.organization_id = t0.id
WHERE
t0.ident = ?
LIMIT
1
SELECT t0.id AS id_1, t0.naam AS naam_2, t0.display_name AS display_name_3, t0.ident AS ident_4, t0.website AS website_5, t0.logo AS logo_6, t0.verdien_model_cat_id AS verdien_model_cat_id_7, t0.actief AS actief_8, t0.domain_string AS domain_string_9, t0.disclaimer AS disclaimer_10, t0.fin_gast_email AS fin_gast_email_11, t0.gast_email_to_self AS gast_email_to_self_12, t0.korte_flow_available AS korte_flow_available_13, t0.is_single_sign_on AS is_single_sign_on_14, t0.show_financial_import_export AS show_financial_import_export_15, t0.street AS street_16, t0.house_number AS house_number_17, t0.house_number_addition AS house_number_addition_18, t0.postal_code AS postal_code_19, t0.city AS city_20, t0.capsearch_globals AS capsearch_globals_21, t0.is_expert_complete AS is_expert_complete_22, t0.lg_google_analytics_id AS lg_google_analytics_id_23, t0.lg_show_lenders AS lg_show_lenders_24, t0.lg_show_carousel AS lg_show_carousel_25, t0.lg_show_powered_by AS lg_show_powered_by_26, t0.is_expert_send AS is_expert_send_27, t0.show_contract_and_billing AS show_contract_and_billing_28, t0.kvk_nummer AS kvk_nummer_29, t0.not_in_kvk AS not_in_kvk_30, t0.use_two_factor AS use_two_factor_31, t0.client_email_exclude_string AS client_email_exclude_string_32, t0.policy_text AS policy_text_33, t0.created_at AS created_at_34, t0.is_active AS is_active_35, t0.code AS code_36, t0.exact_relation_code AS exact_relation_code_37, t0.license_model_id AS license_model_id_38, t0.capsearch_as_financier AS capsearch_as_financier_39, t0.financier_portal_url AS financier_portal_url_40, t0.master_organisatie_id AS master_organisatie_id_41, t0.korte_flow_client_id AS korte_flow_client_id_42, t43.id AS id_44, t43.organization_name AS organization_name_45, t43.postal_code AS postal_code_46, t43.house_number AS house_number_47, t43.house_number_addition AS house_number_addition_48, t43.street AS street_49, t43.city AS city_50, t43.kvk_number AS kvk_number_51, t43.not_in_kvk AS not_in_kvk_52, t43.gender AS gender_53, t43.first_name AS first_name_54, t43.middle_name AS middle_name_55, t43.last_name AS last_name_56, t43.email AS email_57, t43.organization_id AS organization_id_58, t59.id AS id_60, t59.start_date AS start_date_61, t59.end_date AS end_date_62, t59.number_users AS number_users_63, t59.show_conditions_financier AS show_conditions_financier_64, t59.show_conditions_capsearch1 AS show_conditions_capsearch1_65, t59.show_conditions_capsearch2 AS show_conditions_capsearch2_66, t59.organisatie_id AS organisatie_id_67, t59.contract_model_id AS contract_model_id_68, t69.id AS id_70, t69.main_color AS main_color_71, t69.main_color_text AS main_color_text_72, t69.second_main_color AS second_main_color_73, t69.second_main_color_text AS second_main_color_text_74, t69.third_main_color AS third_main_color_75, t69.third_main_color_text AS third_main_color_text_76, t69.background_color AS background_color_77, t69.line_color AS line_color_78, t69.menu_active_item_color AS menu_active_item_color_79, t69.menu_line_color AS menu_line_color_80, t69.menu_nav_bar_text_color AS menu_nav_bar_text_color_81, t69.menu_nav_bar_color AS menu_nav_bar_color_82, t69.menu_nav_bar_line_color AS menu_nav_bar_line_color_83, t69.btn_border_width AS btn_border_width_84, t69.btn_border_radius AS btn_border_radius_85, t69.table_header_color AS table_header_color_86, t69.table_header_text_color AS table_header_text_color_87, t69.table_total_color AS table_total_color_88, t69.table_total_text_color AS table_total_text_color_89, t69.prog_bar_color AS prog_bar_color_90, t69.prog_bar_ball_color AS prog_bar_ball_color_91, t69.prog_bar_item_background_color AS prog_bar_item_background_color_92, t69.prog_bar_item_background_color_active AS prog_bar_item_background_color_active_93, t69.prog_bar_item_background_color_completed AS prog_bar_item_background_color_completed_94, t69.prog_bar_item_text_color AS prog_bar_item_text_color_95, t69.prog_bar_item_text_color_active AS prog_bar_item_text_color_active_96, t69.prog_bar_item_text_color_completed AS prog_bar_item_text_color_completed_97, t69.vertical_menu_background AS vertical_menu_background_98, t69.vertical_menu_text_color AS vertical_menu_text_color_99, t69.vertical_menu_background_color_active AS vertical_menu_background_color_active_100, t69.vertical_menu_text_color_active AS vertical_menu_text_color_active_101, t69.use_logo AS use_logo_102, t69.use_in_inter_app AS use_in_inter_app_103, t69.use_in_onder_app AS use_in_onder_app_104, t69.use_in_lgapp AS use_in_lgapp_105, t69.use_custom_font AS use_custom_font_106, t69.organization_id AS organization_id_107, t0.leadgenerator_id AS leadgenerator_id_108, t0.country_cat_id AS country_cat_id_109 FROM 00_organisatie t0 LEFT JOIN 00_billing_info t43 ON t43.organization_id = t0.id LEFT JOIN 00_organisatie_contract t59 ON t59.organisatie_id = t0.id LEFT JOIN 00_style_custom t69 ON t69.organization_id = t0.id WHERE t0.ident = 'capsearch' LIMIT 1;
|
| 6 |
1.12 ms |
SELECT t0.id AS id_1, t0.naam AS naam_2, t0.display_name AS display_name_3, t0.ident AS ident_4, t0.website AS website_5, t0.logo AS logo_6, t0.verdien_model_cat_id AS verdien_model_cat_id_7, t0.actief AS actief_8, t0.domain_string AS domain_string_9, t0.disclaimer AS disclaimer_10, t0.fin_gast_email AS fin_gast_email_11, t0.gast_email_to_self AS gast_email_to_self_12, t0.korte_flow_available AS korte_flow_available_13, t0.is_single_sign_on AS is_single_sign_on_14, t0.show_financial_import_export AS show_financial_import_export_15, t0.street AS street_16, t0.house_number AS house_number_17, t0.house_number_addition AS house_number_addition_18, t0.postal_code AS postal_code_19, t0.city AS city_20, t0.capsearch_globals AS capsearch_globals_21, t0.is_expert_complete AS is_expert_complete_22, t0.lg_google_analytics_id AS lg_google_analytics_id_23, t0.lg_show_lenders AS lg_show_lenders_24, t0.lg_show_carousel AS lg_show_carousel_25, t0.lg_show_powered_by AS lg_show_powered_by_26, t0.is_expert_send AS is_expert_send_27, t0.show_contract_and_billing AS show_contract_and_billing_28, t0.kvk_nummer AS kvk_nummer_29, t0.not_in_kvk AS not_in_kvk_30, t0.use_two_factor AS use_two_factor_31, t0.client_email_exclude_string AS client_email_exclude_string_32, t0.policy_text AS policy_text_33, t0.created_at AS created_at_34, t0.is_active AS is_active_35, t0.code AS code_36, t0.exact_relation_code AS exact_relation_code_37, t0.license_model_id AS license_model_id_38, t0.capsearch_as_financier AS capsearch_as_financier_39, t0.financier_portal_url AS financier_portal_url_40, t0.master_organisatie_id AS master_organisatie_id_41, t0.korte_flow_client_id AS korte_flow_client_id_42, t43.id AS id_44, t43.organization_name AS organization_name_45, t43.postal_code AS postal_code_46, t43.house_number AS house_number_47, t43.house_number_addition AS house_number_addition_48, t43.street AS street_49, t43.city AS city_50, t43.kvk_number AS kvk_number_51, t43.not_in_kvk AS not_in_kvk_52, t43.gender AS gender_53, t43.first_name AS first_name_54, t43.middle_name AS middle_name_55, t43.last_name AS last_name_56, t43.email AS email_57, t43.organization_id AS organization_id_58, t59.id AS id_60, t59.start_date AS start_date_61, t59.end_date AS end_date_62, t59.number_users AS number_users_63, t59.show_conditions_financier AS show_conditions_financier_64, t59.show_conditions_capsearch1 AS show_conditions_capsearch1_65, t59.show_conditions_capsearch2 AS show_conditions_capsearch2_66, t59.organisatie_id AS organisatie_id_67, t59.contract_model_id AS contract_model_id_68, t69.id AS id_70, t69.main_color AS main_color_71, t69.main_color_text AS main_color_text_72, t69.second_main_color AS second_main_color_73, t69.second_main_color_text AS second_main_color_text_74, t69.third_main_color AS third_main_color_75, t69.third_main_color_text AS third_main_color_text_76, t69.background_color AS background_color_77, t69.line_color AS line_color_78, t69.menu_active_item_color AS menu_active_item_color_79, t69.menu_line_color AS menu_line_color_80, t69.menu_nav_bar_text_color AS menu_nav_bar_text_color_81, t69.menu_nav_bar_color AS menu_nav_bar_color_82, t69.menu_nav_bar_line_color AS menu_nav_bar_line_color_83, t69.btn_border_width AS btn_border_width_84, t69.btn_border_radius AS btn_border_radius_85, t69.table_header_color AS table_header_color_86, t69.table_header_text_color AS table_header_text_color_87, t69.table_total_color AS table_total_color_88, t69.table_total_text_color AS table_total_text_color_89, t69.prog_bar_color AS prog_bar_color_90, t69.prog_bar_ball_color AS prog_bar_ball_color_91, t69.prog_bar_item_background_color AS prog_bar_item_background_color_92, t69.prog_bar_item_background_color_active AS prog_bar_item_background_color_active_93, t69.prog_bar_item_background_color_completed AS prog_bar_item_background_color_completed_94, t69.prog_bar_item_text_color AS prog_bar_item_text_color_95, t69.prog_bar_item_text_color_active AS prog_bar_item_text_color_active_96, t69.prog_bar_item_text_color_completed AS prog_bar_item_text_color_completed_97, t69.vertical_menu_background AS vertical_menu_background_98, t69.vertical_menu_text_color AS vertical_menu_text_color_99, t69.vertical_menu_background_color_active AS vertical_menu_background_color_active_100, t69.vertical_menu_text_color_active AS vertical_menu_text_color_active_101, t69.use_logo AS use_logo_102, t69.use_in_inter_app AS use_in_inter_app_103, t69.use_in_onder_app AS use_in_onder_app_104, t69.use_in_lgapp AS use_in_lgapp_105, t69.use_custom_font AS use_custom_font_106, t69.organization_id AS organization_id_107, t0.leadgenerator_id AS leadgenerator_id_108, t0.country_cat_id AS country_cat_id_109 FROM 00_organisatie t0 LEFT JOIN 00_billing_info t43 ON t43.organization_id = t0.id LEFT JOIN 00_organisatie_contract t59 ON t59.organisatie_id = t0.id LEFT JOIN 00_style_custom t69 ON t69.organization_id = t0.id WHERE t0.id = ? LIMIT 1
SELECT
t0.id AS id_1,
t0.naam AS naam_2,
t0.display_name AS display_name_3,
t0.ident AS ident_4,
t0.website AS website_5,
t0.logo AS logo_6,
t0.verdien_model_cat_id AS verdien_model_cat_id_7,
t0.actief AS actief_8,
t0.domain_string AS domain_string_9,
t0.disclaimer AS disclaimer_10,
t0.fin_gast_email AS fin_gast_email_11,
t0.gast_email_to_self AS gast_email_to_self_12,
t0.korte_flow_available AS korte_flow_available_13,
t0.is_single_sign_on AS is_single_sign_on_14,
t0.show_financial_import_export AS show_financial_import_export_15,
t0.street AS street_16,
t0.house_number AS house_number_17,
t0.house_number_addition AS house_number_addition_18,
t0.postal_code AS postal_code_19,
t0.city AS city_20,
t0.capsearch_globals AS capsearch_globals_21,
t0.is_expert_complete AS is_expert_complete_22,
t0.lg_google_analytics_id AS lg_google_analytics_id_23,
t0.lg_show_lenders AS lg_show_lenders_24,
t0.lg_show_carousel AS lg_show_carousel_25,
t0.lg_show_powered_by AS lg_show_powered_by_26,
t0.is_expert_send AS is_expert_send_27,
t0.show_contract_and_billing AS show_contract_and_billing_28,
t0.kvk_nummer AS kvk_nummer_29,
t0.not_in_kvk AS not_in_kvk_30,
t0.use_two_factor AS use_two_factor_31,
t0.client_email_exclude_string AS client_email_exclude_string_32,
t0.policy_text AS policy_text_33,
t0.created_at AS created_at_34,
t0.is_active AS is_active_35,
t0.code AS code_36,
t0.exact_relation_code AS exact_relation_code_37,
t0.license_model_id AS license_model_id_38,
t0.capsearch_as_financier AS capsearch_as_financier_39,
t0.financier_portal_url AS financier_portal_url_40,
t0.master_organisatie_id AS master_organisatie_id_41,
t0.korte_flow_client_id AS korte_flow_client_id_42,
t43.id AS id_44,
t43.organization_name AS organization_name_45,
t43.postal_code AS postal_code_46,
t43.house_number AS house_number_47,
t43.house_number_addition AS house_number_addition_48,
t43.street AS street_49,
t43.city AS city_50,
t43.kvk_number AS kvk_number_51,
t43.not_in_kvk AS not_in_kvk_52,
t43.gender AS gender_53,
t43.first_name AS first_name_54,
t43.middle_name AS middle_name_55,
t43.last_name AS last_name_56,
t43.email AS email_57,
t43.organization_id AS organization_id_58,
t59.id AS id_60,
t59.start_date AS start_date_61,
t59.end_date AS end_date_62,
t59.number_users AS number_users_63,
t59.show_conditions_financier AS show_conditions_financier_64,
t59.show_conditions_capsearch1 AS show_conditions_capsearch1_65,
t59.show_conditions_capsearch2 AS show_conditions_capsearch2_66,
t59.organisatie_id AS organisatie_id_67,
t59.contract_model_id AS contract_model_id_68,
t69.id AS id_70,
t69.main_color AS main_color_71,
t69.main_color_text AS main_color_text_72,
t69.second_main_color AS second_main_color_73,
t69.second_main_color_text AS second_main_color_text_74,
t69.third_main_color AS third_main_color_75,
t69.third_main_color_text AS third_main_color_text_76,
t69.background_color AS background_color_77,
t69.line_color AS line_color_78,
t69.menu_active_item_color AS menu_active_item_color_79,
t69.menu_line_color AS menu_line_color_80,
t69.menu_nav_bar_text_color AS menu_nav_bar_text_color_81,
t69.menu_nav_bar_color AS menu_nav_bar_color_82,
t69.menu_nav_bar_line_color AS menu_nav_bar_line_color_83,
t69.btn_border_width AS btn_border_width_84,
t69.btn_border_radius AS btn_border_radius_85,
t69.table_header_color AS table_header_color_86,
t69.table_header_text_color AS table_header_text_color_87,
t69.table_total_color AS table_total_color_88,
t69.table_total_text_color AS table_total_text_color_89,
t69.prog_bar_color AS prog_bar_color_90,
t69.prog_bar_ball_color AS prog_bar_ball_color_91,
t69.prog_bar_item_background_color AS prog_bar_item_background_color_92,
t69.prog_bar_item_background_color_active AS prog_bar_item_background_color_active_93,
t69.prog_bar_item_background_color_completed AS prog_bar_item_background_color_completed_94,
t69.prog_bar_item_text_color AS prog_bar_item_text_color_95,
t69.prog_bar_item_text_color_active AS prog_bar_item_text_color_active_96,
t69.prog_bar_item_text_color_completed AS prog_bar_item_text_color_completed_97,
t69.vertical_menu_background AS vertical_menu_background_98,
t69.vertical_menu_text_color AS vertical_menu_text_color_99,
t69.vertical_menu_background_color_active AS vertical_menu_background_color_active_100,
t69.vertical_menu_text_color_active AS vertical_menu_text_color_active_101,
t69.use_logo AS use_logo_102,
t69.use_in_inter_app AS use_in_inter_app_103,
t69.use_in_onder_app AS use_in_onder_app_104,
t69.use_in_lgapp AS use_in_lgapp_105,
t69.use_custom_font AS use_custom_font_106,
t69.organization_id AS organization_id_107,
t0.leadgenerator_id AS leadgenerator_id_108,
t0.country_cat_id AS country_cat_id_109
FROM
00_organisatie t0
LEFT JOIN 00_billing_info t43 ON t43.organization_id = t0.id
LEFT JOIN 00_organisatie_contract t59 ON t59.organisatie_id = t0.id
LEFT JOIN 00_style_custom t69 ON t69.organization_id = t0.id
WHERE
t0.id = ?
LIMIT
1
SELECT t0.id AS id_1, t0.naam AS naam_2, t0.display_name AS display_name_3, t0.ident AS ident_4, t0.website AS website_5, t0.logo AS logo_6, t0.verdien_model_cat_id AS verdien_model_cat_id_7, t0.actief AS actief_8, t0.domain_string AS domain_string_9, t0.disclaimer AS disclaimer_10, t0.fin_gast_email AS fin_gast_email_11, t0.gast_email_to_self AS gast_email_to_self_12, t0.korte_flow_available AS korte_flow_available_13, t0.is_single_sign_on AS is_single_sign_on_14, t0.show_financial_import_export AS show_financial_import_export_15, t0.street AS street_16, t0.house_number AS house_number_17, t0.house_number_addition AS house_number_addition_18, t0.postal_code AS postal_code_19, t0.city AS city_20, t0.capsearch_globals AS capsearch_globals_21, t0.is_expert_complete AS is_expert_complete_22, t0.lg_google_analytics_id AS lg_google_analytics_id_23, t0.lg_show_lenders AS lg_show_lenders_24, t0.lg_show_carousel AS lg_show_carousel_25, t0.lg_show_powered_by AS lg_show_powered_by_26, t0.is_expert_send AS is_expert_send_27, t0.show_contract_and_billing AS show_contract_and_billing_28, t0.kvk_nummer AS kvk_nummer_29, t0.not_in_kvk AS not_in_kvk_30, t0.use_two_factor AS use_two_factor_31, t0.client_email_exclude_string AS client_email_exclude_string_32, t0.policy_text AS policy_text_33, t0.created_at AS created_at_34, t0.is_active AS is_active_35, t0.code AS code_36, t0.exact_relation_code AS exact_relation_code_37, t0.license_model_id AS license_model_id_38, t0.capsearch_as_financier AS capsearch_as_financier_39, t0.financier_portal_url AS financier_portal_url_40, t0.master_organisatie_id AS master_organisatie_id_41, t0.korte_flow_client_id AS korte_flow_client_id_42, t43.id AS id_44, t43.organization_name AS organization_name_45, t43.postal_code AS postal_code_46, t43.house_number AS house_number_47, t43.house_number_addition AS house_number_addition_48, t43.street AS street_49, t43.city AS city_50, t43.kvk_number AS kvk_number_51, t43.not_in_kvk AS not_in_kvk_52, t43.gender AS gender_53, t43.first_name AS first_name_54, t43.middle_name AS middle_name_55, t43.last_name AS last_name_56, t43.email AS email_57, t43.organization_id AS organization_id_58, t59.id AS id_60, t59.start_date AS start_date_61, t59.end_date AS end_date_62, t59.number_users AS number_users_63, t59.show_conditions_financier AS show_conditions_financier_64, t59.show_conditions_capsearch1 AS show_conditions_capsearch1_65, t59.show_conditions_capsearch2 AS show_conditions_capsearch2_66, t59.organisatie_id AS organisatie_id_67, t59.contract_model_id AS contract_model_id_68, t69.id AS id_70, t69.main_color AS main_color_71, t69.main_color_text AS main_color_text_72, t69.second_main_color AS second_main_color_73, t69.second_main_color_text AS second_main_color_text_74, t69.third_main_color AS third_main_color_75, t69.third_main_color_text AS third_main_color_text_76, t69.background_color AS background_color_77, t69.line_color AS line_color_78, t69.menu_active_item_color AS menu_active_item_color_79, t69.menu_line_color AS menu_line_color_80, t69.menu_nav_bar_text_color AS menu_nav_bar_text_color_81, t69.menu_nav_bar_color AS menu_nav_bar_color_82, t69.menu_nav_bar_line_color AS menu_nav_bar_line_color_83, t69.btn_border_width AS btn_border_width_84, t69.btn_border_radius AS btn_border_radius_85, t69.table_header_color AS table_header_color_86, t69.table_header_text_color AS table_header_text_color_87, t69.table_total_color AS table_total_color_88, t69.table_total_text_color AS table_total_text_color_89, t69.prog_bar_color AS prog_bar_color_90, t69.prog_bar_ball_color AS prog_bar_ball_color_91, t69.prog_bar_item_background_color AS prog_bar_item_background_color_92, t69.prog_bar_item_background_color_active AS prog_bar_item_background_color_active_93, t69.prog_bar_item_background_color_completed AS prog_bar_item_background_color_completed_94, t69.prog_bar_item_text_color AS prog_bar_item_text_color_95, t69.prog_bar_item_text_color_active AS prog_bar_item_text_color_active_96, t69.prog_bar_item_text_color_completed AS prog_bar_item_text_color_completed_97, t69.vertical_menu_background AS vertical_menu_background_98, t69.vertical_menu_text_color AS vertical_menu_text_color_99, t69.vertical_menu_background_color_active AS vertical_menu_background_color_active_100, t69.vertical_menu_text_color_active AS vertical_menu_text_color_active_101, t69.use_logo AS use_logo_102, t69.use_in_inter_app AS use_in_inter_app_103, t69.use_in_onder_app AS use_in_onder_app_104, t69.use_in_lgapp AS use_in_lgapp_105, t69.use_custom_font AS use_custom_font_106, t69.organization_id AS organization_id_107, t0.leadgenerator_id AS leadgenerator_id_108, t0.country_cat_id AS country_cat_id_109 FROM 00_organisatie t0 LEFT JOIN 00_billing_info t43 ON t43.organization_id = t0.id LEFT JOIN 00_organisatie_contract t59 ON t59.organisatie_id = t0.id LEFT JOIN 00_style_custom t69 ON t69.organization_id = t0.id WHERE t0.id = 1 LIMIT 1;
|