Symfony Profiler

SELECT
  COUNT(d0_.id) AS sclr_0
FROM
  fusacq_dbo.detail_annonce_synthese_strategique d0_
  LEFT JOIN fusacq_dbo.annonces_vendeur a1_ ON (
    a1_.id_annonce_vendeur = d0_.id_annonce
  )
WHERE
  d0_.date_envoi_deposant IS NOT NULL
  AND a1_.mode_annonce IN (?, ?)

SELECT COUNT(d0_.id) AS sclr_0 FROM fusacq_dbo.detail_annonce_synthese_strategique d0_ LEFT JOIN fusacq_dbo.annonces_vendeur a1_ ON (a1_.id_annonce_vendeur = d0_.id_annonce) WHERE d0_.date_envoi_deposant IS NOT NULL AND a1_.mode_annonce IN ('publique', 'publique_elite');

SELECT
  COUNT(d0_.id) AS sclr_0
FROM
  fusacq_dbo.detail_annonce_capital_immateriel d0_
  LEFT JOIN fusacq_dbo.annonces_vendeur a1_ ON (
    d0_.id_annonce = a1_.id_annonce_vendeur
  )
WHERE
  a1_.mode_annonce = ?
  AND d0_.marque_propre IS NOT NULL
  AND d0_.marque_propre IN (?, ?, ?)

SELECT COUNT(d0_.id) AS sclr_0 FROM fusacq_dbo.detail_annonce_capital_immateriel d0_ LEFT JOIN fusacq_dbo.annonces_vendeur a1_ ON (d0_.id_annonce = a1_.id_annonce_vendeur) WHERE a1_.mode_annonce = 'publique' AND d0_.marque_propre IS NOT NULL AND d0_.marque_propre IN ('regionale', 'nationale', 'internationale');

SELECT
  COUNT(d0_.id) AS sclr_0
FROM
  fusacq_dbo.detail_annonce_capital_immateriel d0_
  LEFT JOIN fusacq_dbo.annonces_vendeur a1_ ON (
    d0_.id_annonce = a1_.id_annonce_vendeur
  )
WHERE
  a1_.mode_annonce = ?
  AND d0_.positionnement_niche IS NOT NULL
  AND d0_.positionnement_niche IN (?)

SELECT COUNT(d0_.id) AS sclr_0 FROM fusacq_dbo.detail_annonce_capital_immateriel d0_ LEFT JOIN fusacq_dbo.annonces_vendeur a1_ ON (d0_.id_annonce = a1_.id_annonce_vendeur) WHERE a1_.mode_annonce = 'publique' AND d0_.positionnement_niche IS NOT NULL AND d0_.positionnement_niche IN ('oui');

SELECT
  COUNT(d0_.id) AS sclr_0
FROM
  fusacq_dbo.detail_annonce_capital_immateriel d0_
  LEFT JOIN fusacq_dbo.annonces_vendeur a1_ ON (
    d0_.id_annonce = a1_.id_annonce_vendeur
  )
WHERE
  a1_.mode_annonce = ?
  AND d0_.technicite_produits_services IS NOT NULL
  AND d0_.technicite_produits_services IN (?)

SELECT COUNT(d0_.id) AS sclr_0 FROM fusacq_dbo.detail_annonce_capital_immateriel d0_ LEFT JOIN fusacq_dbo.annonces_vendeur a1_ ON (d0_.id_annonce = a1_.id_annonce_vendeur) WHERE a1_.mode_annonce = 'publique' AND d0_.technicite_produits_services IS NOT NULL AND d0_.technicite_produits_services IN ('forte');

SELECT
  COUNT(d0_.id) AS sclr_0
FROM
  fusacq_dbo.detail_annonce_capital_immateriel d0_
  LEFT JOIN fusacq_dbo.annonces_vendeur a1_ ON (
    d0_.id_annonce = a1_.id_annonce_vendeur
  )
WHERE
  a1_.mode_annonce = ?
  AND d0_.standardisation_offre IS NOT NULL
  AND d0_.standardisation_offre IN (?)

SELECT COUNT(d0_.id) AS sclr_0 FROM fusacq_dbo.detail_annonce_capital_immateriel d0_ LEFT JOIN fusacq_dbo.annonces_vendeur a1_ ON (d0_.id_annonce = a1_.id_annonce_vendeur) WHERE a1_.mode_annonce = 'publique' AND d0_.standardisation_offre IS NOT NULL AND d0_.standardisation_offre IN ('standardisee');

