Symfony Profiler

SELECT
  count(DISTINCT e0_.id) AS sclr_0
FROM
  entreprise e0_
  LEFT JOIN contact c1_ ON (
    c1_.firm_id = e0_.id
    AND c1_.is_responsible = 1
  )
WHERE
  e0_.status = ?
  AND e0_.figurer_annuaire_adherents = 1

SELECT count(DISTINCT e0_.id) AS sclr_0 FROM entreprise e0_ LEFT JOIN contact c1_ ON (c1_.firm_id = e0_.id AND c1_.is_responsible = 1) WHERE e0_.status = 2 AND e0_.figurer_annuaire_adherents = 1;

SELECT
  DISTINCT e0_.id AS id_0
FROM
  entreprise e0_
  LEFT JOIN contact c1_ ON (
    c1_.firm_id = e0_.id
    AND c1_.is_responsible = 1
  )
WHERE
  e0_.status = ?
  AND e0_.figurer_annuaire_adherents = 1
LIMIT
  15

SELECT DISTINCT e0_.id AS id_0 FROM entreprise e0_ LEFT JOIN contact c1_ ON (c1_.firm_id = e0_.id AND c1_.is_responsible = 1) WHERE e0_.status = 2 AND e0_.figurer_annuaire_adherents = 1 LIMIT 15;

SELECT
  e0_.status AS status_0,
  e0_.id AS id_1,
  e0_.raison_social AS raison_social_2,
  e0_.adresse AS adresse_3,
  e0_.tel1 AS tel1_4,
  e0_.tel2 AS tel2_5,
  e0_.fax AS fax_6,
  e0_.email AS email_7,
  e0_.code_siren AS code_siren_8,
  e0_.code_ape AS code_ape_9,
  e0_.num_tva_intracom AS num_tva_intracom_10,
  e0_.ancien_identifiant AS ancien_identifiant_11,
  e0_.identifiant_compta AS identifiant_compta_12,
  e0_.num_ede_negoce AS num_ede_negoce_13,
  e0_.num_ede_centre AS num_ede_centre_14,
  e0_.num_ede_elevage AS num_ede_elevage_15,
  e0_.nombre_employes AS nombre_employes_16,
  e0_.autre_specialite AS autre_specialite_17,
  e0_.volume_animaux AS volume_animaux_18,
  e0_.souhaite_adherer AS souhaite_adherer_19,
  e0_.figurer_annuaire_adherents AS figurer_annuaire_adherents_20,
  e0_.figurer_annuaire_internet AS figurer_annuaire_internet_21,
  e0_.figurer_au_nom_de AS figurer_au_nom_de_22,
  e0_.statut_paiement AS statut_paiement_23,
  e0_.raison_non_adhesion AS raison_non_adhesion_24,
  e0_.date_cessation AS date_cessation_25,
  e0_.chiffre_dernier_total AS chiffre_dernier_total_26,
  e0_.commentaires AS commentaires_27,
  e0_.is_transporter AS is_transporter_28,
  e0_.transport_pour_autrui AS transport_pour_autrui_29,
  e0_.lien_url AS lien_url_30,
  e0_.ville AS ville_31,
  e0_.code_postal AS code_postal_32,
  e0_.adresse2 AS adresse2_33,
  e0_.nombre_veaux AS nombre_veaux_34,
  e0_.nombre_maigres AS nombre_maigres_35,
  e0_.nombre_elev_prod AS nombre_elev_prod_36,
  e0_.nombre_boucherie AS nombre_boucherie_37,
  e0_.nombre_ovins AS nombre_ovins_38,
  e0_.nombre_porcins AS nombre_porcins_39,
  e0_.nombre_equins AS nombre_equins_40,
  e0_.nombre_caprins AS nombre_caprins_41,
  e0_.autre_activite AS autre_activite_42,
  e0_.code_adherent AS code_adherent_43,
  e0_.is_quali_negoce AS is_quali_negoce_44,
  e0_.quali_negoce_certification_date AS quali_negoce_certification_date_45,
  e0_.quali_negoce_contact_name AS quali_negoce_contact_name_46,
  e0_.raison_non_adhesion_autre AS raison_non_adhesion_autre_47,
  e0_.total_count_species AS total_count_species_48,
  e0_.quali_negoce_pre_audit_date AS quali_negoce_pre_audit_date_49,
  e0_.is_member AS is_member_50,
  e0_.groupe_entreprise_id AS groupe_entreprise_id_51,
  e0_.departement_id AS departement_id_52,
  e0_.syndicat_id AS syndicat_id_53,
  e0_.transporteur_id AS transporteur_id_54,
  e0_.contact_responsable_id AS contact_responsable_id_55,
  e0_.home_region_id AS home_region_id_56,
  e0_.commission_id AS commission_id_57,
  e0_.quali_negoce_contact_id AS quali_negoce_contact_id_58,
  e0_.firm_type_id AS firm_type_id_59
FROM
  entreprise e0_
  LEFT JOIN contact c1_ ON (
    c1_.firm_id = e0_.id
    AND c1_.is_responsible = 1
  )
WHERE
  e0_.status = ?
  AND e0_.figurer_annuaire_adherents = 1
  AND e0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

