Symfony Profiler

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

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

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

SELECT
  s0_.raison_sociale AS raison_sociale_0,
  s0_.id_societe AS id_societe_1,
  l1_.id_gestionnaire_fonds AS id_gestionnaire_fonds_2
FROM
  fusacq_dbo.societes s0_
  LEFT JOIN fusacq_dbo.lien_participations_fonds l1_ ON (
    s0_.id_societe = l1_.id_participation
  )
WHERE
  s0_.id_societe = ?
  AND l1_.id_gestionnaire_fonds IS NOT NULL
LIMIT
  1

SELECT s0_.raison_sociale AS raison_sociale_0, s0_.id_societe AS id_societe_1, l1_.id_gestionnaire_fonds AS id_gestionnaire_fonds_2 FROM fusacq_dbo.societes s0_ LEFT JOIN fusacq_dbo.lien_participations_fonds l1_ ON (s0_.id_societe = l1_.id_participation) WHERE s0_.id_societe = 4845 AND l1_.id_gestionnaire_fonds IS NOT NULL LIMIT 1;

SELECT
  DISTINCT b0_.id_operation AS id_operation_0,
  b1_.id_actualite AS id_actualite_1,
  b1_.date_mise_en_ligne AS date_mise_en_ligne_2,
  b1_.titre_actualite AS titre_actualite_3,
  b1_.provenance_flux_actualite AS provenance_flux_actualite_4,
  b1_.autorisation_blog AS autorisation_blog_5
FROM
  fusacq_dbo.buzz_roles b0_
  LEFT JOIN fusacq_dbo.buzz_actualites b1_ ON (
    b0_.id_operation = b1_.id_operation
  )
WHERE
  b1_.mode_actualite = ?
  AND b1_.mode_actualite <> ?
  AND b1_.date_mise_en_ligne IS NOT NULL
  AND b1_.date_mise_en_ligne <> ?
  AND SUBSTRING(
    b1_.date_mise_en_ligne
    FROM
      1 FOR 8
  ) <= ?
  AND b1_.autorisation_blog <> ?
  AND (
    (
      b0_.id_acteur = ?
      AND b0_.table_sql_acteur = ?
    )
    OR (
      b0_.id_acteur_passif = ?
      AND b0_.table_sql_acteur_passif = ?
    )
  )
ORDER BY
  b1_.date_mise_en_ligne DESC
LIMIT
  1000

SELECT DISTINCT b0_.id_operation AS id_operation_0, b1_.id_actualite AS id_actualite_1, b1_.date_mise_en_ligne AS date_mise_en_ligne_2, b1_.titre_actualite AS titre_actualite_3, b1_.provenance_flux_actualite AS provenance_flux_actualite_4, b1_.autorisation_blog AS autorisation_blog_5 FROM fusacq_dbo.buzz_roles b0_ LEFT JOIN fusacq_dbo.buzz_actualites b1_ ON (b0_.id_operation = b1_.id_operation) WHERE b1_.mode_actualite = 'publique' AND b1_.mode_actualite <> 'supprime' AND b1_.date_mise_en_ligne IS NOT NULL AND b1_.date_mise_en_ligne <> '' AND SUBSTRING(b1_.date_mise_en_ligne FROM 1 FOR 8) <= '20260403' AND b1_.autorisation_blog <> 'non' AND ((b0_.id_acteur = '4845' AND b0_.table_sql_acteur = 'societes_news') OR (b0_.id_acteur_passif = '4845' AND b0_.table_sql_acteur_passif = 'societes_news')) ORDER BY b1_.date_mise_en_ligne DESC LIMIT 1000;

SELECT
  b0_.id_operation AS id_operation_0,
  b0_.provenance_flux_actualite AS provenance_flux_actualite_1,
  b0_.visibilite_flux AS visibilite_flux_2
FROM
  fusacq_dbo.buzz_actualites b0_
WHERE
  b0_.id_actualite = ?
LIMIT
  1

SELECT b0_.id_operation AS id_operation_0, b0_.provenance_flux_actualite AS provenance_flux_actualite_1, b0_.visibilite_flux AS visibilite_flux_2 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = 98331 LIMIT 1;

SELECT
  b0_.id_secteur_activite AS id_secteur_activite_0
FROM
  fusacq_dbo.buzz_operations b0_
