Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.date_created AS date_created_2,
  t0.email AS email_3,
  t0.username AS username_4,
  t0.password AS password_5,
  t0.last_name AS last_name_6,
  t0.first_name AS first_name_7,
  t0.code_conseiller AS code_conseiller_8,
  t0.numero_siren AS numero_siren_9,
  t0.phone_prefix AS phone_prefix_10,
  t0.phone AS phone_11,
  t0.sex AS sex_12,
  t0.date_de_naissance AS date_de_naissance_13,
  t0.numero_de_voie AS numero_de_voie_14,
  t0.code_postal AS code_postal_15,
  t0.ville AS ville_16,
  t0.pays AS pays_17,
  t0.token_reset AS token_reset_18,
  t0.status AS status_19,
  t0.adherent_distributeur AS adherent_distributeur_20,
  t0.dic_is_file AS dic_is_file_21,
  t0.roles AS roles_22,
  t0.current_sign AS current_sign_23,
  t0.token_signup_continue AS token_signup_continue_24,
  t0.step_signup AS step_signup_25,
  t0.is_auto_signup AS is_auto_signup_26,
  t0.send_mail_reminder7 AS send_mail_reminder7_27,
  t0.send_mail_reminder7_date AS send_mail_reminder7_date_28,
  t0.send_mail_reminder14 AS send_mail_reminder14_29,
  t0.auto_sign_folder_number AS auto_sign_folder_number_30,
  t0.adresse_fiscale_france AS adresse_fiscale_france_31,
  t0.accept_conditions_generales_utilisation AS accept_conditions_generales_utilisation_32,
  t0.connaissance_protection_donnees_personnelles AS connaissance_protection_donnees_personnelles_33,
  t0.accepte_recevoir_proposition_commercial_mail_telephone AS accepte_recevoir_proposition_commercial_mail_telephone_34,
  t0.method_for_sign_email AS method_for_sign_email_35,
  t0.date_auto_deleted AS date_auto_deleted_36,
  t0.last_open_date AS last_open_date_37,
  t0.accept_recevoir_document_garantie_email AS accept_recevoir_document_garantie_email_38,
  t0.accept_proposition_commercial_email AS accept_proposition_commercial_email_39,
  t0.accept_proposition_commercial_telephone AS accept_proposition_commercial_telephone_40,
  t0.seller_can_epargne AS seller_can_epargne_41,
  t0.seller_can_retraite AS seller_can_retraite_42,
  t0.seller_interne AS seller_interne_43,
  t0.crm_exploitable AS crm_exploitable_44,
  t0.crm_status AS crm_status_45,
  t0.crm_status_date_change AS crm_status_date_change_46,
  t0.crm_notes AS crm_notes_47,
  t0.crm_type_signature AS crm_type_signature_48,
  t0.last_login AS last_login_49,
  t0.crm_seller_id AS crm_seller_id_50,
  t0.seller_old_id AS seller_old_id_51
FROM
  69pixl_user t0
WHERE
  t0.token_signup_continue = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.date_created AS date_created_2, t0.email AS email_3, t0.username AS username_4, t0.password AS password_5, t0.last_name AS last_name_6, t0.first_name AS first_name_7, t0.code_conseiller AS code_conseiller_8, t0.numero_siren AS numero_siren_9, t0.phone_prefix AS phone_prefix_10, t0.phone AS phone_11, t0.sex AS sex_12, t0.date_de_naissance AS date_de_naissance_13, t0.numero_de_voie AS numero_de_voie_14, t0.code_postal AS code_postal_15, t0.ville AS ville_16, t0.pays AS pays_17, t0.token_reset AS token_reset_18, t0.status AS status_19, t0.adherent_distributeur AS adherent_distributeur_20, t0.dic_is_file AS dic_is_file_21, t0.roles AS roles_22, t0.current_sign AS current_sign_23, t0.token_signup_continue AS token_signup_continue_24, t0.step_signup AS step_signup_25, t0.is_auto_signup AS is_auto_signup_26, t0.send_mail_reminder7 AS send_mail_reminder7_27, t0.send_mail_reminder7_date AS send_mail_reminder7_date_28, t0.send_mail_reminder14 AS send_mail_reminder14_29, t0.auto_sign_folder_number AS auto_sign_folder_number_30, t0.adresse_fiscale_france AS adresse_fiscale_france_31, t0.accept_conditions_generales_utilisation AS accept_conditions_generales_utilisation_32, t0.connaissance_protection_donnees_personnelles AS connaissance_protection_donnees_personnelles_33, t0.accepte_recevoir_proposition_commercial_mail_telephone AS accepte_recevoir_proposition_commercial_mail_telephone_34, t0.method_for_sign_email AS method_for_sign_email_35, t0.date_auto_deleted AS date_auto_deleted_36, t0.last_open_date AS last_open_date_37, t0.accept_recevoir_document_garantie_email AS accept_recevoir_document_garantie_email_38, t0.accept_proposition_commercial_email AS accept_proposition_commercial_email_39, t0.accept_proposition_commercial_telephone AS accept_proposition_commercial_telephone_40, t0.seller_can_epargne AS seller_can_epargne_41, t0.seller_can_retraite AS seller_can_retraite_42, t0.seller_interne AS seller_interne_43, t0.crm_exploitable AS crm_exploitable_44, t0.crm_status AS crm_status_45, t0.crm_status_date_change AS crm_status_date_change_46, t0.crm_notes AS crm_notes_47, t0.crm_type_signature AS crm_type_signature_48, t0.last_login AS last_login_49, t0.crm_seller_id AS crm_seller_id_50, t0.seller_old_id AS seller_old_id_51 FROM 69pixl_user t0 WHERE t0.token_signup_continue = 'fdf8f87ada8fd0606b0ee50666445012256b97be' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  69pixl_user
SET
  last_login = ?
WHERE
  id = ?