SELECT e0_.status AS status_0, e0_.id AS id_1, e0_.raison_social AS raison_social_2, e0_.adresse AS adresse_3, e0_.tel1 AS tel1_4, e0_.tel2 AS tel2_5, e0_.fax AS fax_6, e0_.email AS email_7, e0_.code_siren AS code_siren_8, e0_.code_ape AS code_ape_9, e0_.num_tva_intracom AS num_tva_intracom_10, e0_.ancien_identifiant AS ancien_identifiant_11, e0_.identifiant_compta AS identifiant_compta_12, e0_.num_ede_negoce AS num_ede_negoce_13, e0_.num_ede_centre AS num_ede_centre_14, e0_.num_ede_elevage AS num_ede_elevage_15, e0_.nombre_employes AS nombre_employes_16, e0_.autre_specialite AS autre_specialite_17, e0_.volume_animaux AS volume_animaux_18, e0_.souhaite_adherer AS souhaite_adherer_19, e0_.figurer_annuaire_adherents AS figurer_annuaire_adherents_20, e0_.figurer_annuaire_internet AS figurer_annuaire_internet_21, e0_.figurer_au_nom_de AS figurer_au_nom_de_22, e0_.statut_paiement AS statut_paiement_23, e0_.raison_non_adhesion AS raison_non_adhesion_24, e0_.date_cessation AS date_cessation_25, e0_.chiffre_dernier_total AS chiffre_dernier_total_26, e0_.commentaires AS commentaires_27, e0_.is_transporter AS is_transporter_28, e0_.transport_pour_autrui AS transport_pour_autrui_29, e0_.lien_url AS lien_url_30, e0_.ville AS ville_31, e0_.code_postal AS code_postal_32, e0_.adresse2 AS adresse2_33, e0_.nombre_veaux AS nombre_veaux_34, e0_.nombre_maigres AS nombre_maigres_35, e0_.nombre_elev_prod AS nombre_elev_prod_36, e0_.nombre_boucherie AS nombre_boucherie_37, e0_.nombre_ovins AS nombre_ovins_38, e0_.nombre_porcins AS nombre_porcins_39, e0_.nombre_equins AS nombre_equins_40, e0_.nombre_caprins AS nombre_caprins_41, e0_.autre_activite AS autre_activite_42, e0_.code_adherent AS code_adherent_43, e0_.is_quali_negoce AS is_quali_negoce_44, e0_.quali_negoce_certification_date AS quali_negoce_certification_date_45, e0_.quali_negoce_contact_name AS quali_negoce_contact_name_46, e0_.raison_non_adhesion_autre AS raison_non_adhesion_autre_47, e0_.total_count_species AS total_count_species_48, e0_.quali_negoce_pre_audit_date AS quali_negoce_pre_audit_date_49, e0_.is_member AS is_member_50, e0_.groupe_entreprise_id AS groupe_entreprise_id_51, e0_.departement_id AS departement_id_52, e0_.syndicat_id AS syndicat_id_53, e0_.transporteur_id AS transporteur_id_54, e0_.contact_responsable_id AS contact_responsable_id_55, e0_.home_region_id AS home_region_id_56, e0_.commission_id AS commission_id_57, e0_.quali_negoce_contact_id AS quali_negoce_contact_id_58, e0_.firm_type_id AS firm_type_id_59 FROM entreprise e0_ LEFT JOIN contact c1_ ON (c1_.firm_id = e0_.id AND c1_.is_responsible = 1) WHERE e0_.status = 2 AND e0_.figurer_annuaire_adherents = 1 AND e0_.id IN (774, 1037, 1140, 1305, 1348, 1484, 1510, 1536, 1559, 1572, 1583, 1596, 1602, 1606, 1611);

