Symfony Profiler

SELECT
  p0_.valeur_parametre AS valeur_parametre_0
FROM
  partage_dbo.parametres_divers p0_
WHERE
  p0_.id_type_parametre_divers = 1
  AND p0_.nom_parametre = 'list_nombres_acueil_fusacq'

SELECT p0_.valeur_parametre AS valeur_parametre_0 FROM partage_dbo.parametres_divers p0_ WHERE p0_.id_type_parametre_divers = 1 AND p0_.nom_parametre = 'list_nombres_acueil_fusacq';

SELECT
  s.id_repreneur AS idRepreneur,
  s.titre_profil AS titreProfil,
  s.date_parution_initiale AS dateParutionInitiale,
  s.ville,
  s.id_localisations_recherchees AS idLocalisationsRecherchees,
  s.titre_societe_recherchee AS titreSocieteRecherchee,
  COALESCE(d.devise, 'EUR') AS devise,
  d.montant_apport,
  s.montant_apport AS montantApport
FROM
  fusacq_dbo.annuaire_repreneurs s
  LEFT JOIN fusacq_dbo.annuaire_repreneurs_details d ON d.id_repreneur = s.id_repreneur
WHERE
  s.mode_profil = 'publique'
  AND s.id_pays = '01'
UNION
SELECT
  s.id_repreneur AS idRepreneur,
  s.titre_profil AS titreProfil,
  s.date_parution_initiale AS dateParutionInitiale,
  s.ville,
  s.id_localisations_recherchees AS idLocalisationsRecherchees,
  s.titre_societe_recherchee AS titreSocieteRecherchee,
  COALESCE(d.devise, 'EUR') AS devise,
  d.montant_apport,
  s.montant_apport AS montantApport
FROM
  fusacq_dbo.annuaire_repreneurs s
  LEFT JOIN fusacq_dbo.annuaire_repreneurs_details d ON d.id_repreneur = s.id_repreneur
WHERE
  s.mode_profil = 'publique'
  AND (
    s.id_localisations_recherchees LIKE '%,01,%'
    OR s.id_localisations_recherchees LIKE '%,01'
    OR s.id_localisations_recherchees LIKE '01,%'
  )
UNION
SELECT
  s.id_repreneur AS idRepreneur,
  s.titre_profil AS titreProfil,
  s.date_parution_initiale AS dateParutionInitiale,
  s.ville,
  s.id_localisations_recherchees AS idLocalisationsRecherchees,
  s.titre_societe_recherchee AS titreSocieteRecherchee,
  COALESCE(d.devise, 'EUR') AS devise,
  d.montant_apport,
  s.montant_apport AS montantApport
FROM
  fusacq_dbo.annuaire_repreneurs s
  LEFT JOIN fusacq_dbo.annuaire_repreneurs_details d ON d.id_repreneur = s.id_repreneur
WHERE
  s.mode_profil = 'publique'
  AND s.id_pays = '33'
LIMIT
  5

SELECT s.id_repreneur AS idRepreneur,s.titre_profil AS titreProfil  ,s.date_parution_initiale  AS dateParutionInitiale,s.ville,s.id_localisations_recherchees AS idLocalisationsRecherchees,s.titre_societe_recherchee AS titreSocieteRecherchee,COALESCE(d.devise, 'EUR') AS devise,d.montant_apport,s.montant_apport AS  montantApport
            FROM  fusacq_dbo.annuaire_repreneurs s
            LEFT JOIN fusacq_dbo.annuaire_repreneurs_details d ON  d.id_repreneur = s.id_repreneur
            WHERE  s.mode_profil='publique' AND  s.id_pays = '01' 
            UNION
            SELECT s.id_repreneur AS idRepreneur,s.titre_profil AS titreProfil  ,s.date_parution_initiale  AS dateParutionInitiale,s.ville,s.id_localisations_recherchees AS idLocalisationsRecherchees,s.titre_societe_recherchee AS titreSocieteRecherchee,COALESCE(d.devise, 'EUR') AS devise,d.montant_apport,s.montant_apport AS  montantApport
            FROM  fusacq_dbo.annuaire_repreneurs s
            LEFT JOIN fusacq_dbo.annuaire_repreneurs_details d ON  d.id_repreneur = s.id_repreneur
            WHERE  s.mode_profil='publique' AND  ( s.id_localisations_recherchees LIKE '%,01,%' OR s.id_localisations_recherchees LIKE '%,01' OR s.id_localisations_recherchees LIKE '01,%'  )
            UNION
            SELECT s.id_repreneur AS idRepreneur,s.titre_profil AS titreProfil  ,s.date_parution_initiale  AS dateParutionInitiale,s.ville,s.id_localisations_recherchees AS idLocalisationsRecherchees,s.titre_societe_recherchee AS titreSocieteRecherchee,COALESCE(d.devise, 'EUR') AS devise,d.montant_apport,s.montant_apport AS  montantApport
            FROM  fusacq_dbo.annuaire_repreneurs s
            LEFT JOIN fusacq_dbo.annuaire_repreneurs_details d ON  d.id_repreneur = s.id_repreneur
            WHERE  s.mode_profil='publique' AND  s.id_pays = '33'  
            LIMIT 5 
            ;

