Symfony Profiler

SELECT
  v0_.nom_ville AS nom_ville_0
FROM
  fusacq_dbo.villes v0_
WHERE
  v0_.code_departement LIKE ?
ORDER BY
  v0_.population DESC
LIMIT
  3

SELECT v0_.nom_ville AS nom_ville_0 FROM fusacq_dbo.villes v0_ WHERE v0_.code_departement LIKE '33_17%' ORDER BY v0_.population DESC LIMIT 3;

SELECT
  COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0
FROM
  fusacq_dbo.annonces_vendeur a0_
WHERE
  a0_.date_parution_initiale IS NOT NULL
  AND a0_.mode_annonce = 'publique'
  AND a0_.tpe_pme = 'oui'
  AND (a0_.id_departement = ?)

SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND (a0_.id_departement = '33_17_59');

SELECT
  COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0
FROM
  fusacq_dbo.annonces_vendeur a0_
WHERE
  (
    a0_.date_parution_initiale IS NOT NULL
    OR a0_.date_parution_initiale_elite IS NOT NULL
  )
  AND (
    a0_.mode_annonce = 'publique'
    OR a0_.mode_annonce = 'publique_elite'
  )
  AND a0_.tpe_pme = 'oui'
  AND a0_.statuts LIKE '99%'
  AND (a0_.id_departement = ?)

SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE (a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL) AND (a0_.mode_annonce = 'publique' OR a0_.mode_annonce = 'publique_elite') AND a0_.tpe_pme = 'oui' AND a0_.statuts LIKE '99%' AND (a0_.id_departement = '33_17_59');

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
  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_maximale_investissement_participation' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';

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
  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_maximale_investissement_participation' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';

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_.code_postal LIKE ?)
  AND s0_.afficher_vendeur = 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_.code_postal LIKE '59%') AND s0_.afficher_vendeur = 1;

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

SELECT
  COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0
FROM
  fusacq_dbo.annonces_vendeur a0_
WHERE
  a0_.date_parution_initiale IS NOT NULL
  AND a0_.mode_annonce = 'publique'
  AND a0_.tpe_pme = 'oui'
  AND (a0_.id_departement = ?)

SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND (a0_.id_departement = '33_17_62');

SELECT
  COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0
FROM
  fusacq_dbo.annonces_vendeur a0_
WHERE
  (
    a0_.date_parution_initiale IS NOT NULL
    OR a0_.date_parution_initiale_elite IS NOT NULL
  )
  AND (
    a0_.mode_annonce = 'publique'
    OR a0_.mode_annonce = 'publique_elite'
  )
  AND a0_.tpe_pme = 'oui'
  AND a0_.statuts LIKE '99%'
  AND (a0_.id_departement = ?)

SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE (a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL) AND (a0_.mode_annonce = 'publique' OR a0_.mode_annonce = 'publique_elite') AND a0_.tpe_pme = 'oui' AND a0_.statuts LIKE '99%' AND (a0_.id_departement = '33_17_62');

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
  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_maximale_investissement_participation' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';

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
  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_maximale_investissement_participation' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';

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_.code_postal LIKE ?)
  AND s0_.afficher_vendeur = 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_.code_postal LIKE '62%') AND s0_.afficher_vendeur = 1;

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

SELECT
  COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0
FROM
  fusacq_dbo.annonces_vendeur a0_
WHERE
  a0_.date_parution_initiale IS NOT NULL
  AND a0_.mode_annonce = 'publique'
  AND a0_.tpe_pme = 'oui'
  AND (a0_.id_departement = ?)

SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND (a0_.id_departement = '33_17_99');

SELECT
  COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0
FROM
  fusacq_dbo.annonces_vendeur a0_
WHERE
  (
    a0_.date_parution_initiale IS NOT NULL
    OR a0_.date_parution_initiale_elite IS NOT NULL
  )
  AND (
    a0_.mode_annonce = 'publique'
    OR a0_.mode_annonce = 'publique_elite'
  )
  AND a0_.tpe_pme = 'oui'
  AND a0_.statuts LIKE '99%'
  AND (a0_.id_departement = ?)

SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE (a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL) AND (a0_.mode_annonce = 'publique' OR a0_.mode_annonce = 'publique_elite') AND a0_.tpe_pme = 'oui' AND a0_.statuts LIKE '99%' AND (a0_.id_departement = '33_17_99');

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
  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_maximale_investissement_participation' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';

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
  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_maximale_investissement_participation' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';

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_.code_postal LIKE ?)
  AND s0_.afficher_vendeur = 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_.code_postal LIKE '99%') AND s0_.afficher_vendeur = 1;

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

