Symfony Profiler

SELECT
  b0_.id_actualite AS id_actualite_0,
  b0_.date_creation AS date_creation_1,
  b0_.date_reception AS date_reception_2,
  b0_.date_mise_en_ligne AS date_mise_en_ligne_3,
  b0_.date_evenement AS date_evenement_4,
  b0_.titre_actualite AS titre_actualite_5,
  b0_.sous_titre AS sous_titre_6,
  b0_.description_actualite AS description_actualite_7,
  b0_.provenance_flux_actualite AS provenance_flux_actualite_8,
  b0_.type_actualite AS type_actualite_9,
  b0_.nom_fichier_xml AS nom_fichier_xml_10,
  b0_.id_message_blog AS id_message_blog_11,
  b0_.id_societe_prestataire AS id_societe_prestataire_12,
  b0_.id_service_principal AS id_service_principal_13,
  b0_.id_operation AS id_operation_14,
  b0_.mode_actualite AS mode_actualite_15,
  b0_.modifie_par_utilisateur AS modifie_par_utilisateur_16,
  b0_.deja_publique AS deja_publique_17,
  b0_.id_actualite_redirection AS id_actualite_redirection_18,
  b0_.site_internet AS site_internet_19,
  b0_.pour_en_savoir_plus AS pour_en_savoir_plus_20,
  b0_.societe_source AS societe_source_21,
  b0_.mots_cles AS mots_cles_22,
  b0_.a_la_une AS a_la_une_23,
  b0_.parution_franchises AS parution_franchises_24,
  b0_.a_la_une_du_jour AS a_la_une_du_jour_25,
  b0_.selection_we AS selection_we_26,
  b0_.a_la_une_accueil AS a_la_une_accueil_27,
  b0_.a_la_une_news_actu AS a_la_une_news_actu_28,
  b0_.utiliser_artviper AS utiliser_artviper_29,
  b0_.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_30,
  b0_.visibilite_flux AS visibilite_flux_31,
  b0_.personne_physique_impliquee AS personne_physique_impliquee_32,
  b0_.societe_impliquee AS societe_impliquee_33,
  b0_.fonds_implique AS fonds_implique_34,
  b0_.id_localisation AS id_localisation_35,
  b0_.id_secteur_activite AS id_secteur_activite_36,
  b0_.vignette AS vignette_37,
  b0_.vignette_small AS vignette_small_38,
  b0_.photo_actualite AS photo_actualite_39,
  b0_.alerte_envoyee AS alerte_envoyee_40,
  b0_.id_participation AS id_participation_41,
  b0_.id_participation_temporaire AS id_participation_temporaire_42,
  b0_.id_operation_temporaire AS id_operation_temporaire_43,
  b0_.id_fonds_bot AS id_fonds_bot_44,
  b0_.souhaite_classement AS souhaite_classement_45,
  b0_.souhaite_reseau AS souhaite_reseau_46,
  b0_.souhaite_prestation AS souhaite_prestation_47,
  b0_.souhaite_nom_reseau AS souhaite_nom_reseau_48,
  b0_.autorisation_blog AS autorisation_blog_49,
  b0_.contact_validation AS contact_validation_50,
  b0_.commentaires_blog AS commentaires_blog_51,
  b0_.apparition_classement AS apparition_classement_52,
  b0_.classement_reseau AS classement_reseau_53,
  b0_.classement_prestation AS classement_prestation_54,
  b0_.id_reseau AS id_reseau_55,
  b0_.suivi_classement AS suivi_classement_56,
  b0_.is_description_html AS is_description_html_57,
  b0_.is_forum_active AS is_forum_active_58,
  b0_.actu_ess AS actu_ess_59,
  b0_.suivi_actualite AS suivi_actualite_60,
  b0_.date_validation AS date_validation_61,
  b0_.indexe_google AS indexe_google_62
FROM
  fusacq_dbo.buzz_actualites b0_
WHERE
  b0_.id_actualite = ?
  AND b0_.mode_actualite <> ?
LIMIT
  1

SELECT b0_.id_actualite AS id_actualite_0, b0_.date_creation AS date_creation_1, b0_.date_reception AS date_reception_2, b0_.date_mise_en_ligne AS date_mise_en_ligne_3, b0_.date_evenement AS date_evenement_4, b0_.titre_actualite AS titre_actualite_5, b0_.sous_titre AS sous_titre_6, b0_.description_actualite AS description_actualite_7, b0_.provenance_flux_actualite AS provenance_flux_actualite_8, b0_.type_actualite AS type_actualite_9, b0_.nom_fichier_xml AS nom_fichier_xml_10, b0_.id_message_blog AS id_message_blog_11, b0_.id_societe_prestataire AS id_societe_prestataire_12, b0_.id_service_principal AS id_service_principal_13, b0_.id_operation AS id_operation_14, b0_.mode_actualite AS mode_actualite_15, b0_.modifie_par_utilisateur AS modifie_par_utilisateur_16, b0_.deja_publique AS deja_publique_17, b0_.id_actualite_redirection AS id_actualite_redirection_18, b0_.site_internet AS site_internet_19, b0_.pour_en_savoir_plus AS pour_en_savoir_plus_20, b0_.societe_source AS societe_source_21, b0_.mots_cles AS mots_cles_22, b0_.a_la_une AS a_la_une_23, b0_.parution_franchises AS parution_franchises_24, b0_.a_la_une_du_jour AS a_la_une_du_jour_25, b0_.selection_we AS selection_we_26, b0_.a_la_une_accueil AS a_la_une_accueil_27, b0_.a_la_une_news_actu AS a_la_une_news_actu_28, b0_.utiliser_artviper AS utiliser_artviper_29, b0_.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_30, b0_.visibilite_flux AS visibilite_flux_31, b0_.personne_physique_impliquee AS personne_physique_impliquee_32, b0_.societe_impliquee AS societe_impliquee_33, b0_.fonds_implique AS fonds_implique_34, b0_.id_localisation AS id_localisation_35, b0_.id_secteur_activite AS id_secteur_activite_36, b0_.vignette AS vignette_37, b0_.vignette_small AS vignette_small_38, b0_.photo_actualite AS photo_actualite_39, b0_.alerte_envoyee AS alerte_envoyee_40, b0_.id_participation AS id_participation_41, b0_.id_participation_temporaire AS id_participation_temporaire_42, b0_.id_operation_temporaire AS id_operation_temporaire_43, b0_.id_fonds_bot AS id_fonds_bot_44, b0_.souhaite_classement AS souhaite_classement_45, b0_.souhaite_reseau AS souhaite_reseau_46, b0_.souhaite_prestation AS souhaite_prestation_47, b0_.souhaite_nom_reseau AS souhaite_nom_reseau_48, b0_.autorisation_blog AS autorisation_blog_49, b0_.contact_validation AS contact_validation_50, b0_.commentaires_blog AS commentaires_blog_51, b0_.apparition_classement AS apparition_classement_52, b0_.classement_reseau AS classement_reseau_53, b0_.classement_prestation AS classement_prestation_54, b0_.id_reseau AS id_reseau_55, b0_.suivi_classement AS suivi_classement_56, b0_.is_description_html AS is_description_html_57, b0_.is_forum_active AS is_forum_active_58, b0_.actu_ess AS actu_ess_59, b0_.suivi_actualite AS suivi_actualite_60, b0_.date_validation AS date_validation_61, b0_.indexe_google AS indexe_google_62 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = 258605 AND b0_.mode_actualite <> 'supprime' LIMIT 1;

