Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.created_at AS created_at_3,
  t0.auth_user_id AS auth_user_id_4
FROM
  auth_tokens t0
WHERE
  t0.value = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.value AS value_2, t0.created_at AS created_at_3, t0.auth_user_id AS auth_user_id_4 FROM auth_tokens t0 WHERE t0.value = 'PV+J7oCwYo3NcU+5Hns5dpkp7IPU1eoH4cCNMqOgfoTcflSgIaLtmhJSWphgPwLS6G4=' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.password_mail AS password_mail_3,
  t0.password AS password_4,
  t0.roles AS roles_5,
  t0.old_login AS old_login_6,
  t0.old_password AS old_password_7,
  t0.actuel AS actuel_8,
  t0.fonction AS fonction_9,
  t0.date_arrive AS date_arrive_10,
  t0.tel_interne AS tel_interne_11,
  t0.adresse_envoi AS adresse_envoi_12,
  t0.count_email_verifier_existant_adelete AS count_email_verifier_existant_adelete_13,
  t0.u_systeme AS u_systeme_14,
  t0.user_id AS user_id_15,
  t16.id AS id_17,
  t16.prenom AS prenom_18,
  t16.nom AS nom_19,
  t16.email AS email_20,
  t16.resp_conge AS resp_conge_21,
  t16.tel AS tel_22,
  t16.civilite AS civilite_23,
  t16.id_adress AS id_adress_24
FROM
  auth_user t0
  LEFT JOIN user t16 ON t0.user_id = t16.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.password_mail AS password_mail_3, t0.password AS password_4, t0.roles AS roles_5, t0.old_login AS old_login_6, t0.old_password AS old_password_7, t0.actuel AS actuel_8, t0.fonction AS fonction_9, t0.date_arrive AS date_arrive_10, t0.tel_interne AS tel_interne_11, t0.adresse_envoi AS adresse_envoi_12, t0.count_email_verifier_existant_adelete AS count_email_verifier_existant_adelete_13, t0.u_systeme AS u_systeme_14, t0.user_id AS user_id_15, t16.id AS id_17, t16.prenom AS prenom_18, t16.nom AS nom_19, t16.email AS email_20, t16.resp_conge AS resp_conge_21, t16.tel AS tel_22, t16.civilite AS civilite_23, t16.id_adress AS id_adress_24 FROM auth_user t0 LEFT JOIN user t16 ON t0.user_id = t16.id WHERE t0.id = 174;

SELECT
  t0.id AS id_1,
  t0.ancien_id AS ancien_id_2,
  t0.libelle AS libelle_3,
  t0.genre AS genre_4
FROM
  civilite t0
WHERE
  t0.id IN (?)

SELECT t0.id AS id_1, t0.ancien_id AS ancien_id_2, t0.libelle AS libelle_3, t0.genre AS genre_4 FROM civilite t0 WHERE t0.id IN (3);

SELECT
  t0.id AS id_1,
  t0.role AS role_2,
  t0.adresse_coupure AS adresse_coupure_3,
  t0.adresse_generique AS adresse_generique_4,
  t0.color AS color_5,
  t0.id_client AS id_client_6,
  t7.id AS id_8,
  t7.nom AS nom_9,
  t7.adresse_generique AS adresse_generique_10,
  t7.adresse_coupure AS adresse_coupure_11,
  t7.actuel AS actuel_12,
  t7.ancien_id AS ancien_id_13,
  t7.dirigeant AS dirigeant_14,
  t7.date_entree AS date_entree_15,
  t7.date_sortie AS date_sortie_16,
  t7.duree AS duree_17,
  t7.score AS score_18,
  t7.logo_id AS logo_id_19,
  t7.pressroom_client AS pressroom_client_20,
  t7.etat_id AS etat_id_21,
  t7.liste_journaliste_interview_article_id AS liste_journaliste_interview_article_id_22,
  t0.id_user AS id_user_23
FROM
  client_role_user t0
  LEFT JOIN client t7 ON t0.id_client = t7.id
WHERE
  t0.id_user IN (?)

SELECT t0.id AS id_1, t0.role AS role_2, t0.adresse_coupure AS adresse_coupure_3, t0.adresse_generique AS adresse_generique_4, t0.color AS color_5, t0.id_client AS id_client_6, t7.id AS id_8, t7.nom AS nom_9, t7.adresse_generique AS adresse_generique_10, t7.adresse_coupure AS adresse_coupure_11, t7.actuel AS actuel_12, t7.ancien_id AS ancien_id_13, t7.dirigeant AS dirigeant_14, t7.date_entree AS date_entree_15, t7.date_sortie AS date_sortie_16, t7.duree AS duree_17, t7.score AS score_18, t7.logo_id AS logo_id_19, t7.pressroom_client AS pressroom_client_20, t7.etat_id AS etat_id_21, t7.liste_journaliste_interview_article_id AS liste_journaliste_interview_article_id_22, t0.id_user AS id_user_23 FROM client_role_user t0 LEFT JOIN client t7 ON t0.id_client = t7.id WHERE t0.id_user IN (174);

