Symfony Profiler

SELECT
  COUNT(DISTINCT s0_.id_societe) AS sclr_0
FROM
  fusacq_dbo.societes s0_
  INNER JOIN fusacq_dbo.lien_participations_fonds l1_ ON (
    l1_.id_participation = s0_.id_societe
  )
WHERE
  (l1_.mode = 'publique')
  AND (
    s0_.mode_participation = 'publique'
  )
  AND (s0_.mode_societe = 'publique')
  AND (s0_.id_pays <> '00')
  AND s0_.ca_n < 300000
  AND l1_.date_investissement >= 201104
  AND l1_.date_investissement <= 202104
  AND (s0_.id_region = ?)
  AND s0_.afficher_acheteur = 1

SELECT COUNT(DISTINCT s0_.id_societe) AS sclr_0 FROM fusacq_dbo.societes s0_ INNER JOIN fusacq_dbo.lien_participations_fonds l1_ ON (l1_.id_participation = s0_.id_societe) WHERE (l1_.mode = 'publique') AND (s0_.mode_participation = 'publique') AND (s0_.mode_societe = 'publique') AND (s0_.id_pays <> '00') AND s0_.ca_n < 300000 AND l1_.date_investissement >= 201104 AND l1_.date_investissement <= 202104 AND (s0_.id_region = '33_01') AND s0_.afficher_acheteur = 1;

SELECT
  d0_.value AS value_0
FROM
  partage_dbo.data_parametre_site d0_
  LEFT JOIN partage_dbo.parametre_site p1_ ON (
    p1_.id_parametre_site = d0_.id_parametre_site
  )
WHERE
  p1_.nom = ?
  AND p1_.valide = ?
  AND d0_.code_pays = ?
  AND d0_.plateforme = ?

SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = 'anciennete_minimale_investissement_participation' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';

SELECT
  COUNT(DISTINCT a0_.id_repreneur) AS sclr_0
FROM
  fusacq_dbo.annuaire_repreneurs a0_
WHERE
  (a0_.mode_profil = 'publique')
  AND (
    a0_.id_secteur_activite_recherche LIKE ?
    OR a0_.id_secteur_activite_recherche LIKE ?
    OR a0_.id_secteur_activite_recherche LIKE ?
  )
  AND (
    a0_.id_secteur_activite_recherche LIKE ?
    OR a0_.id_secteur_activite_recherche LIKE ?
    OR a0_.id_secteur_activite_recherche LIKE ?
  )
  AND (
    a0_.id_localisations_recherchees LIKE ?
    OR a0_.id_localisations_recherchees LIKE ?
    OR a0_.id_localisations_recherchees LIKE ?
    OR a0_.id_localisations_recherchees LIKE ?
    OR a0_.id_localisations_recherchees LIKE ?
    OR a0_.id_localisations_recherchees LIKE ?
  )

SELECT COUNT(DISTINCT a0_.id_repreneur) AS sclr_0 FROM fusacq_dbo.annuaire_repreneurs a0_ WHERE (a0_.mode_profil = 'publique') AND (a0_.id_secteur_activite_recherche LIKE '%,30106,%' OR a0_.id_secteur_activite_recherche LIKE '30106,%' OR a0_.id_secteur_activite_recherche LIKE '%,30106') AND (a0_.id_secteur_activite_recherche LIKE '%,30106,%' OR a0_.id_secteur_activite_recherche LIKE '30106,%' OR a0_.id_secteur_activite_recherche LIKE '%,30106') AND (a0_.id_localisations_recherchees LIKE '33,%' OR a0_.id_localisations_recherchees LIKE '33' OR a0_.id_localisations_recherchees LIKE '%,33,%' OR a0_.id_localisations_recherchees LIKE '%,33' OR a0_.id_localisations_recherchees LIKE '%,33_01%' OR a0_.id_localisations_recherchees LIKE '33_01%');

SELECT
  COUNT(
    DISTINCT s0_.id_gestionnaire_fonds
  ) AS sclr_0
FROM
  fusacq_dbo.societe_gestionnaire_fonds s0_
  INNER JOIN fusacq_dbo.lien_participations_fonds l1_ ON (
    l1_.id_gestionnaire_fonds = s0_.id_gestionnaire_fonds
  )
  INNER JOIN fusacq_dbo.societes s2_ ON (
    s2_.id_societe = l1_.id_participation
  )
WHERE
  s2_.mode_participation = 'publique'
  AND l1_.mode = 'publique'
  AND s0_.mode = 'publique'
  AND s2_.mode_societe = 'publique'
  AND s0_.stade_investissement LIKE '%4%'
  AND (s0_.id_region = ?)

SELECT COUNT(DISTINCT s0_.id_gestionnaire_fonds) AS sclr_0 FROM fusacq_dbo.societe_gestionnaire_fonds s0_ INNER JOIN fusacq_dbo.lien_participations_fonds l1_ ON (l1_.id_gestionnaire_fonds = s0_.id_gestionnaire_fonds) INNER JOIN fusacq_dbo.societes s2_ ON (s2_.id_societe = l1_.id_participation) WHERE s2_.mode_participation = 'publique' AND l1_.mode = 'publique' AND s0_.mode = 'publique' AND s2_.mode_societe = 'publique' AND s0_.stade_investissement LIKE '%4%' AND (s0_.id_region = '33_01');