SELECT
  t0.id_societe_prestataire AS id_societe_prestataire_1,
  t0.raison_sociale AS raison_sociale_2,
  t0.contact_facturation AS contact_facturation_3,
  t0.adresse AS adresse_4,
  t0.code_postal AS code_postal_5,
  t0.ville AS ville_6,
  t0.pays AS pays_7,
  t0.telephone AS telephone_8,
  t0.fax AS fax_9,
  t0.login_utilisateur AS login_utilisateur_10,
  t0.mail_contact AS mail_contact_11,
  t0.etat_abonnement AS etat_abonnement_12,
  t0.reference_abonnement AS reference_abonnement_13,
  t0.relance_fin_carte AS relance_fin_carte_14,
  t0.type_pays AS type_pays_15,
  t0.numero_tva AS numero_tva_16,
  t0.complement_abonnement AS complement_abonnement_17,
  t0.mode_reglement_abonnement AS mode_reglement_abonnement_18,
  t0.nb_prestations_sans_cb AS nb_prestations_sans_cb_19,
  t0.nb_coordonnees_par_service AS nb_coordonnees_par_service_20,
  t0.parametres_blog_site AS parametres_blog_site_21,
  t0.code_acces_blog AS code_acces_blog_22,
  t0.abonnements_autres_services AS abonnements_autres_services_23,
  t0.date_debut_referencement AS date_debut_referencement_24,
  t0.date_fin_referencement AS date_fin_referencement_25,
  t0.cession_droit_auteur AS cession_droit_auteur_26,
  t0.segments_classements_concernes AS segments_classements_concernes_27
FROM
  fusacq_dbo.societes_prestataire t0
WHERE
  t0.id_societe_prestataire = ?

SELECT t0.id_societe_prestataire AS id_societe_prestataire_1, t0.raison_sociale AS raison_sociale_2, t0.contact_facturation AS contact_facturation_3, t0.adresse AS adresse_4, t0.code_postal AS code_postal_5, t0.ville AS ville_6, t0.pays AS pays_7, t0.telephone AS telephone_8, t0.fax AS fax_9, t0.login_utilisateur AS login_utilisateur_10, t0.mail_contact AS mail_contact_11, t0.etat_abonnement AS etat_abonnement_12, t0.reference_abonnement AS reference_abonnement_13, t0.relance_fin_carte AS relance_fin_carte_14, t0.type_pays AS type_pays_15, t0.numero_tva AS numero_tva_16, t0.complement_abonnement AS complement_abonnement_17, t0.mode_reglement_abonnement AS mode_reglement_abonnement_18, t0.nb_prestations_sans_cb AS nb_prestations_sans_cb_19, t0.nb_coordonnees_par_service AS nb_coordonnees_par_service_20, t0.parametres_blog_site AS parametres_blog_site_21, t0.code_acces_blog AS code_acces_blog_22, t0.abonnements_autres_services AS abonnements_autres_services_23, t0.date_debut_referencement AS date_debut_referencement_24, t0.date_fin_referencement AS date_fin_referencement_25, t0.cession_droit_auteur AS cession_droit_auteur_26, t0.segments_classements_concernes AS segments_classements_concernes_27 FROM fusacq_dbo.societes_prestataire t0 WHERE t0.id_societe_prestataire = 1325;

SELECT
  c0_.adresse AS adresse_0,
  c0_.code_postal AS code_postal_1,
  c0_.ville AS ville_2,
  c0_.pays AS pays_3,
  c0_.telephone AS telephone_4,
  c0_.fax AS fax_5,
  c0_.email_contact1 AS email_contact1_6,
  c0_.nom_contact1 AS nom_contact1_7
FROM
  fusacq_dbo.coordonnees_service_prestataire c0_
WHERE
  c0_.id_societe_prestataire = ?
LIMIT
  1

SELECT c0_.adresse AS adresse_0, c0_.code_postal AS code_postal_1, c0_.ville AS ville_2, c0_.pays AS pays_3, c0_.telephone AS telephone_4, c0_.fax AS fax_5, c0_.email_contact1 AS email_contact1_6, c0_.nom_contact1 AS nom_contact1_7 FROM fusacq_dbo.coordonnees_service_prestataire c0_ WHERE c0_.id_societe_prestataire = 1325 LIMIT 1;

