Symfony Profiler

SELECT
  *
FROM
  fusacq_dbo.buzz_actualites
WHERE
  id_actualite = ?
  AND mode_actualite != ?
LIMIT
  1

SELECT * FROM fusacq_dbo.buzz_actualites WHERE id_actualite = 257803 AND mode_actualite != 'supprime' LIMIT 1;

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.alerte_envoyee AS alerte_envoyee_40,
  t0.id_participation AS id_participation_41,
  t0.id_participation_temporaire AS id_participation_temporaire_42,
  t0.id_operation_temporaire AS id_operation_temporaire_43,
  t0.id_fonds_bot AS id_fonds_bot_44,
  t0.souhaite_classement AS souhaite_classement_45,
  t0.souhaite_reseau AS souhaite_reseau_46,
  t0.souhaite_prestation AS souhaite_prestation_47,
  t0.souhaite_nom_reseau AS souhaite_nom_reseau_48,
  t0.autorisation_blog AS autorisation_blog_49,
  t0.contact_validation AS contact_validation_50,
  t0.commentaires_blog AS commentaires_blog_51,
  t0.apparition_classement AS apparition_classement_52,
  t0.classement_reseau AS classement_reseau_53,
  t0.classement_prestation AS classement_prestation_54,
  t0.id_reseau AS id_reseau_55,
  t0.suivi_classement AS suivi_classement_56,
  t0.is_description_html AS is_description_html_57,
  t0.is_forum_active AS is_forum_active_58,
  t0.actu_ess AS actu_ess_59,
  t0.suivi_actualite AS suivi_actualite_60,
  t0.date_validation AS date_validation_61,
  t0.indexe_google AS indexe_google_62
FROM
  fusacq_dbo.buzz_actualites t0
WHERE
  t0.id_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.alerte_envoyee AS alerte_envoyee_40, t0.id_participation AS id_participation_41, t0.id_participation_temporaire AS id_participation_temporaire_42, t0.id_operation_temporaire AS id_operation_temporaire_43, t0.id_fonds_bot AS id_fonds_bot_44, t0.souhaite_classement AS souhaite_classement_45, t0.souhaite_reseau AS souhaite_reseau_46, t0.souhaite_prestation AS souhaite_prestation_47, t0.souhaite_nom_reseau AS souhaite_nom_reseau_48, t0.autorisation_blog AS autorisation_blog_49, t0.contact_validation AS contact_validation_50, t0.commentaires_blog AS commentaires_blog_51, t0.apparition_classement AS apparition_classement_52, t0.classement_reseau AS classement_reseau_53, t0.classement_prestation AS classement_prestation_54, t0.id_reseau AS id_reseau_55, t0.suivi_classement AS suivi_classement_56, t0.is_description_html AS is_description_html_57, t0.is_forum_active AS is_forum_active_58, t0.actu_ess AS actu_ess_59, t0.suivi_actualite AS suivi_actualite_60, t0.date_validation AS date_validation_61, t0.indexe_google AS indexe_google_62 FROM fusacq_dbo.buzz_actualites t0 WHERE t0.id_actualite = 257803;

SELECT
  photo_actualite
FROM
  fusacq_dbo.buzz_actualites
WHERE
  id_actualite = ?

SELECT photo_actualite FROM fusacq_dbo.buzz_actualites WHERE id_actualite = 257803;

SELECT
  photo_actualite
FROM
  fusacq_dbo.buzz_actualites
WHERE
  id_actualite = ?

SELECT photo_actualite FROM fusacq_dbo.buzz_actualites WHERE id_actualite = 257803;

SELECT
  provenance_flux_actualite,
  visibilite_flux
FROM
  fusacq_dbo.buzz_actualites
WHERE
  id_actualite = ?
LIMIT
  1

SELECT provenance_flux_actualite, visibilite_flux FROM fusacq_dbo.buzz_actualites WHERE id_actualite = 257803 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 = ?
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 = 257803 LIMIT 1;

SELECT
  b0_.id_secteur_activite AS id_secteur_activite_0
FROM
  fusacq_dbo.buzz_operations b0_
WHERE
  b0_.id_actualite_principale = ?
  AND b0_.id_secteur_activite IS NOT NULL