SELECT
  COUNT(
    DISTINCT a0_.id_annonce_acheteur
  ) AS sclr_0
FROM
  fusacq_dbo.annonces_acheteur a0_
WHERE
  a0_.date_parution_initiale IS NOT NULL
  AND a0_.mode_annonce = 'publique'
  AND a0_.tpe_pme = 'oui'
  AND a0_.type_raprochement = 'partenaire'
  AND a0_.id_secteur_activite = ?
  AND (
    (
      a0_.id_region = ?
      OR a0_.id_region = ?
      OR a0_.autres_localisations LIKE ?
      OR a0_.autres_localisations LIKE ?
    )
    OR (
      (
        a0_.id_region LIKE ''
        OR a0_.id_region IS NULL
      )
      AND (
        a0_.id_pays = ?
        OR a0_.autres_localisations LIKE ?
        OR a0_.autres_localisations LIKE ?
        OR a0_.autres_localisations LIKE ?
        OR a0_.autres_localisations LIKE ?
      )
    )
  )

SELECT COUNT(DISTINCT a0_.id_annonce_acheteur) AS sclr_0 FROM fusacq_dbo.annonces_acheteur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND a0_.type_raprochement = 'partenaire' AND a0_.id_secteur_activite = '30106' AND ((a0_.id_region = '33_01' OR a0_.id_region = '33_99' OR a0_.autres_localisations LIKE '33_01%' OR a0_.autres_localisations LIKE '%,33_01%') OR ((a0_.id_region LIKE '' OR a0_.id_region IS NULL) AND (a0_.id_pays = '33' OR a0_.autres_localisations LIKE '33' OR a0_.autres_localisations LIKE '33%' OR a0_.autres_localisations LIKE '%,33%' OR a0_.autres_localisations LIKE '%,33')));

SELECT
  COUNT(
    DISTINCT a0_.id_annonce_acheteur
  ) AS sclr_0
FROM
  fusacq_dbo.annonces_acheteur a0_
WHERE
  a0_.date_parution_initiale IS NOT NULL
  AND a0_.mode_annonce = 'publique'
  AND a0_.tpe_pme = 'oui'
  AND a0_.id_secteur_activite = ?
  AND (
    (
      a0_.id_region = ?
      OR a0_.id_region = ?
      OR a0_.autres_localisations LIKE ?
      OR a0_.autres_localisations LIKE ?
    )
    OR (
      (
        a0_.id_region LIKE ''
        OR a0_.id_region IS NULL
      )
      AND (
        a0_.id_pays = ?
        OR a0_.autres_localisations LIKE ?
        OR a0_.autres_localisations LIKE ?
        OR a0_.autres_localisations LIKE ?
        OR a0_.autres_localisations LIKE ?
      )
    )
  )

SELECT COUNT(DISTINCT a0_.id_annonce_acheteur) AS sclr_0 FROM fusacq_dbo.annonces_acheteur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND a0_.id_secteur_activite = '30106' AND ((a0_.id_region = '33_01' OR a0_.id_region = '33_99' OR a0_.autres_localisations LIKE '33_01%' OR a0_.autres_localisations LIKE '%,33_01%') OR ((a0_.id_region LIKE '' OR a0_.id_region IS NULL) AND (a0_.id_pays = '33' OR a0_.autres_localisations LIKE '33' OR a0_.autres_localisations LIKE '33%' OR a0_.autres_localisations LIKE '%,33%' OR a0_.autres_localisations LIKE '%,33')));

SELECT
  COUNT(DISTINCT s0_.id_societe) AS sclr_0
FROM
  fusacq_dbo.societes s0_
  INNER JOIN fusacq_dbo.buzz_roles b1_ ON (b1_.id_acteur = s0_.id_societe)
  INNER JOIN fusacq_dbo.buzz_operations b2_ ON (
    b2_.id_operation = b1_.id_operation
  )
  INNER JOIN fusacq_dbo.buzz_actualites b3_ ON (
    b2_.id_actualite_principale = b3_.id_actualite
  )
WHERE
  b1_.id_type_role = ?
  AND b3_.mode_actualite = ?
  AND (
    b1_.table_sql_acteur = ?
    OR b1_.table_sql_acteur_passif = ?
  )
  AND b2_.type_operation = 'fusion_acquisition'
  AND b3_.date_mise_en_ligne <= 20260421032535
  AND s0_.afficher_acheteur = 1
  AND b2_.date_operation <= ?
  AND (s0_.id_pays = ?)
GROUP BY
  s0_.id_societe