WHERE
  b0_.id_operation = ?
LIMIT
  1

SELECT b0_.id_secteur_activite AS id_secteur_activite_0 FROM fusacq_dbo.buzz_operations b0_ WHERE b0_.id_operation = 11172 LIMIT 1;

SELECT
  b0_.id_operation AS id_operation_0
FROM
  fusacq_dbo.buzz_actualites b0_
WHERE
  b0_.id_actualite = ?
LIMIT
  1

SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = 98331 LIMIT 1;

SELECT
  a0_.id_annonce_vendeur AS id_annonce_vendeur_0,
  a0_.titre_annonce AS titre_annonce_1,
  a0_.description_activite AS description_activite_2,
  a0_.date_parution AS date_parution_3,
  a0_.date_parution_initiale AS date_parution_initiale_4,
  a0_.id_secteur_activite AS id_secteur_activite_5,
  a0_.code_naf_oseo_nouveau AS code_naf_oseo_nouveau_6,
  a0_.ca_n AS ca_n_7,
  a0_.id_departement AS id_departement_8,
  a0_.id_region AS id_region_9,
  a0_.id_pays AS id_pays_10,
  a0_.zone_geographique AS zone_geographique_11
FROM
  buzz_lien_operations_annonces_vendeur b1_
  LEFT JOIN fusacq_dbo.annonces_vendeur a0_ ON (
    b1_.id_annonce = a0_.id_annonce_vendeur
  )
WHERE
  b1_.id_operation = ?
ORDER BY
  a0_.ca_n DESC
LIMIT
  5

SELECT a0_.id_annonce_vendeur AS id_annonce_vendeur_0, a0_.titre_annonce AS titre_annonce_1, a0_.description_activite AS description_activite_2, a0_.date_parution AS date_parution_3, a0_.date_parution_initiale AS date_parution_initiale_4, a0_.id_secteur_activite AS id_secteur_activite_5, a0_.code_naf_oseo_nouveau AS code_naf_oseo_nouveau_6, a0_.ca_n AS ca_n_7, a0_.id_departement AS id_departement_8, a0_.id_region AS id_region_9, a0_.id_pays AS id_pays_10, a0_.zone_geographique AS zone_geographique_11 FROM buzz_lien_operations_annonces_vendeur b1_ LEFT JOIN fusacq_dbo.annonces_vendeur a0_ ON (b1_.id_annonce = a0_.id_annonce_vendeur) WHERE b1_.id_operation = 11172 ORDER BY a0_.ca_n DESC LIMIT 5;

SELECT
  b0_.id_secteur_activite AS id_secteur_activite_0
FROM
  fusacq_dbo.buzz_operations b0_
WHERE
  b0_.id_operation = ?
LIMIT
  1

SELECT b0_.id_secteur_activite AS id_secteur_activite_0 FROM fusacq_dbo.buzz_operations b0_ WHERE b0_.id_operation = 11172 LIMIT 1;

SELECT
  a0_.id_annonce_acheteur AS id_annonce_acheteur_0,
  a0_.titre_annonce AS titre_annonce_1,
  a0_.ca_max AS ca_max_2,
  a0_.id_region AS id_region_3,
  a0_.id_pays AS id_pays_4,
  a0_.id_departement AS id_departement_5,
  a0_.autres_localisations AS autres_localisations_6
FROM
  fusacq_dbo.annonces_acheteur a0_
WHERE
  a0_.id_secteur_activite = ?
  AND a0_.mode_annonce = ?
  AND a0_.tpe_pme = ?
ORDER BY
  a0_.date_parution_initiale DESC
LIMIT
  5

SELECT a0_.id_annonce_acheteur AS id_annonce_acheteur_0, a0_.titre_annonce AS titre_annonce_1, a0_.ca_max AS ca_max_2, a0_.id_region AS id_region_3, a0_.id_pays AS id_pays_4, a0_.id_departement AS id_departement_5, a0_.autres_localisations AS autres_localisations_6 FROM fusacq_dbo.annonces_acheteur a0_ WHERE a0_.id_secteur_activite = 61401 AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' ORDER BY a0_.date_parution_initiale DESC LIMIT 5;

SELECT
  s0_.id_secteur_activite AS id_secteur_activite_0,
  s0_.nom_secteur_activite AS nom_secteur_activite_1,
  s0_.nom_secteur_activite AS nom_secteur_activite_2