SELECT
  t0.status AS status_1,
  t0.id AS id_2,
  t0.type_contact AS type_contact_3,
  t0.nom AS nom_4,
  t0.prenom AS prenom_5,
  t0.tel_portable AS tel_portable_6,
  t0.tel_portable2 AS tel_portable2_7,
  t0.tel_bureau AS tel_bureau_8,
  t0.email_contact AS email_contact_9,
  t0.date_naissance AS date_naissance_10,
  t0.commentaire AS commentaire_11,
  t0.adresse AS adresse_12,
  t0.adresse2 AS adresse2_13,
  t0.ville AS ville_14,
  t0.code_postal AS code_postal_15,
  t0.is_responsible AS is_responsible_16,
  t0.is_privileged AS is_privileged_17,
  t0.civilite AS civilite_18,
  t0.type AS type_19,
  t20.status AS status_21,
  t20.id AS id_22,
  t20.raison_social AS raison_social_23,
  t20.adresse AS adresse_24,
  t20.tel1 AS tel1_25,
  t20.tel2 AS tel2_26,
  t20.fax AS fax_27,
  t20.email AS email_28,
  t20.code_siren AS code_siren_29,
  t20.code_ape AS code_ape_30,
  t20.num_tva_intracom AS num_tva_intracom_31,
  t20.ancien_identifiant AS ancien_identifiant_32,
  t20.identifiant_compta AS identifiant_compta_33,
  t20.num_ede_negoce AS num_ede_negoce_34,
  t20.num_ede_centre AS num_ede_centre_35,
  t20.num_ede_elevage AS num_ede_elevage_36,
  t20.nombre_employes AS nombre_employes_37,
  t20.autre_specialite AS autre_specialite_38,
  t20.volume_animaux AS volume_animaux_39,
  t20.souhaite_adherer AS souhaite_adherer_40,
  t20.figurer_annuaire_adherents AS figurer_annuaire_adherents_41,
  t20.figurer_annuaire_internet AS figurer_annuaire_internet_42,
  t20.figurer_au_nom_de AS figurer_au_nom_de_43,
  t20.statut_paiement AS statut_paiement_44,
  t20.raison_non_adhesion AS raison_non_adhesion_45,
  t20.date_cessation AS date_cessation_46,
  t20.chiffre_dernier_total AS chiffre_dernier_total_47,
  t20.commentaires AS commentaires_48,
  t20.is_transporter AS is_transporter_49,
  t20.transport_pour_autrui AS transport_pour_autrui_50,
  t20.lien_url AS lien_url_51,
  t20.ville AS ville_52,
  t20.code_postal AS code_postal_53,
  t20.adresse2 AS adresse2_54,
  t20.nombre_veaux AS nombre_veaux_55,
  t20.nombre_maigres AS nombre_maigres_56,
  t20.nombre_elev_prod AS nombre_elev_prod_57,
  t20.nombre_boucherie AS nombre_boucherie_58,
  t20.nombre_ovins AS nombre_ovins_59,
  t20.nombre_porcins AS nombre_porcins_60,
  t20.nombre_equins AS nombre_equins_61,
  t20.nombre_caprins AS nombre_caprins_62,
  t20.autre_activite AS autre_activite_63,
  t20.code_adherent AS code_adherent_64,
  t20.is_quali_negoce AS is_quali_negoce_65,
  t20.quali_negoce_certification_date AS quali_negoce_certification_date_66,
  t20.quali_negoce_contact_name AS quali_negoce_contact_name_67,
  t20.raison_non_adhesion_autre AS raison_non_adhesion_autre_68,
  t20.total_count_species AS total_count_species_69,
  t20.quali_negoce_pre_audit_date AS quali_negoce_pre_audit_date_70,
  t20.is_member AS is_member_71,
  t20.groupe_entreprise_id AS groupe_entreprise_id_72,
  t20.departement_id AS departement_id_73,
  t20.syndicat_id AS syndicat_id_74,
  t20.transporteur_id AS transporteur_id_75,
  t20.contact_responsable_id AS contact_responsable_id_76,
  t20.home_region_id AS home_region_id_77,
  t20.commission_id AS commission_id_78,
  t20.quali_negoce_contact_id AS quali_negoce_contact_id_79,
  t20.firm_type_id AS firm_type_id_80,
  t0.firm_id AS firm_id_81,
  t0.user_id AS user_id_82,
  t0.etablissement_id AS etablissement_id_83
FROM
  contact t0
  LEFT JOIN entreprise t20 ON t20.contact_responsable_id = t0.id
WHERE
  t0.firm_id = ?
ORDER BY
  t0.is_responsible DESC

SELECT t0.status AS status_1, t0.id AS id_2, t0.type_contact AS type_contact_3, t0.nom AS nom_4, t0.prenom AS prenom_5, t0.tel_portable AS tel_portable_6, t0.tel_portable2 AS tel_portable2_7, t0.tel_bureau AS tel_bureau_8, t0.email_contact AS email_contact_9, t0.date_naissance AS date_naissance_10, t0.commentaire AS commentaire_11, t0.adresse AS adresse_12, t0.adresse2 AS adresse2_13, t0.ville AS ville_14, t0.code_postal AS code_postal_15, t0.is_responsible AS is_responsible_16, t0.is_privileged AS is_privileged_17, t0.civilite AS civilite_18, t0.type AS type_19, t20.status AS status_21, t20.id AS id_22, t20.raison_social AS raison_social_23, t20.adresse AS adresse_24, t20.tel1 AS tel1_25, t20.tel2 AS tel2_26, t20.fax AS fax_27, t20.email AS email_28, t20.code_siren AS code_siren_29, t20.code_ape AS code_ape_30, t20.num_tva_intracom AS num_tva_intracom_31, t20.ancien_identifiant AS ancien_identifiant_32, t20.identifiant_compta AS identifiant_compta_33, t20.num_ede_negoce AS num_ede_negoce_34, t20.num_ede_centre AS num_ede_centre_35, t20.num_ede_elevage AS num_ede_elevage_36, t20.nombre_employes AS nombre_employes_37, t20.autre_specialite AS autre_specialite_38, t20.volume_animaux AS volume_animaux_39, t20.souhaite_adherer AS souhaite_adherer_40, t20.figurer_annuaire_adherents AS figurer_annuaire_adherents_41, t20.figurer_annuaire_internet AS figurer_annuaire_internet_42, t20.figurer_au_nom_de AS figurer_au_nom_de_43, t20.statut_paiement AS statut_paiement_44, t20.raison_non_adhesion AS raison_non_adhesion_45, t20.date_cessation AS date_cessation_46, t20.chiffre_dernier_total AS chiffre_dernier_total_47, t20.commentaires AS commentaires_48, t20.is_transporter AS is_transporter_49, t20.transport_pour_autrui AS transport_pour_autrui_50, t20.lien_url AS lien_url_51, t20.ville AS ville_52, t20.code_postal AS code_postal_53, t20.adresse2 AS adresse2_54, t20.nombre_veaux AS nombre_veaux_55, t20.nombre_maigres AS nombre_maigres_56, t20.nombre_elev_prod AS nombre_elev_prod_57, t20.nombre_boucherie AS nombre_boucherie_58, t20.nombre_ovins AS nombre_ovins_59, t20.nombre_porcins AS nombre_porcins_60, t20.nombre_equins AS nombre_equins_61, t20.nombre_caprins AS nombre_caprins_62, t20.autre_activite AS autre_activite_63, t20.code_adherent AS code_adherent_64, t20.is_quali_negoce AS is_quali_negoce_65, t20.quali_negoce_certification_date AS quali_negoce_certification_date_66, t20.quali_negoce_contact_name AS quali_negoce_contact_name_67, t20.raison_non_adhesion_autre AS raison_non_adhesion_autre_68, t20.total_count_species AS total_count_species_69, t20.quali_negoce_pre_audit_date AS quali_negoce_pre_audit_date_70, t20.is_member AS is_member_71, t20.groupe_entreprise_id AS groupe_entreprise_id_72, t20.departement_id AS departement_id_73, t20.syndicat_id AS syndicat_id_74, t20.transporteur_id AS transporteur_id_75, t20.contact_responsable_id AS contact_responsable_id_76, t20.home_region_id AS home_region_id_77, t20.commission_id AS commission_id_78, t20.quali_negoce_contact_id AS quali_negoce_contact_id_79, t20.firm_type_id AS firm_type_id_80, t0.firm_id AS firm_id_81, t0.user_id AS user_id_82, t0.etablissement_id AS etablissement_id_83 FROM contact t0 LEFT JOIN entreprise t20 ON t20.contact_responsable_id = t0.id WHERE t0.firm_id = 774 ORDER BY t0.is_responsible DESC;