SELECT
  l0_.id_localisation AS id_localisation_0,
  l0_.nom_localisation AS nom_localisation_1,
  l0_.prefixe AS prefixe_2
FROM
  fusacq_dbo.localisations l0_
WHERE
  l0_.id_localisation_pere = ?
  AND l0_.id_localisation NOT LIKE ?

SELECT l0_.id_localisation AS id_localisation_0, l0_.nom_localisation AS nom_localisation_1, l0_.prefixe AS prefixe_2 FROM fusacq_dbo.localisations l0_ WHERE l0_.id_localisation_pere = '01' AND l0_.id_localisation NOT LIKE '%_99';

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

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

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

SELECT COUNT(DISTINCT a0_.id_repreneur) AS sclr_0 FROM fusacq_dbo.annuaire_repreneurs a0_ WHERE a0_.mode_profil = 'publique' AND (a0_.id_localisations_recherchees LIKE '%,01_02%' OR (a0_.id_localisations_recherchees LIKE '%,01,%' OR a0_.id_localisations_recherchees LIKE '%,01' OR a0_.id_localisations_recherchees IS NULL));

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

SELECT COUNT(DISTINCT a0_.id_repreneur) AS sclr_0 FROM fusacq_dbo.annuaire_repreneurs a0_ WHERE a0_.mode_profil = 'publique' AND (a0_.id_localisations_recherchees LIKE '%,01_03%' OR (a0_.id_localisations_recherchees LIKE '%,01,%' OR a0_.id_localisations_recherchees LIKE '%,01' OR a0_.id_localisations_recherchees IS NULL));

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

SELECT COUNT(DISTINCT a0_.id_repreneur) AS sclr_0 FROM fusacq_dbo.annuaire_repreneurs a0_ WHERE a0_.mode_profil = 'publique' AND (a0_.id_localisations_recherchees LIKE '%,01_04%' OR (a0_.id_localisations_recherchees LIKE '%,01,%' OR a0_.id_localisations_recherchees LIKE '%,01' OR a0_.id_localisations_recherchees IS NULL));

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

SELECT COUNT(DISTINCT a0_.id_repreneur) AS sclr_0 FROM fusacq_dbo.annuaire_repreneurs a0_ WHERE a0_.mode_profil = 'publique' AND (a0_.id_localisations_recherchees LIKE '%,01_05%' OR (a0_.id_localisations_recherchees LIKE '%,01,%' OR a0_.id_localisations_recherchees LIKE '%,01' OR a0_.id_localisations_recherchees IS NULL));

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

SELECT COUNT(DISTINCT a0_.id_repreneur) AS sclr_0 FROM fusacq_dbo.annuaire_repreneurs a0_ WHERE a0_.mode_profil = 'publique' AND (a0_.id_localisations_recherchees LIKE '%,01_06%' OR (a0_.id_localisations_recherchees LIKE '%,01,%' OR a0_.id_localisations_recherchees LIKE '%,01' OR a0_.id_localisations_recherchees IS NULL));

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

SELECT COUNT(DISTINCT a0_.id_repreneur) AS sclr_0 FROM fusacq_dbo.annuaire_repreneurs a0_ WHERE a0_.mode_profil = 'publique' AND (a0_.id_localisations_recherchees LIKE '%,01_07%' OR (a0_.id_localisations_recherchees LIKE '%,01,%' OR a0_.id_localisations_recherchees LIKE '%,01' OR a0_.id_localisations_recherchees IS NULL));

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