SELECT
  t0.id AS id_1,
  t0.ancien_id AS ancien_id_2,
  t0.nom AS nom_3,
  t0.date_creation AS date_creation_4,
  t0.siren AS siren_5,
  t0.capital AS capital_6,
  t0.effectif AS effectif_7,
  t0.implantation AS implantation_8,
  t0.commentaires AS commentaires_9,
  t0.creation AS creation_10,
  t0.modification AS modification_11,
  t0.auteur_id AS auteur_id_12,
  t0.appartenir_a_id AS appartenir_a_id_13,
  t0.client_id AS client_id_14,
  t0.forme_juridique_id AS forme_juridique_id_15,
  t0.genre_id AS genre_id_16,
  t0.categorie_generale_id AS categorie_generale_id_17,
  t0.coordonnees_id AS coordonnees_id_18,
  t0.dirigeant_id AS dirigeant_id_19,
  t0.ape_id AS ape_id_20
FROM
  organisation t0
WHERE
  t0.client_id = ?

SELECT t0.id AS id_1, t0.ancien_id AS ancien_id_2, t0.nom AS nom_3, t0.date_creation AS date_creation_4, t0.siren AS siren_5, t0.capital AS capital_6, t0.effectif AS effectif_7, t0.implantation AS implantation_8, t0.commentaires AS commentaires_9, t0.creation AS creation_10, t0.modification AS modification_11, t0.auteur_id AS auteur_id_12, t0.appartenir_a_id AS appartenir_a_id_13, t0.client_id AS client_id_14, t0.forme_juridique_id AS forme_juridique_id_15, t0.genre_id AS genre_id_16, t0.categorie_generale_id AS categorie_generale_id_17, t0.coordonnees_id AS coordonnees_id_18, t0.dirigeant_id AS dirigeant_id_19, t0.ape_id AS ape_id_20 FROM organisation t0 WHERE t0.client_id = 403;

SELECT
  t0.id AS id_1,
  t0.ancien_id AS ancien_id_2,
  t0.nom AS nom_3,
  t0.date_creation AS date_creation_4,
  t0.siren AS siren_5,
  t0.capital AS capital_6,
  t0.effectif AS effectif_7,
  t0.implantation AS implantation_8,
  t0.commentaires AS commentaires_9,
  t0.creation AS creation_10,
  t0.modification AS modification_11,
  t0.auteur_id AS auteur_id_12,
  t0.appartenir_a_id AS appartenir_a_id_13,
  t0.client_id AS client_id_14,
  t0.forme_juridique_id AS forme_juridique_id_15,
  t0.genre_id AS genre_id_16,
  t0.categorie_generale_id AS categorie_generale_id_17,
  t0.coordonnees_id AS coordonnees_id_18,
  t0.dirigeant_id AS dirigeant_id_19,
  t0.ape_id AS ape_id_20
FROM
  organisation t0
WHERE
  t0.client_id = ?

SELECT t0.id AS id_1, t0.ancien_id AS ancien_id_2, t0.nom AS nom_3, t0.date_creation AS date_creation_4, t0.siren AS siren_5, t0.capital AS capital_6, t0.effectif AS effectif_7, t0.implantation AS implantation_8, t0.commentaires AS commentaires_9, t0.creation AS creation_10, t0.modification AS modification_11, t0.auteur_id AS auteur_id_12, t0.appartenir_a_id AS appartenir_a_id_13, t0.client_id AS client_id_14, t0.forme_juridique_id AS forme_juridique_id_15, t0.genre_id AS genre_id_16, t0.categorie_generale_id AS categorie_generale_id_17, t0.coordonnees_id AS coordonnees_id_18, t0.dirigeant_id AS dirigeant_id_19, t0.ape_id AS ape_id_20 FROM organisation t0 WHERE t0.client_id = 422;

SELECT
  t0.id AS id_1,
  t0.ancien_id AS ancien_id_2,
  t0.nom AS nom_3,
  t0.date_creation AS date_creation_4,
  t0.siren AS siren_5,
  t0.capital AS capital_6,
  t0.effectif AS effectif_7,
  t0.implantation AS implantation_8,
  t0.commentaires AS commentaires_9,
  t0.creation AS creation_10,
  t0.modification AS modification_11,
  t0.auteur_id AS auteur_id_12,
  t0.appartenir_a_id AS appartenir_a_id_13,
  t0.client_id AS client_id_14,
  t0.forme_juridique_id AS forme_juridique_id_15,
  t0.genre_id AS genre_id_16,
  t0.categorie_generale_id AS categorie_generale_id_17,
  t0.coordonnees_id AS coordonnees_id_18,
  t0.dirigeant_id AS dirigeant_id_19,
  t0.ape_id AS ape_id_20
FROM
  organisation t0
WHERE
  t0.client_id = ?