SELECT
  DISTINCT a0_.mode_annonce AS mode_annonce_0,
  a0_.id_annonce_vendeur AS id_annonce_vendeur_1,
  a0_.titre_annonce AS titre_annonce_2,
  a0_.date_parution_initiale AS date_parution_initiale_3,
  a0_.date_parution AS date_parution_4,
  a0_.date_parution_initiale_elite AS date_parution_initiale_elite_5,
  a0_.date_parution_elite AS date_parution_elite_6,
  a0_.date_fin_publique_elite AS date_fin_publique_elite_7,
  a0_.ca_n AS ca_n_8,
  a0_.id_pays AS id_pays_9,
  a0_.id_region AS id_region_10,
  a0_.zone_geographique AS zone_geographique_11,
  a0_.id_departement AS id_departement_12,
  a0_.statuts AS statuts_13,
  a0_.id_langue AS id_langue_14,
  a0_.id_secteur_activite AS id_secteur_activite_15
FROM
  fusacq_dbo.annonces_vendeur a0_
WHERE
  a0_.date_parution_initiale_elite IS NOT NULL
  AND a0_.mode_annonce = 'publique_elite'
  AND a0_.tpe_pme = 'oui'
  AND (a0_.id_region = ?)
ORDER BY
  a0_.ca_n DESC,
  a0_.id_annonce_vendeur DESC

SELECT DISTINCT a0_.mode_annonce AS mode_annonce_0, a0_.id_annonce_vendeur AS id_annonce_vendeur_1, a0_.titre_annonce AS titre_annonce_2, a0_.date_parution_initiale AS date_parution_initiale_3, a0_.date_parution AS date_parution_4, a0_.date_parution_initiale_elite AS date_parution_initiale_elite_5, a0_.date_parution_elite AS date_parution_elite_6, a0_.date_fin_publique_elite AS date_fin_publique_elite_7, a0_.ca_n AS ca_n_8, a0_.id_pays AS id_pays_9, a0_.id_region AS id_region_10, a0_.zone_geographique AS zone_geographique_11, a0_.id_departement AS id_departement_12, a0_.statuts AS statuts_13, a0_.id_langue AS id_langue_14, a0_.id_secteur_activite AS id_secteur_activite_15 FROM fusacq_dbo.annonces_vendeur a0_ WHERE a0_.date_parution_initiale_elite IS NOT NULL AND a0_.mode_annonce = 'publique_elite' AND a0_.tpe_pme = 'oui' AND (a0_.id_region = '33_17') ORDER BY a0_.ca_n DESC, a0_.id_annonce_vendeur DESC;

SELECT
  COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0
FROM
  fusacq_dbo.annonces_vendeur a0_
WHERE
  a0_.date_parution_initiale_elite IS NOT NULL
  AND a0_.mode_annonce = 'publique_elite'
  AND a0_.tpe_pme = 'oui'
  AND (a0_.id_region = ?)
ORDER BY
  a0_.ca_n DESC,
  a0_.id_annonce_vendeur DESC

SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE a0_.date_parution_initiale_elite IS NOT NULL AND a0_.mode_annonce = 'publique_elite' AND a0_.tpe_pme = 'oui' AND (a0_.id_region = '33_17') ORDER BY a0_.ca_n DESC, a0_.id_annonce_vendeur DESC;

SELECT
  COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0
FROM
  fusacq_dbo.annonces_vendeur a0_
WHERE
  a0_.date_parution_initiale IS NOT NULL
  AND a0_.mode_annonce = 'publique'
  AND a0_.tpe_pme = 'oui'
  AND (a0_.id_region = ?)

SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND (a0_.id_region = '33_17');

SELECT
  COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0
FROM
  fusacq_dbo.annonces_vendeur a0_
WHERE
  (
    a0_.date_parution_initiale IS NOT NULL
    OR a0_.date_parution_initiale_elite IS NOT NULL
  )
  AND (
    a0_.mode_annonce = 'publique'
    OR a0_.mode_annonce = 'publique_elite'
  )
  AND a0_.tpe_pme = 'oui'
  AND a0_.statuts LIKE '99%'
  AND (a0_.id_region = ?)

SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE (a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL) AND (a0_.mode_annonce = 'publique' OR a0_.mode_annonce = 'publique_elite') AND a0_.tpe_pme = 'oui' AND a0_.statuts LIKE '99%' AND (a0_.id_region = '33_17');

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
  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_maximale_investissement_participation' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';

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
  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_maximale_investissement_participation' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';

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_vendeur = 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_17') AND s0_.afficher_vendeur = 1;

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_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_region = '33_17' OR a0_.id_region = '33_99' OR a0_.autres_localisations LIKE '33_17%' OR a0_.autres_localisations LIKE '%,33_17%') 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_vendeur) AS sclr_0
FROM
  fusacq_dbo.annonces_vendeur a0_