SELECT
  COUNT(d0_.id) AS sclr_0
FROM
  fusacq_dbo.detail_annonce_capital_immateriel d0_
  LEFT JOIN fusacq_dbo.annonces_vendeur a1_ ON (
    d0_.id_annonce = a1_.id_annonce_vendeur
  )
WHERE
  a1_.mode_annonce = ?
  AND d0_.sensibilite_prix IS NOT NULL
  AND d0_.sensibilite_prix IN (?)

SELECT COUNT(d0_.id) AS sclr_0 FROM fusacq_dbo.detail_annonce_capital_immateriel d0_ LEFT JOIN fusacq_dbo.annonces_vendeur a1_ ON (d0_.id_annonce = a1_.id_annonce_vendeur) WHERE a1_.mode_annonce = 'publique' AND d0_.sensibilite_prix IS NOT NULL AND d0_.sensibilite_prix IN ('tres_faible');

SELECT
  COUNT(d0_.id) AS sclr_0
FROM
  fusacq_dbo.detail_annonce_capital_immateriel d0_
  LEFT JOIN fusacq_dbo.annonces_vendeur a1_ ON (
    d0_.id_annonce = a1_.id_annonce_vendeur
  )
WHERE
  a1_.mode_annonce = ?
  AND d0_.nombre_concurrents IS NOT NULL
  AND d0_.nombre_concurrents IN (?, ?, ?)

SELECT COUNT(d0_.id) AS sclr_0 FROM fusacq_dbo.detail_annonce_capital_immateriel d0_ LEFT JOIN fusacq_dbo.annonces_vendeur a1_ ON (d0_.id_annonce = a1_.id_annonce_vendeur) WHERE a1_.mode_annonce = 'publique' AND d0_.nombre_concurrents IS NOT NULL AND d0_.nombre_concurrents IN ('5_10', 'inf_5', 'monopole');

SELECT
  COUNT(d0_.id) AS sclr_0
FROM
  fusacq_dbo.detail_annonce_capital_immateriel d0_
  LEFT JOIN fusacq_dbo.annonces_vendeur a1_ ON (
    d0_.id_annonce = a1_.id_annonce_vendeur
  )
WHERE
  a1_.mode_annonce = ?
  AND d0_.position_sous_traitant IS NOT NULL
  AND d0_.position_sous_traitant IN (?)

SELECT COUNT(d0_.id) AS sclr_0 FROM fusacq_dbo.detail_annonce_capital_immateriel d0_ LEFT JOIN fusacq_dbo.annonces_vendeur a1_ ON (d0_.id_annonce = a1_.id_annonce_vendeur) WHERE a1_.mode_annonce = 'publique' AND d0_.position_sous_traitant IS NOT NULL AND d0_.position_sous_traitant IN ('non_concerne');

SELECT
  COUNT(d0_.id) AS sclr_0
FROM
  fusacq_dbo.detail_annonce_capital_immateriel d0_
  LEFT JOIN fusacq_dbo.annonces_vendeur a1_ ON (
    d0_.id_annonce = a1_.id_annonce_vendeur
  )
WHERE
  a1_.mode_annonce = ?
  AND d0_.resilience_crises IS NOT NULL
  AND d0_.resilience_crises IN (?)

SELECT COUNT(d0_.id) AS sclr_0 FROM fusacq_dbo.detail_annonce_capital_immateriel d0_ LEFT JOIN fusacq_dbo.annonces_vendeur a1_ ON (d0_.id_annonce = a1_.id_annonce_vendeur) WHERE a1_.mode_annonce = 'publique' AND d0_.resilience_crises IS NOT NULL AND d0_.resilience_crises IN ('solide');

SELECT
  COUNT(d0_.id) AS sclr_0
FROM
  fusacq_dbo.detail_annonce_capital_immateriel d0_
  LEFT JOIN fusacq_dbo.annonces_vendeur a1_ ON (
    d0_.id_annonce = a1_.id_annonce_vendeur
  )
WHERE
  a1_.mode_annonce = ?
  AND d0_.tendance_marche IS NOT NULL
  AND d0_.tendance_marche IN (?, ?)