UPDATE 69pixl_user SET last_login = '2025-12-17 06:42:33' WHERE id = 2880;

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.status AS status_2,
  t0.validated_files_by_customer AS validated_files_by_customer_3,
  t0.validated_files_by_customer_date AS validated_files_by_customer_date_4,
  t0.validated_files_by_seller AS validated_files_by_seller_5,
  t0.validated_files_by_seller_date AS validated_files_by_seller_date_6,
  t0.validated_folder_by_seller AS validated_folder_by_seller_7,
  t0.validated_folder_by_seller_date AS validated_folder_by_seller_date_8,
  t0.validated_folder_by_customer AS validated_folder_by_customer_9,
  t0.validated_folder_by_customer_date AS validated_folder_by_customer_date_10,
  t0.validated_dic_status AS validated_dic_status_11,
  t0.validated_dic_date AS validated_dic_date_12,
  t0.validated_dic_accept AS validated_dic_accept_13,
  t0.validated_fic_status AS validated_fic_status_14,
  t0.validated_fic_date AS validated_fic_date_15,
  t0.validated_fic_accept AS validated_fic_accept_16,
  t0.validated_ba_status AS validated_ba_status_17,
  t0.validated_ba_date AS validated_ba_date_18,
  t0.validated_ba_accept AS validated_ba_accept_19,
  t0.validated_sepa_status AS validated_sepa_status_20,
  t0.validated_sepa_date AS validated_sepa_date_21,
  t0.validated_sepa_accept AS validated_sepa_accept_22,
  t0.validated_status_status AS validated_status_status_23,
  t0.validated_status_date AS validated_status_date_24,
  t0.validated_status_accept AS validated_status_accept_25,
  t0.validated_reglement_status AS validated_reglement_status_26,
  t0.validated_reglement_date AS validated_reglement_date_27,
  t0.validated_reglement_accept AS validated_reglement_accept_28,
  t0.with_representant_legal1 AS with_representant_legal1_29,
  t0.with_representant_legal2 AS with_representant_legal2_30,
  t0.url_sign AS url_sign_31,
  t0.url_sign_seller AS url_sign_seller_32,
  t0.signed_seller AS signed_seller_33,
  t0.signed_seller_hooks AS signed_seller_hooks_34,
  t0.number_membership_folder AS number_membership_folder_35,
  t0.mail_send_customer AS mail_send_customer_36,
  t0.mail_send_seller AS mail_send_seller_37,
  t0.mail_send_gestion AS mail_send_gestion_38,
  t0.error_you_sign AS error_you_sign_39,
  t0.platform_version AS platform_version_40,
  t0.yousign_version AS yousign_version_41,
  t0.documents_version AS documents_version_42,
  t0.sign_date AS sign_date_43,
  t0.member_id AS member_id_44,
  t0.member_legal1_id AS member_legal1_id_45,
  t0.member_legal2_id AS member_legal2_id_46,
  t0.seller_member_id AS seller_member_id_47,
  t0.procedure_id AS procedure_id_48,
  t0.member_legal1_sign AS member_legal1_sign_49,
  t0.member_legal2_sign AS member_legal2_sign_50,
  t0.product AS product_51,
  t0.send_mail_no_sign AS send_mail_no_sign_52,
  t0.send_mail_no_sign_date AS send_mail_no_sign_date_53,
  t0.start_procedure_sign_date AS start_procedure_sign_date_54,
  t0.send_mail_reminder7 AS send_mail_reminder7_55,
  t0.send_mail_reminder21 AS send_mail_reminder21_56,
  t0.initial_fullweb AS initial_fullweb_57,
  t0.dic_is_file AS dic_is_file_58,
  t0.seller_id AS seller_id_59,
  t0.user_id AS user_id_60,
  t0.dic_id AS dic_id_61,
  t0.fic_id AS fic_id_62,
  t0.ba_id AS ba_id_63
FROM
  69pixl_membership t0
WHERE
  t0.user_id = ?
ORDER BY
  t0.id DESC
LIMIT
  1

SELECT t0.id AS id_1, t0.status AS status_2, t0.validated_files_by_customer AS validated_files_by_customer_3, t0.validated_files_by_customer_date AS validated_files_by_customer_date_4, t0.validated_files_by_seller AS validated_files_by_seller_5, t0.validated_files_by_seller_date AS validated_files_by_seller_date_6, t0.validated_folder_by_seller AS validated_folder_by_seller_7, t0.validated_folder_by_seller_date AS validated_folder_by_seller_date_8, t0.validated_folder_by_customer AS validated_folder_by_customer_9, t0.validated_folder_by_customer_date AS validated_folder_by_customer_date_10, t0.validated_dic_status AS validated_dic_status_11, t0.validated_dic_date AS validated_dic_date_12, t0.validated_dic_accept AS validated_dic_accept_13, t0.validated_fic_status AS validated_fic_status_14, t0.validated_fic_date AS validated_fic_date_15, t0.validated_fic_accept AS validated_fic_accept_16, t0.validated_ba_status AS validated_ba_status_17, t0.validated_ba_date AS validated_ba_date_18, t0.validated_ba_accept AS validated_ba_accept_19, t0.validated_sepa_status AS validated_sepa_status_20, t0.validated_sepa_date AS validated_sepa_date_21, t0.validated_sepa_accept AS validated_sepa_accept_22, t0.validated_status_status AS validated_status_status_23, t0.validated_status_date AS validated_status_date_24, t0.validated_status_accept AS validated_status_accept_25, t0.validated_reglement_status AS validated_reglement_status_26, t0.validated_reglement_date AS validated_reglement_date_27, t0.validated_reglement_accept AS validated_reglement_accept_28, t0.with_representant_legal1 AS with_representant_legal1_29, t0.with_representant_legal2 AS with_representant_legal2_30, t0.url_sign AS url_sign_31, t0.url_sign_seller AS url_sign_seller_32, t0.signed_seller AS signed_seller_33, t0.signed_seller_hooks AS signed_seller_hooks_34, t0.number_membership_folder AS number_membership_folder_35, t0.mail_send_customer AS mail_send_customer_36, t0.mail_send_seller AS mail_send_seller_37, t0.mail_send_gestion AS mail_send_gestion_38, t0.error_you_sign AS error_you_sign_39, t0.platform_version AS platform_version_40, t0.yousign_version AS yousign_version_41, t0.documents_version AS documents_version_42, t0.sign_date AS sign_date_43, t0.member_id AS member_id_44, t0.member_legal1_id AS member_legal1_id_45, t0.member_legal2_id AS member_legal2_id_46, t0.seller_member_id AS seller_member_id_47, t0.procedure_id AS procedure_id_48, t0.member_legal1_sign AS member_legal1_sign_49, t0.member_legal2_sign AS member_legal2_sign_50, t0.product AS product_51, t0.send_mail_no_sign AS send_mail_no_sign_52, t0.send_mail_no_sign_date AS send_mail_no_sign_date_53, t0.start_procedure_sign_date AS start_procedure_sign_date_54, t0.send_mail_reminder7 AS send_mail_reminder7_55, t0.send_mail_reminder21 AS send_mail_reminder21_56, t0.initial_fullweb AS initial_fullweb_57, t0.dic_is_file AS dic_is_file_58, t0.seller_id AS seller_id_59, t0.user_id AS user_id_60, t0.dic_id AS dic_id_61, t0.fic_id AS fic_id_62, t0.ba_id AS ba_id_63 FROM 69pixl_membership t0 WHERE t0.user_id = 2880 ORDER BY t0.id DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.status AS status_2,
  t0.validated_files_by_customer AS validated_files_by_customer_3,
  t0.validated_files_by_customer_date AS validated_files_by_customer_date_4,
  t0.validated_files_by_seller AS validated_files_by_seller_5,
  t0.validated_files_by_seller_date AS validated_files_by_seller_date_6,
  t0.validated_folder_by_seller AS validated_folder_by_seller_7,
  t0.validated_folder_by_seller_date AS validated_folder_by_seller_date_8,
  t0.validated_folder_by_customer AS validated_folder_by_customer_9,
  t0.validated_folder_by_customer_date AS validated_folder_by_customer_date_10,
  t0.validated_dic_status AS validated_dic_status_11,
  t0.validated_dic_date AS validated_dic_date_12,
  t0.validated_dic_accept AS validated_dic_accept_13,
  t0.validated_fic_status AS validated_fic_status_14,
  t0.validated_fic_date AS validated_fic_date_15,
  t0.validated_fic_accept AS validated_fic_accept_16,
  t0.validated_ba_status AS validated_ba_status_17,
  t0.validated_ba_date AS validated_ba_date_18,
  t0.validated_ba_accept AS validated_ba_accept_19,
  t0.validated_sepa_status AS validated_sepa_status_20,
  t0.validated_sepa_date AS validated_sepa_date_21,
  t0.validated_sepa_accept AS validated_sepa_accept_22,
  t0.validated_status_status AS validated_status_status_23,
  t0.validated_status_date AS validated_status_date_24,
  t0.validated_status_accept AS validated_status_accept_25,
  t0.validated_reglement_status AS validated_reglement_status_26,
  t0.validated_reglement_date AS validated_reglement_date_27,
  t0.validated_reglement_accept AS validated_reglement_accept_28,
  t0.with_representant_legal1 AS with_representant_legal1_29,
  t0.with_representant_legal2 AS with_representant_legal2_30,
  t0.url_sign AS url_sign_31,
  t0.url_sign_seller AS url_sign_seller_32,
  t0.signed_seller AS signed_seller_33,
  t0.signed_seller_hooks AS signed_seller_hooks_34,
  t0.number_membership_folder AS number_membership_folder_35,
  t0.mail_send_customer AS mail_send_customer_36,
  t0.mail_send_seller AS mail_send_seller_37,
  t0.mail_send_gestion AS mail_send_gestion_38,
  t0.error_you_sign AS error_you_sign_39,
  t0.platform_version AS platform_version_40,
  t0.yousign_version AS yousign_version_41,
  t0.documents_version AS documents_version_42,
  t0.sign_date AS sign_date_43,
  t0.member_id AS member_id_44,
  t0.member_legal1_id AS member_legal1_id_45,
  t0.member_legal2_id AS member_legal2_id_46,
  t0.seller_member_id AS seller_member_id_47,
  t0.procedure_id AS procedure_id_48,
  t0.member_legal1_sign AS member_legal1_sign_49,
  t0.member_legal2_sign AS member_legal2_sign_50,
  t0.product AS product_51,
  t0.send_mail_no_sign AS send_mail_no_sign_52,
  t0.send_mail_no_sign_date AS send_mail_no_sign_date_53,
  t0.start_procedure_sign_date AS start_procedure_sign_date_54,
  t0.send_mail_reminder7 AS send_mail_reminder7_55,
  t0.send_mail_reminder21 AS send_mail_reminder21_56,
  t0.initial_fullweb AS initial_fullweb_57,
  t0.dic_is_file AS dic_is_file_58,
  t0.seller_id AS seller_id_59,
  t0.user_id AS user_id_60,
  t0.dic_id AS dic_id_61,
  t0.fic_id AS fic_id_62,
  t0.ba_id AS ba_id_63
