Symfony Profiler

SELECT
  a0_.id AS id_0,
  a0_.email AS email_1,
  a0_.phone_number AS phone_number_2,
  a0_.password AS password_3,
  a0_.roles AS roles_4,
  a0_.lastname AS lastname_5,
  a0_.firstname AS firstname_6,
  a0_.created_at AS created_at_7,
  a0_.registration_source AS registration_source_8,
  a0_.honorific_prefix AS honorific_prefix_9,
  a0_.reset_token AS reset_token_10,
  a0_.reset_token_expiration_date AS reset_token_expiration_date_11,
  a0_.uniq_id AS uniq_id_12,
  a0_.code_confirmation AS code_confirmation_13,
  a0_.updated_at AS updated_at_14,
  a0_.is_active AS is_active_15
FROM
  app_users a0_
WHERE
  a0_.email = ?
  OR a0_.phone_number = ?

SELECT a0_.id AS id_0, a0_.email AS email_1, a0_.phone_number AS phone_number_2, a0_.password AS password_3, a0_.roles AS roles_4, a0_.lastname AS lastname_5, a0_.firstname AS firstname_6, a0_.created_at AS created_at_7, a0_.registration_source AS registration_source_8, a0_.honorific_prefix AS honorific_prefix_9, a0_.reset_token AS reset_token_10, a0_.reset_token_expiration_date AS reset_token_expiration_date_11, a0_.uniq_id AS uniq_id_12, a0_.code_confirmation AS code_confirmation_13, a0_.updated_at AS updated_at_14, a0_.is_active AS is_active_15 FROM app_users a0_ WHERE a0_.email = 'florian@digidom.pro' OR a0_.phone_number = 'florian@digidom.pro';

SELECT
  t0.id AS id_1,
  t0.address_country AS address_country_2,
  t0.address_locality AS address_locality_3,
  t0.address_region AS address_region_4,
  t0.postal_code AS postal_code_5,
  t0.street_address AS street_address_6,
  t0.standardized_address AS standardized_address_7
FROM
  postal_address t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.address_country AS address_country_2, t0.address_locality AS address_locality_3, t0.address_region AS address_region_4, t0.postal_code AS postal_code_5, t0.street_address AS street_address_6, t0.standardized_address AS standardized_address_7 FROM postal_address t0 WHERE t0.id = 135979;

