Symfony Profiler

SELECT
  t0.id_parametre AS id_parametre_1,
  t0.type_parametre AS type_parametre_2,
  t0.plateforme_parametre AS plateforme_parametre_3,
  t0.nom_parametre AS nom_parametre_4,
  t0.valeur_parametre AS valeur_parametre_5
FROM
  partage_dbo.parametres_generaux t0
WHERE
  t0.nom_parametre = ?

SELECT t0.id_parametre AS id_parametre_1, t0.type_parametre AS type_parametre_2, t0.plateforme_parametre AS plateforme_parametre_3, t0.nom_parametre AS nom_parametre_4, t0.valeur_parametre AS valeur_parametre_5 FROM partage_dbo.parametres_generaux t0 WHERE t0.nom_parametre = 'segment_defaut_classements';

SELECT
  t0.id_parametre AS id_parametre_1,
  t0.type_parametre AS type_parametre_2,
  t0.plateforme_parametre AS plateforme_parametre_3,
  t0.nom_parametre AS nom_parametre_4,
  t0.valeur_parametre AS valeur_parametre_5
FROM
  partage_dbo.parametres_generaux t0
WHERE
  t0.nom_parametre = ?

SELECT t0.id_parametre AS id_parametre_1, t0.type_parametre AS type_parametre_2, t0.plateforme_parametre AS plateforme_parametre_3, t0.nom_parametre AS nom_parametre_4, t0.valeur_parametre AS valeur_parametre_5 FROM partage_dbo.parametres_generaux t0 WHERE t0.nom_parametre = 'localisation_defaut_classements';

SELECT
  t0.id_parametre AS id_parametre_1,
  t0.type_parametre AS type_parametre_2,
  t0.plateforme_parametre AS plateforme_parametre_3,
  t0.nom_parametre AS nom_parametre_4,
  t0.valeur_parametre AS valeur_parametre_5
FROM
  partage_dbo.parametres_generaux t0
WHERE
  t0.nom_parametre = ?

SELECT t0.id_parametre AS id_parametre_1, t0.type_parametre AS type_parametre_2, t0.plateforme_parametre AS plateforme_parametre_3, t0.nom_parametre AS nom_parametre_4, t0.valeur_parametre AS valeur_parametre_5 FROM partage_dbo.parametres_generaux t0 WHERE t0.nom_parametre = 'annee_defaut_classements';

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
  DISTINCT(a.id_operation),
  s.raison_sociale,
  s.segments_classements_concernes,
  o.montant_operation,
  o.maj_min_capital,
  o.fourchette_ca,
  o.ca_societe_achetee,
  o.pct_capital_achete,
  u.factur_nom_societe,
  sp.titre_service,
  sp.url_site_web,
  sp.url_site_web_visible,
  sp.utiliser_artviper,
  sp.src_image_si_artviper_desactive,
  sp.id_service_prestataire,
  sp.nom_commercial_societe,
  sp.id_societe_prestataire
FROM
  buzz_actualites AS a,
  societes_prestataire AS s,
  services_prestataire AS sp,
  buzz_operations AS o,
  buzz_roles AS r,
  utilisateurs AS u
WHERE
  a.type_actualite = 'reference'
  AND a.mode_actualite = 'publique'
  AND a.id_operation IS NOT NULL
  AND a.apparition_classement = 'oui'
  AND a.classement_prestation = 'oui'
  AND r.id_membre IS NULL
  AND o.id_operation = a.id_operation
  AND o.type_operation = 'fusion_acquisition'
  AND (
    o.date_operation BETWEEN '20250101'
    AND '20251231'
  )
  AND (
    a.date_mise_en_ligne BETWEEN '20250101000000'
    AND '20260205235959'
  )
  AND o.id_operation = r.id_operation
  AND r.id_type_role = 14
  AND r.id_acteur = sp.id_service_prestataire
  AND sp.id_societe_prestataire = s.id_societe_prestataire
  AND a.id_societe_prestataire = s.id_societe_prestataire
  AND u.login_utilisateur = s.login_utilisateur
ORDER BY
  sp.id_societe_prestataire,
  sp.id_service_prestataire

SELECT
                DISTINCT(a.id_operation),
                s.raison_sociale,
                s.segments_classements_concernes,
                o.montant_operation,
                o.maj_min_capital,
                o.fourchette_ca,
                o.ca_societe_achetee,
                o.pct_capital_achete,
                u.factur_nom_societe,
                sp.titre_service,
                sp.url_site_web,
                sp.url_site_web_visible,
                sp.utiliser_artviper,
                sp.src_image_si_artviper_desactive,
                sp.id_service_prestataire,
                sp.nom_commercial_societe,
                sp.id_societe_prestataire
                FROM
                buzz_actualites AS a,
                societes_prestataire AS s,
                services_prestataire AS sp,
                buzz_operations AS o,
                buzz_roles AS r,
                utilisateurs AS u
                WHERE a.type_actualite='reference'
                AND a.mode_actualite='publique'
                AND a.id_operation IS NOT NULL
                AND a.apparition_classement = 'oui'
                AND a.classement_prestation = 'oui'
                AND r.id_membre IS NULL
                
                AND o.id_operation = a.id_operation
                AND o.type_operation = 'fusion_acquisition'
                 AND (o.date_operation BETWEEN '20250101' AND '20251231'  ) AND (a.date_mise_en_ligne BETWEEN '20250101000000' AND '20260205235959' ) 
                
                AND o.id_operation = r.id_operation
                AND r.id_type_role=14
                AND r.id_acteur = sp.id_service_prestataire
                AND sp.id_societe_prestataire = s.id_societe_prestataire
                AND a.id_societe_prestataire = s.id_societe_prestataire
                AND u.login_utilisateur = s.login_utilisateur
                ORDER BY sp.id_societe_prestataire,sp.id_service_prestataire;

