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
  a0_.id_annonce_vendeur AS id_annonce_vendeur_0,
  a0_.titre_annonce AS titre_annonce_1,
  a0_.ca_n AS ca_n_2,
  a0_.date_parution_initiale AS date_parution_initiale_3,
  a0_.date_parution_initiale_elite AS date_parution_initiale_elite_4,
  a0_.id_pays AS id_pays_5,
  a0_.id_region AS id_region_6,
  a0_.id_departement AS id_departement_7,
  a0_.id_langue AS id_langue_8,
  a0_.date_fin_publique_elite AS date_fin_publique_elite_9
FROM
  fusacq_dbo.annonces_vendeur a0_
WHERE
  a0_.mode_annonce = 'publique'
  AND a0_.tpe_pme = 'oui'
  AND a0_.visible_dernieres_annonces IS NULL
  AND a0_.statuts NOT LIKE '99%'
ORDER BY
  a0_.date_parution_initiale_complete DESC
LIMIT
  5

SELECT a0_.id_annonce_vendeur AS id_annonce_vendeur_0, a0_.titre_annonce AS titre_annonce_1, a0_.ca_n AS ca_n_2, a0_.date_parution_initiale AS date_parution_initiale_3, a0_.date_parution_initiale_elite AS date_parution_initiale_elite_4, a0_.id_pays AS id_pays_5, a0_.id_region AS id_region_6, a0_.id_departement AS id_departement_7, a0_.id_langue AS id_langue_8, a0_.date_fin_publique_elite AS date_fin_publique_elite_9 FROM fusacq_dbo.annonces_vendeur a0_ WHERE a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND a0_.visible_dernieres_annonces IS NULL AND a0_.statuts NOT LIKE '99%' ORDER BY a0_.date_parution_initiale_complete DESC LIMIT 5;

SELECT
  t0_.id_translate_annonce_vendeur AS id_translate_annonce_vendeur_0,
  t0_.id_annonce_vendeur AS id_annonce_vendeur_1,
  t0_.description_activite AS description_activite_2,
  t0_.titre_annonce AS titre_annonce_3,
  t0_.commentaires AS commentaires_4,
  t0_.mots_cle_recherche AS mots_cle_recherche_5,
  t0_.mots_cles AS mots_cles_6,
  t0_.points_forts AS points_forts_7,
  t0_.points_faibles AS points_faibles_8,
  t0_.raison_cession AS raison_cession_9,
  t0_.concurrence AS concurrence_10,
  t0_.positionnement_marche AS positionnement_marche_11,
  t0_.elements_complementaires AS elements_complementaires_12,
  t0_.profil_repreneur_recherche AS profil_repreneur_recherche_13,
  t0_.code_langue AS code_langue_14
FROM
  fusacq_dbo.translate_annonce_vendeur t0_
WHERE
  t0_.id_annonce_vendeur = ?
  AND t0_.code_langue = ?

SELECT t0_.id_translate_annonce_vendeur AS id_translate_annonce_vendeur_0, t0_.id_annonce_vendeur AS id_annonce_vendeur_1, t0_.description_activite AS description_activite_2, t0_.titre_annonce AS titre_annonce_3, t0_.commentaires AS commentaires_4, t0_.mots_cle_recherche AS mots_cle_recherche_5, t0_.mots_cles AS mots_cles_6, t0_.points_forts AS points_forts_7, t0_.points_faibles AS points_faibles_8, t0_.raison_cession AS raison_cession_9, t0_.concurrence AS concurrence_10, t0_.positionnement_marche AS positionnement_marche_11, t0_.elements_complementaires AS elements_complementaires_12, t0_.profil_repreneur_recherche AS profil_repreneur_recherche_13, t0_.code_langue AS code_langue_14 FROM fusacq_dbo.translate_annonce_vendeur t0_ WHERE t0_.id_annonce_vendeur = 90105 AND t0_.code_langue = 'FR';

SELECT
  t0_.id_translate_annonce_vendeur AS id_translate_annonce_vendeur_0,
  t0_.id_annonce_vendeur AS id_annonce_vendeur_1,
  t0_.description_activite AS description_activite_2,
  t0_.titre_annonce AS titre_annonce_3,
  t0_.commentaires AS commentaires_4,
  t0_.mots_cle_recherche AS mots_cle_recherche_5,
  t0_.mots_cles AS mots_cles_6,
  t0_.points_forts AS points_forts_7,
  t0_.points_faibles AS points_faibles_8,
  t0_.raison_cession AS raison_cession_9,
  t0_.concurrence AS concurrence_10,
  t0_.positionnement_marche AS positionnement_marche_11,
  t0_.elements_complementaires AS elements_complementaires_12,
  t0_.profil_repreneur_recherche AS profil_repreneur_recherche_13,
  t0_.code_langue AS code_langue_14