SELECT
  t0.id_societe AS id_societe_1,
  t0.id_societe_news AS id_societe_news_2,
  t0.id_participation AS id_participation_3,
  t0.mode_participation AS mode_participation_4,
  t0.deja_publique AS deja_publique_5,
  t0.raison_sociale AS raison_sociale_6,
  t0.raison_sociale_formatee AS raison_sociale_formatee_7,
  t0.nom_president AS nom_president_8,
  t0.nom_directeur_general AS nom_directeur_general_9,
  t0.adresse AS adresse_10,
  t0.ville AS ville_11,
  t0.code_postal AS code_postal_12,
  t0.telephone AS telephone_13,
  t0.fax AS fax_14,
  t0.id_pays AS id_pays_15,
  t0.devise AS devise_16,
  t0.id_region AS id_region_17,
  t0.filiales_bureaux AS filiales_bureaux_18,
  t0.id_secteur_activite AS id_secteur_activite_19,
  t0.id_secteur_activite_fonds AS id_secteur_activite_fonds_20,
  t0.site_internet AS site_internet_21,
  t0.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_22,
  t0.mail_contact AS mail_contact_23,
  t0.resume_activite AS resume_activite_24,
  t0.description_activite AS description_activite_25,
  t0.mots_cles AS mots_cles_26,
  t0.strategie_developpement AS strategie_developpement_27,
  t0.marge_brute_n AS marge_brute_n_28,
  t0.resultat_exploitation_n AS resultat_exploitation_n_29,
  t0.resultat_net_n AS resultat_net_n_30,
  t0.ca_n AS ca_n_31,
  t0.nb_personnes_n AS nb_personnes_n_32,
  t0.annee_n AS annee_n_33,
  t0.date_mise_a_jour AS date_mise_a_jour_34,
  t0.fichier_joint AS fichier_joint_35,
  t0.commentaire_interne AS commentaire_interne_36,
  t0.societe_cotee AS societe_cotee_37,
  t0.login_demande_publication AS login_demande_publication_38,
  t0.date_relance AS date_relance_39,
  t0.relance_mise_a_jour AS relance_mise_a_jour_40,
  t0.numero_siren AS numero_siren_41,
  t0.montant_total_investi AS montant_total_investi_42,
  t0.capital_total_investisseur AS capital_total_investisseur_43,
  t0.titre_newsletter AS titre_newsletter_44,
  t0.resume_newsletter AS resume_newsletter_45,
  t0.date_dernier_investissement AS date_dernier_investissement_46,
  t0.type_profil_participation AS type_profil_participation_47,
  t0.mode_societe AS mode_societe_48,
  t0.utiliser_artviper AS utiliser_artviper_49,
  t0.numero_siret AS numero_siret_50,
  t0.code_naf AS code_naf_51,
  t0.vignette AS vignette_52,
  t0.vignette_small AS vignette_small_53,
  t0.ca_n_inf AS ca_n_inf_54,
  t0.ca_n_sup AS ca_n_sup_55,
  t0.id_societe_mere AS id_societe_mere_56,
  t0.date_maj_administrateur AS date_maj_administrateur_57,
  t0.administrateur AS administrateur_58,
  t0.etat_resume AS etat_resume_59,
  t0.afficher_vendeur AS afficher_vendeur_60,
  t0.afficher_acheteur AS afficher_acheteur_61
FROM
  fusacq_dbo.societes t0
WHERE
  t0.raison_sociale = ?
LIMIT
  1

SELECT t0.id_societe AS id_societe_1, t0.id_societe_news AS id_societe_news_2, t0.id_participation AS id_participation_3, t0.mode_participation AS mode_participation_4, t0.deja_publique AS deja_publique_5, t0.raison_sociale AS raison_sociale_6, t0.raison_sociale_formatee AS raison_sociale_formatee_7, t0.nom_president AS nom_president_8, t0.nom_directeur_general AS nom_directeur_general_9, t0.adresse AS adresse_10, t0.ville AS ville_11, t0.code_postal AS code_postal_12, t0.telephone AS telephone_13, t0.fax AS fax_14, t0.id_pays AS id_pays_15, t0.devise AS devise_16, t0.id_region AS id_region_17, t0.filiales_bureaux AS filiales_bureaux_18, t0.id_secteur_activite AS id_secteur_activite_19, t0.id_secteur_activite_fonds AS id_secteur_activite_fonds_20, t0.site_internet AS site_internet_21, t0.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_22, t0.mail_contact AS mail_contact_23, t0.resume_activite AS resume_activite_24, t0.description_activite AS description_activite_25, t0.mots_cles AS mots_cles_26, t0.strategie_developpement AS strategie_developpement_27, t0.marge_brute_n AS marge_brute_n_28, t0.resultat_exploitation_n AS resultat_exploitation_n_29, t0.resultat_net_n AS resultat_net_n_30, t0.ca_n AS ca_n_31, t0.nb_personnes_n AS nb_personnes_n_32, t0.annee_n AS annee_n_33, t0.date_mise_a_jour AS date_mise_a_jour_34, t0.fichier_joint AS fichier_joint_35, t0.commentaire_interne AS commentaire_interne_36, t0.societe_cotee AS societe_cotee_37, t0.login_demande_publication AS login_demande_publication_38, t0.date_relance AS date_relance_39, t0.relance_mise_a_jour AS relance_mise_a_jour_40, t0.numero_siren AS numero_siren_41, t0.montant_total_investi AS montant_total_investi_42, t0.capital_total_investisseur AS capital_total_investisseur_43, t0.titre_newsletter AS titre_newsletter_44, t0.resume_newsletter AS resume_newsletter_45, t0.date_dernier_investissement AS date_dernier_investissement_46, t0.type_profil_participation AS type_profil_participation_47, t0.mode_societe AS mode_societe_48, t0.utiliser_artviper AS utiliser_artviper_49, t0.numero_siret AS numero_siret_50, t0.code_naf AS code_naf_51, t0.vignette AS vignette_52, t0.vignette_small AS vignette_small_53, t0.ca_n_inf AS ca_n_inf_54, t0.ca_n_sup AS ca_n_sup_55, t0.id_societe_mere AS id_societe_mere_56, t0.date_maj_administrateur AS date_maj_administrateur_57, t0.administrateur AS administrateur_58, t0.etat_resume AS etat_resume_59, t0.afficher_vendeur AS afficher_vendeur_60, t0.afficher_acheteur AS afficher_acheteur_61 FROM fusacq_dbo.societes t0 WHERE t0.raison_sociale = 'CNCFA' LIMIT 1;