LIMIT
  1

SELECT b0_.id_secteur_activite AS id_secteur_activite_0 FROM fusacq_dbo.buzz_operations b0_ WHERE b0_.id_actualite_principale = 257803 AND b0_.id_secteur_activite IS NOT NULL LIMIT 1;

SELECT
  b0_.id_secteur_activite AS id_secteur_activite_0,
  COUNT(b0_.id_operation) AS sclr_1
FROM
  fusacq_dbo.buzz_operations b0_
WHERE
  b0_.id_secteur_activite IS NOT NULL
GROUP BY
  b0_.id_secteur_activite
ORDER BY
  sclr_1 DESC
LIMIT
  1

SELECT b0_.id_secteur_activite AS id_secteur_activite_0, COUNT(b0_.id_operation) AS sclr_1 FROM fusacq_dbo.buzz_operations b0_ WHERE b0_.id_secteur_activite IS NOT NULL GROUP BY b0_.id_secteur_activite ORDER BY sclr_1 DESC LIMIT 1;

SELECT
  *
FROM
  fusacq_dbo.buzz_actualites
WHERE
  id_actualite = ?
  AND mode_actualite != ?
LIMIT
  1

SELECT * FROM fusacq_dbo.buzz_actualites WHERE id_actualite = 257803 AND mode_actualite != 'supprime' LIMIT 1;

SELECT
  photo_actualite
FROM
  fusacq_dbo.buzz_actualites
WHERE
  id_actualite = ?

SELECT photo_actualite FROM fusacq_dbo.buzz_actualites WHERE id_actualite = 257803;

SELECT
  photo_actualite
FROM
  fusacq_dbo.buzz_actualites
WHERE
  id_actualite = ?

SELECT photo_actualite FROM fusacq_dbo.buzz_actualites WHERE id_actualite = 257803;

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 = 50205
    )
    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 = 50205
      )
  ) AS combined
WHERE
  id_actualite != 257803
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 = 50205
        ) 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 = 50205
        )) AS combined WHERE id_actualite != 257803 ORDER BY date_mise_en_ligne DESC LIMIT 5;

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 <= '20260414113723'
                AND id_localisation LIKE CONCAT('33', '%')
        ) t
        WHERE rn <= 2
        ORDER BY date_mise_en_ligne DESC, id_actualite DESC
    ;

SELECT
  *
FROM
  fusacq_dbo.buzz_actualites
WHERE
  id_actualite = ?
  AND mode_actualite != ?
LIMIT
  1

SELECT * FROM fusacq_dbo.buzz_actualites WHERE id_actualite = 257803 AND mode_actualite != 'supprime' LIMIT 1;

SELECT
  photo_actualite
FROM
  fusacq_dbo.buzz_actualites
WHERE
  id_actualite = ?

SELECT photo_actualite FROM fusacq_dbo.buzz_actualites WHERE id_actualite = 257803;

SELECT
  photo_actualite
FROM
  fusacq_dbo.buzz_actualites
WHERE
  id_actualite = ?

SELECT photo_actualite FROM fusacq_dbo.buzz_actualites WHERE id_actualite = 257803;

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 = 50205
    )
    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 = 50205
      )
  ) AS combined
WHERE
  id_actualite != 257803
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 = 50205
        ) 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 = 50205
        )) AS combined WHERE id_actualite != 257803 ORDER BY date_mise_en_ligne DESC LIMIT 5;

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 <= '20260414113723'
                AND id_localisation LIKE CONCAT('33', '%')
        ) t
        WHERE rn <= 2
        ORDER BY date_mise_en_ligne DESC, id_actualite DESC
    ;

SELECT
  t0.id_actualite AS id_actualite_1,
  t0.nb_affichages AS nb_affichages_2
FROM
  fusacq_dbo.statistiques_nb_consultations_actualites_buzz t0
WHERE
  t0.id_actualite = ?
LIMIT
  1

SELECT t0.id_actualite AS id_actualite_1, t0.nb_affichages AS nb_affichages_2 FROM fusacq_dbo.statistiques_nb_consultations_actualites_buzz t0 WHERE t0.id_actualite = 257803 LIMIT 1;