Symfony Profiler

SELECT
  t0.id_localisation AS id_localisation_1,
  t0.dept AS dept_2,
  t0.nom_localisation AS nom_localisation_3,
  t0.id_localisation_pere AS id_localisation_pere_4,
  t0.prefixe AS prefixe_5,
  t0.recherche AS recherche_6
FROM
  fusacq_dbo.localisations t0
WHERE
  t0.id_localisation_pere = ?

SELECT t0.id_localisation AS id_localisation_1, t0.dept AS dept_2, t0.nom_localisation AS nom_localisation_3, t0.id_localisation_pere AS id_localisation_pere_4, t0.prefixe AS prefixe_5, t0.recherche AS recherche_6 FROM fusacq_dbo.localisations t0 WHERE t0.id_localisation_pere = '33';

SELECT
  t0.id_actualite AS id_actualite_1,
  t0.date_creation AS date_creation_2,
  t0.date_reception AS date_reception_3,
  t0.date_mise_en_ligne AS date_mise_en_ligne_4,
  t0.date_evenement AS date_evenement_5,
  t0.titre_actualite AS titre_actualite_6,
  t0.sous_titre AS sous_titre_7,
  t0.description_actualite AS description_actualite_8,
  t0.provenance_flux_actualite AS provenance_flux_actualite_9,
  t0.type_actualite AS type_actualite_10,
  t0.nom_fichier_xml AS nom_fichier_xml_11,
  t0.id_message_blog AS id_message_blog_12,
  t0.id_societe_prestataire AS id_societe_prestataire_13,
  t0.id_service_principal AS id_service_principal_14,
  t0.id_operation AS id_operation_15,
  t0.mode_actualite AS mode_actualite_16,
  t0.modifie_par_utilisateur AS modifie_par_utilisateur_17,
  t0.deja_publique AS deja_publique_18,
  t0.id_actualite_redirection AS id_actualite_redirection_19,
  t0.site_internet AS site_internet_20,
  t0.pour_en_savoir_plus AS pour_en_savoir_plus_21,
  t0.societe_source AS societe_source_22,
  t0.mots_cles AS mots_cles_23,
  t0.a_la_une AS a_la_une_24,
  t0.parution_franchises AS parution_franchises_25,
  t0.a_la_une_du_jour AS a_la_une_du_jour_26,
  t0.selection_we AS selection_we_27,
  t0.a_la_une_accueil AS a_la_une_accueil_28,
  t0.a_la_une_news_actu AS a_la_une_news_actu_29,
  t0.utiliser_artviper AS utiliser_artviper_30,
  t0.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_31,
  t0.visibilite_flux AS visibilite_flux_32,
  t0.personne_physique_impliquee AS personne_physique_impliquee_33,
  t0.societe_impliquee AS societe_impliquee_34,
  t0.fonds_implique AS fonds_implique_35,
  t0.id_localisation AS id_localisation_36,
  t0.id_secteur_activite AS id_secteur_activite_37,
  t0.vignette AS vignette_38,
  t0.vignette_small AS vignette_small_39,
  t0.photo_actualite AS photo_actualite_40,
  t0.alerte_envoyee AS alerte_envoyee_41,
  t0.id_participation AS id_participation_42,
  t0.id_participation_temporaire AS id_participation_temporaire_43,
  t0.id_operation_temporaire AS id_operation_temporaire_44,
  t0.id_fonds_bot AS id_fonds_bot_45,
  t0.souhaite_classement AS souhaite_classement_46,
  t0.souhaite_reseau AS souhaite_reseau_47,
  t0.souhaite_prestation AS souhaite_prestation_48,
  t0.souhaite_nom_reseau AS souhaite_nom_reseau_49,
  t0.autorisation_blog AS autorisation_blog_50,
  t0.contact_validation AS contact_validation_51,
  t0.commentaires_blog AS commentaires_blog_52,
  t0.apparition_classement AS apparition_classement_53,
  t0.classement_reseau AS classement_reseau_54,
  t0.classement_prestation AS classement_prestation_55,
  t0.id_reseau AS id_reseau_56,
  t0.suivi_classement AS suivi_classement_57,
  t0.is_description_html AS is_description_html_58,
  t0.is_forum_active AS is_forum_active_59,
  t0.actu_ess AS actu_ess_60,
  t0.suivi_actualite AS suivi_actualite_61,
  t0.date_validation AS date_validation_62,
  t0.indexe_google AS indexe_google_63