SELECT COUNT(DISTINCT a0_.id_repreneur) AS sclr_0 FROM fusacq_dbo.annuaire_repreneurs a0_ WHERE a0_.mode_profil = 'publique' AND (a0_.id_localisations_recherchees LIKE '%,01_08%' OR (a0_.id_localisations_recherchees LIKE '%,01,%' OR a0_.id_localisations_recherchees LIKE '%,01' OR a0_.id_localisations_recherchees IS NULL));

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

SELECT COUNT(DISTINCT a0_.id_repreneur) AS sclr_0 FROM fusacq_dbo.annuaire_repreneurs a0_ WHERE a0_.mode_profil = 'publique' AND (a0_.id_localisations_recherchees LIKE '%,01_09%' OR (a0_.id_localisations_recherchees LIKE '%,01,%' OR a0_.id_localisations_recherchees LIKE '%,01' OR a0_.id_localisations_recherchees IS NULL));

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

SELECT COUNT(DISTINCT a0_.id_repreneur) AS sclr_0 FROM fusacq_dbo.annuaire_repreneurs a0_ WHERE a0_.mode_profil = 'publique' AND (a0_.id_localisations_recherchees LIKE '%,01_10%' OR (a0_.id_localisations_recherchees LIKE '%,01,%' OR a0_.id_localisations_recherchees LIKE '%,01' OR a0_.id_localisations_recherchees IS NULL));

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

SELECT COUNT(DISTINCT a0_.id_repreneur) AS sclr_0 FROM fusacq_dbo.annuaire_repreneurs a0_ WHERE a0_.mode_profil = 'publique' AND (a0_.id_localisations_recherchees LIKE '%,01_11%' OR (a0_.id_localisations_recherchees LIKE '%,01,%' OR a0_.id_localisations_recherchees LIKE '%,01' OR a0_.id_localisations_recherchees IS NULL));

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

SELECT COUNT(DISTINCT a0_.id_repreneur) AS sclr_0 FROM fusacq_dbo.annuaire_repreneurs a0_ WHERE a0_.mode_profil = 'publique' AND (a0_.id_localisations_recherchees LIKE '%,01_12%' OR (a0_.id_localisations_recherchees LIKE '%,01,%' OR a0_.id_localisations_recherchees LIKE '%,01' OR a0_.id_localisations_recherchees IS NULL));

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

SELECT COUNT(DISTINCT a0_.id_repreneur) AS sclr_0 FROM fusacq_dbo.annuaire_repreneurs a0_ WHERE a0_.mode_profil = 'publique' AND (a0_.id_localisations_recherchees LIKE '%,01_13%' OR (a0_.id_localisations_recherchees LIKE '%,01,%' OR a0_.id_localisations_recherchees LIKE '%,01' OR a0_.id_localisations_recherchees IS NULL));

SELECT
  COUNT(DISTINCT i0_.id_investisseur) AS sclr_0
FROM
  fusacq_dbo.investisseurs_prives i0_
WHERE
  i0_.mode = 'publique'
  AND (
    i0_.id_localisations_recherchees LIKE ?
    OR i0_.id_localisations_recherchees IS NULL
  )
ORDER BY
  i0_.id_investisseur DESC

SELECT COUNT(DISTINCT i0_.id_investisseur) AS sclr_0 FROM fusacq_dbo.investisseurs_prives i0_ WHERE i0_.mode = 'publique' AND (i0_.id_localisations_recherchees LIKE '%,33%' OR i0_.id_localisations_recherchees IS NULL) ORDER BY i0_.id_investisseur DESC;

SELECT
  COUNT(DISTINCT a0_.id_repreneur) AS sclr_0
FROM
  fusacq_dbo.annuaire_repreneurs a0_