SELECT t0.id AS id_1, t0.ancien_id AS ancien_id_2, t0.nom AS nom_3, t0.date_creation AS date_creation_4, t0.siren AS siren_5, t0.capital AS capital_6, t0.effectif AS effectif_7, t0.implantation AS implantation_8, t0.commentaires AS commentaires_9, t0.creation AS creation_10, t0.modification AS modification_11, t0.auteur_id AS auteur_id_12, t0.appartenir_a_id AS appartenir_a_id_13, t0.client_id AS client_id_14, t0.forme_juridique_id AS forme_juridique_id_15, t0.genre_id AS genre_id_16, t0.categorie_generale_id AS categorie_generale_id_17, t0.coordonnees_id AS coordonnees_id_18, t0.dirigeant_id AS dirigeant_id_19, t0.ape_id AS ape_id_20 FROM organisation t0 WHERE t0.client_id = 272;

SELECT
  t0.id AS id_1,
  t0.ancien_id AS ancien_id_2,
  t0.nom AS nom_3,
  t0.date_creation AS date_creation_4,
  t0.siren AS siren_5,
  t0.capital AS capital_6,
  t0.effectif AS effectif_7,
  t0.implantation AS implantation_8,
  t0.commentaires AS commentaires_9,
  t0.creation AS creation_10,
  t0.modification AS modification_11,
  t0.auteur_id AS auteur_id_12,
  t0.appartenir_a_id AS appartenir_a_id_13,
  t0.client_id AS client_id_14,
  t0.forme_juridique_id AS forme_juridique_id_15,
  t0.genre_id AS genre_id_16,
  t0.categorie_generale_id AS categorie_generale_id_17,
  t0.coordonnees_id AS coordonnees_id_18,
  t0.dirigeant_id AS dirigeant_id_19,
  t0.ape_id AS ape_id_20
FROM
  organisation t0
WHERE
  t0.client_id = ?

SELECT t0.id AS id_1, t0.ancien_id AS ancien_id_2, t0.nom AS nom_3, t0.date_creation AS date_creation_4, t0.siren AS siren_5, t0.capital AS capital_6, t0.effectif AS effectif_7, t0.implantation AS implantation_8, t0.commentaires AS commentaires_9, t0.creation AS creation_10, t0.modification AS modification_11, t0.auteur_id AS auteur_id_12, t0.appartenir_a_id AS appartenir_a_id_13, t0.client_id AS client_id_14, t0.forme_juridique_id AS forme_juridique_id_15, t0.genre_id AS genre_id_16, t0.categorie_generale_id AS categorie_generale_id_17, t0.coordonnees_id AS coordonnees_id_18, t0.dirigeant_id AS dirigeant_id_19, t0.ape_id AS ape_id_20 FROM organisation t0 WHERE t0.client_id = 425;

SELECT
  t0.id AS id_1,
  t0.ancien_id AS ancien_id_2,
  t0.nom AS nom_3,
  t0.date_creation AS date_creation_4,
  t0.siren AS siren_5,
  t0.capital AS capital_6,
  t0.effectif AS effectif_7,
  t0.implantation AS implantation_8,
  t0.commentaires AS commentaires_9,
  t0.creation AS creation_10,
  t0.modification AS modification_11,
  t0.auteur_id AS auteur_id_12,
  t0.appartenir_a_id AS appartenir_a_id_13,
  t0.client_id AS client_id_14,
  t0.forme_juridique_id AS forme_juridique_id_15,
  t0.genre_id AS genre_id_16,
  t0.categorie_generale_id AS categorie_generale_id_17,
  t0.coordonnees_id AS coordonnees_id_18,
  t0.dirigeant_id AS dirigeant_id_19,
  t0.ape_id AS ape_id_20
FROM
  organisation t0
WHERE
  t0.client_id = ?

SELECT t0.id AS id_1, t0.ancien_id AS ancien_id_2, t0.nom AS nom_3, t0.date_creation AS date_creation_4, t0.siren AS siren_5, t0.capital AS capital_6, t0.effectif AS effectif_7, t0.implantation AS implantation_8, t0.commentaires AS commentaires_9, t0.creation AS creation_10, t0.modification AS modification_11, t0.auteur_id AS auteur_id_12, t0.appartenir_a_id AS appartenir_a_id_13, t0.client_id AS client_id_14, t0.forme_juridique_id AS forme_juridique_id_15, t0.genre_id AS genre_id_16, t0.categorie_generale_id AS categorie_generale_id_17, t0.coordonnees_id AS coordonnees_id_18, t0.dirigeant_id AS dirigeant_id_19, t0.ape_id AS ape_id_20 FROM organisation t0 WHERE t0.client_id = 240;