SELECT
  t0.id_service_prestataire AS id_service_prestataire_1,
  t0.id_societe_prestataire AS id_societe_prestataire_2,
  t0.id_langue AS id_langue_3,
  t0.titre_service AS titre_service_4,
  t0.nom_contact1 AS nom_contact1_5,
  t0.email_contact1 AS email_contact1_6,
  t0.nom_contact2 AS nom_contact2_7,
  t0.email_contact2 AS email_contact2_8,
  t0.url_site_web AS url_site_web_9,
  t0.url_site_web_visible AS url_site_web_visible_10,
  t0.tel AS tel_11,
  t0.fax AS fax_12,
  t0.description_service AS description_service_13,
  t0.resume_service AS resume_service_14,
  t0.nom_commercial_societe AS nom_commercial_societe_15,
  t0.statut AS statut_16,
  t0.id_secteur_activite AS id_secteur_activite_17,
  t0.id_secteur_new AS id_secteur_new_18,
  t0.id_localisation_prestataire AS id_localisation_prestataire_19,
  t0.cout_mensuel AS cout_mensuel_20,
  t0.date_demande_publication AS date_demande_publication_21,
  t0.deja_publique AS deja_publique_22,
  t0.date_mise_en_ligne AS date_mise_en_ligne_23,
  t0.gratuite_service AS gratuite_service_24,
  t0.montant_gratuite AS montant_gratuite_25,
  t0.adresse AS adresse_26,
  t0.code_postal AS code_postal_27,
  t0.ville AS ville_28,
  t0.pays AS pays_29,
  t0.contact_si_autre_service AS contact_si_autre_service_30,
  t0.resume_newsletter AS resume_newsletter_31,
  t0.nb_apparitions_newsletter AS nb_apparitions_newsletter_32,
  t0.localisation_pour_referencement AS localisation_pour_referencement_33,
  t0.titre_newsletter AS titre_newsletter_34,
  t0.inscription_partenaire AS inscription_partenaire_35,
  t0.date_fin_gratuite_estimee AS date_fin_gratuite_estimee_36,
  t0.suivi_prestation AS suivi_prestation_37,
  t0.remuneration_partenaire_si_gratuite AS remuneration_partenaire_si_gratuite_38,
  t0.numero_adherent_cncfa AS numero_adherent_cncfa_39,
  t0.id_reseau AS id_reseau_40,
  t0.visibilite AS visibilite_41,
  t0.utiliser_artviper AS utiliser_artviper_42,
  t0.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_43,
  t0.url_vignette AS url_vignette_44,
  t0.date_derniere_mise_en_avant AS date_derniere_mise_en_avant_45,
  t0.id_pays AS id_pays_46
FROM
  fusacq_dbo.services_prestataire t0
WHERE
  t0.id_service_prestataire = ?
LIMIT
  1

SELECT t0.id_service_prestataire AS id_service_prestataire_1, t0.id_societe_prestataire AS id_societe_prestataire_2, t0.id_langue AS id_langue_3, t0.titre_service AS titre_service_4, t0.nom_contact1 AS nom_contact1_5, t0.email_contact1 AS email_contact1_6, t0.nom_contact2 AS nom_contact2_7, t0.email_contact2 AS email_contact2_8, t0.url_site_web AS url_site_web_9, t0.url_site_web_visible AS url_site_web_visible_10, t0.tel AS tel_11, t0.fax AS fax_12, t0.description_service AS description_service_13, t0.resume_service AS resume_service_14, t0.nom_commercial_societe AS nom_commercial_societe_15, t0.statut AS statut_16, t0.id_secteur_activite AS id_secteur_activite_17, t0.id_secteur_new AS id_secteur_new_18, t0.id_localisation_prestataire AS id_localisation_prestataire_19, t0.cout_mensuel AS cout_mensuel_20, t0.date_demande_publication AS date_demande_publication_21, t0.deja_publique AS deja_publique_22, t0.date_mise_en_ligne AS date_mise_en_ligne_23, t0.gratuite_service AS gratuite_service_24, t0.montant_gratuite AS montant_gratuite_25, t0.adresse AS adresse_26, t0.code_postal AS code_postal_27, t0.ville AS ville_28, t0.pays AS pays_29, t0.contact_si_autre_service AS contact_si_autre_service_30, t0.resume_newsletter AS resume_newsletter_31, t0.nb_apparitions_newsletter AS nb_apparitions_newsletter_32, t0.localisation_pour_referencement AS localisation_pour_referencement_33, t0.titre_newsletter AS titre_newsletter_34, t0.inscription_partenaire AS inscription_partenaire_35, t0.date_fin_gratuite_estimee AS date_fin_gratuite_estimee_36, t0.suivi_prestation AS suivi_prestation_37, t0.remuneration_partenaire_si_gratuite AS remuneration_partenaire_si_gratuite_38, t0.numero_adherent_cncfa AS numero_adherent_cncfa_39, t0.id_reseau AS id_reseau_40, t0.visibilite AS visibilite_41, t0.utiliser_artviper AS utiliser_artviper_42, t0.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_43, t0.url_vignette AS url_vignette_44, t0.date_derniere_mise_en_avant AS date_derniere_mise_en_avant_45, t0.id_pays AS id_pays_46 FROM fusacq_dbo.services_prestataire t0 WHERE t0.id_service_prestataire = 1012 LIMIT 1;