SELECT
  DISTINCT(a.id_operation),
  s.raison_sociale,
  s.segments_classements_concernes,
  o.montant_operation,
  o.maj_min_capital,
  o.fourchette_ca,
  o.ca_societe_achetee,
  o.pct_capital_achete,
  u.factur_nom_societe,
  sp.titre_service,
  sp.url_site_web,
  sp.url_site_web_visible,
  sp.utiliser_artviper,
  sp.src_image_si_artviper_desactive,
  sp.id_service_prestataire,
  sp.nom_commercial_societe,
  sp.id_societe_prestataire
FROM
  buzz_actualites AS a,
  societes_prestataire AS s,
  services_prestataire AS sp,
  buzz_operations AS o,
  buzz_roles AS r,
  utilisateurs AS u
WHERE
  a.type_actualite = 'reference'
  AND a.mode_actualite = 'publique'
  AND a.id_operation IS NOT NULL
  AND a.apparition_classement = 'oui'
  AND a.classement_prestation = 'oui'
  AND r.id_membre IS NULL
  AND o.id_operation = a.id_operation
  AND o.type_operation = 'fusion_acquisition'
  AND (
    o.date_operation BETWEEN '20250101'
    AND '20251231'
  )
  AND (
    a.date_mise_en_ligne BETWEEN '20250101000000'
    AND '20260205235959'
  )
  AND o.id_operation = r.id_operation
  AND r.id_type_role = 5
  AND r.id_acteur = sp.id_service_prestataire
  AND sp.id_societe_prestataire = s.id_societe_prestataire
  AND a.id_societe_prestataire = s.id_societe_prestataire
  AND u.login_utilisateur = s.login_utilisateur
ORDER BY
  sp.id_societe_prestataire,
  sp.id_service_prestataire

SELECT
                DISTINCT(a.id_operation),
                s.raison_sociale,
                s.segments_classements_concernes,
                o.montant_operation,
                o.maj_min_capital,
                o.fourchette_ca,
                o.ca_societe_achetee,
                o.pct_capital_achete,
                u.factur_nom_societe,
                sp.titre_service,
                sp.url_site_web,
                sp.url_site_web_visible,
                sp.utiliser_artviper,
                sp.src_image_si_artviper_desactive,
                sp.id_service_prestataire,
                sp.nom_commercial_societe,
                sp.id_societe_prestataire
                FROM
                buzz_actualites AS a,
                societes_prestataire AS s,
                services_prestataire AS sp,
                buzz_operations AS o,
                buzz_roles AS r,
                utilisateurs AS u
                WHERE a.type_actualite='reference'
                AND a.mode_actualite='publique'
                AND a.id_operation IS NOT NULL
                AND a.apparition_classement = 'oui'
                AND a.classement_prestation = 'oui'
                AND r.id_membre IS NULL
                
                AND o.id_operation = a.id_operation
                AND o.type_operation = 'fusion_acquisition'
                 AND (o.date_operation BETWEEN '20250101' AND '20251231'  ) AND (a.date_mise_en_ligne BETWEEN '20250101000000' AND '20260205235959' ) 
                
                AND o.id_operation = r.id_operation
                AND r.id_type_role=5
                AND r.id_acteur = sp.id_service_prestataire
                AND sp.id_societe_prestataire = s.id_societe_prestataire
                AND a.id_societe_prestataire = s.id_societe_prestataire
                AND u.login_utilisateur = s.login_utilisateur
                ORDER BY sp.id_societe_prestataire,sp.id_service_prestataire;

SELECT
  DISTINCT(a.id_operation),
  s.raison_sociale,
  s.segments_classements_concernes,
  o.montant_operation,
  o.maj_min_capital,
  o.fourchette_ca,
  o.ca_societe_achetee,
  o.pct_capital_achete,
  u.factur_nom_societe,
  sp.titre_service,
  sp.url_site_web,
  sp.url_site_web_visible,
  sp.utiliser_artviper,
  sp.src_image_si_artviper_desactive,
  sp.id_service_prestataire,
  sp.nom_commercial_societe,
  sp.id_societe_prestataire
FROM
  buzz_actualites AS a,
  societes_prestataire AS s,
  services_prestataire AS sp,
  buzz_operations AS o,
  buzz_roles AS r,
  utilisateurs AS u