SELECT
  t0.id AS id_1,
  t0.ancien_id AS ancien_id_2,
  t0.nom AS nom_3,
  t0.date_creation AS date_creation_4,
  t0.siren AS siren_5,
  t0.capital AS capital_6,
  t0.effectif AS effectif_7,
  t0.implantation AS implantation_8,
  t0.commentaires AS commentaires_9,
  t0.creation AS creation_10,
  t0.modification AS modification_11,
  t0.auteur_id AS auteur_id_12,
  t0.appartenir_a_id AS appartenir_a_id_13,
  t0.client_id AS client_id_14,
  t0.forme_juridique_id AS forme_juridique_id_15,
  t0.genre_id AS genre_id_16,
  t0.categorie_generale_id AS categorie_generale_id_17,
  t0.coordonnees_id AS coordonnees_id_18,
  t0.dirigeant_id AS dirigeant_id_19,
  t0.ape_id AS ape_id_20
FROM
  organisation t0
WHERE
  t0.client_id = ?

SELECT t0.id AS id_1, t0.ancien_id AS ancien_id_2, t0.nom AS nom_3, t0.date_creation AS date_creation_4, t0.siren AS siren_5, t0.capital AS capital_6, t0.effectif AS effectif_7, t0.implantation AS implantation_8, t0.commentaires AS commentaires_9, t0.creation AS creation_10, t0.modification AS modification_11, t0.auteur_id AS auteur_id_12, t0.appartenir_a_id AS appartenir_a_id_13, t0.client_id AS client_id_14, t0.forme_juridique_id AS forme_juridique_id_15, t0.genre_id AS genre_id_16, t0.categorie_generale_id AS categorie_generale_id_17, t0.coordonnees_id AS coordonnees_id_18, t0.dirigeant_id AS dirigeant_id_19, t0.ape_id AS ape_id_20 FROM organisation t0 WHERE t0.client_id = 214;

SELECT
  t0.id AS id_1,
  t0.ancien_id AS ancien_id_2,
  t0.nom AS nom_3,
  t0.date_creation AS date_creation_4,
  t0.siren AS siren_5,
  t0.capital AS capital_6,
  t0.effectif AS effectif_7,
  t0.implantation AS implantation_8,
  t0.commentaires AS commentaires_9,
  t0.creation AS creation_10,
  t0.modification AS modification_11,
  t0.auteur_id AS auteur_id_12,
  t0.appartenir_a_id AS appartenir_a_id_13,
  t0.client_id AS client_id_14,
  t0.forme_juridique_id AS forme_juridique_id_15,
  t0.genre_id AS genre_id_16,
  t0.categorie_generale_id AS categorie_generale_id_17,
  t0.coordonnees_id AS coordonnees_id_18,
  t0.dirigeant_id AS dirigeant_id_19,
  t0.ape_id AS ape_id_20
FROM
  organisation t0
WHERE
  t0.client_id = ?

SELECT t0.id AS id_1, t0.ancien_id AS ancien_id_2, t0.nom AS nom_3, t0.date_creation AS date_creation_4, t0.siren AS siren_5, t0.capital AS capital_6, t0.effectif AS effectif_7, t0.implantation AS implantation_8, t0.commentaires AS commentaires_9, t0.creation AS creation_10, t0.modification AS modification_11, t0.auteur_id AS auteur_id_12, t0.appartenir_a_id AS appartenir_a_id_13, t0.client_id AS client_id_14, t0.forme_juridique_id AS forme_juridique_id_15, t0.genre_id AS genre_id_16, t0.categorie_generale_id AS categorie_generale_id_17, t0.coordonnees_id AS coordonnees_id_18, t0.dirigeant_id AS dirigeant_id_19, t0.ape_id AS ape_id_20 FROM organisation t0 WHERE t0.client_id = 375;

SELECT
  t0.id AS id_1,
  t0.ancien_id AS ancien_id_2,
  t0.nom AS nom_3,
  t0.date_creation AS date_creation_4,
  t0.siren AS siren_5,
  t0.capital AS capital_6,
  t0.effectif AS effectif_7,
  t0.implantation AS implantation_8,
  t0.commentaires AS commentaires_9,
  t0.creation AS creation_10,
  t0.modification AS modification_11,
  t0.auteur_id AS auteur_id_12,
  t0.appartenir_a_id AS appartenir_a_id_13,
  t0.client_id AS client_id_14,
  t0.forme_juridique_id AS forme_juridique_id_15,
  t0.genre_id AS genre_id_16,
  t0.categorie_generale_id AS categorie_generale_id_17,
  t0.coordonnees_id AS coordonnees_id_18,
  t0.dirigeant_id AS dirigeant_id_19,
  t0.ape_id AS ape_id_20
FROM
  organisation t0
WHERE
  t0.client_id = ?

SELECT t0.id AS id_1, t0.ancien_id AS ancien_id_2, t0.nom AS nom_3, t0.date_creation AS date_creation_4, t0.siren AS siren_5, t0.capital AS capital_6, t0.effectif AS effectif_7, t0.implantation AS implantation_8, t0.commentaires AS commentaires_9, t0.creation AS creation_10, t0.modification AS modification_11, t0.auteur_id AS auteur_id_12, t0.appartenir_a_id AS appartenir_a_id_13, t0.client_id AS client_id_14, t0.forme_juridique_id AS forme_juridique_id_15, t0.genre_id AS genre_id_16, t0.categorie_generale_id AS categorie_generale_id_17, t0.coordonnees_id AS coordonnees_id_18, t0.dirigeant_id AS dirigeant_id_19, t0.ape_id AS ape_id_20 FROM organisation t0 WHERE t0.client_id = 397;