FROM
  69pixl_membership t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.status AS status_2, t0.validated_files_by_customer AS validated_files_by_customer_3, t0.validated_files_by_customer_date AS validated_files_by_customer_date_4, t0.validated_files_by_seller AS validated_files_by_seller_5, t0.validated_files_by_seller_date AS validated_files_by_seller_date_6, t0.validated_folder_by_seller AS validated_folder_by_seller_7, t0.validated_folder_by_seller_date AS validated_folder_by_seller_date_8, t0.validated_folder_by_customer AS validated_folder_by_customer_9, t0.validated_folder_by_customer_date AS validated_folder_by_customer_date_10, t0.validated_dic_status AS validated_dic_status_11, t0.validated_dic_date AS validated_dic_date_12, t0.validated_dic_accept AS validated_dic_accept_13, t0.validated_fic_status AS validated_fic_status_14, t0.validated_fic_date AS validated_fic_date_15, t0.validated_fic_accept AS validated_fic_accept_16, t0.validated_ba_status AS validated_ba_status_17, t0.validated_ba_date AS validated_ba_date_18, t0.validated_ba_accept AS validated_ba_accept_19, t0.validated_sepa_status AS validated_sepa_status_20, t0.validated_sepa_date AS validated_sepa_date_21, t0.validated_sepa_accept AS validated_sepa_accept_22, t0.validated_status_status AS validated_status_status_23, t0.validated_status_date AS validated_status_date_24, t0.validated_status_accept AS validated_status_accept_25, t0.validated_reglement_status AS validated_reglement_status_26, t0.validated_reglement_date AS validated_reglement_date_27, t0.validated_reglement_accept AS validated_reglement_accept_28, t0.with_representant_legal1 AS with_representant_legal1_29, t0.with_representant_legal2 AS with_representant_legal2_30, t0.url_sign AS url_sign_31, t0.url_sign_seller AS url_sign_seller_32, t0.signed_seller AS signed_seller_33, t0.signed_seller_hooks AS signed_seller_hooks_34, t0.number_membership_folder AS number_membership_folder_35, t0.mail_send_customer AS mail_send_customer_36, t0.mail_send_seller AS mail_send_seller_37, t0.mail_send_gestion AS mail_send_gestion_38, t0.error_you_sign AS error_you_sign_39, t0.platform_version AS platform_version_40, t0.yousign_version AS yousign_version_41, t0.documents_version AS documents_version_42, t0.sign_date AS sign_date_43, t0.member_id AS member_id_44, t0.member_legal1_id AS member_legal1_id_45, t0.member_legal2_id AS member_legal2_id_46, t0.seller_member_id AS seller_member_id_47, t0.procedure_id AS procedure_id_48, t0.member_legal1_sign AS member_legal1_sign_49, t0.member_legal2_sign AS member_legal2_sign_50, t0.product AS product_51, t0.send_mail_no_sign AS send_mail_no_sign_52, t0.send_mail_no_sign_date AS send_mail_no_sign_date_53, t0.start_procedure_sign_date AS start_procedure_sign_date_54, t0.send_mail_reminder7 AS send_mail_reminder7_55, t0.send_mail_reminder21 AS send_mail_reminder21_56, t0.initial_fullweb AS initial_fullweb_57, t0.dic_is_file AS dic_is_file_58, t0.seller_id AS seller_id_59, t0.user_id AS user_id_60, t0.dic_id AS dic_id_61, t0.fic_id AS fic_id_62, t0.ba_id AS ba_id_63 FROM 69pixl_membership t0 WHERE t0.user_id = 2880;