SELECT
  t0.id AS id_1,
  t0.courrier_mail AS courrier_mail_2,
  t0.courrier_push AS courrier_push_3,
  t0.courrier_reexpedition AS courrier_reexpedition_4,
  t0.colis_mail AS colis_mail_5,
  t0.colis_push AS colis_push_6,
  t0.colis_reexpedition AS colis_reexpedition_7,
  t0.reco_mail AS reco_mail_8,
  t0.reco_push AS reco_push_9,
  t0.reco_reexpedition AS reco_reexpedition_10,
  t0.commercial_mail AS commercial_mail_11,
  t0.commercial_phone AS commercial_phone_12,
  t13.id AS id_14,
  t13.legal_name AS legal_name_15,
  t13.telephone AS telephone_16,
  t13.vat_id AS vat_id_17,
  t13.legal_status AS legal_status_18,
  t13.purpose AS purpose_19,
  t13.founding_date AS founding_date_20,
  t13.fiscal_date AS fiscal_date_21,
  t13.fiscal_date_end AS fiscal_date_end_22,
  t13.first_fiscal_date AS first_fiscal_date_23,
  t13.first_fiscal_date_end AS first_fiscal_date_end_24,
  t13.head_quarters_address_type AS head_quarters_address_type_25,
  t13.legal_representative_address_type AS legal_representative_address_type_26,
  t13.share_capital AS share_capital_27,
  t13.share_capital_type AS share_capital_type_28,
  t13.share_capital_fixed_amount AS share_capital_fixed_amount_29,
  t13.shares_count AS shares_count_30,
  t13.bank_choice AS bank_choice_31,
  t13.registration_source AS registration_source_32,
  t13.commercial_court_registry AS commercial_court_registry_33,
  t13.sector_other AS sector_other_34,
  t13.rcs AS rcs_35,
  t13.status AS status_36,
  t13.email AS email_37,
  t13.mandatary AS mandatary_38,
  t13.bal AS bal_39,
  t13.forwarding_frequency AS forwarding_frequency_40,
  t13.forwarding_address_name AS forwarding_address_name_41,
  t13.alternate_name AS alternate_name_42,
  t13.domiciliation_start_date AS domiciliation_start_date_43,
  t13.created_at AS created_at_44,
  t13.termination_date AS termination_date_45,
  t13.termination_reason AS termination_reason_46,
  t13.termination_reason_other AS termination_reason_other_47,
  t13.siret AS siret_48,
  t13.is_new_immatriculation AS is_new_immatriculation_49,
  t13.is_new_domiciliation AS is_new_domiciliation_50,
  t13.mandat_id AS mandat_id_51,
  t13.conversion_reason AS conversion_reason_52,
  t13.status_is_forced AS status_is_forced_53,
  t13.uniq_id AS uniq_id_54,
  t13.iban AS iban_55,
  t13.reference_gocardless AS reference_gocardless_56,
  t13.is_forwarding_active AS is_forwarding_active_57,
  t13.vatrate AS vatrate_58,
  t13.is_imported AS is_imported_59,
  t13.credit_notes_amount AS credit_notes_amount_60,
  t13.available_credits AS available_credits_61,
  t13.invoice_token AS invoice_token_62,
  t13.share_capital_free_percentage AS share_capital_free_percentage_63,
  t13.is_prescriber AS is_prescriber_64,
  t13.have_accountant AS have_accountant_65,
  t13.status_immatriculation AS status_immatriculation_66,
  t13.is_exempt_tva AS is_exempt_tva_67,
  t13.project_stage AS project_stage_68,
  t13.status_invoice_payed AS status_invoice_payed_69,
  t13.date_max_unpaid AS date_max_unpaid_70,
  t13.is_have_auditor AS is_have_auditor_71,
  t13.benefit_imposition AS benefit_imposition_72,
  t13.benefit_imposition_option AS benefit_imposition_option_73,
  t13.vat_taxe_regim AS vat_taxe_regim_74,
  t13.vat_taxe_regime_option AS vat_taxe_regime_option_75,
  t13.prolongation_date_kyc AS prolongation_date_kyc_76,
  t13.status_transfert AS status_transfert_77,
  t13.is_new_transfert AS is_new_transfert_78,
  t13.special_request_bal AS special_request_bal_79,
  t13.trac_fin AS trac_fin_80,
  t13.trac_fin_note AS trac_fin_note_81,
  t13.pack_imat AS pack_imat_82,
  t13.is_authorize_prescriber AS is_authorize_prescriber_83,
  t13.is_attached_to_prescriber AS is_attached_to_prescriber_84,
  t13.is_emptybal AS is_emptybal_85,
  t13.is_authorized_debit AS is_authorized_debit_86,
  t13.history_nav_tunnel AS history_nav_tunnel_87,
  t13.note AS note_88,
  t13.reason_change AS reason_change_89,
  t13.previous_pack AS previous_pack_90,
  t13.zapier_hook_url AS zapier_hook_url_91,
  t13.sigle AS sigle_92,
  t13.enseigne AS enseigne_93,
  t13.corporate_object AS corporate_object_94,
  t13.place_know_digidom AS place_know_digidom_95,
  t13.other_place_known_digidom AS other_place_known_digidom_96,
  t13.bank_name AS bank_name_97,
  t13.titulaire AS titulaire_98,
  t13.is_invalid_email AS is_invalid_email_99,
  t13.is_invalid_phone_number AS is_invalid_phone_number_100,
  t13.special_customer_type AS special_customer_type_101,
  t13.encrypted_parent_id AS encrypted_parent_id_102,
  t13.is_referral_process_finished AS is_referral_process_finished_103,
  t13.is_digidom_accountant AS is_digidom_accountant_104,
  t13.is_surveillance AS is_surveillance_105,
  t13.beneficial_owners AS beneficial_owners_106,
  t13.accounts_submission_last_year AS accounts_submission_last_year_107,
  t13.address_id AS address_id_108,
  t13.accountant_id AS accountant_id_109,
  t13.sector_id AS sector_id_110,
  t13.store_id AS store_id_111,
  t13.forwarding_address_id AS forwarding_address_id_112,
  t13.prescriber_id AS prescriber_id_113,
  t13.notification_preference_id AS notification_preference_id_114,
  t13.discount_code_id AS discount_code_id_115,
  t13.prescriber_source_id AS prescriber_source_id_116,
  t13.reason_unpaid_id AS reason_unpaid_id_117,
  t13.reason_ribinactive_id AS reason_ribinactive_id_118,
  t13.activity_category_id AS activity_category_id_119,
  t13.referral_source_id AS referral_source_id_120,
  t13.activity_domain_id AS activity_domain_id_121
