| 1 |
2.02 ms |
SELECT t0.id AS id_1, t0.legal_name AS legal_name_2, t0.telephone AS telephone_3, t0.vat_id AS vat_id_4, t0.legal_status AS legal_status_5, t0.purpose AS purpose_6, t0.founding_date AS founding_date_7, t0.fiscal_date AS fiscal_date_8, t0.fiscal_date_end AS fiscal_date_end_9, t0.first_fiscal_date AS first_fiscal_date_10, t0.first_fiscal_date_end AS first_fiscal_date_end_11, t0.head_quarters_address_type AS head_quarters_address_type_12, t0.legal_representative_address_type AS legal_representative_address_type_13, t0.share_capital AS share_capital_14, t0.share_capital_type AS share_capital_type_15, t0.share_capital_fixed_amount AS share_capital_fixed_amount_16, t0.shares_count AS shares_count_17, t0.bank_choice AS bank_choice_18, t0.registration_source AS registration_source_19, t0.commercial_court_registry AS commercial_court_registry_20, t0.sector_other AS sector_other_21, t0.rcs AS rcs_22, t0.status AS status_23, t0.email AS email_24, t0.mandatary AS mandatary_25, t0.bal AS bal_26, t0.forwarding_frequency AS forwarding_frequency_27, t0.forwarding_address_name AS forwarding_address_name_28, t0.alternate_name AS alternate_name_29, t0.domiciliation_start_date AS domiciliation_start_date_30, t0.created_at AS created_at_31, t0.termination_date AS termination_date_32, t0.termination_reason AS termination_reason_33, t0.termination_reason_other AS termination_reason_other_34, t0.siret AS siret_35, t0.is_new_immatriculation AS is_new_immatriculation_36, t0.is_new_domiciliation AS is_new_domiciliation_37, t0.mandat_id AS mandat_id_38, t0.conversion_reason AS conversion_reason_39, t0.status_is_forced AS status_is_forced_40, t0.uniq_id AS uniq_id_41, t0.iban AS iban_42, t0.reference_gocardless AS reference_gocardless_43, t0.is_forwarding_active AS is_forwarding_active_44, t0.vatrate AS vatrate_45, t0.is_imported AS is_imported_46, t0.credit_notes_amount AS credit_notes_amount_47, t0.available_credits AS available_credits_48, t0.invoice_token AS invoice_token_49, t0.share_capital_free_percentage AS share_capital_free_percentage_50, t0.is_prescriber AS is_prescriber_51, t0.have_accountant AS have_accountant_52, t0.status_immatriculation AS status_immatriculation_53, t0.is_exempt_tva AS is_exempt_tva_54, t0.project_stage AS project_stage_55, t0.status_invoice_payed AS status_invoice_payed_56, t0.date_max_unpaid AS date_max_unpaid_57, t0.is_have_auditor AS is_have_auditor_58, t0.benefit_imposition AS benefit_imposition_59, t0.benefit_imposition_option AS benefit_imposition_option_60, t0.vat_taxe_regim AS vat_taxe_regim_61, t0.vat_taxe_regime_option AS vat_taxe_regime_option_62, t0.prolongation_date_kyc AS prolongation_date_kyc_63, t0.status_transfert AS status_transfert_64, t0.is_new_transfert AS is_new_transfert_65, t0.special_request_bal AS special_request_bal_66, t0.trac_fin AS trac_fin_67, t0.trac_fin_note AS trac_fin_note_68, t0.pack_imat AS pack_imat_69, t0.is_authorize_prescriber AS is_authorize_prescriber_70, t0.is_attached_to_prescriber AS is_attached_to_prescriber_71, t0.is_emptybal AS is_emptybal_72, t0.is_authorized_debit AS is_authorized_debit_73, t0.history_nav_tunnel AS history_nav_tunnel_74, t0.note AS note_75, t0.reason_change AS reason_change_76, t0.previous_pack AS previous_pack_77, t0.zapier_hook_url AS zapier_hook_url_78, t0.sigle AS sigle_79, t0.enseigne AS enseigne_80, t0.corporate_object AS corporate_object_81, t0.place_know_digidom AS place_know_digidom_82, t0.other_place_known_digidom AS other_place_known_digidom_83, t0.bank_name AS bank_name_84, t0.titulaire AS titulaire_85, t0.is_invalid_email AS is_invalid_email_86, t0.is_invalid_phone_number AS is_invalid_phone_number_87, t0.special_customer_type AS special_customer_type_88, t0.encrypted_parent_id AS encrypted_parent_id_89, t0.is_referral_process_finished AS is_referral_process_finished_90, t0.is_digidom_accountant AS is_digidom_accountant_91, t0.is_surveillance AS is_surveillance_92, t0.beneficial_owners AS beneficial_owners_93, t0.accounts_submission_last_year AS accounts_submission_last_year_94, t0.address_id AS address_id_95, t0.accountant_id AS accountant_id_96, t0.sector_id AS sector_id_97, t0.store_id AS store_id_98, t0.forwarding_address_id AS forwarding_address_id_99, t0.prescriber_id AS prescriber_id_100, t0.notification_preference_id AS notification_preference_id_101, t0.discount_code_id AS discount_code_id_102, t103.id AS id_104, t103.given_name AS given_name_105, t103.family_name AS family_name_106, t103.phone_number AS phone_number_107, t103.email AS email_108, t103.service AS service_109, t103.created_at AS created_at_110, t103.note AS note_111, t103.status AS status_112, t103.generate_user AS generate_user_113, t103.call_time AS call_time_114, t103.priority AS priority_115, t103.date AS date_116, t103.step AS step_117, t103.source AS source_118, t103.legal_name AS legal_name_119, t103.pack AS pack_120, t103.manager_id AS manager_id_121, t103.formality_id AS formality_id_122, t103.organization_id AS organization_id_123, t0.prescriber_source_id AS prescriber_source_id_124, t0.reason_unpaid_id AS reason_unpaid_id_125, t0.reason_ribinactive_id AS reason_ribinactive_id_126, t127.id AS id_128, t127.alternate_name AS alternate_name_129, t127.legal_name AS legal_name_130, t127.name_legal_representative AS name_legal_representative_131, t127.organization_id AS organization_id_132, t0.activity_category_id AS activity_category_id_133, t0.referral_source_id AS referral_source_id_134, t0.activity_domain_id AS activity_domain_id_135, t136.id AS id_137, t136.signature_request_id AS signature_request_id_138, t136.created_at AS created_at_139, t136.external_file_id AS external_file_id_140, t136.last_uploaded_file_at AS last_uploaded_file_at_141, t136.organization_id AS organization_id_142 FROM organization t0 LEFT JOIN leads t103 ON t103.organization_id = t0.id LEFT JOIN ibml_organization_configuration t127 ON t127.organization_id = t0.id LEFT JOIN process_yousign t136 ON t136.organization_id = t0.id WHERE t0.id = ?
SELECT
t0.id AS id_1,
t0.legal_name AS legal_name_2,
t0.telephone AS telephone_3,
t0.vat_id AS vat_id_4,
t0.legal_status AS legal_status_5,
t0.purpose AS purpose_6,
t0.founding_date AS founding_date_7,
t0.fiscal_date AS fiscal_date_8,
t0.fiscal_date_end AS fiscal_date_end_9,
t0.first_fiscal_date AS first_fiscal_date_10,
t0.first_fiscal_date_end AS first_fiscal_date_end_11,
t0.head_quarters_address_type AS head_quarters_address_type_12,
t0.legal_representative_address_type AS legal_representative_address_type_13,
t0.share_capital AS share_capital_14,
t0.share_capital_type AS share_capital_type_15,
t0.share_capital_fixed_amount AS share_capital_fixed_amount_16,
t0.shares_count AS shares_count_17,
t0.bank_choice AS bank_choice_18,
t0.registration_source AS registration_source_19,
t0.commercial_court_registry AS commercial_court_registry_20,
t0.sector_other AS sector_other_21,
t0.rcs AS rcs_22,
t0.status AS status_23,
t0.email AS email_24,
t0.mandatary AS mandatary_25,
t0.bal AS bal_26,
t0.forwarding_frequency AS forwarding_frequency_27,
t0.forwarding_address_name AS forwarding_address_name_28,
t0.alternate_name AS alternate_name_29,
t0.domiciliation_start_date AS domiciliation_start_date_30,
t0.created_at AS created_at_31,
t0.termination_date AS termination_date_32,
t0.termination_reason AS termination_reason_33,
t0.termination_reason_other AS termination_reason_other_34,
t0.siret AS siret_35,
t0.is_new_immatriculation AS is_new_immatriculation_36,
t0.is_new_domiciliation AS is_new_domiciliation_37,
t0.mandat_id AS mandat_id_38,
t0.conversion_reason AS conversion_reason_39,
t0.status_is_forced AS status_is_forced_40,
t0.uniq_id AS uniq_id_41,
t0.iban AS iban_42,
t0.reference_gocardless AS reference_gocardless_43,
t0.is_forwarding_active AS is_forwarding_active_44,
t0.vatrate AS vatrate_45,
t0.is_imported AS is_imported_46,
t0.credit_notes_amount AS credit_notes_amount_47,
t0.available_credits AS available_credits_48,
t0.invoice_token AS invoice_token_49,
t0.share_capital_free_percentage AS share_capital_free_percentage_50,
t0.is_prescriber AS is_prescriber_51,
t0.have_accountant AS have_accountant_52,
t0.status_immatriculation AS status_immatriculation_53,
t0.is_exempt_tva AS is_exempt_tva_54,
t0.project_stage AS project_stage_55,
t0.status_invoice_payed AS status_invoice_payed_56,
t0.date_max_unpaid AS date_max_unpaid_57,
t0.is_have_auditor AS is_have_auditor_58,
t0.benefit_imposition AS benefit_imposition_59,
t0.benefit_imposition_option AS benefit_imposition_option_60,
t0.vat_taxe_regim AS vat_taxe_regim_61,
t0.vat_taxe_regime_option AS vat_taxe_regime_option_62,
t0.prolongation_date_kyc AS prolongation_date_kyc_63,
t0.status_transfert AS status_transfert_64,
t0.is_new_transfert AS is_new_transfert_65,
t0.special_request_bal AS special_request_bal_66,
t0.trac_fin AS trac_fin_67,
t0.trac_fin_note AS trac_fin_note_68,
t0.pack_imat AS pack_imat_69,
t0.is_authorize_prescriber AS is_authorize_prescriber_70,
t0.is_attached_to_prescriber AS is_attached_to_prescriber_71,
t0.is_emptybal AS is_emptybal_72,
t0.is_authorized_debit AS is_authorized_debit_73,
t0.history_nav_tunnel AS history_nav_tunnel_74,
t0.note AS note_75,
t0.reason_change AS reason_change_76,
t0.previous_pack AS previous_pack_77,
t0.zapier_hook_url AS zapier_hook_url_78,
t0.sigle AS sigle_79,
t0.enseigne AS enseigne_80,
t0.corporate_object AS corporate_object_81,
t0.place_know_digidom AS place_know_digidom_82,
t0.other_place_known_digidom AS other_place_known_digidom_83,
t0.bank_name AS bank_name_84,
t0.titulaire AS titulaire_85,
t0.is_invalid_email AS is_invalid_email_86,
t0.is_invalid_phone_number AS is_invalid_phone_number_87,
t0.special_customer_type AS special_customer_type_88,
t0.encrypted_parent_id AS encrypted_parent_id_89,
t0.is_referral_process_finished AS is_referral_process_finished_90,
t0.is_digidom_accountant AS is_digidom_accountant_91,
t0.is_surveillance AS is_surveillance_92,
t0.beneficial_owners AS beneficial_owners_93,
t0.accounts_submission_last_year AS accounts_submission_last_year_94,
t0.address_id AS address_id_95,
t0.accountant_id AS accountant_id_96,
t0.sector_id AS sector_id_97,
t0.store_id AS store_id_98,
t0.forwarding_address_id AS forwarding_address_id_99,
t0.prescriber_id AS prescriber_id_100,
t0.notification_preference_id AS notification_preference_id_101,
t0.discount_code_id AS discount_code_id_102,
t103.id AS id_104,
t103.given_name AS given_name_105,
t103.family_name AS family_name_106,
t103.phone_number AS phone_number_107,
t103.email AS email_108,
t103.service AS service_109,
t103.created_at AS created_at_110,
t103.note AS note_111,
t103.status AS status_112,
t103.generate_user AS generate_user_113,
t103.call_time AS call_time_114,
t103.priority AS priority_115,
t103.date AS date_116,
t103.step AS step_117,
t103.source AS source_118,
t103.legal_name AS legal_name_119,
t103.pack AS pack_120,
t103.manager_id AS manager_id_121,
t103.formality_id AS formality_id_122,
t103.organization_id AS organization_id_123,
t0.prescriber_source_id AS prescriber_source_id_124,
t0.reason_unpaid_id AS reason_unpaid_id_125,
t0.reason_ribinactive_id AS reason_ribinactive_id_126,
t127.id AS id_128,
t127.alternate_name AS alternate_name_129,
t127.legal_name AS legal_name_130,
t127.name_legal_representative AS name_legal_representative_131,
t127.organization_id AS organization_id_132,
t0.activity_category_id AS activity_category_id_133,
t0.referral_source_id AS referral_source_id_134,
t0.activity_domain_id AS activity_domain_id_135,
t136.id AS id_137,
t136.signature_request_id AS signature_request_id_138,
t136.created_at AS created_at_139,
t136.external_file_id AS external_file_id_140,
t136.last_uploaded_file_at AS last_uploaded_file_at_141,
t136.organization_id AS organization_id_142
FROM
organization t0
LEFT JOIN leads t103 ON t103.organization_id = t0.id
LEFT JOIN ibml_organization_configuration t127 ON t127.organization_id = t0.id
LEFT JOIN process_yousign t136 ON t136.organization_id = t0.id
WHERE
t0.id = ?
SELECT t0.id AS id_1, t0.legal_name AS legal_name_2, t0.telephone AS telephone_3, t0.vat_id AS vat_id_4, t0.legal_status AS legal_status_5, t0.purpose AS purpose_6, t0.founding_date AS founding_date_7, t0.fiscal_date AS fiscal_date_8, t0.fiscal_date_end AS fiscal_date_end_9, t0.first_fiscal_date AS first_fiscal_date_10, t0.first_fiscal_date_end AS first_fiscal_date_end_11, t0.head_quarters_address_type AS head_quarters_address_type_12, t0.legal_representative_address_type AS legal_representative_address_type_13, t0.share_capital AS share_capital_14, t0.share_capital_type AS share_capital_type_15, t0.share_capital_fixed_amount AS share_capital_fixed_amount_16, t0.shares_count AS shares_count_17, t0.bank_choice AS bank_choice_18, t0.registration_source AS registration_source_19, t0.commercial_court_registry AS commercial_court_registry_20, t0.sector_other AS sector_other_21, t0.rcs AS rcs_22, t0.status AS status_23, t0.email AS email_24, t0.mandatary AS mandatary_25, t0.bal AS bal_26, t0.forwarding_frequency AS forwarding_frequency_27, t0.forwarding_address_name AS forwarding_address_name_28, t0.alternate_name AS alternate_name_29, t0.domiciliation_start_date AS domiciliation_start_date_30, t0.created_at AS created_at_31, t0.termination_date AS termination_date_32, t0.termination_reason AS termination_reason_33, t0.termination_reason_other AS termination_reason_other_34, t0.siret AS siret_35, t0.is_new_immatriculation AS is_new_immatriculation_36, t0.is_new_domiciliation AS is_new_domiciliation_37, t0.mandat_id AS mandat_id_38, t0.conversion_reason AS conversion_reason_39, t0.status_is_forced AS status_is_forced_40, t0.uniq_id AS uniq_id_41, t0.iban AS iban_42, t0.reference_gocardless AS reference_gocardless_43, t0.is_forwarding_active AS is_forwarding_active_44, t0.vatrate AS vatrate_45, t0.is_imported AS is_imported_46, t0.credit_notes_amount AS credit_notes_amount_47, t0.available_credits AS available_credits_48, t0.invoice_token AS invoice_token_49, t0.share_capital_free_percentage AS share_capital_free_percentage_50, t0.is_prescriber AS is_prescriber_51, t0.have_accountant AS have_accountant_52, t0.status_immatriculation AS status_immatriculation_53, t0.is_exempt_tva AS is_exempt_tva_54, t0.project_stage AS project_stage_55, t0.status_invoice_payed AS status_invoice_payed_56, t0.date_max_unpaid AS date_max_unpaid_57, t0.is_have_auditor AS is_have_auditor_58, t0.benefit_imposition AS benefit_imposition_59, t0.benefit_imposition_option AS benefit_imposition_option_60, t0.vat_taxe_regim AS vat_taxe_regim_61, t0.vat_taxe_regime_option AS vat_taxe_regime_option_62, t0.prolongation_date_kyc AS prolongation_date_kyc_63, t0.status_transfert AS status_transfert_64, t0.is_new_transfert AS is_new_transfert_65, t0.special_request_bal AS special_request_bal_66, t0.trac_fin AS trac_fin_67, t0.trac_fin_note AS trac_fin_note_68, t0.pack_imat AS pack_imat_69, t0.is_authorize_prescriber AS is_authorize_prescriber_70, t0.is_attached_to_prescriber AS is_attached_to_prescriber_71, t0.is_emptybal AS is_emptybal_72, t0.is_authorized_debit AS is_authorized_debit_73, t0.history_nav_tunnel AS history_nav_tunnel_74, t0.note AS note_75, t0.reason_change AS reason_change_76, t0.previous_pack AS previous_pack_77, t0.zapier_hook_url AS zapier_hook_url_78, t0.sigle AS sigle_79, t0.enseigne AS enseigne_80, t0.corporate_object AS corporate_object_81, t0.place_know_digidom AS place_know_digidom_82, t0.other_place_known_digidom AS other_place_known_digidom_83, t0.bank_name AS bank_name_84, t0.titulaire AS titulaire_85, t0.is_invalid_email AS is_invalid_email_86, t0.is_invalid_phone_number AS is_invalid_phone_number_87, t0.special_customer_type AS special_customer_type_88, t0.encrypted_parent_id AS encrypted_parent_id_89, t0.is_referral_process_finished AS is_referral_process_finished_90, t0.is_digidom_accountant AS is_digidom_accountant_91, t0.is_surveillance AS is_surveillance_92, t0.beneficial_owners AS beneficial_owners_93, t0.accounts_submission_last_year AS accounts_submission_last_year_94, t0.address_id AS address_id_95, t0.accountant_id AS accountant_id_96, t0.sector_id AS sector_id_97, t0.store_id AS store_id_98, t0.forwarding_address_id AS forwarding_address_id_99, t0.prescriber_id AS prescriber_id_100, t0.notification_preference_id AS notification_preference_id_101, t0.discount_code_id AS discount_code_id_102, t103.id AS id_104, t103.given_name AS given_name_105, t103.family_name AS family_name_106, t103.phone_number AS phone_number_107, t103.email AS email_108, t103.service AS service_109, t103.created_at AS created_at_110, t103.note AS note_111, t103.status AS status_112, t103.generate_user AS generate_user_113, t103.call_time AS call_time_114, t103.priority AS priority_115, t103.date AS date_116, t103.step AS step_117, t103.source AS source_118, t103.legal_name AS legal_name_119, t103.pack AS pack_120, t103.manager_id AS manager_id_121, t103.formality_id AS formality_id_122, t103.organization_id AS organization_id_123, t0.prescriber_source_id AS prescriber_source_id_124, t0.reason_unpaid_id AS reason_unpaid_id_125, t0.reason_ribinactive_id AS reason_ribinactive_id_126, t127.id AS id_128, t127.alternate_name AS alternate_name_129, t127.legal_name AS legal_name_130, t127.name_legal_representative AS name_legal_representative_131, t127.organization_id AS organization_id_132, t0.activity_category_id AS activity_category_id_133, t0.referral_source_id AS referral_source_id_134, t0.activity_domain_id AS activity_domain_id_135, t136.id AS id_137, t136.signature_request_id AS signature_request_id_138, t136.created_at AS created_at_139, t136.external_file_id AS external_file_id_140, t136.last_uploaded_file_at AS last_uploaded_file_at_141, t136.organization_id AS organization_id_142 FROM organization t0 LEFT JOIN leads t103 ON t103.organization_id = t0.id LEFT JOIN ibml_organization_configuration t127 ON t127.organization_id = t0.id LEFT JOIN process_yousign t136 ON t136.organization_id = t0.id WHERE t0.id = '27867';
|