SELECT
  t0.id AS id_1,
  t0.sex AS sex_2,
  t0.nom AS nom_3,
  t0.prenom AS prenom_4,
  t0.date_de_naissance AS date_de_naissance_5,
  t0.lieu_de_naissance AS lieu_de_naissance_6,
  t0.nationalite AS nationalite_7,
  t0.adresse_fiscale_residence_france AS adresse_fiscale_residence_france_8,
  t0.adresse_fiscale AS adresse_fiscale_9,
  t0.adresse_fiscale_code_postal AS adresse_fiscale_code_postal_10,
  t0.adresse_postale AS adresse_postale_11,
  t0.adresse_pays AS adresse_pays_12,
  t0.adresse_ville AS adresse_ville_13,
  t0.adresse_code_postal AS adresse_code_postal_14,
  t0.adresse_fiscale_ville AS adresse_fiscale_ville_15,
  t0.adresse_fiscale_pays AS adresse_fiscale_pays_16,
  t0.telephone AS telephone_17,
  t0.tel_fix_prefix AS tel_fix_prefix_18,
  t0.tel_fix AS tel_fix_19,
  t0.email AS email_20,
  t0.accept_recevoir_document_garantie_email AS accept_recevoir_document_garantie_email_21,
  t0.accept_proposition_commercial_email AS accept_proposition_commercial_email_22,
  t0.accept_proposition_commercial_telephone AS accept_proposition_commercial_telephone_23,
  t0.accept_information_garantie AS accept_information_garantie_24,
  t0.personne_politiquement_exposee AS personne_politiquement_exposee_25,
  t0.personne_politiquement_exposee_type AS personne_politiquement_exposee_type_26,
  t0.personne_politiquement_exposee_ma_fonction AS personne_politiquement_exposee_ma_fonction_27,
  t0.personne_politiquement_exposee_entourage_nom AS personne_politiquement_exposee_entourage_nom_28,
  t0.personne_politiquement_exposee_entourage_fonction AS personne_politiquement_exposee_entourage_fonction_29,
  t0.personne_politiquement_exposee_entourage_lien AS personne_politiquement_exposee_entourage_lien_30,
  t0.green_card AS green_card_31,
  t0.resident_fiscal_pays_autre_france_etat_unis AS resident_fiscal_pays_autre_france_etat_unis_32,
  t0.residence_identification_fiscal_pays AS residence_identification_fiscal_pays_33,
  t0.situation_familliale AS situation_familliale_34,
  t0.nombre_enfant AS nombre_enfant_35,
  t0.nombre_enfant_charge AS nombre_enfant_charge_36,
  t0.situation_proffesionnelle AS situation_proffesionnelle_37,
  t0.profession AS profession_38,
  t0.profession_csp_category AS profession_csp_category_39,
  t0.profession_csp_sous_category AS profession_csp_sous_category_40,
  t0.reconnaisance_nation AS reconnaisance_nation_41,
  t0.date_reconnaisance_nation AS date_reconnaisance_nation_42,
  t0.beneficiez_protection_juridique AS beneficiez_protection_juridique_43,
  t0.protection_juridique AS protection_juridique_44,
  t0.protection_juridique_other AS protection_juridique_other_45,
  t0.protection_juridique_mineur AS protection_juridique_mineur_46,
  t0.rep_legal1_use AS rep_legal1_use_47,
  t0.rep_legal1_sex AS rep_legal1_sex_48,
  t0.rep_legal1_nom AS rep_legal1_nom_49,
  t0.rep_legal1_prenoms AS rep_legal1_prenoms_50,
  t0.rep_legal1_date_de_naissance AS rep_legal1_date_de_naissance_51,
  t0.rep_legal1_lieu_de_naissance AS rep_legal1_lieu_de_naissance_52,
  t0.rep_legal1_nationalite AS rep_legal1_nationalite_53,
  t0.rep_legal1_residance_fiscal_france AS rep_legal1_residance_fiscal_france_54,
  t0.rep_legal1_fiscal_adresse AS rep_legal1_fiscal_adresse_55,
  t0.rep_legal1_fiscal_code_postal AS rep_legal1_fiscal_code_postal_56,
  t0.rep_legal1_fiscal_ville AS rep_legal1_fiscal_ville_57,
  t0.rep_legal1_fiscal_pays AS rep_legal1_fiscal_pays_58,
  t0.rep_legal1_postale_adresse AS rep_legal1_postale_adresse_59,
  t0.rep_legal1_postale_code_postal AS rep_legal1_postale_code_postal_60,
  t0.rep_legal1_postale_ville AS rep_legal1_postale_ville_61,
  t0.rep_legal1_postale_pays AS rep_legal1_postale_pays_62,
  t0.rep_legal1_telephone_portable_prefix AS rep_legal1_telephone_portable_prefix_63,
  t0.rep_legal1_telephone_portable AS rep_legal1_telephone_portable_64,
  t0.rep_legal1_telephone_prefix AS rep_legal1_telephone_prefix_65,
  t0.rep_legal1_telephone AS rep_legal1_telephone_66,
  t0.rep_legal1_email AS rep_legal1_email_67,
  t0.rep_legal1_situation_familiale AS rep_legal1_situation_familiale_68,
  t0.rep_legal1_nombre_enfant AS rep_legal1_nombre_enfant_69,
  t0.rep_legal1_nombre_enfant_charge AS rep_legal1_nombre_enfant_charge_70,
  t0.rep_legal1_qualite_de AS rep_legal1_qualite_de_71,
  t0.rep_legal1_politiquement_expose AS rep_legal1_politiquement_expose_72,
  t0.rep_legal1_personne_politiquement_exposee_type AS rep_legal1_personne_politiquement_exposee_type_73,
  t0.rep_legal1_personne_politiquement_exposee_ma_fonction AS rep_legal1_personne_politiquement_exposee_ma_fonction_74,
  t0.rep_legal1_personne_politiquement_exposee_entourage_fonction AS rep_legal1_personne_politiquement_exposee_entourage_fonction_75,
  t0.rep_legal1_personne_politiquement_exposee_entourage_lien AS rep_legal1_personne_politiquement_exposee_entourage_lien_76,
  t0.rep_legal1_green_card AS rep_legal1_green_card_77,
  t0.rep_legal1_residance_fiscal_autre_pays_france_etat_unis AS rep_legal1_residance_fiscal_autre_pays_france_etat_unis_78,
  t0.rep_legal1_residence_identification_fiscal_pays AS rep_legal1_residence_identification_fiscal_pays_79,
  t0.rep_legal1_accept_recevoir_document_garantie_email AS rep_legal1_accept_recevoir_document_garantie_email_80,
  t0.rep_legal1_accept_proposition_commercial_email AS rep_legal1_accept_proposition_commercial_email_81,
  t0.rep_legal1_accept_proposition_commercial_telephone AS rep_legal1_accept_proposition_commercial_telephone_82,
  t0.rep_legal2_use AS rep_legal2_use_83,
  t0.rep_legal2_sex AS rep_legal2_sex_84,
  t0.rep_legal2_nom AS rep_legal2_nom_85,
  t0.rep_legal2_prenoms AS rep_legal2_prenoms_86,
  t0.rep_legal2_date_de_naissance AS rep_legal2_date_de_naissance_87,
  t0.rep_legal2_lieu_de_naissance AS rep_legal2_lieu_de_naissance_88,
  t0.rep_legal2_nationalite AS rep_legal2_nationalite_89,
  t0.rep_legal2_residance_fiscal_france AS rep_legal2_residance_fiscal_france_90,
  t0.rep_legal2_fiscal_adresse AS rep_legal2_fiscal_adresse_91,
  t0.rep_legal2_fiscal_code_postal AS rep_legal2_fiscal_code_postal_92,
  t0.rep_legal2_fiscal_ville AS rep_legal2_fiscal_ville_93,
  t0.rep_legal2_fiscal_pays AS rep_legal2_fiscal_pays_94,
  t0.rep_legal2_postale_adresse AS rep_legal2_postale_adresse_95,
  t0.rep_legal2_postale_code_postal AS rep_legal2_postale_code_postal_96,
  t0.rep_legal2_postale_ville AS rep_legal2_postale_ville_97,
  t0.rep_legal2_postale_pays AS rep_legal2_postale_pays_98,
  t0.rep_legal2_telephone_portable_prefix AS rep_legal2_telephone_portable_prefix_99,
  t0.rep_legal2_telephone_portable AS rep_legal2_telephone_portable_100,
  t0.rep_legal2_telephone_prefix AS rep_legal2_telephone_prefix_101,
  t0.rep_legal2_telephone AS rep_legal2_telephone_102,
  t0.rep_legal2_email AS rep_legal2_email_103,
  t0.rep_legal2_situation_familiale AS rep_legal2_situation_familiale_104,
  t0.rep_legal2_nombre_enfant AS rep_legal2_nombre_enfant_105,
  t0.rep_legal2_nombre_enfant_charge AS rep_legal2_nombre_enfant_charge_106,
  t0.rep_legal2_qualite_de AS rep_legal2_qualite_de_107,
  t0.rep_legal2_politiquement_expose AS rep_legal2_politiquement_expose_108,
  t0.rep_legal2_personne_politiquement_exposee_type AS rep_legal2_personne_politiquement_exposee_type_109,
  t0.rep_legal2_personne_politiquement_exposee_ma_fonction AS rep_legal2_personne_politiquement_exposee_ma_fonction_110,
  t0.rep_legal2_personne_politiquement_exposee_entourage_fonction AS ep_legal2_personne_politiquement_exposee_entourage_fonction_111,
  t0.rep_legal2_personne_politiquement_exposee_entourage_lien AS rep_legal2_personne_politiquement_exposee_entourage_lien_112,
  t0.rep_legal2_green_card AS rep_legal2_green_card_113,
  t0.rep_legal2_residance_fiscal_autre_pays_france_etat_unis AS rep_legal2_residance_fiscal_autre_pays_france_etat_unis_114,
  t0.rep_legal2_residence_identification_fiscal_pays AS rep_legal2_residence_identification_fiscal_pays_115,
  t0.rep_legal2_accept_recevoir_document_garantie_email AS rep_legal2_accept_recevoir_document_garantie_email_116,
  t0.rep_legal2_accept_proposition_commercial_email AS rep_legal2_accept_proposition_commercial_email_117,
  t0.rep_legal2_accept_proposition_commercial_telephone AS rep_legal2_accept_proposition_commercial_telephone_118,
  t0.pref_investi_durabilite AS pref_investi_durabilite_119,
  t0.pref_investi_durabilite_environnement_taxonomie_europe AS pref_investi_durabilite_environnement_taxonomie_europe_120,
  t0.pref_investi_durabilite_objectif_environnemental_social AS pref_investi_durabilite_objectif_environnemental_social_121,
  t0.pref_investi_durabilite_effet_negatif AS pref_investi_durabilite_effet_negatif_122,
  t0.pref_investi_durabilite_confirmation_adhesion AS pref_investi_durabilite_confirmation_adhesion_123,
  t0.evaluation_patrimoine AS evaluation_patrimoine_124,
  t0.evaluation_patrimoine_composition AS evaluation_patrimoine_composition_125,
  t0.evaluation_patrimoine_composition_other AS evaluation_patrimoine_composition_other_126,
  t0.revenus_net_mensuels_foyer AS revenus_net_mensuels_foyer_127,
  t0.revenus_net_mensuels_foyer_composition AS revenus_net_mensuels_foyer_composition_128,
  t0.revenus_net_mensuels_foyer_composition_other AS revenus_net_mensuels_foyer_composition_other_129,
  t0.part_charge_reguliere AS part_charge_reguliere_130,
  t0.rep_legal1_evaluation_patrimoine AS rep_legal1_evaluation_patrimoine_131,
  t0.rep_legal1_evaluation_patrimoine_composition AS rep_legal1_evaluation_patrimoine_composition_132,
  t0.rep_legal1_evaluation_patrimoine_composition_other AS rep_legal1_evaluation_patrimoine_composition_other_133,
  t0.rep_legal1_revenus_net_mensuels_foyer AS rep_legal1_revenus_net_mensuels_foyer_134,
  t0.rep_legal1_revenus_net_mensuels_foyer_composition AS rep_legal1_revenus_net_mensuels_foyer_composition_135,
  t0.rep_legal1_revenus_net_mensuels_foyer_composition_other AS rep_legal1_revenus_net_mensuels_foyer_composition_other_136,
  t0.rep_legal1_part_charge_reguliere AS rep_legal1_part_charge_reguliere_137,
  t0.rep_legal2_evaluation_patrimoine AS rep_legal2_evaluation_patrimoine_138,
  t0.rep_legal2_evaluation_patrimoine_composition AS rep_legal2_evaluation_patrimoine_composition_139,
  t0.rep_legal2_evaluation_patrimoine_composition_other AS rep_legal2_evaluation_patrimoine_composition_other_140,
  t0.rep_legal2_revenus_net_mensuels_foyer AS rep_legal2_revenus_net_mensuels_foyer_141,
  t0.rep_legal2_revenus_net_mensuels_foyer_composition AS rep_legal2_revenus_net_mensuels_foyer_composition_142,
  t0.rep_legal2_revenus_net_mensuels_foyer_composition_other AS rep_legal2_revenus_net_mensuels_foyer_composition_other_143,
  t0.rep_legal2_part_charge_reguliere AS rep_legal2_part_charge_reguliere_144,
  t0.niveau_connaissance_retraite AS niveau_connaissance_retraite_145,
  t0.objectifs_pricipaux AS objectifs_pricipaux_146,
  t0.objectifs_epargne_priorite AS objectifs_epargne_priorite_147,
  t0.objectifs_temps_fonds AS objectifs_temps_fonds_148,
  t0.objectifs_temps_fonds_tres_court AS objectifs_temps_fonds_tres_court_149,
  t0.objectifs_temps_fonds_court AS objectifs_temps_fonds_court_150,
  t0.objectifs_temps_fonds_moyen AS objectifs_temps_fonds_moyen_151,
  t0.objectifs_temps_fonds_long AS objectifs_temps_fonds_long_152,
  t0.objectifs_montant_intial AS objectifs_montant_intial_153,
  t0.objectifs_montant_initial_provient_assurance_vie AS objectifs_montant_initial_provient_assurance_vie_154,
  t0.objectifs_placement_sur_patrimoine_total AS objectifs_placement_sur_patrimoine_total_155,
  t0.garantie_date_souhaite AS garantie_date_souhaite_156,
  t0.souscrire_retraite_mutualiste_pour_constituer AS souscrire_retraite_mutualiste_pour_constituer_157,
  t0.recommandation_conseiller AS recommandation_conseiller_158,
  t0.je_certifie_sur_honneur AS je_certifie_sur_honneur_159,
  t0.jaccepte_preconisation AS jaccepte_preconisation_160,
  t0.souscrire_autre_contrat AS souscrire_autre_contrat_161,
  t0.reconnais_connaissance_fic AS reconnais_connaissance_fic_162,
  t0.atteste_recu_information_detaillee AS atteste_recu_information_detaillee_163,
  t0.atteste_recu_dic_et_reglement AS atteste_recu_dic_et_reglement_164,
  t0.reconnais_preconisations_adaptees AS reconnais_preconisations_adaptees_165,
  t0.date_signe AS date_signe_166,
  t0.lieu_signe AS lieu_signe_167,
  t0.status AS status_168,
  t0.url_pdf AS url_pdf_169,
  t0.url_pdf_sign AS url_pdf_sign_170,
  t0.id_you_sign AS id_you_sign_171,
  t172.id AS id_173,
  t172.status AS status_174,
  t172.validated_files_by_customer AS validated_files_by_customer_175,
  t172.validated_files_by_customer_date AS validated_files_by_customer_date_176,
  t172.validated_files_by_seller AS validated_files_by_seller_177,
  t172.validated_files_by_seller_date AS validated_files_by_seller_date_178,
  t172.validated_folder_by_seller AS validated_folder_by_seller_179,
  t172.validated_folder_by_seller_date AS validated_folder_by_seller_date_180,
  t172.validated_folder_by_customer AS validated_folder_by_customer_181,
  t172.validated_folder_by_customer_date AS validated_folder_by_customer_date_182,
  t172.validated_dic_status AS validated_dic_status_183,
  t172.validated_dic_date AS validated_dic_date_184,
  t172.validated_dic_accept AS validated_dic_accept_185,
  t172.validated_fic_status AS validated_fic_status_186,
  t172.validated_fic_date AS validated_fic_date_187,
  t172.validated_fic_accept AS validated_fic_accept_188,
  t172.validated_ba_status AS validated_ba_status_189,
  t172.validated_ba_date AS validated_ba_date_190,
  t172.validated_ba_accept AS validated_ba_accept_191,
  t172.validated_sepa_status AS validated_sepa_status_192,
  t172.validated_sepa_date AS validated_sepa_date_193,
  t172.validated_sepa_accept AS validated_sepa_accept_194,
  t172.validated_status_status AS validated_status_status_195,
  t172.validated_status_date AS validated_status_date_196,
  t172.validated_status_accept AS validated_status_accept_197,
  t172.validated_reglement_status AS validated_reglement_status_198,
  t172.validated_reglement_date AS validated_reglement_date_199,
  t172.validated_reglement_accept AS validated_reglement_accept_200,
  t172.with_representant_legal1 AS with_representant_legal1_201,
  t172.with_representant_legal2 AS with_representant_legal2_202,
  t172.url_sign AS url_sign_203,
  t172.url_sign_seller AS url_sign_seller_204,
  t172.signed_seller AS signed_seller_205,
  t172.signed_seller_hooks AS signed_seller_hooks_206,
  t172.number_membership_folder AS number_membership_folder_207,
  t172.mail_send_customer AS mail_send_customer_208,
  t172.mail_send_seller AS mail_send_seller_209,
  t172.mail_send_gestion AS mail_send_gestion_210,
  t172.error_you_sign AS error_you_sign_211,
  t172.platform_version AS platform_version_212,
  t172.yousign_version AS yousign_version_213,
  t172.documents_version AS documents_version_214,
  t172.sign_date AS sign_date_215,
  t172.member_id AS member_id_216,
  t172.member_legal1_id AS member_legal1_id_217,
  t172.member_legal2_id AS member_legal2_id_218,
  t172.seller_member_id AS seller_member_id_219,
  t172.procedure_id AS procedure_id_220,
  t172.member_legal1_sign AS member_legal1_sign_221,
  t172.member_legal2_sign AS member_legal2_sign_222,
  t172.product AS product_223,
  t172.send_mail_no_sign AS send_mail_no_sign_224,
  t172.send_mail_no_sign_date AS send_mail_no_sign_date_225,
  t172.start_procedure_sign_date AS start_procedure_sign_date_226,
  t172.send_mail_reminder7 AS send_mail_reminder7_227,
  t172.send_mail_reminder21 AS send_mail_reminder21_228,
  t172.initial_fullweb AS initial_fullweb_229,
  t172.dic_is_file AS dic_is_file_230,
  t172.seller_id AS seller_id_231,
  t172.user_id AS user_id_232,
  t172.dic_id AS dic_id_233,
  t172.fic_id AS fic_id_234,
  t172.ba_id AS ba_id_235