SELECT
  e0_.id_membre AS id_membre_0
FROM
  fusacq_dbo.services_prestataire s1_
  LEFT JOIN fusacq_dbo.equipes_prestataire e0_ ON (
    s1_.id_societe_prestataire = e0_.id_societe_prestataire
  )
WHERE
  s1_.id_service_prestataire = ?
LIMIT
  1

SELECT e0_.id_membre AS id_membre_0 FROM fusacq_dbo.services_prestataire s1_ LEFT JOIN fusacq_dbo.equipes_prestataire e0_ ON (s1_.id_societe_prestataire = e0_.id_societe_prestataire) WHERE s1_.id_service_prestataire = 1012 LIMIT 1;

SELECT
  t0.id_coordonnees AS id_coordonnees_1,
  t0.id_service_prestataire AS id_service_prestataire_2,
  t0.id_societe_prestataire AS id_societe_prestataire_3,
  t0.adresse AS adresse_4,
  t0.code_postal AS code_postal_5,
  t0.ville AS ville_6,
  t0.pays AS pays_7,
  t0.nom_contact1 AS nom_contact1_8,
  t0.email_contact1 AS email_contact1_9,
  t0.nom_contact2 AS nom_contact2_10,
  t0.email_contact2 AS email_contact2_11,
  t0.telephone AS telephone_12,
  t0.indicatif_telephone AS indicatif_telephone_13,
  t0.fax AS fax_14,
  t0.telephone_contact1 AS telephone_contact1_15,
  t0.indicatif_telephone_contact1 AS indicatif_telephone_contact1_16,
  t0.telephone_contact2 AS telephone_contact2_17,
  t0.indicatif_telephone_contact2 AS indicatif_telephone_contact2_18
FROM
  fusacq_dbo.coordonnees_service_prestataire t0
WHERE
  t0.id_service_prestataire = ?
LIMIT
  1

SELECT t0.id_coordonnees AS id_coordonnees_1, t0.id_service_prestataire AS id_service_prestataire_2, t0.id_societe_prestataire AS id_societe_prestataire_3, t0.adresse AS adresse_4, t0.code_postal AS code_postal_5, t0.ville AS ville_6, t0.pays AS pays_7, t0.nom_contact1 AS nom_contact1_8, t0.email_contact1 AS email_contact1_9, t0.nom_contact2 AS nom_contact2_10, t0.email_contact2 AS email_contact2_11, t0.telephone AS telephone_12, t0.indicatif_telephone AS indicatif_telephone_13, t0.fax AS fax_14, t0.telephone_contact1 AS telephone_contact1_15, t0.indicatif_telephone_contact1 AS indicatif_telephone_contact1_16, t0.telephone_contact2 AS telephone_contact2_17, t0.indicatif_telephone_contact2 AS indicatif_telephone_contact2_18 FROM fusacq_dbo.coordonnees_service_prestataire t0 WHERE t0.id_service_prestataire = 1012 LIMIT 1;

SELECT
  t0.id_societe AS id_societe_1,
  t0.id_societe_news AS id_societe_news_2,
  t0.id_participation AS id_participation_3,
  t0.mode_participation AS mode_participation_4,
  t0.deja_publique AS deja_publique_5,
  t0.raison_sociale AS raison_sociale_6,
  t0.raison_sociale_formatee AS raison_sociale_formatee_7,
  t0.nom_president AS nom_president_8,
  t0.nom_directeur_general AS nom_directeur_general_9,
  t0.adresse AS adresse_10,
  t0.ville AS ville_11,
  t0.code_postal AS code_postal_12,
  t0.telephone AS telephone_13,
  t0.fax AS fax_14,
  t0.id_pays AS id_pays_15,
  t0.devise AS devise_16,
  t0.id_region AS id_region_17,
  t0.filiales_bureaux AS filiales_bureaux_18,
  t0.id_secteur_activite AS id_secteur_activite_19,
  t0.id_secteur_activite_fonds AS id_secteur_activite_fonds_20,
  t0.site_internet AS site_internet_21,
  t0.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_22,
  t0.mail_contact AS mail_contact_23,
  t0.resume_activite AS resume_activite_24,
  t0.description_activite AS description_activite_25,
  t0.mots_cles AS mots_cles_26,
  t0.strategie_developpement AS strategie_developpement_27,
  t0.marge_brute_n AS marge_brute_n_28,
  t0.resultat_exploitation_n AS resultat_exploitation_n_29,
  t0.resultat_net_n AS resultat_net_n_30,
  t0.ca_n AS ca_n_31,
  t0.nb_personnes_n AS nb_personnes_n_32,
  t0.annee_n AS annee_n_33,
  t0.date_mise_a_jour AS date_mise_a_jour_34,
  t0.fichier_joint AS fichier_joint_35,
  t0.commentaire_interne AS commentaire_interne_36,
  t0.societe_cotee AS societe_cotee_37,
  t0.login_demande_publication AS login_demande_publication_38,
  t0.date_relance AS date_relance_39,
  t0.relance_mise_a_jour AS relance_mise_a_jour_40,
  t0.numero_siren AS numero_siren_41,
  t0.montant_total_investi AS montant_total_investi_42,
  t0.capital_total_investisseur AS capital_total_investisseur_43,
  t0.titre_newsletter AS titre_newsletter_44,
  t0.resume_newsletter AS resume_newsletter_45,
  t0.date_dernier_investissement AS date_dernier_investissement_46,
  t0.type_profil_participation AS type_profil_participation_47,
  t0.mode_societe AS mode_societe_48,
  t0.utiliser_artviper AS utiliser_artviper_49,
  t0.numero_siret AS numero_siret_50,
  t0.code_naf AS code_naf_51,
  t0.vignette AS vignette_52,
  t0.vignette_small AS vignette_small_53,
  t0.ca_n_inf AS ca_n_inf_54,
  t0.ca_n_sup AS ca_n_sup_55,
  t0.id_societe_mere AS id_societe_mere_56,
  t0.date_maj_administrateur AS date_maj_administrateur_57,
  t0.administrateur AS administrateur_58,
  t0.etat_resume AS etat_resume_59,
  t0.afficher_vendeur AS afficher_vendeur_60,
  t0.afficher_acheteur AS afficher_acheteur_61