FROM
  notification_preference t0
  LEFT JOIN organization t13 ON t13.notification_preference_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.courrier_mail AS courrier_mail_2, t0.courrier_push AS courrier_push_3, t0.courrier_reexpedition AS courrier_reexpedition_4, t0.colis_mail AS colis_mail_5, t0.colis_push AS colis_push_6, t0.colis_reexpedition AS colis_reexpedition_7, t0.reco_mail AS reco_mail_8, t0.reco_push AS reco_push_9, t0.reco_reexpedition AS reco_reexpedition_10, t0.commercial_mail AS commercial_mail_11, t0.commercial_phone AS commercial_phone_12, t13.id AS id_14, t13.legal_name AS legal_name_15, t13.telephone AS telephone_16, t13.vat_id AS vat_id_17, t13.legal_status AS legal_status_18, t13.purpose AS purpose_19, t13.founding_date AS founding_date_20, t13.fiscal_date AS fiscal_date_21, t13.fiscal_date_end AS fiscal_date_end_22, t13.first_fiscal_date AS first_fiscal_date_23, t13.first_fiscal_date_end AS first_fiscal_date_end_24, t13.head_quarters_address_type AS head_quarters_address_type_25, t13.legal_representative_address_type AS legal_representative_address_type_26, t13.share_capital AS share_capital_27, t13.share_capital_type AS share_capital_type_28, t13.share_capital_fixed_amount AS share_capital_fixed_amount_29, t13.shares_count AS shares_count_30, t13.bank_choice AS bank_choice_31, t13.registration_source AS registration_source_32, t13.commercial_court_registry AS commercial_court_registry_33, t13.sector_other AS sector_other_34, t13.rcs AS rcs_35, t13.status AS status_36, t13.email AS email_37, t13.mandatary AS mandatary_38, t13.bal AS bal_39, t13.forwarding_frequency AS forwarding_frequency_40, t13.forwarding_address_name AS forwarding_address_name_41, t13.alternate_name AS alternate_name_42, t13.domiciliation_start_date AS domiciliation_start_date_43, t13.created_at AS created_at_44, t13.termination_date AS termination_date_45, t13.termination_reason AS termination_reason_46, t13.termination_reason_other AS termination_reason_other_47, t13.siret AS siret_48, t13.is_new_immatriculation AS is_new_immatriculation_49, t13.is_new_domiciliation AS is_new_domiciliation_50, t13.mandat_id AS mandat_id_51, t13.conversion_reason AS conversion_reason_52, t13.status_is_forced AS status_is_forced_53, t13.uniq_id AS uniq_id_54, t13.iban AS iban_55, t13.reference_gocardless AS reference_gocardless_56, t13.is_forwarding_active AS is_forwarding_active_57, t13.vatrate AS vatrate_58, t13.is_imported AS is_imported_59, t13.credit_notes_amount AS credit_notes_amount_60, t13.available_credits AS available_credits_61, t13.invoice_token AS invoice_token_62, t13.share_capital_free_percentage AS share_capital_free_percentage_63, t13.is_prescriber AS is_prescriber_64, t13.have_accountant AS have_accountant_65, t13.status_immatriculation AS status_immatriculation_66, t13.is_exempt_tva AS is_exempt_tva_67, t13.project_stage AS project_stage_68, t13.status_invoice_payed AS status_invoice_payed_69, t13.date_max_unpaid AS date_max_unpaid_70, t13.is_have_auditor AS is_have_auditor_71, t13.benefit_imposition AS benefit_imposition_72, t13.benefit_imposition_option AS benefit_imposition_option_73, t13.vat_taxe_regim AS vat_taxe_regim_74, t13.vat_taxe_regime_option AS vat_taxe_regime_option_75, t13.prolongation_date_kyc AS prolongation_date_kyc_76, t13.status_transfert AS status_transfert_77, t13.is_new_transfert AS is_new_transfert_78, t13.special_request_bal AS special_request_bal_79, t13.trac_fin AS trac_fin_80, t13.trac_fin_note AS trac_fin_note_81, t13.pack_imat AS pack_imat_82, t13.is_authorize_prescriber AS is_authorize_prescriber_83, t13.is_attached_to_prescriber AS is_attached_to_prescriber_84, t13.is_emptybal AS is_emptybal_85, t13.is_authorized_debit AS is_authorized_debit_86, t13.history_nav_tunnel AS history_nav_tunnel_87, t13.note AS note_88, t13.reason_change AS reason_change_89, t13.previous_pack AS previous_pack_90, t13.zapier_hook_url AS zapier_hook_url_91, t13.sigle AS sigle_92, t13.enseigne AS enseigne_93, t13.corporate_object AS corporate_object_94, t13.place_know_digidom AS place_know_digidom_95, t13.other_place_known_digidom AS other_place_known_digidom_96, t13.bank_name AS bank_name_97, t13.titulaire AS titulaire_98, t13.is_invalid_email AS is_invalid_email_99, t13.is_invalid_phone_number AS is_invalid_phone_number_100, t13.special_customer_type AS special_customer_type_101, t13.encrypted_parent_id AS encrypted_parent_id_102, t13.is_referral_process_finished AS is_referral_process_finished_103, t13.is_digidom_accountant AS is_digidom_accountant_104, t13.is_surveillance AS is_surveillance_105, t13.beneficial_owners AS beneficial_owners_106, t13.accounts_submission_last_year AS accounts_submission_last_year_107, t13.address_id AS address_id_108, t13.accountant_id AS accountant_id_109, t13.sector_id AS sector_id_110, t13.store_id AS store_id_111, t13.forwarding_address_id AS forwarding_address_id_112, t13.prescriber_id AS prescriber_id_113, t13.notification_preference_id AS notification_preference_id_114, t13.discount_code_id AS discount_code_id_115, t13.prescriber_source_id AS prescriber_source_id_116, t13.reason_unpaid_id AS reason_unpaid_id_117, t13.reason_ribinactive_id AS reason_ribinactive_id_118, t13.activity_category_id AS activity_category_id_119, t13.referral_source_id AS referral_source_id_120, t13.activity_domain_id AS activity_domain_id_121 FROM notification_preference t0 LEFT JOIN organization t13 ON t13.notification_preference_id = t0.id WHERE t0.id = 9706;

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.accountant_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.accountant_id = 16146;