FROM
  fusacq_dbo.buzz_actualites t0
WHERE
  (
    (
      (
        (
          t0.apparition_classement = ?
          AND t0.id_societe_prestataire = ?
        )
        AND t0.date_mise_en_ligne > ?
      )
      AND t0.date_mise_en_ligne < ?
    )
    AND t0.mode_actualite = ?
  )

SELECT t0.id_actualite AS id_actualite_1, t0.date_creation AS date_creation_2, t0.date_reception AS date_reception_3, t0.date_mise_en_ligne AS date_mise_en_ligne_4, t0.date_evenement AS date_evenement_5, t0.titre_actualite AS titre_actualite_6, t0.sous_titre AS sous_titre_7, t0.description_actualite AS description_actualite_8, t0.provenance_flux_actualite AS provenance_flux_actualite_9, t0.type_actualite AS type_actualite_10, t0.nom_fichier_xml AS nom_fichier_xml_11, t0.id_message_blog AS id_message_blog_12, t0.id_societe_prestataire AS id_societe_prestataire_13, t0.id_service_principal AS id_service_principal_14, t0.id_operation AS id_operation_15, t0.mode_actualite AS mode_actualite_16, t0.modifie_par_utilisateur AS modifie_par_utilisateur_17, t0.deja_publique AS deja_publique_18, t0.id_actualite_redirection AS id_actualite_redirection_19, t0.site_internet AS site_internet_20, t0.pour_en_savoir_plus AS pour_en_savoir_plus_21, t0.societe_source AS societe_source_22, t0.mots_cles AS mots_cles_23, t0.a_la_une AS a_la_une_24, t0.parution_franchises AS parution_franchises_25, t0.a_la_une_du_jour AS a_la_une_du_jour_26, t0.selection_we AS selection_we_27, t0.a_la_une_accueil AS a_la_une_accueil_28, t0.a_la_une_news_actu AS a_la_une_news_actu_29, t0.utiliser_artviper AS utiliser_artviper_30, t0.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_31, t0.visibilite_flux AS visibilite_flux_32, t0.personne_physique_impliquee AS personne_physique_impliquee_33, t0.societe_impliquee AS societe_impliquee_34, t0.fonds_implique AS fonds_implique_35, t0.id_localisation AS id_localisation_36, t0.id_secteur_activite AS id_secteur_activite_37, t0.vignette AS vignette_38, t0.vignette_small AS vignette_small_39, t0.photo_actualite AS photo_actualite_40, t0.alerte_envoyee AS alerte_envoyee_41, t0.id_participation AS id_participation_42, t0.id_participation_temporaire AS id_participation_temporaire_43, t0.id_operation_temporaire AS id_operation_temporaire_44, t0.id_fonds_bot AS id_fonds_bot_45, t0.souhaite_classement AS souhaite_classement_46, t0.souhaite_reseau AS souhaite_reseau_47, t0.souhaite_prestation AS souhaite_prestation_48, t0.souhaite_nom_reseau AS souhaite_nom_reseau_49, t0.autorisation_blog AS autorisation_blog_50, t0.contact_validation AS contact_validation_51, t0.commentaires_blog AS commentaires_blog_52, t0.apparition_classement AS apparition_classement_53, t0.classement_reseau AS classement_reseau_54, t0.classement_prestation AS classement_prestation_55, t0.id_reseau AS id_reseau_56, t0.suivi_classement AS suivi_classement_57, t0.is_description_html AS is_description_html_58, t0.is_forum_active AS is_forum_active_59, t0.actu_ess AS actu_ess_60, t0.suivi_actualite AS suivi_actualite_61, t0.date_validation AS date_validation_62, t0.indexe_google AS indexe_google_63 FROM fusacq_dbo.buzz_actualites t0 WHERE ((((t0.apparition_classement = 'oui' AND t0.id_societe_prestataire = '811') AND t0.date_mise_en_ligne > '20250101000000') AND t0.date_mise_en_ligne < '20260205235959') AND t0.mode_actualite = 'publique');