FROM
  fusacq_dbo.societes t0
WHERE
  t0.id_societe = ?

SELECT t0.id_societe AS id_societe_1, t0.id_societe_news AS id_societe_news_2, t0.id_participation AS id_participation_3, t0.mode_participation AS mode_participation_4, t0.deja_publique AS deja_publique_5, t0.raison_sociale AS raison_sociale_6, t0.raison_sociale_formatee AS raison_sociale_formatee_7, t0.nom_president AS nom_president_8, t0.nom_directeur_general AS nom_directeur_general_9, t0.adresse AS adresse_10, t0.ville AS ville_11, t0.code_postal AS code_postal_12, t0.telephone AS telephone_13, t0.fax AS fax_14, t0.id_pays AS id_pays_15, t0.devise AS devise_16, t0.id_region AS id_region_17, t0.filiales_bureaux AS filiales_bureaux_18, t0.id_secteur_activite AS id_secteur_activite_19, t0.id_secteur_activite_fonds AS id_secteur_activite_fonds_20, t0.site_internet AS site_internet_21, t0.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_22, t0.mail_contact AS mail_contact_23, t0.resume_activite AS resume_activite_24, t0.description_activite AS description_activite_25, t0.mots_cles AS mots_cles_26, t0.strategie_developpement AS strategie_developpement_27, t0.marge_brute_n AS marge_brute_n_28, t0.resultat_exploitation_n AS resultat_exploitation_n_29, t0.resultat_net_n AS resultat_net_n_30, t0.ca_n AS ca_n_31, t0.nb_personnes_n AS nb_personnes_n_32, t0.annee_n AS annee_n_33, t0.date_mise_a_jour AS date_mise_a_jour_34, t0.fichier_joint AS fichier_joint_35, t0.commentaire_interne AS commentaire_interne_36, t0.societe_cotee AS societe_cotee_37, t0.login_demande_publication AS login_demande_publication_38, t0.date_relance AS date_relance_39, t0.relance_mise_a_jour AS relance_mise_a_jour_40, t0.numero_siren AS numero_siren_41, t0.montant_total_investi AS montant_total_investi_42, t0.capital_total_investisseur AS capital_total_investisseur_43, t0.titre_newsletter AS titre_newsletter_44, t0.resume_newsletter AS resume_newsletter_45, t0.date_dernier_investissement AS date_dernier_investissement_46, t0.type_profil_participation AS type_profil_participation_47, t0.mode_societe AS mode_societe_48, t0.utiliser_artviper AS utiliser_artviper_49, t0.numero_siret AS numero_siret_50, t0.code_naf AS code_naf_51, t0.vignette AS vignette_52, t0.vignette_small AS vignette_small_53, t0.ca_n_inf AS ca_n_inf_54, t0.ca_n_sup AS ca_n_sup_55, t0.id_societe_mere AS id_societe_mere_56, t0.date_maj_administrateur AS date_maj_administrateur_57, t0.administrateur AS administrateur_58, t0.etat_resume AS etat_resume_59, t0.afficher_vendeur AS afficher_vendeur_60, t0.afficher_acheteur AS afficher_acheteur_61 FROM fusacq_dbo.societes t0 WHERE t0.id_societe = 1325;