FROM
  fusacq_dbo.translate_annonce_vendeur t0_
WHERE
  t0_.id_annonce_vendeur = ?
  AND t0_.code_langue = ?

SELECT t0_.id_translate_annonce_vendeur AS id_translate_annonce_vendeur_0, t0_.id_annonce_vendeur AS id_annonce_vendeur_1, t0_.description_activite AS description_activite_2, t0_.titre_annonce AS titre_annonce_3, t0_.commentaires AS commentaires_4, t0_.mots_cle_recherche AS mots_cle_recherche_5, t0_.mots_cles AS mots_cles_6, t0_.points_forts AS points_forts_7, t0_.points_faibles AS points_faibles_8, t0_.raison_cession AS raison_cession_9, t0_.concurrence AS concurrence_10, t0_.positionnement_marche AS positionnement_marche_11, t0_.elements_complementaires AS elements_complementaires_12, t0_.profil_repreneur_recherche AS profil_repreneur_recherche_13, t0_.code_langue AS code_langue_14 FROM fusacq_dbo.translate_annonce_vendeur t0_ WHERE t0_.id_annonce_vendeur = 90099 AND t0_.code_langue = 'FR';

SELECT
  t0_.id_translate_annonce_vendeur AS id_translate_annonce_vendeur_0,
  t0_.id_annonce_vendeur AS id_annonce_vendeur_1,
  t0_.description_activite AS description_activite_2,
  t0_.titre_annonce AS titre_annonce_3,
  t0_.commentaires AS commentaires_4,
  t0_.mots_cle_recherche AS mots_cle_recherche_5,
  t0_.mots_cles AS mots_cles_6,
  t0_.points_forts AS points_forts_7,
  t0_.points_faibles AS points_faibles_8,
  t0_.raison_cession AS raison_cession_9,
  t0_.concurrence AS concurrence_10,
  t0_.positionnement_marche AS positionnement_marche_11,
  t0_.elements_complementaires AS elements_complementaires_12,
  t0_.profil_repreneur_recherche AS profil_repreneur_recherche_13,
  t0_.code_langue AS code_langue_14
FROM
  fusacq_dbo.translate_annonce_vendeur t0_
WHERE
  t0_.id_annonce_vendeur = ?
  AND t0_.code_langue = ?

SELECT t0_.id_translate_annonce_vendeur AS id_translate_annonce_vendeur_0, t0_.id_annonce_vendeur AS id_annonce_vendeur_1, t0_.description_activite AS description_activite_2, t0_.titre_annonce AS titre_annonce_3, t0_.commentaires AS commentaires_4, t0_.mots_cle_recherche AS mots_cle_recherche_5, t0_.mots_cles AS mots_cles_6, t0_.points_forts AS points_forts_7, t0_.points_faibles AS points_faibles_8, t0_.raison_cession AS raison_cession_9, t0_.concurrence AS concurrence_10, t0_.positionnement_marche AS positionnement_marche_11, t0_.elements_complementaires AS elements_complementaires_12, t0_.profil_repreneur_recherche AS profil_repreneur_recherche_13, t0_.code_langue AS code_langue_14 FROM fusacq_dbo.translate_annonce_vendeur t0_ WHERE t0_.id_annonce_vendeur = 90094 AND t0_.code_langue = 'FR';

SELECT
  t0_.id_translate_annonce_vendeur AS id_translate_annonce_vendeur_0,
  t0_.id_annonce_vendeur AS id_annonce_vendeur_1,
  t0_.description_activite AS description_activite_2,
  t0_.titre_annonce AS titre_annonce_3,
  t0_.commentaires AS commentaires_4,
  t0_.mots_cle_recherche AS mots_cle_recherche_5,
  t0_.mots_cles AS mots_cles_6,
  t0_.points_forts AS points_forts_7,
  t0_.points_faibles AS points_faibles_8,
  t0_.raison_cession AS raison_cession_9,
  t0_.concurrence AS concurrence_10,
  t0_.positionnement_marche AS positionnement_marche_11,
  t0_.elements_complementaires AS elements_complementaires_12,
  t0_.profil_repreneur_recherche AS profil_repreneur_recherche_13,
  t0_.code_langue AS code_langue_14