SELECT
  t0.status AS status_1,
  t0.id AS id_2,
  t0.type_contact AS type_contact_3,
  t0.nom AS nom_4,
  t0.prenom AS prenom_5,
  t0.tel_portable AS tel_portable_6,
  t0.tel_portable2 AS tel_portable2_7,
  t0.tel_bureau AS tel_bureau_8,
  t0.email_contact AS email_contact_9,
  t0.date_naissance AS date_naissance_10,
  t0.commentaire AS commentaire_11,
  t0.adresse AS adresse_12,
  t0.adresse2 AS adresse2_13,
  t0.ville AS ville_14,
  t0.code_postal AS code_postal_15,
  t0.is_responsible AS is_responsible_16,
  t0.is_privileged AS is_privileged_17,
  t0.civilite AS civilite_18,
  t0.type AS type_19,
  t20.status AS status_21,
  t20.id AS id_22,
  t20.raison_social AS raison_social_23,
  t20.adresse AS adresse_24,
  t20.tel1 AS tel1_25,
  t20.tel2 AS tel2_26,
  t20.fax AS fax_27,
  t20.email AS email_28,
  t20.code_siren AS code_siren_29,
  t20.code_ape AS code_ape_30,
  t20.num_tva_intracom AS num_tva_intracom_31,
  t20.ancien_identifiant AS ancien_identifiant_32,
  t20.identifiant_compta AS identifiant_compta_33,
  t20.num_ede_negoce AS num_ede_negoce_34,
  t20.num_ede_centre AS num_ede_centre_35,
  t20.num_ede_elevage AS num_ede_elevage_36,
  t20.nombre_employes AS nombre_employes_37,
  t20.autre_specialite AS autre_specialite_38,
  t20.volume_animaux AS volume_animaux_39,
  t20.souhaite_adherer AS souhaite_adherer_40,
  t20.figurer_annuaire_adherents AS figurer_annuaire_adherents_41,
  t20.figurer_annuaire_internet AS figurer_annuaire_internet_42,
  t20.figurer_au_nom_de AS figurer_au_nom_de_43,
  t20.statut_paiement AS statut_paiement_44,
  t20.raison_non_adhesion AS raison_non_adhesion_45,
  t20.date_cessation AS date_cessation_46,
  t20.chiffre_dernier_total AS chiffre_dernier_total_47,
  t20.commentaires AS commentaires_48,
  t20.is_transporter AS is_transporter_49,
  t20.transport_pour_autrui AS transport_pour_autrui_50,
  t20.lien_url AS lien_url_51,
  t20.ville AS ville_52,
  t20.code_postal AS code_postal_53,
  t20.adresse2 AS adresse2_54,
  t20.nombre_veaux AS nombre_veaux_55,
  t20.nombre_maigres AS nombre_maigres_56,
  t20.nombre_elev_prod AS nombre_elev_prod_57,
  t20.nombre_boucherie AS nombre_boucherie_58,
  t20.nombre_ovins AS nombre_ovins_59,
  t20.nombre_porcins AS nombre_porcins_60,
  t20.nombre_equins AS nombre_equins_61,
  t20.nombre_caprins AS nombre_caprins_62,
  t20.autre_activite AS autre_activite_63,
  t20.code_adherent AS code_adherent_64,
  t20.is_quali_negoce AS is_quali_negoce_65,
  t20.quali_negoce_certification_date AS quali_negoce_certification_date_66,
  t20.quali_negoce_contact_name AS quali_negoce_contact_name_67,
  t20.raison_non_adhesion_autre AS raison_non_adhesion_autre_68,
  t20.total_count_species AS total_count_species_69,
  t20.quali_negoce_pre_audit_date AS quali_negoce_pre_audit_date_70,
  t20.is_member AS is_member_71,
  t20.groupe_entreprise_id AS groupe_entreprise_id_72,
  t20.departement_id AS departement_id_73,
  t20.syndicat_id AS syndicat_id_74,
  t20.transporteur_id AS transporteur_id_75,
  t20.contact_responsable_id AS contact_responsable_id_76,
  t20.home_region_id AS home_region_id_77,
  t20.commission_id AS commission_id_78,
  t20.quali_negoce_contact_id AS quali_negoce_contact_id_79,
  t20.firm_type_id AS firm_type_id_80,
  t0.firm_id AS firm_id_81,
  t0.user_id AS user_id_82,
  t0.etablissement_id AS etablissement_id_83