SELECT COUNT(d0_.id) AS sclr_0 FROM fusacq_dbo.detail_annonce_capital_immateriel d0_ LEFT JOIN fusacq_dbo.annonces_vendeur a1_ ON (d0_.id_annonce = a1_.id_annonce_vendeur) WHERE a1_.mode_annonce = 'publique' AND d0_.tendance_marche IS NOT NULL AND d0_.tendance_marche IN ('croissance_moderee', 'marche_dynamique');

SELECT
  COUNT(d0_.id) AS sclr_0
FROM
  fusacq_dbo.detail_annonce_capital_immateriel d0_
  LEFT JOIN fusacq_dbo.annonces_vendeur a1_ ON (
    d0_.id_annonce = a1_.id_annonce_vendeur
  )
WHERE
  a1_.mode_annonce = ?
  AND d0_.variation_ca_3_ans IS NOT NULL
  AND d0_.variation_ca_3_ans IN (?, ?)

SELECT COUNT(d0_.id) AS sclr_0 FROM fusacq_dbo.detail_annonce_capital_immateriel d0_ LEFT JOIN fusacq_dbo.annonces_vendeur a1_ ON (d0_.id_annonce = a1_.id_annonce_vendeur) WHERE a1_.mode_annonce = 'publique' AND d0_.variation_ca_3_ans IS NOT NULL AND d0_.variation_ca_3_ans IN ('hausse_significative', 'forte_croissance');

SELECT
  COUNT(d0_.id) AS sclr_0
FROM
  fusacq_dbo.detail_annonce_capital_immateriel d0_
  LEFT JOIN fusacq_dbo.annonces_vendeur a1_ ON (
    d0_.id_annonce = a1_.id_annonce_vendeur
  )
WHERE
  a1_.mode_annonce = ?
  AND d0_.nb_clients_actifs IS NOT NULL
  AND d0_.nb_clients_actifs IN (?, ?)

SELECT COUNT(d0_.id) AS sclr_0 FROM fusacq_dbo.detail_annonce_capital_immateriel d0_ LEFT JOIN fusacq_dbo.annonces_vendeur a1_ ON (d0_.id_annonce = a1_.id_annonce_vendeur) WHERE a1_.mode_annonce = 'publique' AND d0_.nb_clients_actifs IS NOT NULL AND d0_.nb_clients_actifs IN ('entre_100_1000', 'plus_1000');

SELECT
  COUNT(d0_.id) AS sclr_0
FROM
  fusacq_dbo.detail_annonce_capital_immateriel d0_
  LEFT JOIN fusacq_dbo.annonces_vendeur a1_ ON (
    d0_.id_annonce = a1_.id_annonce_vendeur
  )
WHERE
  a1_.mode_annonce = ?
  AND d0_.frequence_achat IS NOT NULL
  AND d0_.frequence_achat IN (?, ?, ?)

SELECT COUNT(d0_.id) AS sclr_0 FROM fusacq_dbo.detail_annonce_capital_immateriel d0_ LEFT JOIN fusacq_dbo.annonces_vendeur a1_ ON (d0_.id_annonce = a1_.id_annonce_vendeur) WHERE a1_.mode_annonce = 'publique' AND d0_.frequence_achat IS NOT NULL AND d0_.frequence_achat IN ('annuelle', 'trimestrielle', 'mensuelle_plus');

SELECT
  COUNT(d0_.id) AS sclr_0
FROM
  fusacq_dbo.detail_annonce_capital_immateriel d0_
  LEFT JOIN fusacq_dbo.annonces_vendeur a1_ ON (
    d0_.id_annonce = a1_.id_annonce_vendeur
  )
WHERE
  a1_.mode_annonce = ?
  AND d0_.concentration_ca IS NOT NULL
  AND d0_.concentration_ca IN (?)

SELECT COUNT(d0_.id) AS sclr_0 FROM fusacq_dbo.detail_annonce_capital_immateriel d0_ LEFT JOIN fusacq_dbo.annonces_vendeur a1_ ON (d0_.id_annonce = a1_.id_annonce_vendeur) WHERE a1_.mode_annonce = 'publique' AND d0_.concentration_ca IS NOT NULL AND d0_.concentration_ca IN ('moins_10');

SELECT
  COUNT(d0_.id) AS sclr_0
FROM
  fusacq_dbo.detail_annonce_capital_immateriel d0_
  LEFT JOIN fusacq_dbo.annonces_vendeur a1_ ON (
    d0_.id_annonce = a1_.id_annonce_vendeur
  )