SELECT
  t0.id_operation AS id_operation_1,
  t0.titre_operation AS titre_operation_2,
  t0.type_operation AS type_operation_3,
  t0.mots_cles AS mots_cles_4,
  t0.personne_physique_impliquee AS personne_physique_impliquee_5,
  t0.societe_impliquee AS societe_impliquee_6,
  t0.fonds_implique AS fonds_implique_7,
  t0.suivi_operation AS suivi_operation_8,
  t0.date_operation AS date_operation_9,
  t0.id_secteur_activite AS id_secteur_activite_10,
  t0.id_localisation AS id_localisation_11,
  t0.id_localisation_2 AS id_localisation_2_12,
  t0.id_actualite_principale AS id_actualite_principale_13,
  t0.visibilite_sur_annonces_fusacq AS visibilite_sur_annonces_fusacq_14,
  t0.code_naf AS code_naf_15,
  t0.montant_operation AS montant_operation_16,
  t0.ca_societe_achetee AS ca_societe_achetee_17,
  t0.mode_operation AS mode_operation_18,
  t0.mots_cles_valides AS mots_cles_valides_19,
  t0.check_rattrapage AS check_rattrapage_20,
  t0.pct_capital_achete AS pct_capital_achete_21,
  t0.maj_min_capital AS maj_min_capital_22,
  t0.fourchette_ca AS fourchette_ca_23,
  t0.nb_compte_classement AS nb_compte_classement_24,
  t0.montant_compte_classement AS montant_compte_classement_25
FROM
  fusacq_dbo.buzz_operations t0
WHERE
  t0.id_operation = ?

SELECT t0.id_operation AS id_operation_1, t0.titre_operation AS titre_operation_2, t0.type_operation AS type_operation_3, t0.mots_cles AS mots_cles_4, t0.personne_physique_impliquee AS personne_physique_impliquee_5, t0.societe_impliquee AS societe_impliquee_6, t0.fonds_implique AS fonds_implique_7, t0.suivi_operation AS suivi_operation_8, t0.date_operation AS date_operation_9, t0.id_secteur_activite AS id_secteur_activite_10, t0.id_localisation AS id_localisation_11, t0.id_localisation_2 AS id_localisation_2_12, t0.id_actualite_principale AS id_actualite_principale_13, t0.visibilite_sur_annonces_fusacq AS visibilite_sur_annonces_fusacq_14, t0.code_naf AS code_naf_15, t0.montant_operation AS montant_operation_16, t0.ca_societe_achetee AS ca_societe_achetee_17, t0.mode_operation AS mode_operation_18, t0.mots_cles_valides AS mots_cles_valides_19, t0.check_rattrapage AS check_rattrapage_20, t0.pct_capital_achete AS pct_capital_achete_21, t0.maj_min_capital AS maj_min_capital_22, t0.fourchette_ca AS fourchette_ca_23, t0.nb_compte_classement AS nb_compte_classement_24, t0.montant_compte_classement AS montant_compte_classement_25 FROM fusacq_dbo.buzz_operations t0 WHERE t0.id_operation = 40228;

SELECT
  t0.id_role AS id_role_1,
  t0.id_type_role AS id_type_role_2,
  t0.id_operation AS id_operation_3,
  t0.id_acteur AS id_acteur_4,
  t0.table_sql_acteur AS table_sql_acteur_5,
  t0.id_membre AS id_membre_6,
  t0.id_acteur_passif AS id_acteur_passif_7,
  t0.table_sql_acteur_passif AS table_sql_acteur_passif_8,
  t0.id_membre_passif AS id_membre_passif_9,
  t0.suivi_role AS suivi_role_10,
  t0.complement_type_role AS complement_type_role_11
FROM
  fusacq_dbo.buzz_roles t0
WHERE
  t0.id_operation = ?

SELECT t0.id_role AS id_role_1, t0.id_type_role AS id_type_role_2, t0.id_operation AS id_operation_3, t0.id_acteur AS id_acteur_4, t0.table_sql_acteur AS table_sql_acteur_5, t0.id_membre AS id_membre_6, t0.id_acteur_passif AS id_acteur_passif_7, t0.table_sql_acteur_passif AS table_sql_acteur_passif_8, t0.id_membre_passif AS id_membre_passif_9, t0.suivi_role AS suivi_role_10, t0.complement_type_role AS complement_type_role_11 FROM fusacq_dbo.buzz_roles t0 WHERE t0.id_operation = 40228;