SELECT COUNT(DISTINCT s0_.id_societe) AS sclr_0 FROM fusacq_dbo.societes s0_ INNER JOIN fusacq_dbo.buzz_roles b1_ ON (b1_.id_acteur = s0_.id_societe) INNER JOIN fusacq_dbo.buzz_operations b2_ ON (b2_.id_operation = b1_.id_operation) INNER JOIN fusacq_dbo.buzz_actualites b3_ ON (b2_.id_actualite_principale = b3_.id_actualite) WHERE b1_.id_type_role = '1' AND b3_.mode_actualite = 'publique' AND (b1_.table_sql_acteur = 'societes_news' OR b1_.table_sql_acteur_passif = 'societes_news') AND b2_.type_operation = 'fusion_acquisition' AND b3_.date_mise_en_ligne <= 20260421032535 AND s0_.afficher_acheteur = 1 AND b2_.date_operation <= '20260421' AND (s0_.id_pays = 33) GROUP BY s0_.id_societe;

SELECT
  DISTINCT s0_.id_societe AS id_societe_0,
  b1_.date_mise_en_ligne AS date_mise_en_ligne_1,
  s0_.id_societe AS id_societe_2
FROM
  fusacq_dbo.societes s0_
  INNER JOIN fusacq_dbo.buzz_roles b2_ ON (b2_.id_acteur = s0_.id_societe)
  INNER JOIN fusacq_dbo.buzz_operations b3_ ON (
    b3_.id_operation = b2_.id_operation
  )
  INNER JOIN fusacq_dbo.buzz_actualites b1_ ON (
    b3_.id_actualite_principale = b1_.id_actualite
  )
WHERE
  b2_.id_type_role = ?
  AND b1_.mode_actualite = ?
  AND (
    b2_.table_sql_acteur = ?
    OR b2_.table_sql_acteur_passif = ?
  )
  AND b3_.type_operation = 'fusion_acquisition'
  AND b1_.date_mise_en_ligne <= 20260421032535
  AND s0_.afficher_acheteur = 1
  AND b3_.date_operation <= ?
  AND (s0_.id_pays = ?)
GROUP BY
  s0_.id_societe
ORDER BY
  b1_.date_mise_en_ligne DESC,
  s0_.id_societe DESC
LIMIT
  10 OFFSET 10

SELECT DISTINCT s0_.id_societe AS id_societe_0, b1_.date_mise_en_ligne AS date_mise_en_ligne_1, s0_.id_societe AS id_societe_2 FROM fusacq_dbo.societes s0_ INNER JOIN fusacq_dbo.buzz_roles b2_ ON (b2_.id_acteur = s0_.id_societe) INNER JOIN fusacq_dbo.buzz_operations b3_ ON (b3_.id_operation = b2_.id_operation) INNER JOIN fusacq_dbo.buzz_actualites b1_ ON (b3_.id_actualite_principale = b1_.id_actualite) WHERE b2_.id_type_role = '1' AND b1_.mode_actualite = 'publique' AND (b2_.table_sql_acteur = 'societes_news' OR b2_.table_sql_acteur_passif = 'societes_news') AND b3_.type_operation = 'fusion_acquisition' AND b1_.date_mise_en_ligne <= 20260421032535 AND s0_.afficher_acheteur = 1 AND b3_.date_operation <= '20260421' AND (s0_.id_pays = 33) GROUP BY s0_.id_societe ORDER BY b1_.date_mise_en_ligne DESC, s0_.id_societe DESC LIMIT 10 OFFSET 10;

SELECT
  COUNT(DISTINCT s0_.id_societe) AS sclr_0
FROM
  fusacq_dbo.societes s0_
  INNER JOIN fusacq_dbo.buzz_roles b1_ ON (b1_.id_acteur = s0_.id_societe)
  INNER JOIN fusacq_dbo.buzz_operations b2_ ON (
    b2_.id_operation = b1_.id_operation
  )
  INNER JOIN fusacq_dbo.buzz_actualites b3_ ON (
    b2_.id_actualite_principale = b3_.id_actualite
  )
WHERE
  b1_.id_type_role = ?
  AND b3_.mode_actualite = ?
  AND (
    b1_.table_sql_acteur = ?
    OR b1_.table_sql_acteur_passif = ?
  )
  AND b2_.type_operation = 'fusion_acquisition'
  AND b3_.date_mise_en_ligne <= 20260421032535
  AND s0_.afficher_acheteur = 1
  AND b2_.date_operation <= ?
  AND (s0_.id_pays = ?)

SELECT COUNT(DISTINCT s0_.id_societe) AS sclr_0 FROM fusacq_dbo.societes s0_ INNER JOIN fusacq_dbo.buzz_roles b1_ ON (b1_.id_acteur = s0_.id_societe) INNER JOIN fusacq_dbo.buzz_operations b2_ ON (b2_.id_operation = b1_.id_operation) INNER JOIN fusacq_dbo.buzz_actualites b3_ ON (b2_.id_actualite_principale = b3_.id_actualite) WHERE b1_.id_type_role = '1' AND b3_.mode_actualite = 'publique' AND (b1_.table_sql_acteur = 'societes_news' OR b1_.table_sql_acteur_passif = 'societes_news') AND b2_.type_operation = 'fusion_acquisition' AND b3_.date_mise_en_ligne <= 20260421032535 AND s0_.afficher_acheteur = 1 AND b2_.date_operation <= '20260421' AND (s0_.id_pays = 33);