FROM
  fusacq_dbo.translate_annonce_vendeur t0_
WHERE
  t0_.id_annonce_vendeur = ?
  AND t0_.code_langue = ?

SELECT t0_.id_translate_annonce_vendeur AS id_translate_annonce_vendeur_0, t0_.id_annonce_vendeur AS id_annonce_vendeur_1, t0_.description_activite AS description_activite_2, t0_.titre_annonce AS titre_annonce_3, t0_.commentaires AS commentaires_4, t0_.mots_cle_recherche AS mots_cle_recherche_5, t0_.mots_cles AS mots_cles_6, t0_.points_forts AS points_forts_7, t0_.points_faibles AS points_faibles_8, t0_.raison_cession AS raison_cession_9, t0_.concurrence AS concurrence_10, t0_.positionnement_marche AS positionnement_marche_11, t0_.elements_complementaires AS elements_complementaires_12, t0_.profil_repreneur_recherche AS profil_repreneur_recherche_13, t0_.code_langue AS code_langue_14 FROM fusacq_dbo.translate_annonce_vendeur t0_ WHERE t0_.id_annonce_vendeur = 90225 AND t0_.code_langue = 'FR';

SELECT
  t0_.id_translate_annonce_vendeur AS id_translate_annonce_vendeur_0,
  t0_.id_annonce_vendeur AS id_annonce_vendeur_1,
  t0_.description_activite AS description_activite_2,
  t0_.titre_annonce AS titre_annonce_3,
  t0_.commentaires AS commentaires_4,
  t0_.mots_cle_recherche AS mots_cle_recherche_5,
  t0_.mots_cles AS mots_cles_6,
  t0_.points_forts AS points_forts_7,
  t0_.points_faibles AS points_faibles_8,
  t0_.raison_cession AS raison_cession_9,
  t0_.concurrence AS concurrence_10,
  t0_.positionnement_marche AS positionnement_marche_11,
  t0_.elements_complementaires AS elements_complementaires_12,
  t0_.profil_repreneur_recherche AS profil_repreneur_recherche_13,
  t0_.code_langue AS code_langue_14
FROM
  fusacq_dbo.translate_annonce_vendeur t0_
WHERE
  t0_.id_annonce_vendeur = ?
  AND t0_.code_langue = ?

SELECT t0_.id_translate_annonce_vendeur AS id_translate_annonce_vendeur_0, t0_.id_annonce_vendeur AS id_annonce_vendeur_1, t0_.description_activite AS description_activite_2, t0_.titre_annonce AS titre_annonce_3, t0_.commentaires AS commentaires_4, t0_.mots_cle_recherche AS mots_cle_recherche_5, t0_.mots_cles AS mots_cles_6, t0_.points_forts AS points_forts_7, t0_.points_faibles AS points_faibles_8, t0_.raison_cession AS raison_cession_9, t0_.concurrence AS concurrence_10, t0_.positionnement_marche AS positionnement_marche_11, t0_.elements_complementaires AS elements_complementaires_12, t0_.profil_repreneur_recherche AS profil_repreneur_recherche_13, t0_.code_langue AS code_langue_14 FROM fusacq_dbo.translate_annonce_vendeur t0_ WHERE t0_.id_annonce_vendeur = 90093 AND t0_.code_langue = 'FR';

SELECT
  a0_.id_annonce_vendeur AS id_annonce_vendeur_0,
  a0_.titre_annonce AS titre_annonce_1,
  a0_.ca_n AS ca_n_2,
  a0_.date_parution_initiale AS date_parution_initiale_3,
  a0_.date_parution_initiale_elite AS date_parution_initiale_elite_4,
  a0_.id_pays AS id_pays_5,
  a0_.id_region AS id_region_6,
  a0_.id_departement AS id_departement_7,
  a0_.id_langue AS id_langue_8,
  a0_.date_fin_publique_elite AS date_fin_publique_elite_9
FROM
  fusacq_dbo.annonces_vendeur a0_
WHERE
  a0_.mode_annonce = 'publique_elite'
  AND a0_.tpe_pme = 'oui'
  AND a0_.visible_dernieres_annonces IS NULL
  AND a0_.statuts NOT LIKE '99%'
ORDER BY
  a0_.date_parution_initiale_complete DESC
LIMIT
  5