SELECT
  t0.id AS id_1,
  t0.active AS active_2,
  t0.price AS price_3,
  t0.type AS type_4,
  t0.subscription_deposit AS subscription_deposit_5,
  t0.created_at AS created_at_6,
  t0.discount_without_tax AS discount_without_tax_7,
  t0.payment_dates AS payment_dates_8,
  t0.price_without_tax AS price_without_tax_9,
  t0.stored_total_price_without_tax AS stored_total_price_without_tax_10,
  t0.is_updated_price AS is_updated_price_11,
  t0.next_payment AS next_payment_12,
  t0.pack_history AS pack_history_13,
  t0.not_accepted_scan_enveloppe AS not_accepted_scan_enveloppe_14,
  t0.invoice_generation_date AS invoice_generation_date_15,
  t0.month_number AS month_number_16,
  t0.authorized_reccurency AS authorized_reccurency_17,
  t0.is_cancel_using_offer AS is_cancel_using_offer_18,
  t0.is_digipack_offer AS is_digipack_offer_19,
  t0.deadline_offered AS deadline_offered_20,
  t0.prepaid_months AS prepaid_months_21,
  t0.has_blocked_service AS has_blocked_service_22,
  t0.document_recovery_delay AS document_recovery_delay_23,
  t0.updated_at AS updated_at_24,
  t0.organization_id AS organization_id_25,
  t26.id AS id_27,
  t26.name AS name_28,
  t26.price AS price_29,
  t26.focus AS focus_30,
  t26.price_without_tax AS price_without_tax_31,
  t26.vat_rate AS vat_rate_32,
  t26.discount AS discount_33,
  t26.unique_key AS unique_key_34,
  t26.automation AS automation_35,
  t26.is_published AS is_published_36,
  t26.is_subscription AS is_subscription_37,
  t26.published_name AS published_name_38,
  t26.is_published_pack AS is_published_pack_39,
  t26.type AS type_40,
  t26.legal_status AS legal_status_41,
  t26.created_at AS created_at_42,
  t26.association_pack_id AS association_pack_id_43,
  t26.category_id AS category_id_44,
  t26.recurring_invoice_id AS recurring_invoice_id_45,
  t26.initial_invoice_id AS initial_invoice_id_46,
  t26.subscription_id AS subscription_id_47