SELECT
  COUNT(DISTINCT s0_.id_societe) AS sclr_0
FROM
  fusacq_dbo.societes s0_
  INNER JOIN fusacq_dbo.buzz_roles b1_ ON (b1_.id_acteur = s0_.id_societe)
  INNER JOIN fusacq_dbo.buzz_operations b2_ ON (
    b2_.id_operation = b1_.id_operation
  )
  INNER JOIN fusacq_dbo.buzz_actualites b3_ ON (
    b2_.id_actualite_principale = b3_.id_actualite
  )
WHERE
  b1_.id_type_role = ?
  AND b3_.mode_actualite = ?
  AND (
    b1_.table_sql_acteur = ?
    OR b1_.table_sql_acteur_passif = ?
  )
  AND b2_.type_operation = 'fusion_acquisition'
  AND b3_.date_mise_en_ligne <= 20260421032532
  AND s0_.afficher_acheteur = 1
  AND b2_.date_operation <= ?
  AND (
    s0_.id_region = ?
    OR (
      s0_.id_pays = ?
      AND s0_.code_postal LIKE '75%'
    )
    OR (
      s0_.id_pays = ?
      AND s0_.code_postal LIKE '77%'
    )
    OR (
      s0_.id_pays = ?
      AND s0_.code_postal LIKE '78%'
    )
    OR (
      s0_.id_pays = ?
      AND s0_.code_postal LIKE '91%'
    )
    OR (
      s0_.id_pays = ?
      AND s0_.code_postal LIKE '92%'
    )
    OR (
      s0_.id_pays = ?
      AND s0_.code_postal LIKE '93%'
    )
    OR (
      s0_.id_pays = ?
      AND s0_.code_postal LIKE '94%'
    )
    OR (
      s0_.id_pays = ?
      AND s0_.code_postal LIKE '95%'
    )
  )

SELECT COUNT(DISTINCT s0_.id_societe) AS sclr_0 FROM fusacq_dbo.societes s0_ INNER JOIN fusacq_dbo.buzz_roles b1_ ON (b1_.id_acteur = s0_.id_societe) INNER JOIN fusacq_dbo.buzz_operations b2_ ON (b2_.id_operation = b1_.id_operation) INNER JOIN fusacq_dbo.buzz_actualites b3_ ON (b2_.id_actualite_principale = b3_.id_actualite) WHERE b1_.id_type_role = '1' AND b3_.mode_actualite = 'publique' AND (b1_.table_sql_acteur = 'societes_news' OR b1_.table_sql_acteur_passif = 'societes_news') AND b2_.type_operation = 'fusion_acquisition' AND b3_.date_mise_en_ligne <= 20260421032532 AND s0_.afficher_acheteur = 1 AND b2_.date_operation <= '20260421' AND (s0_.id_region = '33_12' OR (s0_.id_pays = '33' AND s0_.code_postal LIKE '75%') OR (s0_.id_pays = '33' AND s0_.code_postal LIKE '77%') OR (s0_.id_pays = '33' AND s0_.code_postal LIKE '78%') OR (s0_.id_pays = '33' AND s0_.code_postal LIKE '91%') OR (s0_.id_pays = '33' AND s0_.code_postal LIKE '92%') OR (s0_.id_pays = '33' AND s0_.code_postal LIKE '93%') OR (s0_.id_pays = '33' AND s0_.code_postal LIKE '94%') OR (s0_.id_pays = '33' AND s0_.code_postal LIKE '95%'));

SELECT
  COUNT(DISTINCT s0_.id_societe) AS sclr_0
FROM
  fusacq_dbo.societes s0_
  INNER JOIN fusacq_dbo.buzz_roles b1_ ON (b1_.id_acteur = s0_.id_societe)
  INNER JOIN fusacq_dbo.buzz_operations b2_ ON (
    b2_.id_operation = b1_.id_operation
  )
  INNER JOIN fusacq_dbo.buzz_actualites b3_ ON (
    b2_.id_actualite_principale = b3_.id_actualite
  )
WHERE
  b1_.id_type_role = ?
  AND b3_.mode_actualite = ?
  AND (
    b1_.table_sql_acteur = ?
    OR b1_.table_sql_acteur_passif = ?
  )
  AND b2_.type_operation = 'fusion_acquisition'
  AND b3_.date_mise_en_ligne <= 20260421032534
  AND s0_.afficher_acheteur = 1
  AND b2_.date_operation <= ?
  AND (
    s0_.id_region = ?
    OR (
      s0_.id_pays = ?
      AND s0_.code_postal LIKE '01%'
    )
    OR (
      s0_.id_pays = ?
      AND s0_.code_postal LIKE '07%'
    )
    OR (
      s0_.id_pays = ?
      AND s0_.code_postal LIKE '26%'
    )
    OR (
      s0_.id_pays = ?
      AND s0_.code_postal LIKE '69%'
    )
    OR (
      s0_.id_pays = ?
      AND s0_.code_postal LIKE '38%'
    )
    OR (
      s0_.id_pays = ?
      AND s0_.code_postal LIKE '42%'
    )
    OR (
      s0_.id_pays = ?
      AND s0_.code_postal LIKE '73%'
    )
    OR (
      s0_.id_pays = ?
      AND s0_.code_postal LIKE '74%'
    )
  )