FROM
  69pixl_fic t0
  LEFT JOIN 69pixl_membership t172 ON t172.fic_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.sex AS sex_2, t0.nom AS nom_3, t0.prenom AS prenom_4, t0.date_de_naissance AS date_de_naissance_5, t0.lieu_de_naissance AS lieu_de_naissance_6, t0.nationalite AS nationalite_7, t0.adresse_fiscale_residence_france AS adresse_fiscale_residence_france_8, t0.adresse_fiscale AS adresse_fiscale_9, t0.adresse_fiscale_code_postal AS adresse_fiscale_code_postal_10, t0.adresse_postale AS adresse_postale_11, t0.adresse_pays AS adresse_pays_12, t0.adresse_ville AS adresse_ville_13, t0.adresse_code_postal AS adresse_code_postal_14, t0.adresse_fiscale_ville AS adresse_fiscale_ville_15, t0.adresse_fiscale_pays AS adresse_fiscale_pays_16, t0.telephone AS telephone_17, t0.tel_fix_prefix AS tel_fix_prefix_18, t0.tel_fix AS tel_fix_19, t0.email AS email_20, t0.accept_recevoir_document_garantie_email AS accept_recevoir_document_garantie_email_21, t0.accept_proposition_commercial_email AS accept_proposition_commercial_email_22, t0.accept_proposition_commercial_telephone AS accept_proposition_commercial_telephone_23, t0.accept_information_garantie AS accept_information_garantie_24, t0.personne_politiquement_exposee AS personne_politiquement_exposee_25, t0.personne_politiquement_exposee_type AS personne_politiquement_exposee_type_26, t0.personne_politiquement_exposee_ma_fonction AS personne_politiquement_exposee_ma_fonction_27, t0.personne_politiquement_exposee_entourage_nom AS personne_politiquement_exposee_entourage_nom_28, t0.personne_politiquement_exposee_entourage_fonction AS personne_politiquement_exposee_entourage_fonction_29, t0.personne_politiquement_exposee_entourage_lien AS personne_politiquement_exposee_entourage_lien_30, t0.green_card AS green_card_31, t0.resident_fiscal_pays_autre_france_etat_unis AS resident_fiscal_pays_autre_france_etat_unis_32, t0.residence_identification_fiscal_pays AS residence_identification_fiscal_pays_33, t0.situation_familliale AS situation_familliale_34, t0.nombre_enfant AS nombre_enfant_35, t0.nombre_enfant_charge AS nombre_enfant_charge_36, t0.situation_proffesionnelle AS situation_proffesionnelle_37, t0.profession AS profession_38, t0.profession_csp_category AS profession_csp_category_39, t0.profession_csp_sous_category AS profession_csp_sous_category_40, t0.reconnaisance_nation AS reconnaisance_nation_41, t0.date_reconnaisance_nation AS date_reconnaisance_nation_42, t0.beneficiez_protection_juridique AS beneficiez_protection_juridique_43, t0.protection_juridique AS protection_juridique_44, t0.protection_juridique_other AS protection_juridique_other_45, t0.protection_juridique_mineur AS protection_juridique_mineur_46, t0.rep_legal1_use AS rep_legal1_use_47, t0.rep_legal1_sex AS rep_legal1_sex_48, t0.rep_legal1_nom AS rep_legal1_nom_49, t0.rep_legal1_prenoms AS rep_legal1_prenoms_50, t0.rep_legal1_date_de_naissance AS rep_legal1_date_de_naissance_51, t0.rep_legal1_lieu_de_naissance AS rep_legal1_lieu_de_naissance_52, t0.rep_legal1_nationalite AS rep_legal1_nationalite_53, t0.rep_legal1_residance_fiscal_france AS rep_legal1_residance_fiscal_france_54, t0.rep_legal1_fiscal_adresse AS rep_legal1_fiscal_adresse_55, t0.rep_legal1_fiscal_code_postal AS rep_legal1_fiscal_code_postal_56, t0.rep_legal1_fiscal_ville AS rep_legal1_fiscal_ville_57, t0.rep_legal1_fiscal_pays AS rep_legal1_fiscal_pays_58, t0.rep_legal1_postale_adresse AS rep_legal1_postale_adresse_59, t0.rep_legal1_postale_code_postal AS rep_legal1_postale_code_postal_60, t0.rep_legal1_postale_ville AS rep_legal1_postale_ville_61, t0.rep_legal1_postale_pays AS rep_legal1_postale_pays_62, t0.rep_legal1_telephone_portable_prefix AS rep_legal1_telephone_portable_prefix_63, t0.rep_legal1_telephone_portable AS rep_legal1_telephone_portable_64, t0.rep_legal1_telephone_prefix AS rep_legal1_telephone_prefix_65, t0.rep_legal1_telephone AS rep_legal1_telephone_66, t0.rep_legal1_email AS rep_legal1_email_67, t0.rep_legal1_situation_familiale AS rep_legal1_situation_familiale_68, t0.rep_legal1_nombre_enfant AS rep_legal1_nombre_enfant_69, t0.rep_legal1_nombre_enfant_charge AS rep_legal1_nombre_enfant_charge_70, t0.rep_legal1_qualite_de AS rep_legal1_qualite_de_71, t0.rep_legal1_politiquement_expose AS rep_legal1_politiquement_expose_72, t0.rep_legal1_personne_politiquement_exposee_type AS rep_legal1_personne_politiquement_exposee_type_73, t0.rep_legal1_personne_politiquement_exposee_ma_fonction AS rep_legal1_personne_politiquement_exposee_ma_fonction_74, t0.rep_legal1_personne_politiquement_exposee_entourage_fonction AS rep_legal1_personne_politiquement_exposee_entourage_fonction_75, t0.rep_legal1_personne_politiquement_exposee_entourage_lien AS rep_legal1_personne_politiquement_exposee_entourage_lien_76, t0.rep_legal1_green_card AS rep_legal1_green_card_77, t0.rep_legal1_residance_fiscal_autre_pays_france_etat_unis AS rep_legal1_residance_fiscal_autre_pays_france_etat_unis_78, t0.rep_legal1_residence_identification_fiscal_pays AS rep_legal1_residence_identification_fiscal_pays_79, t0.rep_legal1_accept_recevoir_document_garantie_email AS rep_legal1_accept_recevoir_document_garantie_email_80, t0.rep_legal1_accept_proposition_commercial_email AS rep_legal1_accept_proposition_commercial_email_81, t0.rep_legal1_accept_proposition_commercial_telephone AS rep_legal1_accept_proposition_commercial_telephone_82, t0.rep_legal2_use AS rep_legal2_use_83, t0.rep_legal2_sex AS rep_legal2_sex_84, t0.rep_legal2_nom AS rep_legal2_nom_85, t0.rep_legal2_prenoms AS rep_legal2_prenoms_86, t0.rep_legal2_date_de_naissance AS rep_legal2_date_de_naissance_87, t0.rep_legal2_lieu_de_naissance AS rep_legal2_lieu_de_naissance_88, t0.rep_legal2_nationalite AS rep_legal2_nationalite_89, t0.rep_legal2_residance_fiscal_france AS rep_legal2_residance_fiscal_france_90, t0.rep_legal2_fiscal_adresse AS rep_legal2_fiscal_adresse_91, t0.rep_legal2_fiscal_code_postal AS rep_legal2_fiscal_code_postal_92, t0.rep_legal2_fiscal_ville AS rep_legal2_fiscal_ville_93, t0.rep_legal2_fiscal_pays AS rep_legal2_fiscal_pays_94, t0.rep_legal2_postale_adresse AS rep_legal2_postale_adresse_95, t0.rep_legal2_postale_code_postal AS rep_legal2_postale_code_postal_96, t0.rep_legal2_postale_ville AS rep_legal2_postale_ville_97, t0.rep_legal2_postale_pays AS rep_legal2_postale_pays_98, t0.rep_legal2_telephone_portable_prefix AS rep_legal2_telephone_portable_prefix_99, t0.rep_legal2_telephone_portable AS rep_legal2_telephone_portable_100, t0.rep_legal2_telephone_prefix AS rep_legal2_telephone_prefix_101, t0.rep_legal2_telephone AS rep_legal2_telephone_102, t0.rep_legal2_email AS rep_legal2_email_103, t0.rep_legal2_situation_familiale AS rep_legal2_situation_familiale_104, t0.rep_legal2_nombre_enfant AS rep_legal2_nombre_enfant_105, t0.rep_legal2_nombre_enfant_charge AS rep_legal2_nombre_enfant_charge_106, t0.rep_legal2_qualite_de AS rep_legal2_qualite_de_107, t0.rep_legal2_politiquement_expose AS rep_legal2_politiquement_expose_108, t0.rep_legal2_personne_politiquement_exposee_type AS rep_legal2_personne_politiquement_exposee_type_109, t0.rep_legal2_personne_politiquement_exposee_ma_fonction AS rep_legal2_personne_politiquement_exposee_ma_fonction_110, t0.rep_legal2_personne_politiquement_exposee_entourage_fonction AS ep_legal2_personne_politiquement_exposee_entourage_fonction_111, t0.rep_legal2_personne_politiquement_exposee_entourage_lien AS rep_legal2_personne_politiquement_exposee_entourage_lien_112, t0.rep_legal2_green_card AS rep_legal2_green_card_113, t0.rep_legal2_residance_fiscal_autre_pays_france_etat_unis AS rep_legal2_residance_fiscal_autre_pays_france_etat_unis_114, t0.rep_legal2_residence_identification_fiscal_pays AS rep_legal2_residence_identification_fiscal_pays_115, t0.rep_legal2_accept_recevoir_document_garantie_email AS rep_legal2_accept_recevoir_document_garantie_email_116, t0.rep_legal2_accept_proposition_commercial_email AS rep_legal2_accept_proposition_commercial_email_117, t0.rep_legal2_accept_proposition_commercial_telephone AS rep_legal2_accept_proposition_commercial_telephone_118, t0.pref_investi_durabilite AS pref_investi_durabilite_119, t0.pref_investi_durabilite_environnement_taxonomie_europe AS pref_investi_durabilite_environnement_taxonomie_europe_120, t0.pref_investi_durabilite_objectif_environnemental_social AS pref_investi_durabilite_objectif_environnemental_social_121, t0.pref_investi_durabilite_effet_negatif AS pref_investi_durabilite_effet_negatif_122, t0.pref_investi_durabilite_confirmation_adhesion AS pref_investi_durabilite_confirmation_adhesion_123, t0.evaluation_patrimoine AS evaluation_patrimoine_124, t0.evaluation_patrimoine_composition AS evaluation_patrimoine_composition_125, t0.evaluation_patrimoine_composition_other AS evaluation_patrimoine_composition_other_126, t0.revenus_net_mensuels_foyer AS revenus_net_mensuels_foyer_127, t0.revenus_net_mensuels_foyer_composition AS revenus_net_mensuels_foyer_composition_128, t0.revenus_net_mensuels_foyer_composition_other AS revenus_net_mensuels_foyer_composition_other_129, t0.part_charge_reguliere AS part_charge_reguliere_130, t0.rep_legal1_evaluation_patrimoine AS rep_legal1_evaluation_patrimoine_131, t0.rep_legal1_evaluation_patrimoine_composition AS rep_legal1_evaluation_patrimoine_composition_132, t0.rep_legal1_evaluation_patrimoine_composition_other AS rep_legal1_evaluation_patrimoine_composition_other_133, t0.rep_legal1_revenus_net_mensuels_foyer AS rep_legal1_revenus_net_mensuels_foyer_134, t0.rep_legal1_revenus_net_mensuels_foyer_composition AS rep_legal1_revenus_net_mensuels_foyer_composition_135, t0.rep_legal1_revenus_net_mensuels_foyer_composition_other AS rep_legal1_revenus_net_mensuels_foyer_composition_other_136, t0.rep_legal1_part_charge_reguliere AS rep_legal1_part_charge_reguliere_137, t0.rep_legal2_evaluation_patrimoine AS rep_legal2_evaluation_patrimoine_138, t0.rep_legal2_evaluation_patrimoine_composition AS rep_legal2_evaluation_patrimoine_composition_139, t0.rep_legal2_evaluation_patrimoine_composition_other AS rep_legal2_evaluation_patrimoine_composition_other_140, t0.rep_legal2_revenus_net_mensuels_foyer AS rep_legal2_revenus_net_mensuels_foyer_141, t0.rep_legal2_revenus_net_mensuels_foyer_composition AS rep_legal2_revenus_net_mensuels_foyer_composition_142, t0.rep_legal2_revenus_net_mensuels_foyer_composition_other AS rep_legal2_revenus_net_mensuels_foyer_composition_other_143, t0.rep_legal2_part_charge_reguliere AS rep_legal2_part_charge_reguliere_144, t0.niveau_connaissance_retraite AS niveau_connaissance_retraite_145, t0.objectifs_pricipaux AS objectifs_pricipaux_146, t0.objectifs_epargne_priorite AS objectifs_epargne_priorite_147, t0.objectifs_temps_fonds AS objectifs_temps_fonds_148, t0.objectifs_temps_fonds_tres_court AS objectifs_temps_fonds_tres_court_149, t0.objectifs_temps_fonds_court AS objectifs_temps_fonds_court_150, t0.objectifs_temps_fonds_moyen AS objectifs_temps_fonds_moyen_151, t0.objectifs_temps_fonds_long AS objectifs_temps_fonds_long_152, t0.objectifs_montant_intial AS objectifs_montant_intial_153, t0.objectifs_montant_initial_provient_assurance_vie AS objectifs_montant_initial_provient_assurance_vie_154, t0.objectifs_placement_sur_patrimoine_total AS objectifs_placement_sur_patrimoine_total_155, t0.garantie_date_souhaite AS garantie_date_souhaite_156, t0.souscrire_retraite_mutualiste_pour_constituer AS souscrire_retraite_mutualiste_pour_constituer_157, t0.recommandation_conseiller AS recommandation_conseiller_158, t0.je_certifie_sur_honneur AS je_certifie_sur_honneur_159, t0.jaccepte_preconisation AS jaccepte_preconisation_160, t0.souscrire_autre_contrat AS souscrire_autre_contrat_161, t0.reconnais_connaissance_fic AS reconnais_connaissance_fic_162, t0.atteste_recu_information_detaillee AS atteste_recu_information_detaillee_163, t0.atteste_recu_dic_et_reglement AS atteste_recu_dic_et_reglement_164, t0.reconnais_preconisations_adaptees AS reconnais_preconisations_adaptees_165, t0.date_signe AS date_signe_166, t0.lieu_signe AS lieu_signe_167, t0.status AS status_168, t0.url_pdf AS url_pdf_169, t0.url_pdf_sign AS url_pdf_sign_170, t0.id_you_sign AS id_you_sign_171, t172.id AS id_173, t172.status AS status_174, t172.validated_files_by_customer AS validated_files_by_customer_175, t172.validated_files_by_customer_date AS validated_files_by_customer_date_176, t172.validated_files_by_seller AS validated_files_by_seller_177, t172.validated_files_by_seller_date AS validated_files_by_seller_date_178, t172.validated_folder_by_seller AS validated_folder_by_seller_179, t172.validated_folder_by_seller_date AS validated_folder_by_seller_date_180, t172.validated_folder_by_customer AS validated_folder_by_customer_181, t172.validated_folder_by_customer_date AS validated_folder_by_customer_date_182, t172.validated_dic_status AS validated_dic_status_183, t172.validated_dic_date AS validated_dic_date_184, t172.validated_dic_accept AS validated_dic_accept_185, t172.validated_fic_status AS validated_fic_status_186, t172.validated_fic_date AS validated_fic_date_187, t172.validated_fic_accept AS validated_fic_accept_188, t172.validated_ba_status AS validated_ba_status_189, t172.validated_ba_date AS validated_ba_date_190, t172.validated_ba_accept AS validated_ba_accept_191, t172.validated_sepa_status AS validated_sepa_status_192, t172.validated_sepa_date AS validated_sepa_date_193, t172.validated_sepa_accept AS validated_sepa_accept_194, t172.validated_status_status AS validated_status_status_195, t172.validated_status_date AS validated_status_date_196, t172.validated_status_accept AS validated_status_accept_197, t172.validated_reglement_status AS validated_reglement_status_198, t172.validated_reglement_date AS validated_reglement_date_199, t172.validated_reglement_accept AS validated_reglement_accept_200, t172.with_representant_legal1 AS with_representant_legal1_201, t172.with_representant_legal2 AS with_representant_legal2_202, t172.url_sign AS url_sign_203, t172.url_sign_seller AS url_sign_seller_204, t172.signed_seller AS signed_seller_205, t172.signed_seller_hooks AS signed_seller_hooks_206, t172.number_membership_folder AS number_membership_folder_207, t172.mail_send_customer AS mail_send_customer_208, t172.mail_send_seller AS mail_send_seller_209, t172.mail_send_gestion AS mail_send_gestion_210, t172.error_you_sign AS error_you_sign_211, t172.platform_version AS platform_version_212, t172.yousign_version AS yousign_version_213, t172.documents_version AS documents_version_214, t172.sign_date AS sign_date_215, t172.member_id AS member_id_216, t172.member_legal1_id AS member_legal1_id_217, t172.member_legal2_id AS member_legal2_id_218, t172.seller_member_id AS seller_member_id_219, t172.procedure_id AS procedure_id_220, t172.member_legal1_sign AS member_legal1_sign_221, t172.member_legal2_sign AS member_legal2_sign_222, t172.product AS product_223, t172.send_mail_no_sign AS send_mail_no_sign_224, t172.send_mail_no_sign_date AS send_mail_no_sign_date_225, t172.start_procedure_sign_date AS start_procedure_sign_date_226, t172.send_mail_reminder7 AS send_mail_reminder7_227, t172.send_mail_reminder21 AS send_mail_reminder21_228, t172.initial_fullweb AS initial_fullweb_229, t172.dic_is_file AS dic_is_file_230, t172.seller_id AS seller_id_231, t172.user_id AS user_id_232, t172.dic_id AS dic_id_233, t172.fic_id AS fic_id_234, t172.ba_id AS ba_id_235 FROM 69pixl_fic t0 LEFT JOIN 69pixl_membership t172 ON t172.fic_id = t0.id WHERE t0.id = 216;