WHERE
  a.type_actualite = 'reference'
  AND a.mode_actualite = 'publique'
  AND a.id_operation IS NOT NULL
  AND a.apparition_classement = 'oui'
  AND a.classement_prestation = 'oui'
  AND r.id_membre IS NULL
  AND o.id_operation = a.id_operation
  AND o.type_operation = 'fusion_acquisition'
  AND (
    o.date_operation BETWEEN '20250101'
    AND '20251231'
  )
  AND (
    a.date_mise_en_ligne BETWEEN '20250101000000'
    AND '20260205235959'
  )
  AND o.id_operation = r.id_operation
  AND r.id_type_role = 8
  AND r.id_acteur = sp.id_service_prestataire
  AND sp.id_societe_prestataire = s.id_societe_prestataire
  AND a.id_societe_prestataire = s.id_societe_prestataire
  AND u.login_utilisateur = s.login_utilisateur
ORDER BY
  sp.id_societe_prestataire,
  sp.id_service_prestataire

SELECT
                DISTINCT(a.id_operation),
                s.raison_sociale,
                s.segments_classements_concernes,
                o.montant_operation,
                o.maj_min_capital,
                o.fourchette_ca,
                o.ca_societe_achetee,
                o.pct_capital_achete,
                u.factur_nom_societe,
                sp.titre_service,
                sp.url_site_web,
                sp.url_site_web_visible,
                sp.utiliser_artviper,
                sp.src_image_si_artviper_desactive,
                sp.id_service_prestataire,
                sp.nom_commercial_societe,
                sp.id_societe_prestataire
                FROM
                buzz_actualites AS a,
                societes_prestataire AS s,
                services_prestataire AS sp,
                buzz_operations AS o,
                buzz_roles AS r,
                utilisateurs AS u
                WHERE a.type_actualite='reference'
                AND a.mode_actualite='publique'
                AND a.id_operation IS NOT NULL
                AND a.apparition_classement = 'oui'
                AND a.classement_prestation = 'oui'
                AND r.id_membre IS NULL
                
                AND o.id_operation = a.id_operation
                AND o.type_operation = 'fusion_acquisition'
                 AND (o.date_operation BETWEEN '20250101' AND '20251231'  ) AND (a.date_mise_en_ligne BETWEEN '20250101000000' AND '20260205235959' ) 
                
                AND o.id_operation = r.id_operation
                AND r.id_type_role=8
                AND r.id_acteur = sp.id_service_prestataire
                AND sp.id_societe_prestataire = s.id_societe_prestataire
                AND a.id_societe_prestataire = s.id_societe_prestataire
                AND u.login_utilisateur = s.login_utilisateur
                ORDER BY sp.id_societe_prestataire,sp.id_service_prestataire;

SELECT
  DISTINCT(a.id_operation),
  s.raison_sociale,
  s.segments_classements_concernes,
  o.montant_operation,
  o.maj_min_capital,
  o.fourchette_ca,
  o.ca_societe_achetee,
  o.pct_capital_achete,
  u.factur_nom_societe,
  sp.titre_service,
  sp.url_site_web,
  sp.url_site_web_visible,
  sp.utiliser_artviper,
  sp.src_image_si_artviper_desactive,
  sp.id_service_prestataire,
  sp.nom_commercial_societe,
  sp.id_societe_prestataire
FROM
  buzz_actualites AS a,
  societes_prestataire AS s,
  services_prestataire AS sp,
  buzz_operations AS o,
  buzz_roles AS r,
  utilisateurs AS u
WHERE
  a.type_actualite = 'reference'
  AND a.mode_actualite = 'publique'
  AND a.id_operation IS NOT NULL
  AND a.apparition_classement = 'oui'
  AND a.classement_prestation = 'oui'
  AND r.id_membre IS NULL
  AND o.id_operation = a.id_operation
  AND o.type_operation = 'fusion_acquisition'
  AND (
    o.date_operation BETWEEN '20250101'
    AND '20251231'
  )
  AND (
    a.date_mise_en_ligne BETWEEN '20250101000000'
    AND '20260205235959'
  )
  AND o.id_operation = r.id_operation
  AND r.id_type_role = 11
  AND r.id_acteur = sp.id_service_prestataire
  AND sp.id_societe_prestataire = s.id_societe_prestataire
  AND a.id_societe_prestataire = s.id_societe_prestataire
  AND u.login_utilisateur = s.login_utilisateur
ORDER BY
  sp.id_societe_prestataire,
  sp.id_service_prestataire