SELECT
  t0.id AS id_1,
  t0.adresse AS adresse_2,
  t0.ville AS ville_3,
  t0.code_postal AS code_postal_4,
  t0.pays AS pays_5,
  t0.complement AS complement_6
FROM
  adresse t0
WHERE
  t0.id IN (?)

SELECT t0.id AS id_1, t0.adresse AS adresse_2, t0.ville AS ville_3, t0.code_postal AS code_postal_4, t0.pays AS pays_5, t0.complement AS complement_6 FROM adresse t0 WHERE t0.id IN (143);

SELECT
  m0_.id AS id_0,
  m0_.ancien_id AS ancien_id_1,
  m0_.nom AS nom_2,
  m0_.valider_envoi AS valider_envoi_3,
  m0_.envoyer AS envoyer_4,
  m0_.resumer AS resumer_5,
  m0_.type_mail AS type_mail_6,
  m0_.en_cour AS en_cour_7,
  m0_.objet AS objet_8,
  m0_.nb_mail_envoye AS nb_mail_envoye_9,
  m0_.nb_mail AS nb_mail_10,
  m0_.modification_old AS modification_old_11,
  m0_.objet_cour AS objet_cour_12,
  m0_.resumer_cour AS resumer_cour_13,
  m0_.color AS color_14,
  m0_.titre AS titre_15,
  m0_.content AS content_16,
  m0_.date_envoi AS date_envoi_17,
  m0_.langue AS langue_18,
  m0_.debut_mail_coupure AS debut_mail_coupure_19,
  m0_.fin_mail_coupure AS fin_mail_coupure_20,
  m0_.hyperlien AS hyperlien_21,
  m0_.signature AS signature_22,
  m0_.signature_contenu AS signature_contenu_23,
  m0_.priorite AS priorite_24,
  m0_.creation AS creation_25,
  m0_.modification AS modification_26,
  c1_.id AS id_27,
  c1_.nom AS nom_28,
  c1_.adresse_generique AS adresse_generique_29,
  c1_.adresse_coupure AS adresse_coupure_30,
  c1_.actuel AS actuel_31,
  c1_.ancien_id AS ancien_id_32,
  c1_.dirigeant AS dirigeant_33,
  c1_.date_entree AS date_entree_34,
  c1_.date_sortie AS date_sortie_35,
  c1_.duree AS duree_36,
  c1_.score AS score_37,
  l2_.id AS id_38,
  l2_.url AS url_39,
  c3_.id AS id_40,
  c3_.ancien_id AS ancien_id_41,
  c3_.nom AS nom_42,
  c3_.prenom AS prenom_43,
  c3_.email AS email_44,
  e4_.id AS id_45,
  e4_.nom AS nom_46,
  e4_.date_debut AS date_debut_47,
  e4_.date_fin AS date_fin_48,
  e4_.type AS type_49,
  e4_.full_day AS full_day_50,
  e4_.event_nom AS event_nom_51,
  a5_.id AS id_52,
  a5_.username AS username_53,
  a5_.password_mail AS password_mail_54,
  a5_.password AS password_55,
  a5_.roles AS roles_56,
  a5_.old_login AS old_login_57,
  a5_.old_password AS old_password_58,
  a5_.actuel AS actuel_59,
  a5_.fonction AS fonction_60,
  a5_.date_arrive AS date_arrive_61,
  a5_.tel_interne AS tel_interne_62,
  a5_.adresse_envoi AS adresse_envoi_63,
  a5_.count_email_verifier_existant_adelete AS count_email_verifier_existant_adelete_64,
  a5_.u_systeme AS u_systeme_65,
  u6_.id AS id_66,
  u6_.prenom AS prenom_67,
  u6_.nom AS nom_68,
  u6_.email AS email_69,
  u6_.resp_conge AS resp_conge_70,
  u6_.tel AS tel_71,
  a7_.id AS id_72,
  a7_.username AS username_73,
  a7_.password_mail AS password_mail_74,
  a7_.password AS password_75,
  a7_.roles AS roles_76,
  a7_.old_login AS old_login_77,
  a7_.old_password AS old_password_78,
  a7_.actuel AS actuel_79,
  a7_.fonction AS fonction_80,
  a7_.date_arrive AS date_arrive_81,
  a7_.tel_interne AS tel_interne_82,
  a7_.adresse_envoi AS adresse_envoi_83,
  a7_.count_email_verifier_existant_adelete AS count_email_verifier_existant_adelete_84,
  a7_.u_systeme AS u_systeme_85,
  u8_.id AS id_86,
  u8_.prenom AS prenom_87,
  u8_.nom AS nom_88,
  u8_.email AS email_89,
  u8_.resp_conge AS resp_conge_90,
  u8_.tel AS tel_91,
  p9_.id AS id_92,
  p9_.url AS url_93,
  p10_.id AS id_94,
  p10_.partie AS partie_95,
  p10_.contenu AS contenu_96,
  p11_.id AS id_97,
  p11_.url AS url_98,
  p12_.id AS id_99,
  p12_.url AS url_100,
  l13_.id AS id_101,
  l13_.url AS url_102,
  a14_.id AS id_103,
  a14_.username AS username_104,
  a14_.password_mail AS password_mail_105,
  a14_.password AS password_106,
  a14_.roles AS roles_107,
  a14_.old_login AS old_login_108,
  a14_.old_password AS old_password_109,
  a14_.actuel AS actuel_110,
  a14_.fonction AS fonction_111,
  a14_.date_arrive AS date_arrive_112,
  a14_.tel_interne AS tel_interne_113,
  a14_.adresse_envoi AS adresse_envoi_114,
  a14_.count_email_verifier_existant_adelete AS count_email_verifier_existant_adelete_115,
  a14_.u_systeme AS u_systeme_116,
  u15_.id AS id_117,
  u15_.prenom AS prenom_118,
  u15_.nom AS nom_119,
  u15_.email AS email_120,
  u15_.resp_conge AS resp_conge_121,
  u15_.tel AS tel_122,
  o16_.id AS id_123,
  o16_.libelle AS libelle_124,
  n17_.id AS id_125,
  n17_.libelle AS libelle_126,
  s18_.id AS id_127,
  s18_.libelle AS libelle_128,
  l19_.id AS id_129,
  l19_.nom AS nom_130,
  l19_.commentaires AS commentaires_131,
  l19_.creation AS creation_132,
  l19_.modification AS modification_133,
  l19_.ancien_id AS ancien_id_134,
  l20_.id AS id_135,
  l20_.nom AS nom_136,
  l20_.commentaires AS commentaires_137,
  l20_.creation AS creation_138,
  l20_.modification AS modification_139,
  l20_.ancien_id AS ancien_id_140,
  m0_.client_id AS client_id_141,
  m0_.envoye_par AS envoye_par_142,
  m0_.reply_to AS reply_to_143,
  m0_.pdf_id AS pdf_id_144,
  m0_.photo_id AS photo_id_145,
  m0_.logo_id AS logo_id_146,
  m0_.auteur_id AS auteur_id_147,
  m0_.outil_id AS outil_id_148,
  m0_.niveau_id AS niveau_id_149,
  m0_.sous_niveau_id AS sous_niveau_id_150,
  c1_.logo_id AS logo_id_151,
  c1_.pressroom_client AS pressroom_client_152,
  c1_.etat_id AS etat_id_153,
  c1_.liste_journaliste_interview_article_id AS liste_journaliste_interview_article_id_154,
  c3_.client AS client_155,
  e4_.auteur AS auteur_156,
  e4_.salle AS salle_157,
  e4_.client AS client_158,
  a5_.user_id AS user_id_159,
  u6_.civilite AS civilite_160,
  u6_.id_adress AS id_adress_161,
  a7_.user_id AS user_id_162,
  u8_.civilite AS civilite_163,
  u8_.id_adress AS id_adress_164,
  p9_.mailling_id AS mailling_id_165,
  p9_.coupure_id AS coupure_id_166,
  p10_.mailling_id AS mailling_id_167,
  a14_.user_id AS user_id_168,
  u15_.civilite AS civilite_169,
  u15_.id_adress AS id_adress_170,
  l19_.auteur_id AS auteur_id_171,
  l19_.type_id AS type_id_172,
  l20_.auteur_id AS auteur_id_173,
  l20_.type_id AS type_id_174