FROM
  fusacq_dbo.secteurs_activite s0_
WHERE
  s0_.id_secteur_activite = ?

SELECT s0_.id_secteur_activite AS id_secteur_activite_0, s0_.nom_secteur_activite AS nom_secteur_activite_1, s0_.nom_secteur_activite AS nom_secteur_activite_2 FROM fusacq_dbo.secteurs_activite s0_ WHERE s0_.id_secteur_activite = 61401;

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

SELECT
  a0_.id_annonce_vendeur AS id_annonce_vendeur_0,
  a0_.titre_annonce AS titre_annonce_1,
  a0_.description_activite AS description_activite_2,
  a0_.date_parution AS date_parution_3,
  a0_.date_parution_initiale AS date_parution_initiale_4,
  a0_.id_secteur_activite AS id_secteur_activite_5,
  a0_.code_naf_oseo_nouveau AS code_naf_oseo_nouveau_6,
  a0_.ca_n AS ca_n_7,
  a0_.id_departement AS id_departement_8,
  a0_.id_region AS id_region_9,
  a0_.id_pays AS id_pays_10,
  a0_.zone_geographique AS zone_geographique_11
FROM
  buzz_lien_operations_annonces_vendeur b1_
  LEFT JOIN fusacq_dbo.annonces_vendeur a0_ ON (
    b1_.id_annonce = a0_.id_annonce_vendeur
  )
WHERE
  b1_.id_operation = ?
ORDER BY
  a0_.ca_n DESC
LIMIT
  5

SELECT a0_.id_annonce_vendeur AS id_annonce_vendeur_0, a0_.titre_annonce AS titre_annonce_1, a0_.description_activite AS description_activite_2, a0_.date_parution AS date_parution_3, a0_.date_parution_initiale AS date_parution_initiale_4, a0_.id_secteur_activite AS id_secteur_activite_5, a0_.code_naf_oseo_nouveau AS code_naf_oseo_nouveau_6, a0_.ca_n AS ca_n_7, a0_.id_departement AS id_departement_8, a0_.id_region AS id_region_9, a0_.id_pays AS id_pays_10, a0_.zone_geographique AS zone_geographique_11 FROM buzz_lien_operations_annonces_vendeur b1_ LEFT JOIN fusacq_dbo.annonces_vendeur a0_ ON (b1_.id_annonce = a0_.id_annonce_vendeur) WHERE b1_.id_operation = 11172 ORDER BY a0_.ca_n DESC LIMIT 5;

SELECT
  b0_.id_secteur_activite AS id_secteur_activite_0
FROM
  fusacq_dbo.buzz_operations b0_
WHERE
  b0_.id_operation = ?
LIMIT
  1

SELECT b0_.id_secteur_activite AS id_secteur_activite_0 FROM fusacq_dbo.buzz_operations b0_ WHERE b0_.id_operation = 11172 LIMIT 1;

SELECT
  a0_.id_annonce_acheteur AS id_annonce_acheteur_0,
  a0_.titre_annonce AS titre_annonce_1,
  a0_.ca_max AS ca_max_2,
  a0_.id_region AS id_region_3,
  a0_.id_pays AS id_pays_4,
  a0_.id_departement AS id_departement_5,
  a0_.autres_localisations AS autres_localisations_6
FROM
  fusacq_dbo.annonces_acheteur a0_
WHERE
  a0_.id_secteur_activite = ?
  AND a0_.mode_annonce = ?
  AND a0_.tpe_pme = ?
ORDER BY
  a0_.date_parution_initiale DESC
LIMIT
  5

SELECT a0_.id_annonce_acheteur AS id_annonce_acheteur_0, a0_.titre_annonce AS titre_annonce_1, a0_.ca_max AS ca_max_2, a0_.id_region AS id_region_3, a0_.id_pays AS id_pays_4, a0_.id_departement AS id_departement_5, a0_.autres_localisations AS autres_localisations_6 FROM fusacq_dbo.annonces_acheteur a0_ WHERE a0_.id_secteur_activite = 61401 AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' ORDER BY a0_.date_parution_initiale DESC LIMIT 5;

SELECT
  id_localisation,
  id_localisation_2
FROM
  fusacq_dbo.buzz_operations