SELECT
                DISTINCT(a.id_operation),
                s.raison_sociale,
                s.segments_classements_concernes,
                o.montant_operation,
                o.maj_min_capital,
                o.fourchette_ca,
                o.ca_societe_achetee,
                o.pct_capital_achete,
                u.factur_nom_societe,
                sp.titre_service,
                sp.url_site_web,
                sp.url_site_web_visible,
                sp.utiliser_artviper,
                sp.src_image_si_artviper_desactive,
                sp.id_service_prestataire,
                sp.nom_commercial_societe,
                sp.id_societe_prestataire
                FROM
                buzz_actualites AS a,
                societes_prestataire AS s,
                services_prestataire AS sp,
                buzz_operations AS o,
                buzz_roles AS r,
                utilisateurs AS u
                WHERE a.type_actualite='reference'
                AND a.mode_actualite='publique'
                AND a.id_operation IS NOT NULL
                AND a.apparition_classement = 'oui'
                AND a.classement_prestation = 'oui'
                AND r.id_membre IS NULL
                
                AND o.id_operation = a.id_operation
                AND o.type_operation = 'fusion_acquisition'
                 AND (o.date_operation BETWEEN '20250101' AND '20251231'  ) AND (a.date_mise_en_ligne BETWEEN '20250101000000' AND '20260205235959' ) 
                
                AND o.id_operation = r.id_operation
                AND r.id_type_role=11
                AND r.id_acteur = sp.id_service_prestataire
                AND sp.id_societe_prestataire = s.id_societe_prestataire
                AND a.id_societe_prestataire = s.id_societe_prestataire
                AND u.login_utilisateur = s.login_utilisateur
                ORDER BY sp.id_societe_prestataire,sp.id_service_prestataire;

SELECT
  DISTINCT(a.id_operation),
  s.raison_sociale,
  s.segments_classements_concernes,
  o.montant_operation,
  o.maj_min_capital,
  o.fourchette_ca,
  o.ca_societe_achetee,
  o.pct_capital_achete,
  u.factur_nom_societe,
  sp.titre_service,
  sp.url_site_web,
  sp.url_site_web_visible,
  sp.utiliser_artviper,
  sp.src_image_si_artviper_desactive,
  sp.id_service_prestataire,
  sp.nom_commercial_societe,
  sp.id_societe_prestataire
FROM
  buzz_actualites AS a,
  societes_prestataire AS s,
  services_prestataire AS sp,
  buzz_operations AS o,
  buzz_roles AS r,
  utilisateurs AS u
WHERE
  a.type_actualite = 'reference'
  AND a.mode_actualite = 'publique'
  AND a.id_operation IS NOT NULL
  AND a.apparition_classement = 'oui'
  AND a.classement_prestation = 'oui'
  AND r.id_membre IS NULL
  AND o.id_operation = a.id_operation
  AND o.type_operation = 'fusion_acquisition'
  AND (
    o.date_operation BETWEEN '20250101'
    AND '20251231'
  )
  AND (
    a.date_mise_en_ligne BETWEEN '20250101000000'
    AND '20260205235959'
  )
  AND o.id_operation = r.id_operation
  AND r.id_type_role = 17
  AND r.id_acteur = sp.id_service_prestataire
  AND sp.id_societe_prestataire = s.id_societe_prestataire
  AND a.id_societe_prestataire = s.id_societe_prestataire
  AND u.login_utilisateur = s.login_utilisateur
ORDER BY
  sp.id_societe_prestataire,
  sp.id_service_prestataire

SELECT
                DISTINCT(a.id_operation),
                s.raison_sociale,
                s.segments_classements_concernes,
                o.montant_operation,
                o.maj_min_capital,
                o.fourchette_ca,
                o.ca_societe_achetee,
                o.pct_capital_achete,
                u.factur_nom_societe,
                sp.titre_service,
                sp.url_site_web,
                sp.url_site_web_visible,
                sp.utiliser_artviper,
                sp.src_image_si_artviper_desactive,
                sp.id_service_prestataire,
                sp.nom_commercial_societe,
                sp.id_societe_prestataire
                FROM
                buzz_actualites AS a,
                societes_prestataire AS s,
                services_prestataire AS sp,
                buzz_operations AS o,
                buzz_roles AS r,
                utilisateurs AS u
                WHERE a.type_actualite='reference'
                AND a.mode_actualite='publique'
                AND a.id_operation IS NOT NULL
                AND a.apparition_classement = 'oui'
                AND a.classement_prestation = 'oui'
                AND r.id_membre IS NULL
                
                AND o.id_operation = a.id_operation
                AND o.type_operation = 'fusion_acquisition'
                 AND (o.date_operation BETWEEN '20250101' AND '20251231'  ) AND (a.date_mise_en_ligne BETWEEN '20250101000000' AND '20260205235959' ) 
                
                AND o.id_operation = r.id_operation
                AND r.id_type_role=17
                AND r.id_acteur = sp.id_service_prestataire
                AND sp.id_societe_prestataire = s.id_societe_prestataire
                AND a.id_societe_prestataire = s.id_societe_prestataire
                AND u.login_utilisateur = s.login_utilisateur
                ORDER BY sp.id_societe_prestataire,sp.id_service_prestataire;