FROM
  mailling m0_
  INNER JOIN client c1_ ON m0_.client_id = c1_.id
  LEFT JOIN logo l2_ ON c1_.logo_id = l2_.id
  LEFT JOIN client_personne c3_ ON c1_.id = c3_.client
  LEFT JOIN evenement e4_ ON c1_.id = e4_.client
  LEFT JOIN auth_user a5_ ON m0_.envoye_par = a5_.id
  LEFT JOIN user u6_ ON a5_.user_id = u6_.id
  LEFT JOIN auth_user a7_ ON m0_.reply_to = a7_.id
  LEFT JOIN user u8_ ON a7_.user_id = u8_.id
  LEFT JOIN piece_jointe_mailling p9_ ON m0_.id = p9_.mailling_id
  LEFT JOIN partie_cp p10_ ON m0_.id = p10_.mailling_id
  LEFT JOIN pdf p11_ ON m0_.pdf_id = p11_.id
  LEFT JOIN photo_mailling p12_ ON m0_.photo_id = p12_.id
  LEFT JOIN logo_mailling l13_ ON m0_.logo_id = l13_.id
  LEFT JOIN auth_user a14_ ON m0_.auteur_id = a14_.id
  LEFT JOIN user u15_ ON a14_.user_id = u15_.id
  LEFT JOIN outil o16_ ON m0_.outil_id = o16_.id
  LEFT JOIN niveau n17_ ON m0_.niveau_id = n17_.id
  LEFT JOIN sous_niveau s18_ ON m0_.sous_niveau_id = s18_.id
  LEFT JOIN mailling_liste_associee m21_ ON m0_.id = m21_.mailling_id
  LEFT JOIN liste_contact l19_ ON l19_.id = m21_.liste_contact_id
  LEFT JOIN mailling_liste_desassociee m22_ ON m0_.id = m22_.mailling_id
  LEFT JOIN liste_contact l20_ ON l20_.id = m22_.liste_contact_id