WHERE
  a1_.mode_annonce = ?
  AND d0_.fidelite_clientele IS NOT NULL
  AND d0_.fidelite_clientele IN (?)

SELECT COUNT(d0_.id) AS sclr_0 FROM fusacq_dbo.detail_annonce_capital_immateriel d0_ LEFT JOIN fusacq_dbo.annonces_vendeur a1_ ON (d0_.id_annonce = a1_.id_annonce_vendeur) WHERE a1_.mode_annonce = 'publique' AND d0_.fidelite_clientele IS NOT NULL AND d0_.fidelite_clientele IN ('forte');

SELECT
  COUNT(d0_.id) AS sclr_0
FROM
  fusacq_dbo.detail_annonce_capital_immateriel d0_
  LEFT JOIN fusacq_dbo.annonces_vendeur a1_ ON (
    d0_.id_annonce = a1_.id_annonce_vendeur
  )
WHERE
  a1_.mode_annonce = ?
  AND d0_.dependance_du_client IS NOT NULL
  AND d0_.dependance_du_client IN (?, ?)

SELECT COUNT(d0_.id) AS sclr_0 FROM fusacq_dbo.detail_annonce_capital_immateriel d0_ LEFT JOIN fusacq_dbo.annonces_vendeur a1_ ON (d0_.id_annonce = a1_.id_annonce_vendeur) WHERE a1_.mode_annonce = 'publique' AND d0_.dependance_du_client IS NOT NULL AND d0_.dependance_du_client IN ('forte', 'non_concerne');

SELECT
  COUNT(d0_.id) AS sclr_0
FROM
  fusacq_dbo.detail_annonce_capital_immateriel d0_
  LEFT JOIN fusacq_dbo.annonces_vendeur a1_ ON (
    d0_.id_annonce = a1_.id_annonce_vendeur
  )
WHERE
  a1_.mode_annonce = ?
  AND d0_.zone_chalandise IS NOT NULL
  AND d0_.zone_chalandise IN (?, ?)

SELECT COUNT(d0_.id) AS sclr_0 FROM fusacq_dbo.detail_annonce_capital_immateriel d0_ LEFT JOIN fusacq_dbo.annonces_vendeur a1_ ON (d0_.id_annonce = a1_.id_annonce_vendeur) WHERE a1_.mode_annonce = 'publique' AND d0_.zone_chalandise IS NOT NULL AND d0_.zone_chalandise IN ('nationale', 'internationale');

SELECT
  COUNT(d0_.id) AS sclr_0
FROM
  fusacq_dbo.detail_annonce_capital_immateriel d0_
  LEFT JOIN fusacq_dbo.annonces_vendeur a1_ ON (
    d0_.id_annonce = a1_.id_annonce_vendeur
  )
WHERE
  a1_.mode_annonce = ?
  AND d0_.organisation_commerciale IS NOT NULL
  AND d0_.organisation_commerciale IN (?, ?)

SELECT COUNT(d0_.id) AS sclr_0 FROM fusacq_dbo.detail_annonce_capital_immateriel d0_ LEFT JOIN fusacq_dbo.annonces_vendeur a1_ ON (d0_.id_annonce = a1_.id_annonce_vendeur) WHERE a1_.mode_annonce = 'publique' AND d0_.organisation_commerciale IS NOT NULL AND d0_.organisation_commerciale IN ('salaries', 'mixte');

SELECT
  COUNT(d0_.id) AS sclr_0
FROM
  fusacq_dbo.detail_annonce_capital_immateriel d0_
  LEFT JOIN fusacq_dbo.annonces_vendeur a1_ ON (
    d0_.id_annonce = a1_.id_annonce_vendeur
  )
WHERE
  a1_.mode_annonce = ?
  AND d0_.budget_communication IS NOT NULL
  AND d0_.budget_communication IN (?)

SELECT COUNT(d0_.id) AS sclr_0 FROM fusacq_dbo.detail_annonce_capital_immateriel d0_ LEFT JOIN fusacq_dbo.annonces_vendeur a1_ ON (d0_.id_annonce = a1_.id_annonce_vendeur) WHERE a1_.mode_annonce = 'publique' AND d0_.budget_communication IS NOT NULL AND d0_.budget_communication IN ('structure');