FROM
  contact t0
  LEFT JOIN entreprise t20 ON t20.contact_responsable_id = t0.id
WHERE
  t0.firm_id = ?
ORDER BY
  t0.is_responsible DESC

SELECT t0.status AS status_1, t0.id AS id_2, t0.type_contact AS type_contact_3, t0.nom AS nom_4, t0.prenom AS prenom_5, t0.tel_portable AS tel_portable_6, t0.tel_portable2 AS tel_portable2_7, t0.tel_bureau AS tel_bureau_8, t0.email_contact AS email_contact_9, t0.date_naissance AS date_naissance_10, t0.commentaire AS commentaire_11, t0.adresse AS adresse_12, t0.adresse2 AS adresse2_13, t0.ville AS ville_14, t0.code_postal AS code_postal_15, t0.is_responsible AS is_responsible_16, t0.is_privileged AS is_privileged_17, t0.civilite AS civilite_18, t0.type AS type_19, t20.status AS status_21, t20.id AS id_22, t20.raison_social AS raison_social_23, t20.adresse AS adresse_24, t20.tel1 AS tel1_25, t20.tel2 AS tel2_26, t20.fax AS fax_27, t20.email AS email_28, t20.code_siren AS code_siren_29, t20.code_ape AS code_ape_30, t20.num_tva_intracom AS num_tva_intracom_31, t20.ancien_identifiant AS ancien_identifiant_32, t20.identifiant_compta AS identifiant_compta_33, t20.num_ede_negoce AS num_ede_negoce_34, t20.num_ede_centre AS num_ede_centre_35, t20.num_ede_elevage AS num_ede_elevage_36, t20.nombre_employes AS nombre_employes_37, t20.autre_specialite AS autre_specialite_38, t20.volume_animaux AS volume_animaux_39, t20.souhaite_adherer AS souhaite_adherer_40, t20.figurer_annuaire_adherents AS figurer_annuaire_adherents_41, t20.figurer_annuaire_internet AS figurer_annuaire_internet_42, t20.figurer_au_nom_de AS figurer_au_nom_de_43, t20.statut_paiement AS statut_paiement_44, t20.raison_non_adhesion AS raison_non_adhesion_45, t20.date_cessation AS date_cessation_46, t20.chiffre_dernier_total AS chiffre_dernier_total_47, t20.commentaires AS commentaires_48, t20.is_transporter AS is_transporter_49, t20.transport_pour_autrui AS transport_pour_autrui_50, t20.lien_url AS lien_url_51, t20.ville AS ville_52, t20.code_postal AS code_postal_53, t20.adresse2 AS adresse2_54, t20.nombre_veaux AS nombre_veaux_55, t20.nombre_maigres AS nombre_maigres_56, t20.nombre_elev_prod AS nombre_elev_prod_57, t20.nombre_boucherie AS nombre_boucherie_58, t20.nombre_ovins AS nombre_ovins_59, t20.nombre_porcins AS nombre_porcins_60, t20.nombre_equins AS nombre_equins_61, t20.nombre_caprins AS nombre_caprins_62, t20.autre_activite AS autre_activite_63, t20.code_adherent AS code_adherent_64, t20.is_quali_negoce AS is_quali_negoce_65, t20.quali_negoce_certification_date AS quali_negoce_certification_date_66, t20.quali_negoce_contact_name AS quali_negoce_contact_name_67, t20.raison_non_adhesion_autre AS raison_non_adhesion_autre_68, t20.total_count_species AS total_count_species_69, t20.quali_negoce_pre_audit_date AS quali_negoce_pre_audit_date_70, t20.is_member AS is_member_71, t20.groupe_entreprise_id AS groupe_entreprise_id_72, t20.departement_id AS departement_id_73, t20.syndicat_id AS syndicat_id_74, t20.transporteur_id AS transporteur_id_75, t20.contact_responsable_id AS contact_responsable_id_76, t20.home_region_id AS home_region_id_77, t20.commission_id AS commission_id_78, t20.quali_negoce_contact_id AS quali_negoce_contact_id_79, t20.firm_type_id AS firm_type_id_80, t0.firm_id AS firm_id_81, t0.user_id AS user_id_82, t0.etablissement_id AS etablissement_id_83 FROM contact t0 LEFT JOIN entreprise t20 ON t20.contact_responsable_id = t0.id WHERE t0.firm_id = 1037 ORDER BY t0.is_responsible DESC;