WHERE
  m0_.id IN (
    SELECT
      m23_.id
    FROM
      mailling m23_
      INNER JOIN client c24_ ON m23_.client_id = c24_.id
    WHERE
      m23_.envoyer = ?
      AND m23_.type_mail = ?
      AND c24_.id = ?
  )
ORDER BY
  m0_.id DESC

SELECT m0_.id AS id_0, m0_.ancien_id AS ancien_id_1, m0_.nom AS nom_2, m0_.valider_envoi AS valider_envoi_3, m0_.envoyer AS envoyer_4, m0_.resumer AS resumer_5, m0_.type_mail AS type_mail_6, m0_.en_cour AS en_cour_7, m0_.objet AS objet_8, m0_.nb_mail_envoye AS nb_mail_envoye_9, m0_.nb_mail AS nb_mail_10, m0_.modification_old AS modification_old_11, m0_.objet_cour AS objet_cour_12, m0_.resumer_cour AS resumer_cour_13, m0_.color AS color_14, m0_.titre AS titre_15, m0_.content AS content_16, m0_.date_envoi AS date_envoi_17, m0_.langue AS langue_18, m0_.debut_mail_coupure AS debut_mail_coupure_19, m0_.fin_mail_coupure AS fin_mail_coupure_20, m0_.hyperlien AS hyperlien_21, m0_.signature AS signature_22, m0_.signature_contenu AS signature_contenu_23, m0_.priorite AS priorite_24, m0_.creation AS creation_25, m0_.modification AS modification_26, c1_.id AS id_27, c1_.nom AS nom_28, c1_.adresse_generique AS adresse_generique_29, c1_.adresse_coupure AS adresse_coupure_30, c1_.actuel AS actuel_31, c1_.ancien_id AS ancien_id_32, c1_.dirigeant AS dirigeant_33, c1_.date_entree AS date_entree_34, c1_.date_sortie AS date_sortie_35, c1_.duree AS duree_36, c1_.score AS score_37, l2_.id AS id_38, l2_.url AS url_39, c3_.id AS id_40, c3_.ancien_id AS ancien_id_41, c3_.nom AS nom_42, c3_.prenom AS prenom_43, c3_.email AS email_44, e4_.id AS id_45, e4_.nom AS nom_46, e4_.date_debut AS date_debut_47, e4_.date_fin AS date_fin_48, e4_.type AS type_49, e4_.full_day AS full_day_50, e4_.event_nom AS event_nom_51, a5_.id AS id_52, a5_.username AS username_53, a5_.password_mail AS password_mail_54, a5_.password AS password_55, a5_.roles AS roles_56, a5_.old_login AS old_login_57, a5_.old_password AS old_password_58, a5_.actuel AS actuel_59, a5_.fonction AS fonction_60, a5_.date_arrive AS date_arrive_61, a5_.tel_interne AS tel_interne_62, a5_.adresse_envoi AS adresse_envoi_63, a5_.count_email_verifier_existant_adelete AS count_email_verifier_existant_adelete_64, a5_.u_systeme AS u_systeme_65, u6_.id AS id_66, u6_.prenom AS prenom_67, u6_.nom AS nom_68, u6_.email AS email_69, u6_.resp_conge AS resp_conge_70, u6_.tel AS tel_71, a7_.id AS id_72, a7_.username AS username_73, a7_.password_mail AS password_mail_74, a7_.password AS password_75, a7_.roles AS roles_76, a7_.old_login AS old_login_77, a7_.old_password AS old_password_78, a7_.actuel AS actuel_79, a7_.fonction AS fonction_80, a7_.date_arrive AS date_arrive_81, a7_.tel_interne AS tel_interne_82, a7_.adresse_envoi AS adresse_envoi_83, a7_.count_email_verifier_existant_adelete AS count_email_verifier_existant_adelete_84, a7_.u_systeme AS u_systeme_85, u8_.id AS id_86, u8_.prenom AS prenom_87, u8_.nom AS nom_88, u8_.email AS email_89, u8_.resp_conge AS resp_conge_90, u8_.tel AS tel_91, p9_.id AS id_92, p9_.url AS url_93, p10_.id AS id_94, p10_.partie AS partie_95, p10_.contenu AS contenu_96, p11_.id AS id_97, p11_.url AS url_98, p12_.id AS id_99, p12_.url AS url_100, l13_.id AS id_101, l13_.url AS url_102, a14_.id AS id_103, a14_.username AS username_104, a14_.password_mail AS password_mail_105, a14_.password AS password_106, a14_.roles AS roles_107, a14_.old_login AS old_login_108, a14_.old_password AS old_password_109, a14_.actuel AS actuel_110, a14_.fonction AS fonction_111, a14_.date_arrive AS date_arrive_112, a14_.tel_interne AS tel_interne_113, a14_.adresse_envoi AS adresse_envoi_114, a14_.count_email_verifier_existant_adelete AS count_email_verifier_existant_adelete_115, a14_.u_systeme AS u_systeme_116, u15_.id AS id_117, u15_.prenom AS prenom_118, u15_.nom AS nom_119, u15_.email AS email_120, u15_.resp_conge AS resp_conge_121, u15_.tel AS tel_122, o16_.id AS id_123, o16_.libelle AS libelle_124, n17_.id AS id_125, n17_.libelle AS libelle_126, s18_.id AS id_127, s18_.libelle AS libelle_128, l19_.id AS id_129, l19_.nom AS nom_130, l19_.commentaires AS commentaires_131, l19_.creation AS creation_132, l19_.modification AS modification_133, l19_.ancien_id AS ancien_id_134, l20_.id AS id_135, l20_.nom AS nom_136, l20_.commentaires AS commentaires_137, l20_.creation AS creation_138, l20_.modification AS modification_139, l20_.ancien_id AS ancien_id_140, m0_.client_id AS client_id_141, m0_.envoye_par AS envoye_par_142, m0_.reply_to AS reply_to_143, m0_.pdf_id AS pdf_id_144, m0_.photo_id AS photo_id_145, m0_.logo_id AS logo_id_146, m0_.auteur_id AS auteur_id_147, m0_.outil_id AS outil_id_148, m0_.niveau_id AS niveau_id_149, m0_.sous_niveau_id AS sous_niveau_id_150, c1_.logo_id AS logo_id_151, c1_.pressroom_client AS pressroom_client_152, c1_.etat_id AS etat_id_153, c1_.liste_journaliste_interview_article_id AS liste_journaliste_interview_article_id_154, c3_.client AS client_155, e4_.auteur AS auteur_156, e4_.salle AS salle_157, e4_.client AS client_158, a5_.user_id AS user_id_159, u6_.civilite AS civilite_160, u6_.id_adress AS id_adress_161, a7_.user_id AS user_id_162, u8_.civilite AS civilite_163, u8_.id_adress AS id_adress_164, p9_.mailling_id AS mailling_id_165, p9_.coupure_id AS coupure_id_166, p10_.mailling_id AS mailling_id_167, a14_.user_id AS user_id_168, u15_.civilite AS civilite_169, u15_.id_adress AS id_adress_170, l19_.auteur_id AS auteur_id_171, l19_.type_id AS type_id_172, l20_.auteur_id AS auteur_id_173, l20_.type_id AS type_id_174 FROM mailling m0_ INNER JOIN client c1_ ON m0_.client_id = c1_.id LEFT JOIN logo l2_ ON c1_.logo_id = l2_.id LEFT JOIN client_personne c3_ ON c1_.id = c3_.client LEFT JOIN evenement e4_ ON c1_.id = e4_.client LEFT JOIN auth_user a5_ ON m0_.envoye_par = a5_.id LEFT JOIN user u6_ ON a5_.user_id = u6_.id LEFT JOIN auth_user a7_ ON m0_.reply_to = a7_.id LEFT JOIN user u8_ ON a7_.user_id = u8_.id LEFT JOIN piece_jointe_mailling p9_ ON m0_.id = p9_.mailling_id LEFT JOIN partie_cp p10_ ON m0_.id = p10_.mailling_id LEFT JOIN pdf p11_ ON m0_.pdf_id = p11_.id LEFT JOIN photo_mailling p12_ ON m0_.photo_id = p12_.id LEFT JOIN logo_mailling l13_ ON m0_.logo_id = l13_.id LEFT JOIN auth_user a14_ ON m0_.auteur_id = a14_.id LEFT JOIN user u15_ ON a14_.user_id = u15_.id LEFT JOIN outil o16_ ON m0_.outil_id = o16_.id LEFT JOIN niveau n17_ ON m0_.niveau_id = n17_.id LEFT JOIN sous_niveau s18_ ON m0_.sous_niveau_id = s18_.id LEFT JOIN mailling_liste_associee m21_ ON m0_.id = m21_.mailling_id LEFT JOIN liste_contact l19_ ON l19_.id = m21_.liste_contact_id LEFT JOIN mailling_liste_desassociee m22_ ON m0_.id = m22_.mailling_id LEFT JOIN liste_contact l20_ ON l20_.id = m22_.liste_contact_id WHERE m0_.id IN (SELECT m23_.id FROM mailling m23_ INNER JOIN client c24_ ON m23_.client_id = c24_.id WHERE m23_.envoyer = '1' AND m23_.type_mail = 'CP' AND c24_.id = '397') ORDER BY m0_.id DESC;