SELECT
  COUNT(d0_.id) AS sclr_0
FROM
  fusacq_dbo.detail_annonce_capital_immateriel d0_
  LEFT JOIN fusacq_dbo.annonces_vendeur a1_ ON (
    d0_.id_annonce = a1_.id_annonce_vendeur
  )
WHERE
  a1_.mode_annonce = ?
  AND d0_.appreciation_savoir_faire IS NOT NULL
  AND d0_.appreciation_savoir_faire IN (?)

SELECT COUNT(d0_.id) AS sclr_0 FROM fusacq_dbo.detail_annonce_capital_immateriel d0_ LEFT JOIN fusacq_dbo.annonces_vendeur a1_ ON (d0_.id_annonce = a1_.id_annonce_vendeur) WHERE a1_.mode_annonce = 'publique' AND d0_.appreciation_savoir_faire IS NOT NULL AND d0_.appreciation_savoir_faire IN ('unique');

SELECT
  COUNT(d0_.id) AS sclr_0
FROM
  fusacq_dbo.detail_annonce_capital_immateriel d0_
  LEFT JOIN fusacq_dbo.annonces_vendeur a1_ ON (
    d0_.id_annonce = a1_.id_annonce_vendeur
  )
WHERE
  a1_.mode_annonce = ?
  AND d0_.formalisation_savoir_faire IS NOT NULL
  AND d0_.formalisation_savoir_faire IN (?)

SELECT COUNT(d0_.id) AS sclr_0 FROM fusacq_dbo.detail_annonce_capital_immateriel d0_ LEFT JOIN fusacq_dbo.annonces_vendeur a1_ ON (d0_.id_annonce = a1_.id_annonce_vendeur) WHERE a1_.mode_annonce = 'publique' AND d0_.formalisation_savoir_faire IS NOT NULL AND d0_.formalisation_savoir_faire IN ('fortement_formalise');

SELECT
  COUNT(d0_.id) AS sclr_0
FROM
  fusacq_dbo.detail_annonce_capital_immateriel d0_
  LEFT JOIN fusacq_dbo.annonces_vendeur a1_ ON (
    d0_.id_annonce = a1_.id_annonce_vendeur
  )
WHERE
  a1_.mode_annonce = ?
  AND d0_.role_dirigeant IS NOT NULL
  AND d0_.role_dirigeant IN (?, ?)

SELECT COUNT(d0_.id) AS sclr_0 FROM fusacq_dbo.detail_annonce_capital_immateriel d0_ LEFT JOIN fusacq_dbo.annonces_vendeur a1_ ON (d0_.id_annonce = a1_.id_annonce_vendeur) WHERE a1_.mode_annonce = 'publique' AND d0_.role_dirigeant IS NOT NULL AND d0_.role_dirigeant IN ('delegation_efficace', 'second_au_quotidien');

SELECT
  COUNT(d0_.id) AS sclr_0
FROM
  fusacq_dbo.detail_annonce_capital_immateriel d0_
  LEFT JOIN fusacq_dbo.annonces_vendeur a1_ ON (
    d0_.id_annonce = a1_.id_annonce_vendeur
  )
WHERE
  a1_.mode_annonce = ?
  AND d0_.qualification_collaborateurs IS NOT NULL
  AND d0_.qualification_collaborateurs IN (?)

SELECT COUNT(d0_.id) AS sclr_0 FROM fusacq_dbo.detail_annonce_capital_immateriel d0_ LEFT JOIN fusacq_dbo.annonces_vendeur a1_ ON (d0_.id_annonce = a1_.id_annonce_vendeur) WHERE a1_.mode_annonce = 'publique' AND d0_.qualification_collaborateurs IS NOT NULL AND d0_.qualification_collaborateurs IN ('non_qualifie');

SELECT
  COUNT(d0_.id) AS sclr_0
FROM
  fusacq_dbo.detail_annonce_capital_immateriel d0_
  LEFT JOIN fusacq_dbo.annonces_vendeur a1_ ON (
    d0_.id_annonce = a1_.id_annonce_vendeur
  )
WHERE
  a1_.mode_annonce = ?
  AND d0_.difficulte_recrutement IS NOT NULL
  AND d0_.difficulte_recrutement IN (?)