SELECT a0_.id_annonce_vendeur AS id_annonce_vendeur_0, a0_.titre_annonce AS titre_annonce_1, a0_.ca_n AS ca_n_2, a0_.date_parution_initiale AS date_parution_initiale_3, a0_.date_parution_initiale_elite AS date_parution_initiale_elite_4, a0_.id_pays AS id_pays_5, a0_.id_region AS id_region_6, a0_.id_departement AS id_departement_7, a0_.id_langue AS id_langue_8, a0_.date_fin_publique_elite AS date_fin_publique_elite_9 FROM fusacq_dbo.annonces_vendeur a0_ WHERE a0_.mode_annonce = 'publique_elite' AND a0_.tpe_pme = 'oui' AND a0_.visible_dernieres_annonces IS NULL AND a0_.statuts NOT LIKE '99%' ORDER BY a0_.date_parution_initiale_complete DESC LIMIT 5;

SELECT
  t0_.id_translate_annonce_vendeur AS id_translate_annonce_vendeur_0,
  t0_.id_annonce_vendeur AS id_annonce_vendeur_1,
  t0_.description_activite AS description_activite_2,
  t0_.titre_annonce AS titre_annonce_3,
  t0_.commentaires AS commentaires_4,
  t0_.mots_cle_recherche AS mots_cle_recherche_5,
  t0_.mots_cles AS mots_cles_6,
  t0_.points_forts AS points_forts_7,
  t0_.points_faibles AS points_faibles_8,
  t0_.raison_cession AS raison_cession_9,
  t0_.concurrence AS concurrence_10,
  t0_.positionnement_marche AS positionnement_marche_11,
  t0_.elements_complementaires AS elements_complementaires_12,
  t0_.profil_repreneur_recherche AS profil_repreneur_recherche_13,
  t0_.code_langue AS code_langue_14
FROM
  fusacq_dbo.translate_annonce_vendeur t0_
WHERE
  t0_.id_annonce_vendeur = ?
  AND t0_.code_langue = ?

SELECT t0_.id_translate_annonce_vendeur AS id_translate_annonce_vendeur_0, t0_.id_annonce_vendeur AS id_annonce_vendeur_1, t0_.description_activite AS description_activite_2, t0_.titre_annonce AS titre_annonce_3, t0_.commentaires AS commentaires_4, t0_.mots_cle_recherche AS mots_cle_recherche_5, t0_.mots_cles AS mots_cles_6, t0_.points_forts AS points_forts_7, t0_.points_faibles AS points_faibles_8, t0_.raison_cession AS raison_cession_9, t0_.concurrence AS concurrence_10, t0_.positionnement_marche AS positionnement_marche_11, t0_.elements_complementaires AS elements_complementaires_12, t0_.profil_repreneur_recherche AS profil_repreneur_recherche_13, t0_.code_langue AS code_langue_14 FROM fusacq_dbo.translate_annonce_vendeur t0_ WHERE t0_.id_annonce_vendeur = 90228 AND t0_.code_langue = 'FR';

SELECT
  t0_.id_translate_annonce_vendeur AS id_translate_annonce_vendeur_0,
  t0_.id_annonce_vendeur AS id_annonce_vendeur_1,
  t0_.description_activite AS description_activite_2,
  t0_.titre_annonce AS titre_annonce_3,
  t0_.commentaires AS commentaires_4,
  t0_.mots_cle_recherche AS mots_cle_recherche_5,
  t0_.mots_cles AS mots_cles_6,
  t0_.points_forts AS points_forts_7,
  t0_.points_faibles AS points_faibles_8,
  t0_.raison_cession AS raison_cession_9,
  t0_.concurrence AS concurrence_10,
  t0_.positionnement_marche AS positionnement_marche_11,
  t0_.elements_complementaires AS elements_complementaires_12,
  t0_.profil_repreneur_recherche AS profil_repreneur_recherche_13,
  t0_.code_langue AS code_langue_14
FROM
  fusacq_dbo.translate_annonce_vendeur t0_
WHERE
  t0_.id_annonce_vendeur = ?
  AND t0_.code_langue = ?