FROM
  subscription t0
  LEFT JOIN pack t26 ON t26.subscription_id = t0.id
WHERE
  t0.organization_id = ?

SELECT t0.id AS id_1, t0.active AS active_2, t0.price AS price_3, t0.type AS type_4, t0.subscription_deposit AS subscription_deposit_5, t0.created_at AS created_at_6, t0.discount_without_tax AS discount_without_tax_7, t0.payment_dates AS payment_dates_8, t0.price_without_tax AS price_without_tax_9, t0.stored_total_price_without_tax AS stored_total_price_without_tax_10, t0.is_updated_price AS is_updated_price_11, t0.next_payment AS next_payment_12, t0.pack_history AS pack_history_13, t0.not_accepted_scan_enveloppe AS not_accepted_scan_enveloppe_14, t0.invoice_generation_date AS invoice_generation_date_15, t0.month_number AS month_number_16, t0.authorized_reccurency AS authorized_reccurency_17, t0.is_cancel_using_offer AS is_cancel_using_offer_18, t0.is_digipack_offer AS is_digipack_offer_19, t0.deadline_offered AS deadline_offered_20, t0.prepaid_months AS prepaid_months_21, t0.has_blocked_service AS has_blocked_service_22, t0.document_recovery_delay AS document_recovery_delay_23, t0.updated_at AS updated_at_24, t0.organization_id AS organization_id_25, t26.id AS id_27, t26.name AS name_28, t26.price AS price_29, t26.focus AS focus_30, t26.price_without_tax AS price_without_tax_31, t26.vat_rate AS vat_rate_32, t26.discount AS discount_33, t26.unique_key AS unique_key_34, t26.automation AS automation_35, t26.is_published AS is_published_36, t26.is_subscription AS is_subscription_37, t26.published_name AS published_name_38, t26.is_published_pack AS is_published_pack_39, t26.type AS type_40, t26.legal_status AS legal_status_41, t26.created_at AS created_at_42, t26.association_pack_id AS association_pack_id_43, t26.category_id AS category_id_44, t26.recurring_invoice_id AS recurring_invoice_id_45, t26.initial_invoice_id AS initial_invoice_id_46, t26.subscription_id AS subscription_id_47 FROM subscription t0 LEFT JOIN pack t26 ON t26.subscription_id = t0.id WHERE t0.organization_id = 27108;

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.prescriber_id = ?