WHERE
  id_operation = ?
LIMIT
  1

SELECT id_localisation, id_localisation_2 FROM fusacq_dbo.buzz_operations WHERE id_operation = 11172 LIMIT 1;

SELECT
  s0_.id_secteur_activite AS id_secteur_activite_0,
  s0_.nom_secteur_activite AS nom_secteur_activite_1,
  s0_.nom_secteur_activite AS nom_secteur_activite_2
FROM
  fusacq_dbo.secteurs_activite s0_
WHERE
  s0_.id_secteur_activite = ?

SELECT s0_.id_secteur_activite AS id_secteur_activite_0, s0_.nom_secteur_activite AS nom_secteur_activite_1, s0_.nom_secteur_activite AS nom_secteur_activite_2 FROM fusacq_dbo.secteurs_activite s0_ WHERE s0_.id_secteur_activite = 61401;

SELECT
  *
FROM
  (
    (
      SELECT
        DISTINCT ba.id_actualite,
        ba.date_mise_en_ligne,
        ba.titre_actualite,
        ba.sous_titre,
        ba.provenance_flux_actualite,
        ba.id_message_blog,
        ba.id_societe_prestataire,
        ba.visibilite_flux
      FROM
        fusacq_dbo.buzz_operations bo
        INNER JOIN fusacq_dbo.buzz_actualites ba ON bo.id_actualite_principale = ba.id_actualite
      WHERE
        ba.mode_actualite = 'publique'
        AND (
          (
            ba.provenance_flux_actualite = 'blog'
            AND ba.visibilite_flux LIKE '%collaborative%'
          )
          OR ba.provenance_flux_actualite != 'blog'
        )
        AND bo.id_actualite_principale IS NOT NULL
        AND ba.id_actualite IS NOT NULL
        AND bo.id_secteur_activite = 61401
    )
    UNION
      (
        SELECT
          DISTINCT ba.id_actualite,
          ba.date_mise_en_ligne,
          ba.titre_actualite,
          ba.sous_titre,
          ba.provenance_flux_actualite,
          ba.id_message_blog,
          ba.id_societe_prestataire,
          ba.visibilite_flux
        FROM
          fusacq_dbo.buzz_actualites ba
          INNER JOIN fusacq_dbo.buzz_operations bo ON ba.id_operation = bo.id_operation
        WHERE
          ba.mode_actualite = 'publique'
          AND (
            (
              ba.provenance_flux_actualite = 'blog'
              AND ba.visibilite_flux LIKE '%collaborative%'
            )
            OR ba.provenance_flux_actualite != 'blog'
          )
          AND ba.id_operation IS NOT NULL
          AND bo.id_secteur_activite = 61401
      )
  ) AS combined
WHERE
  id_actualite != 98331
ORDER BY
  date_mise_en_ligne DESC
LIMIT
  5

SELECT * FROM ((
            SELECT DISTINCT
                ba.id_actualite,
                ba.date_mise_en_ligne,
                ba.titre_actualite,
                ba.sous_titre,
                ba.provenance_flux_actualite,
                ba.id_message_blog,
                ba.id_societe_prestataire,
                ba.visibilite_flux
            FROM fusacq_dbo.buzz_operations bo
            INNER JOIN fusacq_dbo.buzz_actualites ba ON bo.id_actualite_principale = ba.id_actualite
            WHERE ba.mode_actualite = 'publique'
            AND (
                (ba.provenance_flux_actualite = 'blog' AND ba.visibilite_flux LIKE '%collaborative%')
                OR ba.provenance_flux_actualite != 'blog'
            )
            AND bo.id_actualite_principale IS NOT NULL
            AND ba.id_actualite IS NOT NULL
            AND bo.id_secteur_activite = 61401
        ) UNION (
            SELECT DISTINCT
                ba.id_actualite,
                ba.date_mise_en_ligne,
                ba.titre_actualite,
                ba.sous_titre,
                ba.provenance_flux_actualite,
                ba.id_message_blog,
                ba.id_societe_prestataire,
                ba.visibilite_flux
            FROM fusacq_dbo.buzz_actualites ba
            INNER JOIN fusacq_dbo.buzz_operations bo ON ba.id_operation = bo.id_operation
            WHERE ba.mode_actualite = 'publique'
            AND (
                (ba.provenance_flux_actualite = 'blog' AND ba.visibilite_flux LIKE '%collaborative%')
                OR ba.provenance_flux_actualite != 'blog'
            )
            AND ba.id_operation IS NOT NULL
            AND bo.id_secteur_activite = 61401
        )) AS combined WHERE id_actualite != 98331 ORDER BY date_mise_en_ligne DESC LIMIT 5;

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

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 = '33_06';