SELECT
  t0.status AS status_1,
  t0.id AS id_2,
  t0.type_contact AS type_contact_3,
  t0.nom AS nom_4,
  t0.prenom AS prenom_5,
  t0.tel_portable AS tel_portable_6,
  t0.tel_portable2 AS tel_portable2_7,
  t0.tel_bureau AS tel_bureau_8,
  t0.email_contact AS email_contact_9,
  t0.date_naissance AS date_naissance_10,
  t0.commentaire AS commentaire_11,
  t0.adresse AS adresse_12,
  t0.adresse2 AS adresse2_13,
  t0.ville AS ville_14,
  t0.code_postal AS code_postal_15,
  t0.is_responsible AS is_responsible_16,
  t0.is_privileged AS is_privileged_17,
  t0.civilite AS civilite_18,
  t0.type AS type_19,
  t20.status AS status_21,
  t20.id AS id_22,
  t20.raison_social AS raison_social_23,
  t20.adresse AS adresse_24,
  t20.tel1 AS tel1_25,
  t20.tel2 AS tel2_26,
  t20.fax AS fax_27,
  t20.email AS email_28,
  t20.code_siren AS code_siren_29,
  t20.code_ape AS code_ape_30,
  t20.num_tva_intracom AS num_tva_intracom_31,
  t20.ancien_identifiant AS ancien_identifiant_32,
  t20.identifiant_compta AS identifiant_compta_33,
  t20.num_ede_negoce AS num_ede_negoce_34,
  t20.num_ede_centre AS num_ede_centre_35,
  t20.num_ede_elevage AS num_ede_elevage_36,
  t20.nombre_employes AS nombre_employes_37,
  t20.autre_specialite AS autre_specialite_38,
  t20.volume_animaux AS volume_animaux_39,
  t20.souhaite_adherer AS souhaite_adherer_40,
  t20.figurer_annuaire_adherents AS figurer_annuaire_adherents_41,
  t20.figurer_annuaire_internet AS figurer_annuaire_internet_42,
  t20.figurer_au_nom_de AS figurer_au_nom_de_43,
  t20.statut_paiement AS statut_paiement_44,
  t20.raison_non_adhesion AS raison_non_adhesion_45,
  t20.date_cessation AS date_cessation_46,
  t20.chiffre_dernier_total AS chiffre_dernier_total_47,
  t20.commentaires AS commentaires_48,
  t20.is_transporter AS is_transporter_49,
  t20.transport_pour_autrui AS transport_pour_autrui_50,
  t20.lien_url AS lien_url_51,
  t20.ville AS ville_52,
  t20.code_postal AS code_postal_53,
  t20.adresse2 AS adresse2_54,
  t20.nombre_veaux AS nombre_veaux_55,
  t20.nombre_maigres AS nombre_maigres_56,
  t20.nombre_elev_prod AS nombre_elev_prod_57,
  t20.nombre_boucherie AS nombre_boucherie_58,
  t20.nombre_ovins AS nombre_ovins_59,
  t20.nombre_porcins AS nombre_porcins_60,
  t20.nombre_equins AS nombre_equins_61,
  t20.nombre_caprins AS nombre_caprins_62,
  t20.autre_activite AS autre_activite_63,
  t20.code_adherent AS code_adherent_64,
  t20.is_quali_negoce AS is_quali_negoce_65,
  t20.quali_negoce_certification_date AS quali_negoce_certification_date_66,
  t20.quali_negoce_contact_name AS quali_negoce_contact_name_67,
  t20.raison_non_adhesion_autre AS raison_non_adhesion_autre_68,
  t20.total_count_species AS total_count_species_69,
  t20.quali_negoce_pre_audit_date AS quali_negoce_pre_audit_date_70,
  t20.is_member AS is_member_71,
  t20.groupe_entreprise_id AS groupe_entreprise_id_72,
  t20.departement_id AS departement_id_73,
  t20.syndicat_id AS syndicat_id_74,
  t20.transporteur_id AS transporteur_id_75,
  t20.contact_responsable_id AS contact_responsable_id_76,
  t20.home_region_id AS home_region_id_77,
  t20.commission_id AS commission_id_78,
  t20.quali_negoce_contact_id AS quali_negoce_contact_id_79,
  t20.firm_type_id AS firm_type_id_80,
  t0.firm_id AS firm_id_81,
  t0.user_id AS user_id_82,
  t0.etablissement_id AS etablissement_id_83
FROM
  contact t0
  LEFT JOIN entreprise t20 ON t20.contact_responsable_id = t0.id
WHERE
  t0.firm_id = ?
ORDER BY
  t0.is_responsible DESC