SELECT
  t0.id_operation AS id_operation_1,
  t0.titre_operation AS titre_operation_2,
  t0.type_operation AS type_operation_3,
  t0.mots_cles AS mots_cles_4,
  t0.personne_physique_impliquee AS personne_physique_impliquee_5,
  t0.societe_impliquee AS societe_impliquee_6,
  t0.fonds_implique AS fonds_implique_7,
  t0.suivi_operation AS suivi_operation_8,
  t0.date_operation AS date_operation_9,
  t0.id_secteur_activite AS id_secteur_activite_10,
  t0.id_localisation AS id_localisation_11,
  t0.id_localisation_2 AS id_localisation_2_12,
  t0.id_actualite_principale AS id_actualite_principale_13,
  t0.visibilite_sur_annonces_fusacq AS visibilite_sur_annonces_fusacq_14,
  t0.code_naf AS code_naf_15,
  t0.montant_operation AS montant_operation_16,
  t0.ca_societe_achetee AS ca_societe_achetee_17,
  t0.mode_operation AS mode_operation_18,
  t0.mots_cles_valides AS mots_cles_valides_19,
  t0.check_rattrapage AS check_rattrapage_20,
  t0.pct_capital_achete AS pct_capital_achete_21,
  t0.maj_min_capital AS maj_min_capital_22,
  t0.fourchette_ca AS fourchette_ca_23,
  t0.nb_compte_classement AS nb_compte_classement_24,
  t0.montant_compte_classement AS montant_compte_classement_25
FROM
  fusacq_dbo.buzz_operations t0
WHERE
  t0.id_operation = ?

SELECT t0.id_operation AS id_operation_1, t0.titre_operation AS titre_operation_2, t0.type_operation AS type_operation_3, t0.mots_cles AS mots_cles_4, t0.personne_physique_impliquee AS personne_physique_impliquee_5, t0.societe_impliquee AS societe_impliquee_6, t0.fonds_implique AS fonds_implique_7, t0.suivi_operation AS suivi_operation_8, t0.date_operation AS date_operation_9, t0.id_secteur_activite AS id_secteur_activite_10, t0.id_localisation AS id_localisation_11, t0.id_localisation_2 AS id_localisation_2_12, t0.id_actualite_principale AS id_actualite_principale_13, t0.visibilite_sur_annonces_fusacq AS visibilite_sur_annonces_fusacq_14, t0.code_naf AS code_naf_15, t0.montant_operation AS montant_operation_16, t0.ca_societe_achetee AS ca_societe_achetee_17, t0.mode_operation AS mode_operation_18, t0.mots_cles_valides AS mots_cles_valides_19, t0.check_rattrapage AS check_rattrapage_20, t0.pct_capital_achete AS pct_capital_achete_21, t0.maj_min_capital AS maj_min_capital_22, t0.fourchette_ca AS fourchette_ca_23, t0.nb_compte_classement AS nb_compte_classement_24, t0.montant_compte_classement AS montant_compte_classement_25 FROM fusacq_dbo.buzz_operations t0 WHERE t0.id_operation = 41252;

SELECT
  t0.id_role AS id_role_1,
  t0.id_type_role AS id_type_role_2,
  t0.id_operation AS id_operation_3,
  t0.id_acteur AS id_acteur_4,
  t0.table_sql_acteur AS table_sql_acteur_5,
  t0.id_membre AS id_membre_6,
  t0.id_acteur_passif AS id_acteur_passif_7,
  t0.table_sql_acteur_passif AS table_sql_acteur_passif_8,
  t0.id_membre_passif AS id_membre_passif_9,
  t0.suivi_role AS suivi_role_10,
  t0.complement_type_role AS complement_type_role_11
FROM
  fusacq_dbo.buzz_roles t0
WHERE
  t0.id_operation = ?

SELECT t0.id_role AS id_role_1, t0.id_type_role AS id_type_role_2, t0.id_operation AS id_operation_3, t0.id_acteur AS id_acteur_4, t0.table_sql_acteur AS table_sql_acteur_5, t0.id_membre AS id_membre_6, t0.id_acteur_passif AS id_acteur_passif_7, t0.table_sql_acteur_passif AS table_sql_acteur_passif_8, t0.id_membre_passif AS id_membre_passif_9, t0.suivi_role AS suivi_role_10, t0.complement_type_role AS complement_type_role_11 FROM fusacq_dbo.buzz_roles t0 WHERE t0.id_operation = 41252;