SELECT
  id,
  titre_annonce,
  date_parution_initiale_complete,
  date_parution_initiale,
  type_annonce,
  date_tri
FROM
  (
    SELECT
      id_annonce_vendeur AS id,
      titre_annonce,
      date_parution_initiale_complete,
      date_parution_initiale,
      'V' AS type_annonce,
      CASE WHEN date_parution_initiale_complete IS NOT NULL
      AND date_parution_initiale_complete != ''
      AND LENGTH(
        date_parution_initiale_complete
      ) >= 12
      AND LENGTH(
        date_parution_initiale_complete
      ) <= 14 THEN CASE WHEN LENGTH(
        date_parution_initiale_complete
      ) = 14 THEN date_parution_initiale_complete ELSE CONCAT(
        date_parution_initiale_complete,
        '00'
      ) END ELSE CONCAT(
        date_parution_initiale, '000000'
      ) END AS date_tri
    FROM
      annonces_vendeur
    WHERE
      mode_annonce = 'publique'
      AND tpe_pme = 'oui'
      AND visible_dernieres_annonces IS NULL
      AND date_parution_initiale IS NOT NULL
    UNION ALL
    SELECT
      id_annonce_acheteur AS id,
      titre_annonce,
      date_parution_initiale_complete,
      date_parution_initiale,
      'A' AS type_annonce,
      CASE WHEN date_parution_initiale_complete IS NOT NULL
      AND date_parution_initiale_complete != ''
      AND LENGTH(
        date_parution_initiale_complete
      ) >= 12
      AND LENGTH(
        date_parution_initiale_complete
      ) <= 14 THEN CASE WHEN LENGTH(
        date_parution_initiale_complete
      ) = 14 THEN date_parution_initiale_complete ELSE CONCAT(
        date_parution_initiale_complete,
        '00'
      ) END ELSE CONCAT(
        date_parution_initiale, '000000'
      ) END AS date_tri
    FROM
      annonces_acheteur
    WHERE
      mode_annonce = 'publique'
      AND tpe_pme = 'oui'
      AND date_parution_initiale IS NOT NULL
    UNION ALL
    SELECT
      id_repreneur AS id,
      titre_profil AS titre_annonce,
      date_parution_initiale_complete,
      date_parution_initiale,
      'R' AS type_annonce,
      CASE WHEN date_parution_initiale_complete IS NOT NULL
      AND date_parution_initiale_complete != ''
      AND LENGTH(
        date_parution_initiale_complete
      ) >= 12
      AND LENGTH(
        date_parution_initiale_complete
      ) <= 14 THEN CASE WHEN LENGTH(
        date_parution_initiale_complete
      ) = 14 THEN date_parution_initiale_complete ELSE CONCAT(
        date_parution_initiale_complete,
        '00'
      ) END ELSE CONCAT(
        date_parution_initiale, '000000'
      ) END AS date_tri
    FROM
      annuaire_repreneurs
    WHERE
      mode_profil = 'publique'
      AND date_parution_initiale IS NOT NULL
  ) AS en_direct
ORDER BY
  date_tri DESC,
  id DESC
LIMIT
  :limit