SELECT COUNT(d0_.id) AS sclr_0 FROM fusacq_dbo.detail_annonce_capital_immateriel d0_ LEFT JOIN fusacq_dbo.annonces_vendeur a1_ ON (d0_.id_annonce = a1_.id_annonce_vendeur) WHERE a1_.mode_annonce = 'publique' AND d0_.difficulte_recrutement IS NOT NULL AND d0_.difficulte_recrutement IN ('facile');

SELECT
  COUNT(d0_.id) AS sclr_0
FROM
  fusacq_dbo.detail_annonce_capital_immateriel d0_
  LEFT JOIN fusacq_dbo.annonces_vendeur a1_ ON (
    d0_.id_annonce = a1_.id_annonce_vendeur
  )
WHERE
  a1_.mode_annonce = ?
  AND d0_.climat_social IS NOT NULL
  AND d0_.climat_social IN (?)

SELECT COUNT(d0_.id) AS sclr_0 FROM fusacq_dbo.detail_annonce_capital_immateriel d0_ LEFT JOIN fusacq_dbo.annonces_vendeur a1_ ON (d0_.id_annonce = a1_.id_annonce_vendeur) WHERE a1_.mode_annonce = 'publique' AND d0_.climat_social IS NOT NULL AND d0_.climat_social IN ('excellent');

SELECT
  COUNT(d0_.id) AS sclr_0
FROM
  fusacq_dbo.detail_annonce_capital_immateriel d0_
  LEFT JOIN fusacq_dbo.annonces_vendeur a1_ ON (
    d0_.id_annonce = a1_.id_annonce_vendeur
  )
WHERE
  a1_.mode_annonce = ?
  AND d0_.engagement_societal IS NOT NULL
  AND d0_.engagement_societal IN (?)

SELECT COUNT(d0_.id) AS sclr_0 FROM fusacq_dbo.detail_annonce_capital_immateriel d0_ LEFT JOIN fusacq_dbo.annonces_vendeur a1_ ON (d0_.id_annonce = a1_.id_annonce_vendeur) WHERE a1_.mode_annonce = 'publique' AND d0_.engagement_societal IS NOT NULL AND d0_.engagement_societal IN ('structuree');

SELECT
  COUNT(d0_.id) AS sclr_0
FROM
  fusacq_dbo.detail_annonce_capital_immateriel d0_
  LEFT JOIN fusacq_dbo.annonces_vendeur a1_ ON (
    d0_.id_annonce = a1_.id_annonce_vendeur
  )
WHERE
  a1_.mode_annonce = ?
  AND d0_.typologie_clientele IS NOT NULL
  AND d0_.typologie_clientele LIKE '%particuliers%'

SELECT COUNT(d0_.id) AS sclr_0 FROM fusacq_dbo.detail_annonce_capital_immateriel d0_ LEFT JOIN fusacq_dbo.annonces_vendeur a1_ ON (d0_.id_annonce = a1_.id_annonce_vendeur) WHERE a1_.mode_annonce = 'publique' AND d0_.typologie_clientele IS NOT NULL AND d0_.typologie_clientele LIKE '%particuliers%';

SELECT
  COUNT(d0_.id) AS sclr_0
FROM
  fusacq_dbo.detail_annonce_capital_immateriel d0_
  LEFT JOIN fusacq_dbo.annonces_vendeur a1_ ON (
    d0_.id_annonce = a1_.id_annonce_vendeur
  )
WHERE
  a1_.mode_annonce = ?
  AND d0_.typologie_clientele IS NOT NULL
  AND (
    d0_.typologie_clientele LIKE '%tpe_pme%'
    OR d0_.typologie_clientele LIKE '%eti%'
    OR d0_.typologie_clientele LIKE '%grands_comptes%'
    OR d0_.typologie_clientele LIKE '%collectivites%'
  )

SELECT COUNT(d0_.id) AS sclr_0 FROM fusacq_dbo.detail_annonce_capital_immateriel d0_ LEFT JOIN fusacq_dbo.annonces_vendeur a1_ ON (d0_.id_annonce = a1_.id_annonce_vendeur) WHERE a1_.mode_annonce = 'publique' AND d0_.typologie_clientele IS NOT NULL AND (d0_.typologie_clientele LIKE '%tpe_pme%' OR d0_.typologie_clientele LIKE '%eti%' OR d0_.typologie_clientele LIKE '%grands_comptes%' OR d0_.typologie_clientele LIKE '%collectivites%');