SELECT
  t0.id_societe AS id_societe_1,
  t0.id_societe_news AS id_societe_news_2,
  t0.id_participation AS id_participation_3,
  t0.mode_participation AS mode_participation_4,
  t0.deja_publique AS deja_publique_5,
  t0.raison_sociale AS raison_sociale_6,
  t0.raison_sociale_formatee AS raison_sociale_formatee_7,
  t0.nom_president AS nom_president_8,
  t0.nom_directeur_general AS nom_directeur_general_9,
  t0.adresse AS adresse_10,
  t0.ville AS ville_11,
  t0.code_postal AS code_postal_12,
  t0.telephone AS telephone_13,
  t0.fax AS fax_14,
  t0.id_pays AS id_pays_15,
  t0.devise AS devise_16,
  t0.id_region AS id_region_17,
  t0.filiales_bureaux AS filiales_bureaux_18,
  t0.id_secteur_activite AS id_secteur_activite_19,
  t0.id_secteur_activite_fonds AS id_secteur_activite_fonds_20,
  t0.site_internet AS site_internet_21,
  t0.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_22,
  t0.mail_contact AS mail_contact_23,
  t0.resume_activite AS resume_activite_24,
  t0.description_activite AS description_activite_25,
  t0.mots_cles AS mots_cles_26,
  t0.strategie_developpement AS strategie_developpement_27,
  t0.marge_brute_n AS marge_brute_n_28,
  t0.resultat_exploitation_n AS resultat_exploitation_n_29,
  t0.resultat_net_n AS resultat_net_n_30,
  t0.ca_n AS ca_n_31,
  t0.nb_personnes_n AS nb_personnes_n_32,
  t0.annee_n AS annee_n_33,
  t0.date_mise_a_jour AS date_mise_a_jour_34,
  t0.fichier_joint AS fichier_joint_35,
  t0.commentaire_interne AS commentaire_interne_36,
  t0.societe_cotee AS societe_cotee_37,
  t0.login_demande_publication AS login_demande_publication_38,
  t0.date_relance AS date_relance_39,
  t0.relance_mise_a_jour AS relance_mise_a_jour_40,
  t0.numero_siren AS numero_siren_41,
  t0.montant_total_investi AS montant_total_investi_42,
  t0.capital_total_investisseur AS capital_total_investisseur_43,
  t0.titre_newsletter AS titre_newsletter_44,
  t0.resume_newsletter AS resume_newsletter_45,
  t0.date_dernier_investissement AS date_dernier_investissement_46,
  t0.type_profil_participation AS type_profil_participation_47,
  t0.mode_societe AS mode_societe_48,
  t0.utiliser_artviper AS utiliser_artviper_49,
  t0.numero_siret AS numero_siret_50,
  t0.code_naf AS code_naf_51,
  t0.vignette AS vignette_52,
  t0.vignette_small AS vignette_small_53,
  t0.ca_n_inf AS ca_n_inf_54,
  t0.ca_n_sup AS ca_n_sup_55,
  t0.id_societe_mere AS id_societe_mere_56,
  t0.date_maj_administrateur AS date_maj_administrateur_57,
  t0.administrateur AS administrateur_58,
  t0.etat_resume AS etat_resume_59,
  t0.afficher_vendeur AS afficher_vendeur_60,
  t0.afficher_acheteur AS afficher_acheteur_61
FROM
  fusacq_dbo.societes t0
WHERE
  t0.raison_sociale = ?
LIMIT
  1

SELECT t0.id_societe AS id_societe_1, t0.id_societe_news AS id_societe_news_2, t0.id_participation AS id_participation_3, t0.mode_participation AS mode_participation_4, t0.deja_publique AS deja_publique_5, t0.raison_sociale AS raison_sociale_6, t0.raison_sociale_formatee AS raison_sociale_formatee_7, t0.nom_president AS nom_president_8, t0.nom_directeur_general AS nom_directeur_general_9, t0.adresse AS adresse_10, t0.ville AS ville_11, t0.code_postal AS code_postal_12, t0.telephone AS telephone_13, t0.fax AS fax_14, t0.id_pays AS id_pays_15, t0.devise AS devise_16, t0.id_region AS id_region_17, t0.filiales_bureaux AS filiales_bureaux_18, t0.id_secteur_activite AS id_secteur_activite_19, t0.id_secteur_activite_fonds AS id_secteur_activite_fonds_20, t0.site_internet AS site_internet_21, t0.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_22, t0.mail_contact AS mail_contact_23, t0.resume_activite AS resume_activite_24, t0.description_activite AS description_activite_25, t0.mots_cles AS mots_cles_26, t0.strategie_developpement AS strategie_developpement_27, t0.marge_brute_n AS marge_brute_n_28, t0.resultat_exploitation_n AS resultat_exploitation_n_29, t0.resultat_net_n AS resultat_net_n_30, t0.ca_n AS ca_n_31, t0.nb_personnes_n AS nb_personnes_n_32, t0.annee_n AS annee_n_33, t0.date_mise_a_jour AS date_mise_a_jour_34, t0.fichier_joint AS fichier_joint_35, t0.commentaire_interne AS commentaire_interne_36, t0.societe_cotee AS societe_cotee_37, t0.login_demande_publication AS login_demande_publication_38, t0.date_relance AS date_relance_39, t0.relance_mise_a_jour AS relance_mise_a_jour_40, t0.numero_siren AS numero_siren_41, t0.montant_total_investi AS montant_total_investi_42, t0.capital_total_investisseur AS capital_total_investisseur_43, t0.titre_newsletter AS titre_newsletter_44, t0.resume_newsletter AS resume_newsletter_45, t0.date_dernier_investissement AS date_dernier_investissement_46, t0.type_profil_participation AS type_profil_participation_47, t0.mode_societe AS mode_societe_48, t0.utiliser_artviper AS utiliser_artviper_49, t0.numero_siret AS numero_siret_50, t0.code_naf AS code_naf_51, t0.vignette AS vignette_52, t0.vignette_small AS vignette_small_53, t0.ca_n_inf AS ca_n_inf_54, t0.ca_n_sup AS ca_n_sup_55, t0.id_societe_mere AS id_societe_mere_56, t0.date_maj_administrateur AS date_maj_administrateur_57, t0.administrateur AS administrateur_58, t0.etat_resume AS etat_resume_59, t0.afficher_vendeur AS afficher_vendeur_60, t0.afficher_acheteur AS afficher_acheteur_61 FROM fusacq_dbo.societes t0 WHERE t0.raison_sociale = 'CNCFA' LIMIT 1;