SELECT COUNT(DISTINCT s0_.id_societe) AS sclr_0 FROM fusacq_dbo.societes s0_ INNER JOIN fusacq_dbo.buzz_roles b1_ ON (b1_.id_acteur = s0_.id_societe) INNER JOIN fusacq_dbo.buzz_operations b2_ ON (b2_.id_operation = b1_.id_operation) INNER JOIN fusacq_dbo.buzz_actualites b3_ ON (b2_.id_actualite_principale = b3_.id_actualite) WHERE b1_.id_type_role = '1' AND b3_.mode_actualite = 'publique' AND (b1_.table_sql_acteur = 'societes_news' OR b1_.table_sql_acteur_passif = 'societes_news') AND b2_.type_operation = 'fusion_acquisition' AND b3_.date_mise_en_ligne <= 20260421032534 AND s0_.afficher_acheteur = 1 AND b2_.date_operation <= '20260421' AND (s0_.id_region = '33_22' OR (s0_.id_pays = '33' AND s0_.code_postal LIKE '01%') OR (s0_.id_pays = '33' AND s0_.code_postal LIKE '07%') OR (s0_.id_pays = '33' AND s0_.code_postal LIKE '26%') OR (s0_.id_pays = '33' AND s0_.code_postal LIKE '69%') OR (s0_.id_pays = '33' AND s0_.code_postal LIKE '38%') OR (s0_.id_pays = '33' AND s0_.code_postal LIKE '42%') OR (s0_.id_pays = '33' AND s0_.code_postal LIKE '73%') OR (s0_.id_pays = '33' AND s0_.code_postal LIKE '74%'));

SELECT
  COUNT(DISTINCT s0_.id_societe) AS sclr_0
FROM
  fusacq_dbo.societes s0_
  INNER JOIN fusacq_dbo.buzz_roles b1_ ON (b1_.id_acteur = s0_.id_societe)
  INNER JOIN fusacq_dbo.buzz_operations b2_ ON (
    b2_.id_operation = b1_.id_operation
  )
  INNER JOIN fusacq_dbo.buzz_actualites b3_ ON (
    b2_.id_actualite_principale = b3_.id_actualite
  )
WHERE
  b1_.id_type_role = ?
  AND b3_.mode_actualite = ?
  AND (
    b1_.table_sql_acteur = ?
    OR b1_.table_sql_acteur_passif = ?
  )
  AND b2_.type_operation = 'fusion_acquisition'
  AND b3_.date_mise_en_ligne <= 20260421032533
  AND s0_.afficher_acheteur = 1
  AND b2_.date_operation <= ?
  AND (
    s0_.id_region = ?
    OR (
      s0_.id_pays = ?
      AND s0_.code_postal LIKE '09%'
    )
    OR (
      s0_.id_pays = ?
      AND s0_.code_postal LIKE '12%'
    )
    OR (
      s0_.id_pays = ?
      AND s0_.code_postal LIKE '31%'
    )
    OR (
      s0_.id_pays = ?
      AND s0_.code_postal LIKE '32%'
    )
    OR (
      s0_.id_pays = ?
      AND s0_.code_postal LIKE '46%'
    )
    OR (
      s0_.id_pays = ?
      AND s0_.code_postal LIKE '65%'
    )
    OR (
      s0_.id_pays = ?
      AND s0_.code_postal LIKE '81%'
    )
    OR (
      s0_.id_pays = ?
      AND s0_.code_postal LIKE '82%'
    )
  )

SELECT COUNT(DISTINCT s0_.id_societe) AS sclr_0 FROM fusacq_dbo.societes s0_ INNER JOIN fusacq_dbo.buzz_roles b1_ ON (b1_.id_acteur = s0_.id_societe) INNER JOIN fusacq_dbo.buzz_operations b2_ ON (b2_.id_operation = b1_.id_operation) INNER JOIN fusacq_dbo.buzz_actualites b3_ ON (b2_.id_actualite_principale = b3_.id_actualite) WHERE b1_.id_type_role = '1' AND b3_.mode_actualite = 'publique' AND (b1_.table_sql_acteur = 'societes_news' OR b1_.table_sql_acteur_passif = 'societes_news') AND b2_.type_operation = 'fusion_acquisition' AND b3_.date_mise_en_ligne <= 20260421032533 AND s0_.afficher_acheteur = 1 AND b2_.date_operation <= '20260421' AND (s0_.id_region = '33_16' OR (s0_.id_pays = '33' AND s0_.code_postal LIKE '09%') OR (s0_.id_pays = '33' AND s0_.code_postal LIKE '12%') OR (s0_.id_pays = '33' AND s0_.code_postal LIKE '31%') OR (s0_.id_pays = '33' AND s0_.code_postal LIKE '32%') OR (s0_.id_pays = '33' AND s0_.code_postal LIKE '46%') OR (s0_.id_pays = '33' AND s0_.code_postal LIKE '65%') OR (s0_.id_pays = '33' AND s0_.code_postal LIKE '81%') OR (s0_.id_pays = '33' AND s0_.code_postal LIKE '82%'));