WHERE
  (
    a0_.date_parution_initiale IS NOT NULL
    OR a0_.date_parution_initiale_elite IS NOT NULL
  )
  AND (
    a0_.mode_annonce = 'publique'
    OR a0_.mode_annonce = 'publique_elite'
  )
  AND a0_.tpe_pme = 'oui'
  AND a0_.id_period_annonce_prioritaire <> ''
  AND a0_.id_period_annonce_prioritaire IS NOT NULL
  AND a0_.etat_annonce_prioritaire = 'active'
  AND (a0_.id_region = ?)
ORDER BY
  a0_.date_debut_annonce_prioritaire ASC

SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE (a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL) AND (a0_.mode_annonce = 'publique' OR a0_.mode_annonce = 'publique_elite') AND a0_.tpe_pme = 'oui' AND a0_.id_period_annonce_prioritaire <> '' AND a0_.id_period_annonce_prioritaire IS NOT NULL AND a0_.etat_annonce_prioritaire = 'active' AND (a0_.id_region = '33_17') ORDER BY a0_.date_debut_annonce_prioritaire ASC;

SELECT
  DISTINCT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0
FROM
  fusacq_dbo.annonces_vendeur a0_
WHERE
  (
    a0_.date_parution_initiale IS NOT NULL
    OR a0_.date_parution_initiale_elite IS NOT NULL
  )
  AND (
    a0_.mode_annonce = 'publique'
    OR a0_.mode_annonce = 'publique_elite'
  )
  AND a0_.tpe_pme = 'oui'
  AND a0_.statuts NOT LIKE '99%'
  AND (a0_.id_region = ?)

SELECT DISTINCT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE (a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL) AND (a0_.mode_annonce = 'publique' OR a0_.mode_annonce = 'publique_elite') AND a0_.tpe_pme = 'oui' AND a0_.statuts NOT LIKE '99%' AND (a0_.id_region = '33_17');

SELECT
  DISTINCT a0_.id_annonce_vendeur AS id_annonce_vendeur_0,
  a0_.ca_n AS ca_n_1,
  a0_.id_annonce_vendeur AS id_annonce_vendeur_2
FROM
  fusacq_dbo.annonces_vendeur a0_
WHERE
  (
    a0_.date_parution_initiale IS NOT NULL
    OR a0_.date_parution_initiale_elite IS NOT NULL
  )
  AND (
    a0_.mode_annonce = 'publique'
    OR a0_.mode_annonce = 'publique_elite'
  )
  AND a0_.tpe_pme = 'oui'
  AND a0_.statuts NOT LIKE '99%'
  AND (a0_.id_region = ?)
ORDER BY
  a0_.ca_n DESC,
  a0_.id_annonce_vendeur DESC
LIMIT
  10 OFFSET 20

SELECT DISTINCT a0_.id_annonce_vendeur AS id_annonce_vendeur_0, a0_.ca_n AS ca_n_1, a0_.id_annonce_vendeur AS id_annonce_vendeur_2 FROM fusacq_dbo.annonces_vendeur a0_ WHERE (a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL) AND (a0_.mode_annonce = 'publique' OR a0_.mode_annonce = 'publique_elite') AND a0_.tpe_pme = 'oui' AND a0_.statuts NOT LIKE '99%' AND (a0_.id_region = '33_17') ORDER BY a0_.ca_n DESC, a0_.id_annonce_vendeur DESC LIMIT 10 OFFSET 20;

SELECT
  DISTINCT a0_.mode_annonce AS mode_annonce_0,
  a0_.id_annonce_vendeur AS id_annonce_vendeur_1,
  a0_.titre_annonce AS titre_annonce_2,
  a0_.date_parution_initiale AS date_parution_initiale_3,
  a0_.date_parution AS date_parution_4,
  a0_.date_parution_initiale_elite AS date_parution_initiale_elite_5,
  a0_.date_parution_elite AS date_parution_elite_6,
  a0_.date_fin_publique_elite AS date_fin_publique_elite_7,
  a0_.ca_n AS ca_n_8,
  a0_.id_pays AS id_pays_9,
  a0_.id_region AS id_region_10,
  a0_.zone_geographique AS zone_geographique_11,
  a0_.id_departement AS id_departement_12,
  a0_.statuts AS statuts_13,
  a0_.id_langue AS id_langue_14,
  a0_.id_secteur_activite AS id_secteur_activite_15
FROM
  fusacq_dbo.annonces_vendeur a0_
WHERE
  (
    a0_.date_parution_initiale IS NOT NULL
    OR a0_.date_parution_initiale_elite IS NOT NULL
  )
  AND (
    a0_.mode_annonce = 'publique'
    OR a0_.mode_annonce = 'publique_elite'
  )
  AND a0_.tpe_pme = 'oui'
  AND a0_.statuts NOT LIKE '99%'
  AND (a0_.id_region = ?)
  AND a0_.id_annonce_vendeur IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  a0_.ca_n DESC,
  a0_.id_annonce_vendeur DESC