SELECT
  t0.id_operation AS id_operation_1,
  t0.titre_operation AS titre_operation_2,
  t0.type_operation AS type_operation_3,
  t0.mots_cles AS mots_cles_4,
  t0.personne_physique_impliquee AS personne_physique_impliquee_5,
  t0.societe_impliquee AS societe_impliquee_6,
  t0.fonds_implique AS fonds_implique_7,
  t0.suivi_operation AS suivi_operation_8,
  t0.date_operation AS date_operation_9,
  t0.id_secteur_activite AS id_secteur_activite_10,
  t0.id_localisation AS id_localisation_11,
  t0.id_localisation_2 AS id_localisation_2_12,
  t0.id_actualite_principale AS id_actualite_principale_13,
  t0.visibilite_sur_annonces_fusacq AS visibilite_sur_annonces_fusacq_14,
  t0.code_naf AS code_naf_15,
  t0.montant_operation AS montant_operation_16,
  t0.ca_societe_achetee AS ca_societe_achetee_17,
  t0.mode_operation AS mode_operation_18,
  t0.mots_cles_valides AS mots_cles_valides_19,
  t0.check_rattrapage AS check_rattrapage_20,
  t0.pct_capital_achete AS pct_capital_achete_21,
  t0.maj_min_capital AS maj_min_capital_22,
  t0.fourchette_ca AS fourchette_ca_23,
  t0.nb_compte_classement AS nb_compte_classement_24,
  t0.montant_compte_classement AS montant_compte_classement_25
FROM
  fusacq_dbo.buzz_operations t0
WHERE
  t0.id_operation = ?

SELECT t0.id_operation AS id_operation_1, t0.titre_operation AS titre_operation_2, t0.type_operation AS type_operation_3, t0.mots_cles AS mots_cles_4, t0.personne_physique_impliquee AS personne_physique_impliquee_5, t0.societe_impliquee AS societe_impliquee_6, t0.fonds_implique AS fonds_implique_7, t0.suivi_operation AS suivi_operation_8, t0.date_operation AS date_operation_9, t0.id_secteur_activite AS id_secteur_activite_10, t0.id_localisation AS id_localisation_11, t0.id_localisation_2 AS id_localisation_2_12, t0.id_actualite_principale AS id_actualite_principale_13, t0.visibilite_sur_annonces_fusacq AS visibilite_sur_annonces_fusacq_14, t0.code_naf AS code_naf_15, t0.montant_operation AS montant_operation_16, t0.ca_societe_achetee AS ca_societe_achetee_17, t0.mode_operation AS mode_operation_18, t0.mots_cles_valides AS mots_cles_valides_19, t0.check_rattrapage AS check_rattrapage_20, t0.pct_capital_achete AS pct_capital_achete_21, t0.maj_min_capital AS maj_min_capital_22, t0.fourchette_ca AS fourchette_ca_23, t0.nb_compte_classement AS nb_compte_classement_24, t0.montant_compte_classement AS montant_compte_classement_25 FROM fusacq_dbo.buzz_operations t0 WHERE t0.id_operation = 41518;

SELECT
  t0.id_role AS id_role_1,
  t0.id_type_role AS id_type_role_2,
  t0.id_operation AS id_operation_3,
  t0.id_acteur AS id_acteur_4,
  t0.table_sql_acteur AS table_sql_acteur_5,
  t0.id_membre AS id_membre_6,
  t0.id_acteur_passif AS id_acteur_passif_7,
  t0.table_sql_acteur_passif AS table_sql_acteur_passif_8,
  t0.id_membre_passif AS id_membre_passif_9,
  t0.suivi_role AS suivi_role_10,
  t0.complement_type_role AS complement_type_role_11
FROM
  fusacq_dbo.buzz_roles t0
WHERE
  t0.id_operation = ?