WHERE
  (a0_.mode_profil = 'publique')
  AND (
    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_localisations_recherchees LIKE '%,33%' OR a0_.id_localisations_recherchees 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_pays = ?
    OR a0_.autres_localisations LIKE ?
    OR a0_.autres_localisations LIKE ?
  )
  AND (
    a0_.demarche LIKE '%reprise_majoritaire%'
    OR a0_.demarche LIKE '%association_minoritaire%'
  )
  AND (
    a0_.investissement_possible = 'oui'
  )

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_pays = 33 OR a0_.autres_localisations LIKE '33%' OR a0_.autres_localisations LIKE '%,33%') AND (a0_.demarche LIKE '%reprise_majoritaire%' OR a0_.demarche LIKE '%association_minoritaire%') AND (a0_.investissement_possible = 'oui');

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

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_pays = 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_.type_raprochement = 'partenaire'
  AND (
    a0_.id_pays = ?
    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_pays = 33 OR a0_.autres_localisations LIKE '33%' OR a0_.autres_localisations LIKE '%,33%');

SELECT
  COUNT(DISTINCT i0_.id_investisseur) AS sclr_0
FROM
  fusacq_dbo.investisseurs_prives i0_
WHERE
  i0_.mode = 'publique'
  AND (
    i0_.id_localisations_recherchees LIKE ?
    OR i0_.id_localisations_recherchees IS NULL
  )
ORDER BY
  i0_.id_investisseur DESC

SELECT COUNT(DISTINCT i0_.id_investisseur) AS sclr_0 FROM fusacq_dbo.investisseurs_prives i0_ WHERE i0_.mode = 'publique' AND (i0_.id_localisations_recherchees LIKE '%,32%' OR i0_.id_localisations_recherchees IS NULL) ORDER BY i0_.id_investisseur DESC;

SELECT
  COUNT(DISTINCT a0_.id_repreneur) AS sclr_0
FROM
  fusacq_dbo.annuaire_repreneurs a0_
WHERE
  (a0_.mode_profil = 'publique')
  AND (
    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_localisations_recherchees LIKE '%,32%' OR a0_.id_localisations_recherchees LIKE '32%');

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_pays = ?
    OR a0_.autres_localisations LIKE ?
    OR a0_.autres_localisations LIKE ?
  )
  AND (
    a0_.demarche LIKE '%reprise_majoritaire%'
    OR a0_.demarche LIKE '%association_minoritaire%'
  )
  AND (
    a0_.investissement_possible = 'oui'
  )

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_pays = 32 OR a0_.autres_localisations LIKE '32%' OR a0_.autres_localisations LIKE '%,32%') AND (a0_.demarche LIKE '%reprise_majoritaire%' OR a0_.demarche LIKE '%association_minoritaire%') AND (a0_.investissement_possible = 'oui');

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

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_pays = 32);

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_pays = ?
    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_pays = 32 OR a0_.autres_localisations LIKE '32%' OR a0_.autres_localisations LIKE '%,32%');

SELECT
  COUNT(DISTINCT i0_.id_investisseur) AS sclr_0
FROM
  fusacq_dbo.investisseurs_prives i0_
WHERE
  i0_.mode = 'publique'
  AND (
    i0_.id_localisations_recherchees LIKE ?
    OR i0_.id_localisations_recherchees IS NULL
  )
ORDER BY
  i0_.id_investisseur DESC

SELECT COUNT(DISTINCT i0_.id_investisseur) AS sclr_0 FROM fusacq_dbo.investisseurs_prives i0_ WHERE i0_.mode = 'publique' AND (i0_.id_localisations_recherchees LIKE '%,01%' OR i0_.id_localisations_recherchees IS NULL) ORDER BY i0_.id_investisseur DESC;

SELECT
  COUNT(DISTINCT a0_.id_repreneur) AS sclr_0
FROM
  fusacq_dbo.annuaire_repreneurs a0_
WHERE
  (a0_.mode_profil = 'publique')
  AND (
    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_localisations_recherchees LIKE '%,01%' OR a0_.id_localisations_recherchees LIKE '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_.id_pays = ?
    OR a0_.autres_localisations LIKE ?
    OR a0_.autres_localisations LIKE ?
  )
  AND (
    a0_.demarche LIKE '%reprise_majoritaire%'
    OR a0_.demarche LIKE '%association_minoritaire%'
  )
  AND (
    a0_.investissement_possible = 'oui'
  )

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_pays = '01' OR a0_.autres_localisations LIKE '01%' OR a0_.autres_localisations LIKE '%,01%') AND (a0_.demarche LIKE '%reprise_majoritaire%' OR a0_.demarche LIKE '%association_minoritaire%') AND (a0_.investissement_possible = 'oui');

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

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_pays = '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_pays = ?
    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_pays = '01' OR a0_.autres_localisations LIKE '01%' OR a0_.autres_localisations LIKE '%,01%');