SELECT t0_.id_translate_annonce_vendeur AS id_translate_annonce_vendeur_0, t0_.id_annonce_vendeur AS id_annonce_vendeur_1, t0_.description_activite AS description_activite_2, t0_.titre_annonce AS titre_annonce_3, t0_.commentaires AS commentaires_4, t0_.mots_cle_recherche AS mots_cle_recherche_5, t0_.mots_cles AS mots_cles_6, t0_.points_forts AS points_forts_7, t0_.points_faibles AS points_faibles_8, t0_.raison_cession AS raison_cession_9, t0_.concurrence AS concurrence_10, t0_.positionnement_marche AS positionnement_marche_11, t0_.elements_complementaires AS elements_complementaires_12, t0_.profil_repreneur_recherche AS profil_repreneur_recherche_13, t0_.code_langue AS code_langue_14 FROM fusacq_dbo.translate_annonce_vendeur t0_ WHERE t0_.id_annonce_vendeur = 90226 AND t0_.code_langue = 'FR';

SELECT
  t0_.id_translate_annonce_vendeur AS id_translate_annonce_vendeur_0,
  t0_.id_annonce_vendeur AS id_annonce_vendeur_1,
  t0_.description_activite AS description_activite_2,
  t0_.titre_annonce AS titre_annonce_3,
  t0_.commentaires AS commentaires_4,
  t0_.mots_cle_recherche AS mots_cle_recherche_5,
  t0_.mots_cles AS mots_cles_6,
  t0_.points_forts AS points_forts_7,
  t0_.points_faibles AS points_faibles_8,
  t0_.raison_cession AS raison_cession_9,
  t0_.concurrence AS concurrence_10,
  t0_.positionnement_marche AS positionnement_marche_11,
  t0_.elements_complementaires AS elements_complementaires_12,
  t0_.profil_repreneur_recherche AS profil_repreneur_recherche_13,
  t0_.code_langue AS code_langue_14
FROM
  fusacq_dbo.translate_annonce_vendeur t0_
WHERE
  t0_.id_annonce_vendeur = ?
  AND t0_.code_langue = ?

SELECT t0_.id_translate_annonce_vendeur AS id_translate_annonce_vendeur_0, t0_.id_annonce_vendeur AS id_annonce_vendeur_1, t0_.description_activite AS description_activite_2, t0_.titre_annonce AS titre_annonce_3, t0_.commentaires AS commentaires_4, t0_.mots_cle_recherche AS mots_cle_recherche_5, t0_.mots_cles AS mots_cles_6, t0_.points_forts AS points_forts_7, t0_.points_faibles AS points_faibles_8, t0_.raison_cession AS raison_cession_9, t0_.concurrence AS concurrence_10, t0_.positionnement_marche AS positionnement_marche_11, t0_.elements_complementaires AS elements_complementaires_12, t0_.profil_repreneur_recherche AS profil_repreneur_recherche_13, t0_.code_langue AS code_langue_14 FROM fusacq_dbo.translate_annonce_vendeur t0_ WHERE t0_.id_annonce_vendeur = 90219 AND t0_.code_langue = 'FR';

SELECT
  t0_.id_translate_annonce_vendeur AS id_translate_annonce_vendeur_0,
  t0_.id_annonce_vendeur AS id_annonce_vendeur_1,
  t0_.description_activite AS description_activite_2,
  t0_.titre_annonce AS titre_annonce_3,
  t0_.commentaires AS commentaires_4,
  t0_.mots_cle_recherche AS mots_cle_recherche_5,
  t0_.mots_cles AS mots_cles_6,
  t0_.points_forts AS points_forts_7,
  t0_.points_faibles AS points_faibles_8,
  t0_.raison_cession AS raison_cession_9,
  t0_.concurrence AS concurrence_10,
  t0_.positionnement_marche AS positionnement_marche_11,
  t0_.elements_complementaires AS elements_complementaires_12,
  t0_.profil_repreneur_recherche AS profil_repreneur_recherche_13,
  t0_.code_langue AS code_langue_14
FROM
  fusacq_dbo.translate_annonce_vendeur t0_
WHERE
  t0_.id_annonce_vendeur = ?
  AND t0_.code_langue = ?

SELECT t0_.id_translate_annonce_vendeur AS id_translate_annonce_vendeur_0, t0_.id_annonce_vendeur AS id_annonce_vendeur_1, t0_.description_activite AS description_activite_2, t0_.titre_annonce AS titre_annonce_3, t0_.commentaires AS commentaires_4, t0_.mots_cle_recherche AS mots_cle_recherche_5, t0_.mots_cles AS mots_cles_6, t0_.points_forts AS points_forts_7, t0_.points_faibles AS points_faibles_8, t0_.raison_cession AS raison_cession_9, t0_.concurrence AS concurrence_10, t0_.positionnement_marche AS positionnement_marche_11, t0_.elements_complementaires AS elements_complementaires_12, t0_.profil_repreneur_recherche AS profil_repreneur_recherche_13, t0_.code_langue AS code_langue_14 FROM fusacq_dbo.translate_annonce_vendeur t0_ WHERE t0_.id_annonce_vendeur = 90217 AND t0_.code_langue = 'FR';