SELECT t0.status AS status_1, t0.id AS id_2, t0.type_contact AS type_contact_3, t0.nom AS nom_4, t0.prenom AS prenom_5, t0.tel_portable AS tel_portable_6, t0.tel_portable2 AS tel_portable2_7, t0.tel_bureau AS tel_bureau_8, t0.email_contact AS email_contact_9, t0.date_naissance AS date_naissance_10, t0.commentaire AS commentaire_11, t0.adresse AS adresse_12, t0.adresse2 AS adresse2_13, t0.ville AS ville_14, t0.code_postal AS code_postal_15, t0.is_responsible AS is_responsible_16, t0.is_privileged AS is_privileged_17, t0.civilite AS civilite_18, t0.type AS type_19, t20.status AS status_21, t20.id AS id_22, t20.raison_social AS raison_social_23, t20.adresse AS adresse_24, t20.tel1 AS tel1_25, t20.tel2 AS tel2_26, t20.fax AS fax_27, t20.email AS email_28, t20.code_siren AS code_siren_29, t20.code_ape AS code_ape_30, t20.num_tva_intracom AS num_tva_intracom_31, t20.ancien_identifiant AS ancien_identifiant_32, t20.identifiant_compta AS identifiant_compta_33, t20.num_ede_negoce AS num_ede_negoce_34, t20.num_ede_centre AS num_ede_centre_35, t20.num_ede_elevage AS num_ede_elevage_36, t20.nombre_employes AS nombre_employes_37, t20.autre_specialite AS autre_specialite_38, t20.volume_animaux AS volume_animaux_39, t20.souhaite_adherer AS souhaite_adherer_40, t20.figurer_annuaire_adherents AS figurer_annuaire_adherents_41, t20.figurer_annuaire_internet AS figurer_annuaire_internet_42, t20.figurer_au_nom_de AS figurer_au_nom_de_43, t20.statut_paiement AS statut_paiement_44, t20.raison_non_adhesion AS raison_non_adhesion_45, t20.date_cessation AS date_cessation_46, t20.chiffre_dernier_total AS chiffre_dernier_total_47, t20.commentaires AS commentaires_48, t20.is_transporter AS is_transporter_49, t20.transport_pour_autrui AS transport_pour_autrui_50, t20.lien_url AS lien_url_51, t20.ville AS ville_52, t20.code_postal AS code_postal_53, t20.adresse2 AS adresse2_54, t20.nombre_veaux AS nombre_veaux_55, t20.nombre_maigres AS nombre_maigres_56, t20.nombre_elev_prod AS nombre_elev_prod_57, t20.nombre_boucherie AS nombre_boucherie_58, t20.nombre_ovins AS nombre_ovins_59, t20.nombre_porcins AS nombre_porcins_60, t20.nombre_equins AS nombre_equins_61, t20.nombre_caprins AS nombre_caprins_62, t20.autre_activite AS autre_activite_63, t20.code_adherent AS code_adherent_64, t20.is_quali_negoce AS is_quali_negoce_65, t20.quali_negoce_certification_date AS quali_negoce_certification_date_66, t20.quali_negoce_contact_name AS quali_negoce_contact_name_67, t20.raison_non_adhesion_autre AS raison_non_adhesion_autre_68, t20.total_count_species AS total_count_species_69, t20.quali_negoce_pre_audit_date AS quali_negoce_pre_audit_date_70, t20.is_member AS is_member_71, t20.groupe_entreprise_id AS groupe_entreprise_id_72, t20.departement_id AS departement_id_73, t20.syndicat_id AS syndicat_id_74, t20.transporteur_id AS transporteur_id_75, t20.contact_responsable_id AS contact_responsable_id_76, t20.home_region_id AS home_region_id_77, t20.commission_id AS commission_id_78, t20.quali_negoce_contact_id AS quali_negoce_contact_id_79, t20.firm_type_id AS firm_type_id_80, t0.firm_id AS firm_id_81, t0.user_id AS user_id_82, t0.etablissement_id AS etablissement_id_83 FROM contact t0 LEFT JOIN entreprise t20 ON t20.contact_responsable_id = t0.id WHERE t0.firm_id = 1140 ORDER BY t0.is_responsible DESC;

SELECT
  t0.status AS status_1,
  t0.id AS id_2,
  t0.type_contact AS type_contact_3,
  t0.nom AS nom_4,
  t0.prenom AS prenom_5,
  t0.tel_portable AS tel_portable_6,
  t0.tel_portable2 AS tel_portable2_7,
  t0.tel_bureau AS tel_bureau_8,
  t0.email_contact AS email_contact_9,
  t0.date_naissance AS date_naissance_10,
  t0.commentaire AS commentaire_11,
  t0.adresse AS adresse_12,
  t0.adresse2 AS adresse2_13,
  t0.ville AS ville_14,
  t0.code_postal AS code_postal_15,
  t0.is_responsible AS is_responsible_16,
  t0.is_privileged AS is_privileged_17,
  t0.civilite AS civilite_18,
  t0.type AS type_19,
  t20.status AS status_21,
  t20.id AS id_22,
  t20.raison_social AS raison_social_23,
  t20.adresse AS adresse_24,
  t20.tel1 AS tel1_25,
  t20.tel2 AS tel2_26,
  t20.fax AS fax_27,
  t20.email AS email_28,
  t20.code_siren AS code_siren_29,
  t20.code_ape AS code_ape_30,
  t20.num_tva_intracom AS num_tva_intracom_31,
  t20.ancien_identifiant AS ancien_identifiant_32,
  t20.identifiant_compta AS identifiant_compta_33,
  t20.num_ede_negoce AS num_ede_negoce_34,
  t20.num_ede_centre AS num_ede_centre_35,
  t20.num_ede_elevage AS num_ede_elevage_36,
  t20.nombre_employes AS nombre_employes_37,
  t20.autre_specialite AS autre_specialite_38,
  t20.volume_animaux AS volume_animaux_39,
  t20.souhaite_adherer AS souhaite_adherer_40,
  t20.figurer_annuaire_adherents AS figurer_annuaire_adherents_41,
  t20.figurer_annuaire_internet AS figurer_annuaire_internet_42,
  t20.figurer_au_nom_de AS figurer_au_nom_de_43,
  t20.statut_paiement AS statut_paiement_44,
  t20.raison_non_adhesion AS raison_non_adhesion_45,
  t20.date_cessation AS date_cessation_46,
  t20.chiffre_dernier_total AS chiffre_dernier_total_47,
  t20.commentaires AS commentaires_48,
  t20.is_transporter AS is_transporter_49,
  t20.transport_pour_autrui AS transport_pour_autrui_50,
  t20.lien_url AS lien_url_51,
  t20.ville AS ville_52,
  t20.code_postal AS code_postal_53,
  t20.adresse2 AS adresse2_54,
  t20.nombre_veaux AS nombre_veaux_55,
  t20.nombre_maigres AS nombre_maigres_56,
  t20.nombre_elev_prod AS nombre_elev_prod_57,
  t20.nombre_boucherie AS nombre_boucherie_58,
  t20.nombre_ovins AS nombre_ovins_59,
  t20.nombre_porcins AS nombre_porcins_60,
  t20.nombre_equins AS nombre_equins_61,
  t20.nombre_caprins AS nombre_caprins_62,
  t20.autre_activite AS autre_activite_63,
  t20.code_adherent AS code_adherent_64,
  t20.is_quali_negoce AS is_quali_negoce_65,
  t20.quali_negoce_certification_date AS quali_negoce_certification_date_66,
  t20.quali_negoce_contact_name AS quali_negoce_contact_name_67,
  t20.raison_non_adhesion_autre AS raison_non_adhesion_autre_68,
  t20.total_count_species AS total_count_species_69,
  t20.quali_negoce_pre_audit_date AS quali_negoce_pre_audit_date_70,
  t20.is_member AS is_member_71,
  t20.groupe_entreprise_id AS groupe_entreprise_id_72,
  t20.departement_id AS departement_id_73,
  t20.syndicat_id AS syndicat_id_74,
  t20.transporteur_id AS transporteur_id_75,
  t20.contact_responsable_id AS contact_responsable_id_76,
  t20.home_region_id AS home_region_id_77,
  t20.commission_id AS commission_id_78,
  t20.quali_negoce_contact_id AS quali_negoce_contact_id_79,
  t20.firm_type_id AS firm_type_id_80,
  t0.firm_id AS firm_id_81,
  t0.user_id AS user_id_82,
  t0.etablissement_id AS etablissement_id_83