SELECT
  DISTINCT(a.id_operation),
  a.id_reseau,
  a.titre_actualite,
  re.nom,
  re.id_service_prestataire AS id_service_prestataire_re,
  re.segments_classements_concernes,
  o.ca_societe_achetee,
  o.montant_operation,
  o.maj_min_capital,
  o.pct_capital_achete,
  o.fourchette_ca,
  utilisateurs.factur_nom_societe AS raison_sociale,
  re.site_internet AS url_site_web,
  re.utiliser_artviper AS utiliser_artviper_re,
  re.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_re,
  sp.titre_service,
  sp.utiliser_artviper,
  sp.src_image_si_artviper_desactive,
  sp.id_societe_prestataire,
  sp.id_service_prestataire,
  sp.nom_commercial_societe
FROM
  buzz_actualites AS a,
  societes_prestataire AS s,
  services_prestataire AS sp,
  buzz_operations AS o,
  buzz_roles AS r,
  reseaux AS re,
  utilisateurs
WHERE
  a.type_actualite = 'reference'
  AND a.mode_actualite = 'publique'
  AND a.id_operation IS NOT NULL
  AND a.apparition_classement = 'oui'
  AND a.classement_reseau = 'oui'
  AND s.login_utilisateur = utilisateurs.login_utilisateur
  AND o.id_operation = a.id_operation
  AND r.id_membre IS NULL
  AND o.type_operation = 'fusion_acquisition'
  AND (
    o.date_operation BETWEEN '20250101'
    AND '20251231'
  )
  AND (
    a.date_mise_en_ligne BETWEEN '20250101000000'
    AND '20260205235959'
  )
  AND o.id_operation = r.id_operation
  AND r.id_type_role = 14
  AND r.id_acteur = sp.id_service_prestataire
  AND sp.id_societe_prestataire = s.id_societe_prestataire
  AND a.id_societe_prestataire = s.id_societe_prestataire
  AND a.id_reseau = re.id_reseau
GROUP BY
  o.id_operation
ORDER BY
  a.id_reseau

SELECT
                    DISTINCT(a.id_operation),
                    a.id_reseau,
                    a.titre_actualite,
                    re.nom,
                    re.id_service_prestataire AS id_service_prestataire_re,
                    re.segments_classements_concernes,
                    o.ca_societe_achetee,
                    o.montant_operation,
                    o.maj_min_capital,
                    o.pct_capital_achete,
                    o.fourchette_ca,
                    utilisateurs.factur_nom_societe AS raison_sociale,
                    re.site_internet AS url_site_web,
                    re.utiliser_artviper AS utiliser_artviper_re,
                    re.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_re,
                    sp.titre_service,
                    sp.utiliser_artviper,
                    sp.src_image_si_artviper_desactive,
                    sp.id_societe_prestataire,
                    sp.id_service_prestataire,
                    sp.nom_commercial_societe
                FROM
                    buzz_actualites AS a,
                    societes_prestataire AS s,
                    services_prestataire AS sp,
                    buzz_operations AS o,
                    buzz_roles AS r,
                    reseaux AS re,
                    utilisateurs
                WHERE a.type_actualite='reference'
                AND a.mode_actualite='publique'
                AND a.id_operation IS NOT NULL
                AND a.apparition_classement = 'oui'
                AND a.classement_reseau = 'oui'
                AND s.login_utilisateur = utilisateurs.login_utilisateur
                AND o.id_operation = a.id_operation
                AND r.id_membre IS NULL
                AND o.type_operation = 'fusion_acquisition'
                 AND (o.date_operation BETWEEN '20250101' AND '20251231'  ) AND (a.date_mise_en_ligne BETWEEN '20250101000000' AND '20260205235959' ) 
                
                AND o.id_operation = r.id_operation
                AND r.id_type_role=14
                AND r.id_acteur = sp.id_service_prestataire
                AND sp.id_societe_prestataire = s.id_societe_prestataire
                AND a.id_societe_prestataire = s.id_societe_prestataire
                AND a.id_reseau=re.id_reseau
                GROUP BY o.id_operation
                ORDER BY a.id_reseau;

SELECT
  DISTINCT(a.id_operation),
  a.id_reseau,
  a.titre_actualite,
  re.nom,
  re.id_service_prestataire AS id_service_prestataire_re,
  re.segments_classements_concernes,
  o.ca_societe_achetee,
  o.montant_operation,
  o.maj_min_capital,
  o.pct_capital_achete,
  o.fourchette_ca,
  utilisateurs.factur_nom_societe AS raison_sociale,
  re.site_internet AS url_site_web,
  re.utiliser_artviper AS utiliser_artviper_re,
  re.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_re,
  sp.titre_service,
  sp.utiliser_artviper,
  sp.src_image_si_artviper_desactive,
  sp.id_societe_prestataire,
  sp.id_service_prestataire,
  sp.nom_commercial_societe
FROM
  buzz_actualites AS a,
  societes_prestataire AS s,
  services_prestataire AS sp,
  buzz_operations AS o,
  buzz_roles AS r,
  reseaux AS re,
  utilisateurs