SELECT
  COUNT(DISTINCT s0_.id_societe) AS sclr_0
FROM
  fusacq_dbo.societes s0_
  INNER JOIN fusacq_dbo.buzz_roles b1_ ON (b1_.id_acteur = s0_.id_societe)
  INNER JOIN fusacq_dbo.buzz_operations b2_ ON (
    b2_.id_operation = b1_.id_operation
  )
  INNER JOIN fusacq_dbo.buzz_actualites b3_ ON (
    b2_.id_actualite_principale = b3_.id_actualite
  )
WHERE
  b1_.id_type_role = ?
  AND b3_.mode_actualite = ?
  AND (
    b1_.table_sql_acteur = ?
    OR b1_.table_sql_acteur_passif = ?
  )
  AND b2_.type_operation = 'fusion_acquisition'
  AND b3_.date_mise_en_ligne <= 20260421032534
  AND s0_.afficher_acheteur = 1
  AND b2_.date_operation <= ?
  AND (
    s0_.id_region = ?
    OR (
      s0_.id_pays = ?
      AND s0_.code_postal LIKE '04%'
    )
    OR (
      s0_.id_pays = ?
      AND s0_.code_postal LIKE '05%'
    )
    OR (
      s0_.id_pays = ?
      AND s0_.code_postal LIKE '06%'
    )
    OR (
      s0_.id_pays = ?
      AND s0_.code_postal LIKE '13%'
    )
    OR (
      s0_.id_pays = ?
      AND s0_.code_postal LIKE '83%'
    )
    OR (
      s0_.id_pays = ?
      AND s0_.code_postal LIKE '84%'
    )
  )

SELECT COUNT(DISTINCT s0_.id_societe) AS sclr_0 FROM fusacq_dbo.societes s0_ INNER JOIN fusacq_dbo.buzz_roles b1_ ON (b1_.id_acteur = s0_.id_societe) INNER JOIN fusacq_dbo.buzz_operations b2_ ON (b2_.id_operation = b1_.id_operation) INNER JOIN fusacq_dbo.buzz_actualites b3_ ON (b2_.id_actualite_principale = b3_.id_actualite) WHERE b1_.id_type_role = '1' AND b3_.mode_actualite = 'publique' AND (b1_.table_sql_acteur = 'societes_news' OR b1_.table_sql_acteur_passif = 'societes_news') AND b2_.type_operation = 'fusion_acquisition' AND b3_.date_mise_en_ligne <= 20260421032534 AND s0_.afficher_acheteur = 1 AND b2_.date_operation <= '20260421' AND (s0_.id_region = '33_21' OR (s0_.id_pays = '33' AND s0_.code_postal LIKE '04%') OR (s0_.id_pays = '33' AND s0_.code_postal LIKE '05%') OR (s0_.id_pays = '33' AND s0_.code_postal LIKE '06%') OR (s0_.id_pays = '33' AND s0_.code_postal LIKE '13%') OR (s0_.id_pays = '33' AND s0_.code_postal LIKE '83%') OR (s0_.id_pays = '33' AND s0_.code_postal LIKE '84%'));

SELECT
  COUNT(DISTINCT s0_.id_societe) AS sclr_0
FROM
  fusacq_dbo.societes s0_
  INNER JOIN fusacq_dbo.buzz_roles b1_ ON (b1_.id_acteur = s0_.id_societe)
  INNER JOIN fusacq_dbo.buzz_operations b2_ ON (
    b2_.id_operation = b1_.id_operation
  )
  INNER JOIN fusacq_dbo.buzz_actualites b3_ ON (
    b2_.id_actualite_principale = b3_.id_actualite
  )
WHERE
  b1_.id_type_role = ?
  AND b3_.mode_actualite = ?
  AND (
    b1_.table_sql_acteur = ?
    OR b1_.table_sql_acteur_passif = ?
  )
  AND b2_.type_operation = 'fusion_acquisition'
  AND b3_.date_mise_en_ligne <= 20260421032533
  AND s0_.afficher_acheteur = 1
  AND b2_.date_operation <= ?
  AND (
    s0_.id_region = ?
    OR (
      s0_.id_pays = ?
      AND s0_.code_postal LIKE '44%'
    )
    OR (
      s0_.id_pays = ?
      AND s0_.code_postal LIKE '49%'
    )
    OR (
      s0_.id_pays = ?
      AND s0_.code_postal LIKE '53%'
    )
    OR (
      s0_.id_pays = ?
      AND s0_.code_postal LIKE '72%'
    )
    OR (
      s0_.id_pays = ?
      AND s0_.code_postal LIKE '85%'
    )
  )