SELECT
  d0_.id AS id_0,
  d0_.id_annonce AS id_annonce_1,
  d0_.date_envoi_deposant AS date_envoi_deposant_2,
  d0_.date_generation AS date_generation_3,
  d0_.synthese_strategique AS synthese_strategique_4,
  d0_.positionnement_marche AS positionnement_marche_5,
  d0_.valeur_clientele AS valeur_clientele_6,
  d0_.potentiel_developpement AS potentiel_developpement_7,
  d0_.repreneur_ideal AS repreneur_ideal_8,
  d0_.note AS note_9,
  d0_.commentaire AS commentaire_10,
  d0_.date_debut_consult_gratuite AS date_debut_consult_gratuite_11,
  d0_.date_fin_consult_gratuite AS date_fin_consult_gratuite_12,
  a1_.titre_annonce AS titre_annonce_13
FROM
  fusacq_dbo.detail_annonce_synthese_strategique d0_
  LEFT JOIN fusacq_dbo.annonces_vendeur a1_ ON (
    a1_.id_annonce_vendeur = d0_.id_annonce
  )
WHERE
  d0_.date_envoi_deposant IS NOT NULL
  AND a1_.mode_annonce IN (?, ?)
  AND d0_.date_debut_consult_gratuite IS NOT NULL
  AND d0_.date_fin_consult_gratuite IS NOT NULL
ORDER BY
  d0_.date_fin_consult_gratuite DESC,
  a1_.date_parution DESC

SELECT d0_.id AS id_0, d0_.id_annonce AS id_annonce_1, d0_.date_envoi_deposant AS date_envoi_deposant_2, d0_.date_generation AS date_generation_3, d0_.synthese_strategique AS synthese_strategique_4, d0_.positionnement_marche AS positionnement_marche_5, d0_.valeur_clientele AS valeur_clientele_6, d0_.potentiel_developpement AS potentiel_developpement_7, d0_.repreneur_ideal AS repreneur_ideal_8, d0_.note AS note_9, d0_.commentaire AS commentaire_10, d0_.date_debut_consult_gratuite AS date_debut_consult_gratuite_11, d0_.date_fin_consult_gratuite AS date_fin_consult_gratuite_12, a1_.titre_annonce AS titre_annonce_13 FROM fusacq_dbo.detail_annonce_synthese_strategique d0_ LEFT JOIN fusacq_dbo.annonces_vendeur a1_ ON (a1_.id_annonce_vendeur = d0_.id_annonce) WHERE d0_.date_envoi_deposant IS NOT NULL AND a1_.mode_annonce IN ('publique', 'publique_elite') AND d0_.date_debut_consult_gratuite IS NOT NULL AND d0_.date_fin_consult_gratuite IS NOT NULL ORDER BY d0_.date_fin_consult_gratuite DESC, a1_.date_parution DESC;

SELECT
  a0_.id_annonce_vendeur AS id_annonce_vendeur_0,
  a0_.id_pays AS id_pays_1,
  a0_.id_region AS id_region_2,
  a0_.id_departement AS id_departement_3,
  a0_.titre_annonce AS titre_annonce_4,
  a0_.mode_annonce AS mode_annonce_5,
  a0_.EBE_n AS EBE_n_6,
  a0_.resultat_net_n AS resultat_net_n_7,
  a0_.resultat_exploitation_n AS resultat_exploitation_n_8,
  a0_.marge_brute_n AS marge_brute_n_9,
  a0_.ca_n AS ca_n_10
FROM
  fusacq_dbo.annonces_vendeur a0_
WHERE
  a0_.id_annonce_vendeur = '90123'

SELECT a0_.id_annonce_vendeur AS id_annonce_vendeur_0, a0_.id_pays AS id_pays_1, a0_.id_region AS id_region_2, a0_.id_departement AS id_departement_3, a0_.titre_annonce AS titre_annonce_4, a0_.mode_annonce AS mode_annonce_5, a0_.EBE_n AS EBE_n_6, a0_.resultat_net_n AS resultat_net_n_7, a0_.resultat_exploitation_n AS resultat_exploitation_n_8, a0_.marge_brute_n AS marge_brute_n_9, a0_.ca_n AS ca_n_10 FROM fusacq_dbo.annonces_vendeur a0_ WHERE a0_.id_annonce_vendeur = '90123';