WHERE
  a.type_actualite = 'reference'
  AND a.mode_actualite = 'publique'
  AND a.id_operation IS NOT NULL
  AND a.apparition_classement = 'oui'
  AND a.classement_reseau = 'oui'
  AND s.login_utilisateur = utilisateurs.login_utilisateur
  AND o.id_operation = a.id_operation
  AND r.id_membre IS NULL
  AND o.type_operation = 'fusion_acquisition'
  AND (
    o.date_operation BETWEEN '20250101'
    AND '20251231'
  )
  AND (
    a.date_mise_en_ligne BETWEEN '20250101000000'
    AND '20260205235959'
  )
  AND o.id_operation = r.id_operation
  AND r.id_type_role = 5
  AND r.id_acteur = sp.id_service_prestataire
  AND sp.id_societe_prestataire = s.id_societe_prestataire
  AND a.id_societe_prestataire = s.id_societe_prestataire
  AND a.id_reseau = re.id_reseau
GROUP BY
  o.id_operation
ORDER BY
  a.id_reseau

SELECT
                    DISTINCT(a.id_operation),
                    a.id_reseau,
                    a.titre_actualite,
                    re.nom,
                    re.id_service_prestataire AS id_service_prestataire_re,
                    re.segments_classements_concernes,
                    o.ca_societe_achetee,
                    o.montant_operation,
                    o.maj_min_capital,
                    o.pct_capital_achete,
                    o.fourchette_ca,
                    utilisateurs.factur_nom_societe AS raison_sociale,
                    re.site_internet AS url_site_web,
                    re.utiliser_artviper AS utiliser_artviper_re,
                    re.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_re,
                    sp.titre_service,
                    sp.utiliser_artviper,
                    sp.src_image_si_artviper_desactive,
                    sp.id_societe_prestataire,
                    sp.id_service_prestataire,
                    sp.nom_commercial_societe
                FROM
                    buzz_actualites AS a,
                    societes_prestataire AS s,
                    services_prestataire AS sp,
                    buzz_operations AS o,
                    buzz_roles AS r,
                    reseaux AS re,
                    utilisateurs
                WHERE a.type_actualite='reference'
                AND a.mode_actualite='publique'
                AND a.id_operation IS NOT NULL
                AND a.apparition_classement = 'oui'
                AND a.classement_reseau = 'oui'
                AND s.login_utilisateur = utilisateurs.login_utilisateur
                AND o.id_operation = a.id_operation
                AND r.id_membre IS NULL
                AND o.type_operation = 'fusion_acquisition'
                 AND (o.date_operation BETWEEN '20250101' AND '20251231'  ) AND (a.date_mise_en_ligne BETWEEN '20250101000000' AND '20260205235959' ) 
                
                AND o.id_operation = r.id_operation
                AND r.id_type_role=5
                AND r.id_acteur = sp.id_service_prestataire
                AND sp.id_societe_prestataire = s.id_societe_prestataire
                AND a.id_societe_prestataire = s.id_societe_prestataire
                AND a.id_reseau=re.id_reseau
                GROUP BY o.id_operation
                ORDER BY a.id_reseau;

SELECT
  DISTINCT(a.id_operation),
  a.id_reseau,
  a.titre_actualite,
  re.nom,
  re.id_service_prestataire AS id_service_prestataire_re,
  re.segments_classements_concernes,
  o.ca_societe_achetee,
  o.montant_operation,
  o.maj_min_capital,
  o.pct_capital_achete,
  o.fourchette_ca,
  utilisateurs.factur_nom_societe AS raison_sociale,
  re.site_internet AS url_site_web,
  re.utiliser_artviper AS utiliser_artviper_re,
  re.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_re,
  sp.titre_service,
  sp.utiliser_artviper,
  sp.src_image_si_artviper_desactive,
  sp.id_societe_prestataire,
  sp.id_service_prestataire,
  sp.nom_commercial_societe
FROM
  buzz_actualites AS a,
  societes_prestataire AS s,
  services_prestataire AS sp,
  buzz_operations AS o,
  buzz_roles AS r,
  reseaux AS re,
  utilisateurs
WHERE
  a.type_actualite = 'reference'
  AND a.mode_actualite = 'publique'
  AND a.id_operation IS NOT NULL
  AND a.apparition_classement = 'oui'
  AND a.classement_reseau = 'oui'
  AND s.login_utilisateur = utilisateurs.login_utilisateur
  AND o.id_operation = a.id_operation
  AND r.id_membre IS NULL
  AND o.type_operation = 'fusion_acquisition'
  AND (
    o.date_operation BETWEEN '20250101'
    AND '20251231'
  )
  AND (
    a.date_mise_en_ligne BETWEEN '20250101000000'
    AND '20260205235959'
  )
  AND o.id_operation = r.id_operation
  AND r.id_type_role = 8
  AND r.id_acteur = sp.id_service_prestataire
  AND sp.id_societe_prestataire = s.id_societe_prestataire
  AND a.id_societe_prestataire = s.id_societe_prestataire
  AND a.id_reseau = re.id_reseau
GROUP BY
  o.id_operation
ORDER BY
  a.id_reseau