SELECT t0.id_role AS id_role_1, t0.id_type_role AS id_type_role_2, t0.id_operation AS id_operation_3, t0.id_acteur AS id_acteur_4, t0.table_sql_acteur AS table_sql_acteur_5, t0.id_membre AS id_membre_6, t0.id_acteur_passif AS id_acteur_passif_7, t0.table_sql_acteur_passif AS table_sql_acteur_passif_8, t0.id_membre_passif AS id_membre_passif_9, t0.suivi_role AS suivi_role_10, t0.complement_type_role AS complement_type_role_11 FROM fusacq_dbo.buzz_roles t0 WHERE t0.id_operation = 41518;

SELECT
  t0.id_operation AS id_operation_1,
  t0.titre_operation AS titre_operation_2,
  t0.type_operation AS type_operation_3,
  t0.mots_cles AS mots_cles_4,
  t0.personne_physique_impliquee AS personne_physique_impliquee_5,
  t0.societe_impliquee AS societe_impliquee_6,
  t0.fonds_implique AS fonds_implique_7,
  t0.suivi_operation AS suivi_operation_8,
  t0.date_operation AS date_operation_9,
  t0.id_secteur_activite AS id_secteur_activite_10,
  t0.id_localisation AS id_localisation_11,
  t0.id_localisation_2 AS id_localisation_2_12,
  t0.id_actualite_principale AS id_actualite_principale_13,
  t0.visibilite_sur_annonces_fusacq AS visibilite_sur_annonces_fusacq_14,
  t0.code_naf AS code_naf_15,
  t0.montant_operation AS montant_operation_16,
  t0.ca_societe_achetee AS ca_societe_achetee_17,
  t0.mode_operation AS mode_operation_18,
  t0.mots_cles_valides AS mots_cles_valides_19,
  t0.check_rattrapage AS check_rattrapage_20,
  t0.pct_capital_achete AS pct_capital_achete_21,
  t0.maj_min_capital AS maj_min_capital_22,
  t0.fourchette_ca AS fourchette_ca_23,
  t0.nb_compte_classement AS nb_compte_classement_24,
  t0.montant_compte_classement AS montant_compte_classement_25
FROM
  fusacq_dbo.buzz_operations t0
WHERE
  t0.id_operation = ?

SELECT t0.id_operation AS id_operation_1, t0.titre_operation AS titre_operation_2, t0.type_operation AS type_operation_3, t0.mots_cles AS mots_cles_4, t0.personne_physique_impliquee AS personne_physique_impliquee_5, t0.societe_impliquee AS societe_impliquee_6, t0.fonds_implique AS fonds_implique_7, t0.suivi_operation AS suivi_operation_8, t0.date_operation AS date_operation_9, t0.id_secteur_activite AS id_secteur_activite_10, t0.id_localisation AS id_localisation_11, t0.id_localisation_2 AS id_localisation_2_12, t0.id_actualite_principale AS id_actualite_principale_13, t0.visibilite_sur_annonces_fusacq AS visibilite_sur_annonces_fusacq_14, t0.code_naf AS code_naf_15, t0.montant_operation AS montant_operation_16, t0.ca_societe_achetee AS ca_societe_achetee_17, t0.mode_operation AS mode_operation_18, t0.mots_cles_valides AS mots_cles_valides_19, t0.check_rattrapage AS check_rattrapage_20, t0.pct_capital_achete AS pct_capital_achete_21, t0.maj_min_capital AS maj_min_capital_22, t0.fourchette_ca AS fourchette_ca_23, t0.nb_compte_classement AS nb_compte_classement_24, t0.montant_compte_classement AS montant_compte_classement_25 FROM fusacq_dbo.buzz_operations t0 WHERE t0.id_operation = 41641;

SELECT
  t0.id_role AS id_role_1,
  t0.id_type_role AS id_type_role_2,
  t0.id_operation AS id_operation_3,
  t0.id_acteur AS id_acteur_4,
  t0.table_sql_acteur AS table_sql_acteur_5,
  t0.id_membre AS id_membre_6,
  t0.id_acteur_passif AS id_acteur_passif_7,
  t0.table_sql_acteur_passif AS table_sql_acteur_passif_8,
  t0.id_membre_passif AS id_membre_passif_9,
  t0.suivi_role AS suivi_role_10,
  t0.complement_type_role AS complement_type_role_11
FROM
  fusacq_dbo.buzz_roles t0