SELECT
  t0_.id_translate_annonce_vendeur AS id_translate_annonce_vendeur_0,
  t0_.id_annonce_vendeur AS id_annonce_vendeur_1,
  t0_.description_activite AS description_activite_2,
  t0_.titre_annonce AS titre_annonce_3,
  t0_.commentaires AS commentaires_4,
  t0_.mots_cle_recherche AS mots_cle_recherche_5,
  t0_.mots_cles AS mots_cles_6,
  t0_.points_forts AS points_forts_7,
  t0_.points_faibles AS points_faibles_8,
  t0_.raison_cession AS raison_cession_9,
  t0_.concurrence AS concurrence_10,
  t0_.positionnement_marche AS positionnement_marche_11,
  t0_.elements_complementaires AS elements_complementaires_12,
  t0_.profil_repreneur_recherche AS profil_repreneur_recherche_13,
  t0_.code_langue AS code_langue_14
FROM
  fusacq_dbo.translate_annonce_vendeur t0_
WHERE
  t0_.id_annonce_vendeur = ?
  AND t0_.code_langue = ?

SELECT t0_.id_translate_annonce_vendeur AS id_translate_annonce_vendeur_0, t0_.id_annonce_vendeur AS id_annonce_vendeur_1, t0_.description_activite AS description_activite_2, t0_.titre_annonce AS titre_annonce_3, t0_.commentaires AS commentaires_4, t0_.mots_cle_recherche AS mots_cle_recherche_5, t0_.mots_cles AS mots_cles_6, t0_.points_forts AS points_forts_7, t0_.points_faibles AS points_faibles_8, t0_.raison_cession AS raison_cession_9, t0_.concurrence AS concurrence_10, t0_.positionnement_marche AS positionnement_marche_11, t0_.elements_complementaires AS elements_complementaires_12, t0_.profil_repreneur_recherche AS profil_repreneur_recherche_13, t0_.code_langue AS code_langue_14 FROM fusacq_dbo.translate_annonce_vendeur t0_ WHERE t0_.id_annonce_vendeur = 90216 AND t0_.code_langue = 'FR';

SELECT
  s0_.id_secteur_activite AS id_secteur_activite_0,
  s0_.nom_secteur_activite AS nom_secteur_activite_1
FROM
  fusacq_dbo.secteurs_activite s0_
WHERE
  s0_.id_secteur_activite_pere = 0
  AND (
    s0_.obsolete <> ?
    OR s0_.obsolete IS NULL
  )
ORDER BY
  s0_.nom_secteur_activite ASC

SELECT s0_.id_secteur_activite AS id_secteur_activite_0, s0_.nom_secteur_activite AS nom_secteur_activite_1 FROM fusacq_dbo.secteurs_activite s0_ WHERE s0_.id_secteur_activite_pere = 0 AND (s0_.obsolete <> 'oui' OR s0_.obsolete IS NULL) ORDER BY s0_.nom_secteur_activite ASC;

SELECT
  a0_.identifiant_profil AS identifiant_profil_0,
  COUNT(DISTINCT a1_.id_annonce_vendeur) AS sclr_1
FROM
  fusacq_dbo.annonces_vendeur a1_
  LEFT JOIN fusacq_dbo.annonces_vendeur_profils_standards a0_ ON (
    a0_.id_annonce = a1_.id_annonce_vendeur
  )
WHERE
  a1_.mode_annonce = ?
  AND a0_.identifiant_profil IS NOT NULL
GROUP BY
  a0_.identifiant_profil

SELECT a0_.identifiant_profil AS identifiant_profil_0, COUNT(DISTINCT a1_.id_annonce_vendeur) AS sclr_1 FROM fusacq_dbo.annonces_vendeur a1_ LEFT JOIN fusacq_dbo.annonces_vendeur_profils_standards a0_ ON (a0_.id_annonce = a1_.id_annonce_vendeur) WHERE a1_.mode_annonce = 'publique' AND a0_.identifiant_profil IS NOT NULL GROUP BY a0_.identifiant_profil;