SELECT
                    DISTINCT(a.id_operation),
                    a.id_reseau,
                    a.titre_actualite,
                    re.nom,
                    re.id_service_prestataire AS id_service_prestataire_re,
                    re.segments_classements_concernes,
                    o.ca_societe_achetee,
                    o.montant_operation,
                    o.maj_min_capital,
                    o.pct_capital_achete,
                    o.fourchette_ca,
                    utilisateurs.factur_nom_societe AS raison_sociale,
                    re.site_internet AS url_site_web,
                    re.utiliser_artviper AS utiliser_artviper_re,
                    re.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_re,
                    sp.titre_service,
                    sp.utiliser_artviper,
                    sp.src_image_si_artviper_desactive,
                    sp.id_societe_prestataire,
                    sp.id_service_prestataire,
                    sp.nom_commercial_societe
                FROM
                    buzz_actualites AS a,
                    societes_prestataire AS s,
                    services_prestataire AS sp,
                    buzz_operations AS o,
                    buzz_roles AS r,
                    reseaux AS re,
                    utilisateurs
                WHERE a.type_actualite='reference'
                AND a.mode_actualite='publique'
                AND a.id_operation IS NOT NULL
                AND a.apparition_classement = 'oui'
                AND a.classement_reseau = 'oui'
                AND s.login_utilisateur = utilisateurs.login_utilisateur
                AND o.id_operation = a.id_operation
                AND r.id_membre IS NULL
                AND o.type_operation = 'fusion_acquisition'
                 AND (o.date_operation BETWEEN '20250101' AND '20251231'  ) AND (a.date_mise_en_ligne BETWEEN '20250101000000' AND '20260205235959' ) 
                
                AND o.id_operation = r.id_operation
                AND r.id_type_role=8
                AND r.id_acteur = sp.id_service_prestataire
                AND sp.id_societe_prestataire = s.id_societe_prestataire
                AND a.id_societe_prestataire = s.id_societe_prestataire
                AND a.id_reseau=re.id_reseau
                GROUP BY o.id_operation
                ORDER BY a.id_reseau;

SELECT
  DISTINCT(a.id_operation),
  a.id_reseau,
  a.titre_actualite,
  re.nom,
  re.id_service_prestataire AS id_service_prestataire_re,
  re.segments_classements_concernes,
  o.ca_societe_achetee,
  o.montant_operation,
  o.maj_min_capital,
  o.pct_capital_achete,
  o.fourchette_ca,
  utilisateurs.factur_nom_societe AS raison_sociale,
  re.site_internet AS url_site_web,
  re.utiliser_artviper AS utiliser_artviper_re,
  re.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_re,
  sp.titre_service,
  sp.utiliser_artviper,
  sp.src_image_si_artviper_desactive,
  sp.id_societe_prestataire,
  sp.id_service_prestataire,
  sp.nom_commercial_societe
FROM
  buzz_actualites AS a,
  societes_prestataire AS s,
  services_prestataire AS sp,
  buzz_operations AS o,
  buzz_roles AS r,
  reseaux AS re,
  utilisateurs
WHERE
  a.type_actualite = 'reference'
  AND a.mode_actualite = 'publique'
  AND a.id_operation IS NOT NULL
  AND a.apparition_classement = 'oui'
  AND a.classement_reseau = 'oui'
  AND s.login_utilisateur = utilisateurs.login_utilisateur
  AND o.id_operation = a.id_operation
  AND r.id_membre IS NULL
  AND o.type_operation = 'fusion_acquisition'
  AND (
    o.date_operation BETWEEN '20250101'
    AND '20251231'
  )
  AND (
    a.date_mise_en_ligne BETWEEN '20250101000000'
    AND '20260205235959'
  )
  AND o.id_operation = r.id_operation
  AND r.id_type_role = 11
  AND r.id_acteur = sp.id_service_prestataire
  AND sp.id_societe_prestataire = s.id_societe_prestataire
  AND a.id_societe_prestataire = s.id_societe_prestataire
  AND a.id_reseau = re.id_reseau
GROUP BY
  o.id_operation
ORDER BY
  a.id_reseau

SELECT
                    DISTINCT(a.id_operation),
                    a.id_reseau,
                    a.titre_actualite,
                    re.nom,
                    re.id_service_prestataire AS id_service_prestataire_re,
                    re.segments_classements_concernes,
                    o.ca_societe_achetee,
                    o.montant_operation,
                    o.maj_min_capital,
                    o.pct_capital_achete,
                    o.fourchette_ca,
                    utilisateurs.factur_nom_societe AS raison_sociale,
                    re.site_internet AS url_site_web,
                    re.utiliser_artviper AS utiliser_artviper_re,
                    re.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_re,
                    sp.titre_service,
                    sp.utiliser_artviper,
                    sp.src_image_si_artviper_desactive,
                    sp.id_societe_prestataire,
                    sp.id_service_prestataire,
                    sp.nom_commercial_societe
                FROM
                    buzz_actualites AS a,
                    societes_prestataire AS s,
                    services_prestataire AS sp,
                    buzz_operations AS o,
                    buzz_roles AS r,
                    reseaux AS re,
                    utilisateurs
                WHERE a.type_actualite='reference'
                AND a.mode_actualite='publique'
                AND a.id_operation IS NOT NULL
                AND a.apparition_classement = 'oui'
                AND a.classement_reseau = 'oui'
                AND s.login_utilisateur = utilisateurs.login_utilisateur
                AND o.id_operation = a.id_operation
                AND r.id_membre IS NULL
                AND o.type_operation = 'fusion_acquisition'
                 AND (o.date_operation BETWEEN '20250101' AND '20251231'  ) AND (a.date_mise_en_ligne BETWEEN '20250101000000' AND '20260205235959' ) 
                
                AND o.id_operation = r.id_operation
                AND r.id_type_role=11
                AND r.id_acteur = sp.id_service_prestataire
                AND sp.id_societe_prestataire = s.id_societe_prestataire
                AND a.id_societe_prestataire = s.id_societe_prestataire
                AND a.id_reseau=re.id_reseau
                GROUP BY o.id_operation
                ORDER BY a.id_reseau;