SELECT COUNT(DISTINCT s0_.id_societe) AS sclr_0 FROM fusacq_dbo.societes s0_ INNER JOIN fusacq_dbo.buzz_roles b1_ ON (b1_.id_acteur = s0_.id_societe) INNER JOIN fusacq_dbo.buzz_operations b2_ ON (b2_.id_operation = b1_.id_operation) INNER JOIN fusacq_dbo.buzz_actualites b3_ ON (b2_.id_actualite_principale = b3_.id_actualite) WHERE b1_.id_type_role = '1' AND b3_.mode_actualite = 'publique' AND (b1_.table_sql_acteur = 'societes_news' OR b1_.table_sql_acteur_passif = 'societes_news') AND b2_.type_operation = 'fusion_acquisition' AND b3_.date_mise_en_ligne <= 20260421032533 AND s0_.afficher_acheteur = 1 AND b2_.date_operation <= '20260421' AND (s0_.id_region = '33_18' OR (s0_.id_pays = '33' AND s0_.code_postal LIKE '44%') OR (s0_.id_pays = '33' AND s0_.code_postal LIKE '49%') OR (s0_.id_pays = '33' AND s0_.code_postal LIKE '53%') OR (s0_.id_pays = '33' AND s0_.code_postal LIKE '72%') OR (s0_.id_pays = '33' AND s0_.code_postal LIKE '85%'));

SELECT
  COUNT(DISTINCT s0_.id_societe) AS sclr_0
FROM
  fusacq_dbo.societes s0_
  INNER JOIN fusacq_dbo.buzz_roles b1_ ON (b1_.id_acteur = s0_.id_societe)
  INNER JOIN fusacq_dbo.buzz_operations b2_ ON (
    b2_.id_operation = b1_.id_operation
  )
  INNER JOIN fusacq_dbo.buzz_actualites b3_ ON (
    b2_.id_actualite_principale = b3_.id_actualite
  )
WHERE
  b1_.id_type_role = ?
  AND b3_.mode_actualite = ?
  AND (
    b1_.table_sql_acteur = ?
    OR b1_.table_sql_acteur_passif = ?
  )
  AND b2_.type_operation = 'fusion_acquisition'
  AND b3_.date_mise_en_ligne <= 20260421032529
  AND s0_.afficher_acheteur = 1
  AND b2_.date_operation <= ?
  AND (
    s0_.id_region = ?
    OR (
      s0_.id_pays = ?
      AND s0_.code_postal LIKE '24%'
    )
    OR (
      s0_.id_pays = ?
      AND s0_.code_postal LIKE '33%'
    )
    OR (
      s0_.id_pays = ?
      AND s0_.code_postal LIKE '40%'
    )
    OR (
      s0_.id_pays = ?
      AND s0_.code_postal LIKE '47%'
    )
    OR (
      s0_.id_pays = ?
      AND s0_.code_postal LIKE '64%'
    )
  )

SELECT COUNT(DISTINCT s0_.id_societe) AS sclr_0 FROM fusacq_dbo.societes s0_ INNER JOIN fusacq_dbo.buzz_roles b1_ ON (b1_.id_acteur = s0_.id_societe) INNER JOIN fusacq_dbo.buzz_operations b2_ ON (b2_.id_operation = b1_.id_operation) INNER JOIN fusacq_dbo.buzz_actualites b3_ ON (b2_.id_actualite_principale = b3_.id_actualite) WHERE b1_.id_type_role = '1' AND b3_.mode_actualite = 'publique' AND (b1_.table_sql_acteur = 'societes_news' OR b1_.table_sql_acteur_passif = 'societes_news') AND b2_.type_operation = 'fusion_acquisition' AND b3_.date_mise_en_ligne <= 20260421032529 AND s0_.afficher_acheteur = 1 AND b2_.date_operation <= '20260421' AND (s0_.id_region = '33_02' OR (s0_.id_pays = '33' AND s0_.code_postal LIKE '24%') OR (s0_.id_pays = '33' AND s0_.code_postal LIKE '33%') OR (s0_.id_pays = '33' AND s0_.code_postal LIKE '40%') OR (s0_.id_pays = '33' AND s0_.code_postal LIKE '47%') OR (s0_.id_pays = '33' AND s0_.code_postal LIKE '64%'));

SELECT
  COUNT(DISTINCT s0_.id_societe) AS sclr_0
FROM
  fusacq_dbo.societes s0_
  INNER JOIN fusacq_dbo.buzz_roles b1_ ON (b1_.id_acteur = s0_.id_societe)
  INNER JOIN fusacq_dbo.buzz_operations b2_ ON (
    b2_.id_operation = b1_.id_operation
  )
  INNER JOIN fusacq_dbo.buzz_actualites b3_ ON (
    b2_.id_actualite_principale = b3_.id_actualite
  )