FROM
  contact t0
  LEFT JOIN entreprise t20 ON t20.contact_responsable_id = t0.id
WHERE
  t0.firm_id = ?
ORDER BY
  t0.is_responsible DESC

SELECT t0.status AS status_1, t0.id AS id_2, t0.type_contact AS type_contact_3, t0.nom AS nom_4, t0.prenom AS prenom_5, t0.tel_portable AS tel_portable_6, t0.tel_portable2 AS tel_portable2_7, t0.tel_bureau AS tel_bureau_8, t0.email_contact AS email_contact_9, t0.date_naissance AS date_naissance_10, t0.commentaire AS commentaire_11, t0.adresse AS adresse_12, t0.adresse2 AS adresse2_13, t0.ville AS ville_14, t0.code_postal AS code_postal_15, t0.is_responsible AS is_responsible_16, t0.is_privileged AS is_privileged_17, t0.civilite AS civilite_18, t0.type AS type_19, t20.status AS status_21, t20.id AS id_22, t20.raison_social AS raison_social_23, t20.adresse AS adresse_24, t20.tel1 AS tel1_25, t20.tel2 AS tel2_26, t20.fax AS fax_27, t20.email AS email_28, t20.code_siren AS code_siren_29, t20.code_ape AS code_ape_30, t20.num_tva_intracom AS num_tva_intracom_31, t20.ancien_identifiant AS ancien_identifiant_32, t20.identifiant_compta AS identifiant_compta_33, t20.num_ede_negoce AS num_ede_negoce_34, t20.num_ede_centre AS num_ede_centre_35, t20.num_ede_elevage AS num_ede_elevage_36, t20.nombre_employes AS nombre_employes_37, t20.autre_specialite AS autre_specialite_38, t20.volume_animaux AS volume_animaux_39, t20.souhaite_adherer AS souhaite_adherer_40, t20.figurer_annuaire_adherents AS figurer_annuaire_adherents_41, t20.figurer_annuaire_internet AS figurer_annuaire_internet_42, t20.figurer_au_nom_de AS figurer_au_nom_de_43, t20.statut_paiement AS statut_paiement_44, t20.raison_non_adhesion AS raison_non_adhesion_45, t20.date_cessation AS date_cessation_46, t20.chiffre_dernier_total AS chiffre_dernier_total_47, t20.commentaires AS commentaires_48, t20.is_transporter AS is_transporter_49, t20.transport_pour_autrui AS transport_pour_autrui_50, t20.lien_url AS lien_url_51, t20.ville AS ville_52, t20.code_postal AS code_postal_53, t20.adresse2 AS adresse2_54, t20.nombre_veaux AS nombre_veaux_55, t20.nombre_maigres AS nombre_maigres_56, t20.nombre_elev_prod AS nombre_elev_prod_57, t20.nombre_boucherie AS nombre_boucherie_58, t20.nombre_ovins AS nombre_ovins_59, t20.nombre_porcins AS nombre_porcins_60, t20.nombre_equins AS nombre_equins_61, t20.nombre_caprins AS nombre_caprins_62, t20.autre_activite AS autre_activite_63, t20.code_adherent AS code_adherent_64, t20.is_quali_negoce AS is_quali_negoce_65, t20.quali_negoce_certification_date AS quali_negoce_certification_date_66, t20.quali_negoce_contact_name AS quali_negoce_contact_name_67, t20.raison_non_adhesion_autre AS raison_non_adhesion_autre_68, t20.total_count_species AS total_count_species_69, t20.quali_negoce_pre_audit_date AS quali_negoce_pre_audit_date_70, t20.is_member AS is_member_71, t20.groupe_entreprise_id AS groupe_entreprise_id_72, t20.departement_id AS departement_id_73, t20.syndicat_id AS syndicat_id_74, t20.transporteur_id AS transporteur_id_75, t20.contact_responsable_id AS contact_responsable_id_76, t20.home_region_id AS home_region_id_77, t20.commission_id AS commission_id_78, t20.quali_negoce_contact_id AS quali_negoce_contact_id_79, t20.firm_type_id AS firm_type_id_80, t0.firm_id AS firm_id_81, t0.user_id AS user_id_82, t0.etablissement_id AS etablissement_id_83 FROM contact t0 LEFT JOIN entreprise t20 ON t20.contact_responsable_id = t0.id WHERE t0.firm_id = 1305 ORDER BY t0.is_responsible DESC;