SELECT
  DISTINCT(a.id_operation),
  a.id_reseau,
  a.titre_actualite,
  re.nom,
  re.id_service_prestataire AS id_service_prestataire_re,
  re.segments_classements_concernes,
  o.ca_societe_achetee,
  o.montant_operation,
  o.maj_min_capital,
  o.pct_capital_achete,
  o.fourchette_ca,
  utilisateurs.factur_nom_societe AS raison_sociale,
  re.site_internet AS url_site_web,
  re.utiliser_artviper AS utiliser_artviper_re,
  re.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_re,
  sp.titre_service,
  sp.utiliser_artviper,
  sp.src_image_si_artviper_desactive,
  sp.id_societe_prestataire,
  sp.id_service_prestataire,
  sp.nom_commercial_societe
FROM
  buzz_actualites AS a,
  societes_prestataire AS s,
  services_prestataire AS sp,
  buzz_operations AS o,
  buzz_roles AS r,
  reseaux AS re,
  utilisateurs
WHERE
  a.type_actualite = 'reference'
  AND a.mode_actualite = 'publique'
  AND a.id_operation IS NOT NULL
  AND a.apparition_classement = 'oui'
  AND a.classement_reseau = 'oui'
  AND s.login_utilisateur = utilisateurs.login_utilisateur
  AND o.id_operation = a.id_operation
  AND r.id_membre IS NULL
  AND o.type_operation = 'fusion_acquisition'
  AND (
    o.date_operation BETWEEN '20250101'
    AND '20251231'
  )
  AND (
    a.date_mise_en_ligne BETWEEN '20250101000000'
    AND '20260205235959'
  )
  AND o.id_operation = r.id_operation
  AND r.id_type_role = 17
  AND r.id_acteur = sp.id_service_prestataire
  AND sp.id_societe_prestataire = s.id_societe_prestataire
  AND a.id_societe_prestataire = s.id_societe_prestataire
  AND a.id_reseau = re.id_reseau
GROUP BY
  o.id_operation
ORDER BY
  a.id_reseau

SELECT
                    DISTINCT(a.id_operation),
                    a.id_reseau,
                    a.titre_actualite,
                    re.nom,
                    re.id_service_prestataire AS id_service_prestataire_re,
                    re.segments_classements_concernes,
                    o.ca_societe_achetee,
                    o.montant_operation,
                    o.maj_min_capital,
                    o.pct_capital_achete,
                    o.fourchette_ca,
                    utilisateurs.factur_nom_societe AS raison_sociale,
                    re.site_internet AS url_site_web,
                    re.utiliser_artviper AS utiliser_artviper_re,
                    re.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_re,
                    sp.titre_service,
                    sp.utiliser_artviper,
                    sp.src_image_si_artviper_desactive,
                    sp.id_societe_prestataire,
                    sp.id_service_prestataire,
                    sp.nom_commercial_societe
                FROM
                    buzz_actualites AS a,
                    societes_prestataire AS s,
                    services_prestataire AS sp,
                    buzz_operations AS o,
                    buzz_roles AS r,
                    reseaux AS re,
                    utilisateurs
                WHERE a.type_actualite='reference'
                AND a.mode_actualite='publique'
                AND a.id_operation IS NOT NULL
                AND a.apparition_classement = 'oui'
                AND a.classement_reseau = 'oui'
                AND s.login_utilisateur = utilisateurs.login_utilisateur
                AND o.id_operation = a.id_operation
                AND r.id_membre IS NULL
                AND o.type_operation = 'fusion_acquisition'
                 AND (o.date_operation BETWEEN '20250101' AND '20251231'  ) AND (a.date_mise_en_ligne BETWEEN '20250101000000' AND '20260205235959' ) 
                
                AND o.id_operation = r.id_operation
                AND r.id_type_role=17
                AND r.id_acteur = sp.id_service_prestataire
                AND sp.id_societe_prestataire = s.id_societe_prestataire
                AND a.id_societe_prestataire = s.id_societe_prestataire
                AND a.id_reseau=re.id_reseau
                GROUP BY o.id_operation
                ORDER BY a.id_reseau;