SELECT
  COUNT(DISTINCT i0_.id_investisseur) AS sclr_0
FROM
  fusacq_dbo.investisseurs_prives i0_
WHERE
  i0_.mode = 'publique'
  AND (
    i0_.id_localisations_recherchees LIKE ?
    OR i0_.id_localisations_recherchees IS NULL
  )
ORDER BY
  i0_.id_investisseur DESC

SELECT COUNT(DISTINCT i0_.id_investisseur) AS sclr_0 FROM fusacq_dbo.investisseurs_prives i0_ WHERE i0_.mode = 'publique' AND (i0_.id_localisations_recherchees LIKE '%,41%' OR i0_.id_localisations_recherchees IS NULL) ORDER BY i0_.id_investisseur DESC;

SELECT
  COUNT(DISTINCT a0_.id_repreneur) AS sclr_0
FROM
  fusacq_dbo.annuaire_repreneurs a0_
WHERE
  (a0_.mode_profil = 'publique')
  AND (
    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_localisations_recherchees LIKE '%,41%' OR a0_.id_localisations_recherchees LIKE '41%');

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_pays = ?
    OR a0_.autres_localisations LIKE ?
    OR a0_.autres_localisations LIKE ?
  )
  AND (
    a0_.demarche LIKE '%reprise_majoritaire%'
    OR a0_.demarche LIKE '%association_minoritaire%'
  )
  AND (
    a0_.investissement_possible = 'oui'
  )

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_pays = 41 OR a0_.autres_localisations LIKE '41%' OR a0_.autres_localisations LIKE '%,41%') AND (a0_.demarche LIKE '%reprise_majoritaire%' OR a0_.demarche LIKE '%association_minoritaire%') AND (a0_.investissement_possible = 'oui');

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

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_pays = 41);

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_pays = ?
    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_pays = 41 OR a0_.autres_localisations LIKE '41%' OR a0_.autres_localisations LIKE '%,41%');

SELECT
  COUNT(DISTINCT i0_.id_investisseur) AS sclr_0
FROM
  fusacq_dbo.investisseurs_prives i0_
WHERE
  i0_.mode = 'publique'
  AND (
    i0_.id_localisations_recherchees LIKE ?
    OR i0_.id_localisations_recherchees IS NULL
  )
ORDER BY
  i0_.id_investisseur DESC

SELECT COUNT(DISTINCT i0_.id_investisseur) AS sclr_0 FROM fusacq_dbo.investisseurs_prives i0_ WHERE i0_.mode = 'publique' AND (i0_.id_localisations_recherchees LIKE '%,99%' OR i0_.id_localisations_recherchees IS NULL) ORDER BY i0_.id_investisseur DESC;

SELECT
  COUNT(DISTINCT a0_.id_repreneur) AS sclr_0
FROM
  fusacq_dbo.annuaire_repreneurs a0_
WHERE
  (a0_.mode_profil = 'publique')
  AND (
    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_localisations_recherchees LIKE '%,99%' OR a0_.id_localisations_recherchees LIKE '99%');

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_pays NOT LIKE '33%'
    AND a0_.autres_localisations NOT LIKE '33_%'
  )
  AND (
    a0_.demarche LIKE '%reprise_majoritaire%'
    OR a0_.demarche LIKE '%association_minoritaire%'
  )
  AND (
    a0_.investissement_possible = 'oui'
  )

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_pays NOT LIKE '33%' AND a0_.autres_localisations NOT LIKE '33_%') AND (a0_.demarche LIKE '%reprise_majoritaire%' OR a0_.demarche LIKE '%association_minoritaire%') AND (a0_.investissement_possible = 'oui');

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

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_pays = 99);

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_pays NOT LIKE '33%'
    AND a0_.autres_localisations NOT 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_.type_raprochement = 'partenaire' AND (a0_.id_pays NOT LIKE '33%' AND a0_.autres_localisations NOT LIKE '33_%');