WHERE
  b1_.id_type_role = ?
  AND b3_.mode_actualite = ?
  AND (
    b1_.table_sql_acteur = ?
    OR b1_.table_sql_acteur_passif = ?
  )
  AND b2_.type_operation = 'fusion_acquisition'
  AND b3_.date_mise_en_ligne <= 20260421032530
  AND s0_.afficher_acheteur = 1
  AND b2_.date_operation <= ?
  AND (
    s0_.id_region = ?
    OR (
      s0_.id_pays = ?
      AND s0_.code_postal LIKE '29%'
    )
    OR (
      s0_.id_pays = ?
      AND s0_.code_postal LIKE '22%'
    )
    OR (
      s0_.id_pays = ?
      AND s0_.code_postal LIKE '35%'
    )
    OR (
      s0_.id_pays = ?
      AND s0_.code_postal LIKE '56%'
    )
  )

SELECT COUNT(DISTINCT s0_.id_societe) AS sclr_0 FROM fusacq_dbo.societes s0_ INNER JOIN fusacq_dbo.buzz_roles b1_ ON (b1_.id_acteur = s0_.id_societe) INNER JOIN fusacq_dbo.buzz_operations b2_ ON (b2_.id_operation = b1_.id_operation) INNER JOIN fusacq_dbo.buzz_actualites b3_ ON (b2_.id_actualite_principale = b3_.id_actualite) WHERE b1_.id_type_role = '1' AND b3_.mode_actualite = 'publique' AND (b1_.table_sql_acteur = 'societes_news' OR b1_.table_sql_acteur_passif = 'societes_news') AND b2_.type_operation = 'fusion_acquisition' AND b3_.date_mise_en_ligne <= 20260421032530 AND s0_.afficher_acheteur = 1 AND b2_.date_operation <= '20260421' AND (s0_.id_region = '33_06' OR (s0_.id_pays = '33' AND s0_.code_postal LIKE '29%') OR (s0_.id_pays = '33' AND s0_.code_postal LIKE '22%') OR (s0_.id_pays = '33' AND s0_.code_postal LIKE '35%') OR (s0_.id_pays = '33' AND s0_.code_postal LIKE '56%'));

SELECT
  COUNT(DISTINCT s0_.id_societe) AS sclr_0
FROM
  fusacq_dbo.societes s0_
  INNER JOIN fusacq_dbo.buzz_roles b1_ ON (b1_.id_acteur = s0_.id_societe)
  INNER JOIN fusacq_dbo.buzz_operations b2_ ON (
    b2_.id_operation = b1_.id_operation
  )
  INNER JOIN fusacq_dbo.buzz_actualites b3_ ON (
    b2_.id_actualite_principale = b3_.id_actualite
  )
WHERE
  b1_.id_type_role = ?
  AND b3_.mode_actualite = ?
  AND (
    b1_.table_sql_acteur = ?
    OR b1_.table_sql_acteur_passif = ?
  )
  AND b2_.type_operation = 'fusion_acquisition'
  AND b3_.date_mise_en_ligne <= 20260421032530
  AND s0_.afficher_acheteur = 1
  AND b2_.date_operation <= ?
  AND (
    s0_.id_region = ?
    OR (
      s0_.id_pays = ?
      AND s0_.code_postal LIKE '18%'
    )
    OR (
      s0_.id_pays = ?
      AND s0_.code_postal LIKE '28%'
    )
    OR (
      s0_.id_pays = ?
      AND s0_.code_postal LIKE '36%'
    )
    OR (
      s0_.id_pays = ?
      AND s0_.code_postal LIKE '37%'
    )
    OR (
      s0_.id_pays = ?
      AND s0_.code_postal LIKE '41%'
    )
    OR (
      s0_.id_pays = ?
      AND s0_.code_postal LIKE '45%'
    )
  )

SELECT COUNT(DISTINCT s0_.id_societe) AS sclr_0 FROM fusacq_dbo.societes s0_ INNER JOIN fusacq_dbo.buzz_roles b1_ ON (b1_.id_acteur = s0_.id_societe) INNER JOIN fusacq_dbo.buzz_operations b2_ ON (b2_.id_operation = b1_.id_operation) INNER JOIN fusacq_dbo.buzz_actualites b3_ ON (b2_.id_actualite_principale = b3_.id_actualite) WHERE b1_.id_type_role = '1' AND b3_.mode_actualite = 'publique' AND (b1_.table_sql_acteur = 'societes_news' OR b1_.table_sql_acteur_passif = 'societes_news') AND b2_.type_operation = 'fusion_acquisition' AND b3_.date_mise_en_ligne <= 20260421032530 AND s0_.afficher_acheteur = 1 AND b2_.date_operation <= '20260421' AND (s0_.id_region = '33_07' OR (s0_.id_pays = '33' AND s0_.code_postal LIKE '18%') OR (s0_.id_pays = '33' AND s0_.code_postal LIKE '28%') OR (s0_.id_pays = '33' AND s0_.code_postal LIKE '36%') OR (s0_.id_pays = '33' AND s0_.code_postal LIKE '37%') OR (s0_.id_pays = '33' AND s0_.code_postal LIKE '41%') OR (s0_.id_pays = '33' AND s0_.code_postal LIKE '45%'));