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
  c0_.id AS id_0,
  c0_.ancien_id AS ancien_id_1,
  c0_.nom AS nom_2,
  c0_.prenom AS prenom_3,
  c0_.mode_envoi_pref AS mode_envoi_pref_4,
  c0_.pieces_jointes AS pieces_jointes_5,
  c0_.contact_perso AS contact_perso_6,
  c0_.commentaires AS commentaires_7,
  c0_.objet AS objet_8,
  c0_.date_conclusion AS date_conclusion_9,
  c0_.creation AS creation_10,
  c0_.modification AS modification_11,
  c0_.dernier_import AS dernier_import_12,
  a1_.id AS id_13,
  a1_.username AS username_14,
  a1_.password_mail AS password_mail_15,
  a1_.password AS password_16,
  a1_.roles AS roles_17,
  a1_.old_login AS old_login_18,
  a1_.old_password AS old_password_19,
  a1_.actuel AS actuel_20,
  a1_.fonction AS fonction_21,
  a1_.date_arrive AS date_arrive_22,
  a1_.tel_interne AS tel_interne_23,
  a1_.adresse_envoi AS adresse_envoi_24,
  a1_.count_email_verifier_existant_adelete AS count_email_verifier_existant_adelete_25,
  a1_.u_systeme AS u_systeme_26,
  u2_.id AS id_27,
  u2_.prenom AS prenom_28,
  u2_.nom AS nom_29,
  u2_.email AS email_30,
  u2_.resp_conge AS resp_conge_31,
  u2_.tel AS tel_32,
  c3_.id AS id_33,
  c3_.ancien_id AS ancien_id_34,
  c3_.libelle AS libelle_35,
  c3_.genre AS genre_36,
  f4_.id AS id_37,
  f4_.libelle AS libelle_38,
  f4_.ancien_id AS ancien_id_39,
  c5_.id AS id_40,
  c5_.premier_tel AS premier_tel_41,
  c5_.deuxieme_tel AS deuxieme_tel_42,
  c5_.email AS email_43,
  c5_.rue AS rue_44,
  c5_.complements AS complements_45,
  c5_.boite_postale AS boite_postale_46,
  c5_.code_postal AS code_postal_47,
  c5_.ville AS ville_48,
  c5_.premier_url AS premier_url_49,
  c5_.deuxieme_url AS deuxieme_url_50,
  c5_.creation AS creation_51,
  c5_.modification AS modification_52,
  c5_.ancien_id AS ancien_id_53,
  p6_.id AS id_54,
  p6_.libelle_fr AS libelle_fr_55,
  p6_.libelle_en AS libelle_en_56,
  p6_.iso AS iso_57,
  a7_.id AS id_58,
  a7_.username AS username_59,
  a7_.password_mail AS password_mail_60,
  a7_.password AS password_61,
  a7_.roles AS roles_62,
  a7_.old_login AS old_login_63,
  a7_.old_password AS old_password_64,
  a7_.actuel AS actuel_65,
  a7_.fonction AS fonction_66,
  a7_.date_arrive AS date_arrive_67,
  a7_.tel_interne AS tel_interne_68,
  a7_.adresse_envoi AS adresse_envoi_69,
  a7_.count_email_verifier_existant_adelete AS count_email_verifier_existant_adelete_70,
  a7_.u_systeme AS u_systeme_71,
  u8_.id AS id_72,
  u8_.prenom AS prenom_73,
  u8_.nom AS nom_74,
  u8_.email AS email_75,
  u8_.resp_conge AS resp_conge_76,
  u8_.tel AS tel_77,
  g9_.id AS id_78,
  g9_.libelle AS libelle_79,
  c10_.id AS id_80,
  c10_.libelle AS libelle_81,
  c10_.ancien_id AS ancien_id_82,
  c10_.is_theme_client AS is_theme_client_83,
  s11_.id AS id_84,
  s11_.libelle AS libelle_85,
  s11_.ancien_id AS ancien_id_86,
  l12_.id AS id_87,
  l12_.libelle AS libelle_88,
  l12_.iso AS iso_89,
  p13_.id AS id_90,
  p13_.libelle_fr AS libelle_fr_91,
  p13_.libelle_en AS libelle_en_92,
  p13_.iso AS iso_93,
  o14_.id AS id_94,
  o14_.ancien_id AS ancien_id_95,
  o14_.nom AS nom_96,
  o14_.date_creation AS date_creation_97,
  o14_.siren AS siren_98,
  o14_.capital AS capital_99,
  o14_.effectif AS effectif_100,
  o14_.implantation AS implantation_101,
  o14_.commentaires AS commentaires_102,
  o14_.creation AS creation_103,
  o14_.modification AS modification_104,
  c15_.id AS id_105,
  c15_.premier_tel AS premier_tel_106,
  c15_.deuxieme_tel AS deuxieme_tel_107,
  c15_.email AS email_108,
  o16_.id AS id_109,
  o16_.ancien_id AS ancien_id_110,
  o16_.nom AS nom_111,
  o16_.date_creation AS date_creation_112,
  o16_.siren AS siren_113,
  o16_.capital AS capital_114,
  o16_.effectif AS effectif_115,
  o16_.implantation AS implantation_116,
  o16_.commentaires AS commentaires_117,
  o16_.creation AS creation_118,
  o16_.modification AS modification_119,
  c17_.id AS id_120,
  c17_.ancien_id AS ancien_id_121,
  c17_.dossier AS dossier_122,
  c17_.date_bouclage AS date_bouclage_123,
  c17_.date_parution AS date_parution_124,
  c17_.portrait AS portrait_125,
  c17_.notes AS notes_126,
  c17_.creation AS creation_127,
  c17_.modification AS modification_128,
  s18_.id AS id_129,
  s18_.ancien_id AS ancien_id_130,
  s18_.date AS date_131,
  s18_.titre AS titre_132,
  s18_.commentaires AS commentaires_133,
  s18_.niveau AS niveau_134,
  s18_.a_paraitre AS a_paraitre_135,
  s18_.inclure_ra AS inclure_ra_136,
  s18_.email AS email_137,
  s18_.telephone AS telephone_138,
  s18_.creation AS creation_139,
  s18_.modification AS modification_140,
  s18_.niveau_mutualisation AS niveau_mutualisation_141,
  s18_.calendar_sequence AS calendar_sequence_142,
  c19_.id AS id_143,
  c19_.premier_tel AS premier_tel_144,
  c19_.deuxieme_tel AS deuxieme_tel_145,
  c19_.email AS email_146,
  c19_.participe AS participe_147,
  c19_.date_depart AS date_depart_148,
  c19_.commentaires AS commentaires_149,
  c19_.dernier_email_verif AS dernier_email_verif_150,
  s20_.id AS id_151,
  s20_.nom AS nom_152,
  s20_.date_parution AS date_parution_153,
  s20_.date_bouclage AS date_bouclage_154,
  s20_.audience AS audience_155,
  s20_.mediametrie AS mediametrie_156,
  s20_.ojd AS ojd_157,
  s20_.equiv_pub AS equiv_pub_158,
  s20_.precisions AS precisions_159,
  s20_.positionnement AS positionnement_160,
  s20_.cible AS cible_161,
  s20_.commentaires AS commentaires_162,
  s20_.disponibilite AS disponibilite_163,
  s20_.exemp_dispo AS exemp_dispo_164,
  s20_.ancien_id AS ancien_id_165,
  s20_.creation AS creation_166,
  s20_.modification AS modification_167,
  s20_.tel_standard AS tel_standard_168,
  s20_.tel_publicite AS tel_publicite_169,
  f21_.id AS id_170,
  f21_.libelle AS libelle_171,
  f21_.ancien_id AS ancien_id_172,
  r22_.id AS id_173,
  r22_.linkedin_url AS linkedin_url_174,
  r22_.twitter_url AS twitter_url_175,
  r22_.facebook_url AS facebook_url_176,
  c0_.auteur_id AS auteur_id_177,
  c0_.civilite_id AS civilite_id_178,
  c0_.fonction_id AS fonction_id_179,
  c0_.coordonnees_id AS coordonnees_id_180,
  c0_.genre_id AS genre_id_181,
  c0_.reseaux_sociaux_id AS reseaux_sociaux_id_182,
  a1_.user_id AS user_id_183,
  u2_.civilite AS civilite_184,
  u2_.id_adress AS id_adress_185,
  c5_.pays_id AS pays_id_186,
  c5_.auteur_id AS auteur_id_187,
  a7_.user_id AS user_id_188,
  u8_.civilite AS civilite_189,
  u8_.id_adress AS id_adress_190,
  o14_.auteur_id AS auteur_id_191,
  o14_.appartenir_a_id AS appartenir_a_id_192,
  o14_.client_id AS client_id_193,
  o14_.forme_juridique_id AS forme_juridique_id_194,
  o14_.genre_id AS genre_id_195,
  o14_.categorie_generale_id AS categorie_generale_id_196,
  o14_.coordonnees_id AS coordonnees_id_197,
  o14_.dirigeant_id AS dirigeant_id_198,
  o14_.ape_id AS ape_id_199,
  c15_.contact_id AS contact_id_200,
  c15_.organisation_id AS organisation_id_201,
  o16_.auteur_id AS auteur_id_202,
  o16_.appartenir_a_id AS appartenir_a_id_203,
  o16_.client_id AS client_id_204,
  o16_.forme_juridique_id AS forme_juridique_id_205,
  o16_.genre_id AS genre_id_206,
  o16_.categorie_generale_id AS categorie_generale_id_207,
  o16_.coordonnees_id AS coordonnees_id_208,
  o16_.dirigeant_id AS dirigeant_id_209,
  o16_.ape_id AS ape_id_210,
  c17_.auteur_id AS auteur_id_211,
  c17_.support_id AS support_id_212,
  c17_.emission_id AS emission_id_213,
  s18_.suivi_par_id AS suivi_par_id_214,
  s18_.mutualisation_id AS mutualisation_id_215,
  s18_.contact_id AS contact_id_216,
  s18_.type_relation_id AS type_relation_id_217,
  s18_.vecteur_id AS vecteur_id_218,
  s18_.statut_id AS statut_id_219,
  s18_.auteur_id AS auteur_id_220,
  s18_.evenement_id AS evenement_id_221,
  c19_.contact_id AS contact_id_222,
  c19_.support_id AS support_id_223,
  c19_.fonction_id AS fonction_id_224,
  s20_.casier_id AS casier_id_225,
  s20_.type_media_id AS type_media_id_226,
  s20_.etat_id AS etat_id_227,
  s20_.organisation_id AS organisation_id_228,
  s20_.famille_id AS famille_id_229,
  s20_.periodicite_id AS periodicite_id_230,
  s20_.type_ojd_id AS type_ojd_id_231,
  s20_.zone_diffusion_id AS zone_diffusion_id_232,
  s20_.coordonnees_id AS coordonnees_id_233,
  s20_.auteur_id AS auteur_id_234,
  s20_.logo_support_id AS logo_support_id_235