WHERE
  t0.id_operation = ?

SELECT t0.id_role AS id_role_1, t0.id_type_role AS id_type_role_2, t0.id_operation AS id_operation_3, t0.id_acteur AS id_acteur_4, t0.table_sql_acteur AS table_sql_acteur_5, t0.id_membre AS id_membre_6, t0.id_acteur_passif AS id_acteur_passif_7, t0.table_sql_acteur_passif AS table_sql_acteur_passif_8, t0.id_membre_passif AS id_membre_passif_9, t0.suivi_role AS suivi_role_10, t0.complement_type_role AS complement_type_role_11 FROM fusacq_dbo.buzz_roles t0 WHERE t0.id_operation = 41641;

SELECT
  t0.id_operation AS id_operation_1,
  t0.titre_operation AS titre_operation_2,
  t0.type_operation AS type_operation_3,
  t0.mots_cles AS mots_cles_4,
  t0.personne_physique_impliquee AS personne_physique_impliquee_5,
  t0.societe_impliquee AS societe_impliquee_6,
  t0.fonds_implique AS fonds_implique_7,
  t0.suivi_operation AS suivi_operation_8,
  t0.date_operation AS date_operation_9,
  t0.id_secteur_activite AS id_secteur_activite_10,
  t0.id_localisation AS id_localisation_11,
  t0.id_localisation_2 AS id_localisation_2_12,
  t0.id_actualite_principale AS id_actualite_principale_13,
  t0.visibilite_sur_annonces_fusacq AS visibilite_sur_annonces_fusacq_14,
  t0.code_naf AS code_naf_15,
  t0.montant_operation AS montant_operation_16,
  t0.ca_societe_achetee AS ca_societe_achetee_17,
  t0.mode_operation AS mode_operation_18,
  t0.mots_cles_valides AS mots_cles_valides_19,
  t0.check_rattrapage AS check_rattrapage_20,
  t0.pct_capital_achete AS pct_capital_achete_21,
  t0.maj_min_capital AS maj_min_capital_22,
  t0.fourchette_ca AS fourchette_ca_23,
  t0.nb_compte_classement AS nb_compte_classement_24,
  t0.montant_compte_classement AS montant_compte_classement_25
FROM
  fusacq_dbo.buzz_operations t0
WHERE
  t0.id_operation = ?

SELECT t0.id_operation AS id_operation_1, t0.titre_operation AS titre_operation_2, t0.type_operation AS type_operation_3, t0.mots_cles AS mots_cles_4, t0.personne_physique_impliquee AS personne_physique_impliquee_5, t0.societe_impliquee AS societe_impliquee_6, t0.fonds_implique AS fonds_implique_7, t0.suivi_operation AS suivi_operation_8, t0.date_operation AS date_operation_9, t0.id_secteur_activite AS id_secteur_activite_10, t0.id_localisation AS id_localisation_11, t0.id_localisation_2 AS id_localisation_2_12, t0.id_actualite_principale AS id_actualite_principale_13, t0.visibilite_sur_annonces_fusacq AS visibilite_sur_annonces_fusacq_14, t0.code_naf AS code_naf_15, t0.montant_operation AS montant_operation_16, t0.ca_societe_achetee AS ca_societe_achetee_17, t0.mode_operation AS mode_operation_18, t0.mots_cles_valides AS mots_cles_valides_19, t0.check_rattrapage AS check_rattrapage_20, t0.pct_capital_achete AS pct_capital_achete_21, t0.maj_min_capital AS maj_min_capital_22, t0.fourchette_ca AS fourchette_ca_23, t0.nb_compte_classement AS nb_compte_classement_24, t0.montant_compte_classement AS montant_compte_classement_25 FROM fusacq_dbo.buzz_operations t0 WHERE t0.id_operation = 42521;

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 = '811';

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_societe_prestataire = ?
    AND (
      t0.statut = ?
      OR t0.statut = ?
    )
  )
ORDER BY
  t0.id_service_prestataire DESC

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_societe_prestataire = '811' AND (t0.statut = 'publique' OR t0.statut = 'publique_temporaire')) ORDER BY t0.id_service_prestataire DESC;

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 = ?

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 = 1500;

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_societe_prestataire = ?

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_societe_prestataire = '811';