SELECT
                id,
                titre_annonce,
                date_parution_initiale_complete,
                date_parution_initiale,
                type_annonce,
                date_tri
            FROM (
                SELECT
                    id_annonce_vendeur AS id,
                    titre_annonce,
                    date_parution_initiale_complete,
                    date_parution_initiale,
                    'V' AS type_annonce,
                    CASE 
                        WHEN date_parution_initiale_complete IS NOT NULL 
                             AND date_parution_initiale_complete != '' 
                             AND LENGTH(date_parution_initiale_complete) >= 12 
                             AND LENGTH(date_parution_initiale_complete) <= 14
                        THEN 
                            CASE 
                                WHEN LENGTH(date_parution_initiale_complete) = 14 
                                THEN date_parution_initiale_complete
                                ELSE CONCAT(date_parution_initiale_complete, '00')
                            END
                        ELSE CONCAT(date_parution_initiale, '000000')
                    END AS date_tri
                FROM annonces_vendeur
                WHERE mode_annonce = 'publique'
                AND tpe_pme = 'oui'
                AND visible_dernieres_annonces IS NULL
                AND date_parution_initiale IS NOT NULL
                UNION ALL
                SELECT
                    id_annonce_acheteur AS id,
                    titre_annonce,
                    date_parution_initiale_complete,
                    date_parution_initiale,
                    'A' AS type_annonce,
                    CASE 
                        WHEN date_parution_initiale_complete IS NOT NULL 
                             AND date_parution_initiale_complete != '' 
                             AND LENGTH(date_parution_initiale_complete) >= 12 
                             AND LENGTH(date_parution_initiale_complete) <= 14
                        THEN 
                            CASE 
                                WHEN LENGTH(date_parution_initiale_complete) = 14 
                                THEN date_parution_initiale_complete
                                ELSE CONCAT(date_parution_initiale_complete, '00')
                            END
                        ELSE CONCAT(date_parution_initiale, '000000')
                    END AS date_tri
                FROM annonces_acheteur
                WHERE mode_annonce = 'publique'
                AND tpe_pme = 'oui'
                AND date_parution_initiale IS NOT NULL
                UNION ALL
                SELECT
                    id_repreneur AS id,
                    titre_profil AS titre_annonce,
                    date_parution_initiale_complete,
                    date_parution_initiale,
                    'R' AS type_annonce,
                    CASE 
                        WHEN date_parution_initiale_complete IS NOT NULL 
                             AND date_parution_initiale_complete != '' 
                             AND LENGTH(date_parution_initiale_complete) >= 12 
                             AND LENGTH(date_parution_initiale_complete) <= 14
                        THEN 
                            CASE 
                                WHEN LENGTH(date_parution_initiale_complete) = 14 
                                THEN date_parution_initiale_complete
                                ELSE CONCAT(date_parution_initiale_complete, '00')
                            END
                        ELSE CONCAT(date_parution_initiale, '000000')
                    END AS date_tri
                FROM annuaire_repreneurs
                WHERE mode_profil = 'publique'
                AND date_parution_initiale IS NOT NULL
            ) AS en_direct
            ORDER BY date_tri DESC, id DESC
            LIMIT 5
        ;

SELECT
  id_actualite,
  jour,
  mois,
  type_actualite,
  titre_actualite,
  date_mise_en_ligne
FROM
  (
    SELECT
      id_actualite,
      SUBSTRING(date_mise_en_ligne, 7, 2) AS jour,
      SUBSTRING(date_mise_en_ligne, 5, 2) AS mois,
      type_actualite,
      titre_actualite,
      date_mise_en_ligne,
      ROW_NUMBER() OVER (
        PARTITION BY
          type_actualite
        ORDER BY
          date_mise_en_ligne DESC
      ) AS rn
    FROM
      buzz_actualites
    WHERE
      provenance_flux_actualite = 'blog'
      AND mode_actualite = 'publique'
      AND date_mise_en_ligne <= :now
      AND id_localisation LIKE CONCAT(:idPays, '%')
  ) t
WHERE
  rn <= 2
ORDER BY
  date_mise_en_ligne DESC,
  id_actualite DESC

SELECT id_actualite, jour, mois, type_actualite, titre_actualite, date_mise_en_ligne
        FROM (
            SELECT
                id_actualite,
                SUBSTRING(date_mise_en_ligne, 7, 2) AS jour,
                SUBSTRING(date_mise_en_ligne, 5, 2) AS mois,
                type_actualite,
                titre_actualite,
                date_mise_en_ligne,
                ROW_NUMBER() OVER (PARTITION BY type_actualite ORDER BY date_mise_en_ligne DESC) AS rn
            FROM buzz_actualites
            WHERE
                provenance_flux_actualite = 'blog'
                AND mode_actualite = 'publique'
                AND date_mise_en_ligne <= '20260403161203'
                AND id_localisation LIKE CONCAT('33', '%')
        ) t
        WHERE rn <= 2
        ORDER BY date_mise_en_ligne DESC, id_actualite DESC
    ;