FROM
  contact c0_
  LEFT JOIN auth_user a1_ ON c0_.auteur_id = a1_.id
  LEFT JOIN user u2_ ON a1_.user_id = u2_.id
  LEFT JOIN civilite c3_ ON c0_.civilite_id = c3_.id
  LEFT JOIN fonction f4_ ON c0_.fonction_id = f4_.id
  LEFT JOIN coordonnees c5_ ON c0_.coordonnees_id = c5_.id
  LEFT JOIN pays p6_ ON c5_.pays_id = p6_.id
  LEFT JOIN auth_user a7_ ON c5_.auteur_id = a7_.id
  LEFT JOIN user u8_ ON a7_.user_id = u8_.id
  LEFT JOIN genre g9_ ON c0_.genre_id = g9_.id
  LEFT JOIN contact_categories_generales c23_ ON c0_.id = c23_.contact_id
  LEFT JOIN categories_generales c10_ ON c10_.id = c23_.categories_generales_id
  LEFT JOIN contact_sous_categories_generales c24_ ON c0_.id = c24_.contact_id
  LEFT JOIN sous_categories_generales s11_ ON s11_.id = c24_.sous_categories_generales_id
  LEFT JOIN contact_langues c25_ ON c0_.id = c25_.contact_id
  LEFT JOIN langues l12_ ON l12_.id = c25_.langues_id
  LEFT JOIN contact_pays c26_ ON c0_.id = c26_.contact_id
  LEFT JOIN pays p13_ ON p13_.id = c26_.pays_id
  LEFT JOIN organisation o14_ ON c0_.id = o14_.dirigeant_id
  LEFT JOIN contact_organisation c15_ ON c0_.id = c15_.contact_id
  LEFT JOIN organisation o16_ ON c15_.organisation_id = o16_.id
  LEFT JOIN calendrier_redactionnel_contact c27_ ON c0_.id = c27_.contact_id
  LEFT JOIN calendrier_redactionnel c17_ ON c17_.id = c27_.calendrier_redactionnel_id
  LEFT JOIN suivi s18_ ON c0_.id = s18_.contact_id
  LEFT JOIN contact_support c19_ ON c0_.id = c19_.contact_id
  LEFT JOIN support s20_ ON c19_.support_id = s20_.id
  LEFT JOIN fonction f21_ ON c19_.fonction_id = f21_.id
  LEFT JOIN reseaux_sociaux r22_ ON c0_.reseaux_sociaux_id = r22_.id
WHERE
  (
    CONCAT(c0_.nom, ' ', c0_.prenom) LIKE '%Bertrand Lemaire%'
    OR CONCAT(c0_.prenom, ' ', c0_.nom) LIKE '%Bertrand Lemaire%'
  )
ORDER BY
  c0_.nom ASC