SELECT
  t0.id_societe AS id_societe_1,
  t0.id_societe_news AS id_societe_news_2,
  t0.id_participation AS id_participation_3,
  t0.mode_participation AS mode_participation_4,
  t0.deja_publique AS deja_publique_5,
  t0.raison_sociale AS raison_sociale_6,
  t0.raison_sociale_formatee AS raison_sociale_formatee_7,
  t0.nom_president AS nom_president_8,
  t0.nom_directeur_general AS nom_directeur_general_9,
  t0.adresse AS adresse_10,
  t0.ville AS ville_11,
  t0.code_postal AS code_postal_12,
  t0.telephone AS telephone_13,
  t0.fax AS fax_14,
  t0.id_pays AS id_pays_15,
  t0.devise AS devise_16,
  t0.id_region AS id_region_17,
  t0.filiales_bureaux AS filiales_bureaux_18,
  t0.id_secteur_activite AS id_secteur_activite_19,
  t0.id_secteur_activite_fonds AS id_secteur_activite_fonds_20,
  t0.site_internet AS site_internet_21,
  t0.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_22,
  t0.mail_contact AS mail_contact_23,
  t0.resume_activite AS resume_activite_24,
  t0.description_activite AS description_activite_25,
  t0.mots_cles AS mots_cles_26,
  t0.strategie_developpement AS strategie_developpement_27,
  t0.marge_brute_n AS marge_brute_n_28,
  t0.resultat_exploitation_n AS resultat_exploitation_n_29,
  t0.resultat_net_n AS resultat_net_n_30,
  t0.ca_n AS ca_n_31,
  t0.nb_personnes_n AS nb_personnes_n_32,
  t0.annee_n AS annee_n_33,
  t0.date_mise_a_jour AS date_mise_a_jour_34,
  t0.fichier_joint AS fichier_joint_35,
  t0.commentaire_interne AS commentaire_interne_36,
  t0.societe_cotee AS societe_cotee_37,
  t0.login_demande_publication AS login_demande_publication_38,
  t0.date_relance AS date_relance_39,
  t0.relance_mise_a_jour AS relance_mise_a_jour_40,
  t0.numero_siren AS numero_siren_41,
  t0.montant_total_investi AS montant_total_investi_42,
  t0.capital_total_investisseur AS capital_total_investisseur_43,
  t0.titre_newsletter AS titre_newsletter_44,
  t0.resume_newsletter AS resume_newsletter_45,
  t0.date_dernier_investissement AS date_dernier_investissement_46,
  t0.type_profil_participation AS type_profil_participation_47,
  t0.mode_societe AS mode_societe_48,
  t0.utiliser_artviper AS utiliser_artviper_49,
  t0.numero_siret AS numero_siret_50,
  t0.code_naf AS code_naf_51,
  t0.vignette AS vignette_52,
  t0.vignette_small AS vignette_small_53,
  t0.ca_n_inf AS ca_n_inf_54,
  t0.ca_n_sup AS ca_n_sup_55,
  t0.id_societe_mere AS id_societe_mere_56,
  t0.date_maj_administrateur AS date_maj_administrateur_57,
  t0.administrateur AS administrateur_58,
  t0.etat_resume AS etat_resume_59,
  t0.afficher_vendeur AS afficher_vendeur_60,
  t0.afficher_acheteur AS afficher_acheteur_61
FROM
  fusacq_dbo.societes t0
WHERE
  t0.raison_sociale = ?
LIMIT
  1

SELECT t0.id_societe AS id_societe_1, t0.id_societe_news AS id_societe_news_2, t0.id_participation AS id_participation_3, t0.mode_participation AS mode_participation_4, t0.deja_publique AS deja_publique_5, t0.raison_sociale AS raison_sociale_6, t0.raison_sociale_formatee AS raison_sociale_formatee_7, t0.nom_president AS nom_president_8, t0.nom_directeur_general AS nom_directeur_general_9, t0.adresse AS adresse_10, t0.ville AS ville_11, t0.code_postal AS code_postal_12, t0.telephone AS telephone_13, t0.fax AS fax_14, t0.id_pays AS id_pays_15, t0.devise AS devise_16, t0.id_region AS id_region_17, t0.filiales_bureaux AS filiales_bureaux_18, t0.id_secteur_activite AS id_secteur_activite_19, t0.id_secteur_activite_fonds AS id_secteur_activite_fonds_20, t0.site_internet AS site_internet_21, t0.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_22, t0.mail_contact AS mail_contact_23, t0.resume_activite AS resume_activite_24, t0.description_activite AS description_activite_25, t0.mots_cles AS mots_cles_26, t0.strategie_developpement AS strategie_developpement_27, t0.marge_brute_n AS marge_brute_n_28, t0.resultat_exploitation_n AS resultat_exploitation_n_29, t0.resultat_net_n AS resultat_net_n_30, t0.ca_n AS ca_n_31, t0.nb_personnes_n AS nb_personnes_n_32, t0.annee_n AS annee_n_33, t0.date_mise_a_jour AS date_mise_a_jour_34, t0.fichier_joint AS fichier_joint_35, t0.commentaire_interne AS commentaire_interne_36, t0.societe_cotee AS societe_cotee_37, t0.login_demande_publication AS login_demande_publication_38, t0.date_relance AS date_relance_39, t0.relance_mise_a_jour AS relance_mise_a_jour_40, t0.numero_siren AS numero_siren_41, t0.montant_total_investi AS montant_total_investi_42, t0.capital_total_investisseur AS capital_total_investisseur_43, t0.titre_newsletter AS titre_newsletter_44, t0.resume_newsletter AS resume_newsletter_45, t0.date_dernier_investissement AS date_dernier_investissement_46, t0.type_profil_participation AS type_profil_participation_47, t0.mode_societe AS mode_societe_48, t0.utiliser_artviper AS utiliser_artviper_49, t0.numero_siret AS numero_siret_50, t0.code_naf AS code_naf_51, t0.vignette AS vignette_52, t0.vignette_small AS vignette_small_53, t0.ca_n_inf AS ca_n_inf_54, t0.ca_n_sup AS ca_n_sup_55, t0.id_societe_mere AS id_societe_mere_56, t0.date_maj_administrateur AS date_maj_administrateur_57, t0.administrateur AS administrateur_58, t0.etat_resume AS etat_resume_59, t0.afficher_vendeur AS afficher_vendeur_60, t0.afficher_acheteur AS afficher_acheteur_61 FROM fusacq_dbo.societes t0 WHERE t0.raison_sociale = 'CNCFA' LIMIT 1;