Symfony Profiler

SELECT
  t0.id_gestionnaire_fonds AS id_gestionnaire_fonds_1,
  t0.mode AS mode_2,
  t0.nom_societe AS nom_societe_3,
  t0.adresse_societe AS adresse_societe_4,
  t0.code_postal_societe AS code_postal_societe_5,
  t0.ville_societe AS ville_societe_6,
  t0.site_internet AS site_internet_7,
  t0.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_8,
  t0.nom_contact AS nom_contact_9,
  t0.mail_contact AS mail_contact_10,
  t0.telephone AS telephone_11,
  t0.indicatif AS indicatif_12,
  t0.fax AS fax_13,
  t0.id_pays AS id_pays_14,
  t0.id_region AS id_region_15,
  t0.id_autres_localisations AS id_autres_localisations_16,
  t0.date_mise_a_jour AS date_mise_a_jour_17,
  t0.fichier_joint AS fichier_joint_18,
  t0.strategie_globale_investissement AS strategie_globale_investissement_19,
  t0.login_demande_publication AS login_demande_publication_20,
  t0.date_relance_suivi AS date_relance_suivi_21,
  t0.suivi AS suivi_22,
  t0.societe_active AS societe_active_23,
  t0.type_utilisation AS type_utilisation_24,
  t0.date_relance AS date_relance_25,
  t0.relance_mise_a_jour AS relance_mise_a_jour_26,
  t0.login_resp_tache AS login_resp_tache_27,
  t0.logos AS logos_28,
  t0.date_derniere_MAJ_participations AS date_derniere_MAJ_participations_29,
  t0.id_service_prestataire_associe AS id_service_prestataire_associe_30,
  t0.montant_investissement_min AS montant_investissement_min_31,
  t0.montant_investissement_min_devise AS montant_investissement_min_devise_32,
  t0.montant_investissement_max AS montant_investissement_max_33,
  t0.montant_investissement_max_devise AS montant_investissement_max_devise_34,
  t0.devise AS devise_35,
  t0.taux_change AS taux_change_36,
  t0.type_investissement AS type_investissement_37,
  t0.stade_investissement AS stade_investissement_38,
  t0.etat_fusacq_bot_actu AS etat_fusacq_bot_actu_39,
  t0.suivi_bot_actu AS suivi_bot_actu_40,
  t0.etat_fusacq_bot_part AS etat_fusacq_bot_part_41,
  t0.suivi_bot_part AS suivi_bot_part_42,
  t0.date_relance_respo AS date_relance_respo_43,
  t0.date_valide_respo AS date_valide_respo_44,
  t0.id_secteur_activite AS id_secteur_activite_45,
  t0.mail_respon_maj AS mail_respon_maj_46,
  t0.regions_ciblees AS regions_ciblees_47,
  t0.pays_ciblees AS pays_ciblees_48,
  t0.utiliser_artviper AS utiliser_artviper_49
FROM
  fusacq_dbo.societe_gestionnaire_fonds t0
WHERE
  t0.mode = ?
  AND t0.id_gestionnaire_fonds = ?
LIMIT
  1

SELECT t0.id_gestionnaire_fonds AS id_gestionnaire_fonds_1, t0.mode AS mode_2, t0.nom_societe AS nom_societe_3, t0.adresse_societe AS adresse_societe_4, t0.code_postal_societe AS code_postal_societe_5, t0.ville_societe AS ville_societe_6, t0.site_internet AS site_internet_7, t0.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_8, t0.nom_contact AS nom_contact_9, t0.mail_contact AS mail_contact_10, t0.telephone AS telephone_11, t0.indicatif AS indicatif_12, t0.fax AS fax_13, t0.id_pays AS id_pays_14, t0.id_region AS id_region_15, t0.id_autres_localisations AS id_autres_localisations_16, t0.date_mise_a_jour AS date_mise_a_jour_17, t0.fichier_joint AS fichier_joint_18, t0.strategie_globale_investissement AS strategie_globale_investissement_19, t0.login_demande_publication AS login_demande_publication_20, t0.date_relance_suivi AS date_relance_suivi_21, t0.suivi AS suivi_22, t0.societe_active AS societe_active_23, t0.type_utilisation AS type_utilisation_24, t0.date_relance AS date_relance_25, t0.relance_mise_a_jour AS relance_mise_a_jour_26, t0.login_resp_tache AS login_resp_tache_27, t0.logos AS logos_28, t0.date_derniere_MAJ_participations AS date_derniere_MAJ_participations_29, t0.id_service_prestataire_associe AS id_service_prestataire_associe_30, t0.montant_investissement_min AS montant_investissement_min_31, t0.montant_investissement_min_devise AS montant_investissement_min_devise_32, t0.montant_investissement_max AS montant_investissement_max_33, t0.montant_investissement_max_devise AS montant_investissement_max_devise_34, t0.devise AS devise_35, t0.taux_change AS taux_change_36, t0.type_investissement AS type_investissement_37, t0.stade_investissement AS stade_investissement_38, t0.etat_fusacq_bot_actu AS etat_fusacq_bot_actu_39, t0.suivi_bot_actu AS suivi_bot_actu_40, t0.etat_fusacq_bot_part AS etat_fusacq_bot_part_41, t0.suivi_bot_part AS suivi_bot_part_42, t0.date_relance_respo AS date_relance_respo_43, t0.date_valide_respo AS date_valide_respo_44, t0.id_secteur_activite AS id_secteur_activite_45, t0.mail_respon_maj AS mail_respon_maj_46, t0.regions_ciblees AS regions_ciblees_47, t0.pays_ciblees AS pays_ciblees_48, t0.utiliser_artviper AS utiliser_artviper_49 FROM fusacq_dbo.societe_gestionnaire_fonds t0 WHERE t0.mode = 'publique' AND t0.id_gestionnaire_fonds = '674' LIMIT 1;

SELECT
  b0_.id_actualite AS id_actualite_0,
  b0_.date_creation AS date_creation_1,
  b0_.date_reception AS date_reception_2,
  b0_.date_mise_en_ligne AS date_mise_en_ligne_3,
  b0_.date_evenement AS date_evenement_4,
  b0_.titre_actualite AS titre_actualite_5,
  b0_.sous_titre AS sous_titre_6,
  b0_.description_actualite AS description_actualite_7,
  b0_.provenance_flux_actualite AS provenance_flux_actualite_8,
  b0_.type_actualite AS type_actualite_9,
  b0_.nom_fichier_xml AS nom_fichier_xml_10,
  b0_.id_message_blog AS id_message_blog_11,
  b0_.id_societe_prestataire AS id_societe_prestataire_12,
  b0_.id_service_principal AS id_service_principal_13,
  b0_.id_operation AS id_operation_14,
  b0_.mode_actualite AS mode_actualite_15,
  b0_.modifie_par_utilisateur AS modifie_par_utilisateur_16,
  b0_.deja_publique AS deja_publique_17,
  b0_.id_actualite_redirection AS id_actualite_redirection_18,
  b0_.site_internet AS site_internet_19,
  b0_.pour_en_savoir_plus AS pour_en_savoir_plus_20,
  b0_.societe_source AS societe_source_21,
  b0_.mots_cles AS mots_cles_22,
  b0_.a_la_une AS a_la_une_23,
  b0_.parution_franchises AS parution_franchises_24,
  b0_.a_la_une_du_jour AS a_la_une_du_jour_25,
  b0_.selection_we AS selection_we_26,
  b0_.a_la_une_accueil AS a_la_une_accueil_27,
  b0_.a_la_une_news_actu AS a_la_une_news_actu_28,
  b0_.utiliser_artviper AS utiliser_artviper_29,
  b0_.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_30,
  b0_.visibilite_flux AS visibilite_flux_31,
  b0_.personne_physique_impliquee AS personne_physique_impliquee_32,
  b0_.societe_impliquee AS societe_impliquee_33,
  b0_.fonds_implique AS fonds_implique_34,
  b0_.id_localisation AS id_localisation_35,
  b0_.id_secteur_activite AS id_secteur_activite_36,
  b0_.vignette AS vignette_37,
  b0_.vignette_small AS vignette_small_38,
  b0_.alerte_envoyee AS alerte_envoyee_39,
  b0_.id_participation AS id_participation_40,
  b0_.id_participation_temporaire AS id_participation_temporaire_41,
  b0_.id_operation_temporaire AS id_operation_temporaire_42,
  b0_.id_fonds_bot AS id_fonds_bot_43,
  b0_.souhaite_classement AS souhaite_classement_44,
  b0_.souhaite_reseau AS souhaite_reseau_45,
  b0_.souhaite_prestation AS souhaite_prestation_46,
  b0_.souhaite_nom_reseau AS souhaite_nom_reseau_47,
  b0_.autorisation_blog AS autorisation_blog_48,
  b0_.contact_validation AS contact_validation_49,
  b0_.commentaires_blog AS commentaires_blog_50,
  b0_.apparition_classement AS apparition_classement_51,
  b0_.classement_reseau AS classement_reseau_52,
  b0_.classement_prestation AS classement_prestation_53,
  b0_.id_reseau AS id_reseau_54,
  b0_.suivi_classement AS suivi_classement_55,
  b0_.is_description_html AS is_description_html_56,
  b0_.is_forum_active AS is_forum_active_57,
  b0_.actu_ess AS actu_ess_58,
  b0_.suivi_actualite AS suivi_actualite_59,
  b0_.date_validation AS date_validation_60,
  b0_.indexe_google AS indexe_google_61
FROM
  fusacq_dbo.buzz_actualites b0_
  INNER JOIN fusacq_dbo.buzz_roles b1_ ON (
    b0_.id_operation = b1_.id_operation
  )
WHERE
  b1_.id_type_role = 3
  AND b1_.id_acteur = ?
  AND b0_.mode_actualite = 'publique'

SELECT b0_.id_actualite AS id_actualite_0, b0_.date_creation AS date_creation_1, b0_.date_reception AS date_reception_2, b0_.date_mise_en_ligne AS date_mise_en_ligne_3, b0_.date_evenement AS date_evenement_4, b0_.titre_actualite AS titre_actualite_5, b0_.sous_titre AS sous_titre_6, b0_.description_actualite AS description_actualite_7, b0_.provenance_flux_actualite AS provenance_flux_actualite_8, b0_.type_actualite AS type_actualite_9, b0_.nom_fichier_xml AS nom_fichier_xml_10, b0_.id_message_blog AS id_message_blog_11, b0_.id_societe_prestataire AS id_societe_prestataire_12, b0_.id_service_principal AS id_service_principal_13, b0_.id_operation AS id_operation_14, b0_.mode_actualite AS mode_actualite_15, b0_.modifie_par_utilisateur AS modifie_par_utilisateur_16, b0_.deja_publique AS deja_publique_17, b0_.id_actualite_redirection AS id_actualite_redirection_18, b0_.site_internet AS site_internet_19, b0_.pour_en_savoir_plus AS pour_en_savoir_plus_20, b0_.societe_source AS societe_source_21, b0_.mots_cles AS mots_cles_22, b0_.a_la_une AS a_la_une_23, b0_.parution_franchises AS parution_franchises_24, b0_.a_la_une_du_jour AS a_la_une_du_jour_25, b0_.selection_we AS selection_we_26, b0_.a_la_une_accueil AS a_la_une_accueil_27, b0_.a_la_une_news_actu AS a_la_une_news_actu_28, b0_.utiliser_artviper AS utiliser_artviper_29, b0_.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_30, b0_.visibilite_flux AS visibilite_flux_31, b0_.personne_physique_impliquee AS personne_physique_impliquee_32, b0_.societe_impliquee AS societe_impliquee_33, b0_.fonds_implique AS fonds_implique_34, b0_.id_localisation AS id_localisation_35, b0_.id_secteur_activite AS id_secteur_activite_36, b0_.vignette AS vignette_37, b0_.vignette_small AS vignette_small_38, b0_.alerte_envoyee AS alerte_envoyee_39, b0_.id_participation AS id_participation_40, b0_.id_participation_temporaire AS id_participation_temporaire_41, b0_.id_operation_temporaire AS id_operation_temporaire_42, b0_.id_fonds_bot AS id_fonds_bot_43, b0_.souhaite_classement AS souhaite_classement_44, b0_.souhaite_reseau AS souhaite_reseau_45, b0_.souhaite_prestation AS souhaite_prestation_46, b0_.souhaite_nom_reseau AS souhaite_nom_reseau_47, b0_.autorisation_blog AS autorisation_blog_48, b0_.contact_validation AS contact_validation_49, b0_.commentaires_blog AS commentaires_blog_50, b0_.apparition_classement AS apparition_classement_51, b0_.classement_reseau AS classement_reseau_52, b0_.classement_prestation AS classement_prestation_53, b0_.id_reseau AS id_reseau_54, b0_.suivi_classement AS suivi_classement_55, b0_.is_description_html AS is_description_html_56, b0_.is_forum_active AS is_forum_active_57, b0_.actu_ess AS actu_ess_58, b0_.suivi_actualite AS suivi_actualite_59, b0_.date_validation AS date_validation_60, b0_.indexe_google AS indexe_google_61 FROM fusacq_dbo.buzz_actualites b0_ INNER JOIN fusacq_dbo.buzz_roles b1_ ON (b0_.id_operation = b1_.id_operation) WHERE b1_.id_type_role = 3 AND b1_.id_acteur = '674' AND b0_.mode_actualite = 'publique';

SELECT
  b0_.id_actualite AS id_actualite_0,
  b0_.date_creation AS date_creation_1,
  b0_.date_reception AS date_reception_2,
  b0_.date_mise_en_ligne AS date_mise_en_ligne_3,
  b0_.date_evenement AS date_evenement_4,
  b0_.titre_actualite AS titre_actualite_5,
  b0_.sous_titre AS sous_titre_6,
  b0_.description_actualite AS description_actualite_7,
  b0_.provenance_flux_actualite AS provenance_flux_actualite_8,
  b0_.type_actualite AS type_actualite_9,
  b0_.nom_fichier_xml AS nom_fichier_xml_10,
  b0_.id_message_blog AS id_message_blog_11,
  b0_.id_societe_prestataire AS id_societe_prestataire_12,
  b0_.id_service_principal AS id_service_principal_13,
  b0_.id_operation AS id_operation_14,
  b0_.mode_actualite AS mode_actualite_15,
  b0_.modifie_par_utilisateur AS modifie_par_utilisateur_16,
  b0_.deja_publique AS deja_publique_17,
  b0_.id_actualite_redirection AS id_actualite_redirection_18,
  b0_.site_internet AS site_internet_19,
  b0_.pour_en_savoir_plus AS pour_en_savoir_plus_20,
  b0_.societe_source AS societe_source_21,
  b0_.mots_cles AS mots_cles_22,
  b0_.a_la_une AS a_la_une_23,
  b0_.parution_franchises AS parution_franchises_24,
  b0_.a_la_une_du_jour AS a_la_une_du_jour_25,
  b0_.selection_we AS selection_we_26,
  b0_.a_la_une_accueil AS a_la_une_accueil_27,
  b0_.a_la_une_news_actu AS a_la_une_news_actu_28,
  b0_.utiliser_artviper AS utiliser_artviper_29,
  b0_.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_30,
  b0_.visibilite_flux AS visibilite_flux_31,
  b0_.personne_physique_impliquee AS personne_physique_impliquee_32,
  b0_.societe_impliquee AS societe_impliquee_33,
  b0_.fonds_implique AS fonds_implique_34,
  b0_.id_localisation AS id_localisation_35,
  b0_.id_secteur_activite AS id_secteur_activite_36,
  b0_.vignette AS vignette_37,
  b0_.vignette_small AS vignette_small_38,
  b0_.alerte_envoyee AS alerte_envoyee_39,
  b0_.id_participation AS id_participation_40,
  b0_.id_participation_temporaire AS id_participation_temporaire_41,
  b0_.id_operation_temporaire AS id_operation_temporaire_42,
  b0_.id_fonds_bot AS id_fonds_bot_43,
  b0_.souhaite_classement AS souhaite_classement_44,
  b0_.souhaite_reseau AS souhaite_reseau_45,
  b0_.souhaite_prestation AS souhaite_prestation_46,
  b0_.souhaite_nom_reseau AS souhaite_nom_reseau_47,
  b0_.autorisation_blog AS autorisation_blog_48,
  b0_.contact_validation AS contact_validation_49,
  b0_.commentaires_blog AS commentaires_blog_50,
  b0_.apparition_classement AS apparition_classement_51,
  b0_.classement_reseau AS classement_reseau_52,
  b0_.classement_prestation AS classement_prestation_53,
  b0_.id_reseau AS id_reseau_54,
  b0_.suivi_classement AS suivi_classement_55,
  b0_.is_description_html AS is_description_html_56,
  b0_.is_forum_active AS is_forum_active_57,
  b0_.actu_ess AS actu_ess_58,
  b0_.suivi_actualite AS suivi_actualite_59,
  b0_.date_validation AS date_validation_60,
  b0_.indexe_google AS indexe_google_61
FROM
  fusacq_dbo.buzz_actualites b0_
WHERE
  b0_.id_fonds_bot = ?
  AND b0_.mode_actualite = 'publique'

SELECT b0_.id_actualite AS id_actualite_0, b0_.date_creation AS date_creation_1, b0_.date_reception AS date_reception_2, b0_.date_mise_en_ligne AS date_mise_en_ligne_3, b0_.date_evenement AS date_evenement_4, b0_.titre_actualite AS titre_actualite_5, b0_.sous_titre AS sous_titre_6, b0_.description_actualite AS description_actualite_7, b0_.provenance_flux_actualite AS provenance_flux_actualite_8, b0_.type_actualite AS type_actualite_9, b0_.nom_fichier_xml AS nom_fichier_xml_10, b0_.id_message_blog AS id_message_blog_11, b0_.id_societe_prestataire AS id_societe_prestataire_12, b0_.id_service_principal AS id_service_principal_13, b0_.id_operation AS id_operation_14, b0_.mode_actualite AS mode_actualite_15, b0_.modifie_par_utilisateur AS modifie_par_utilisateur_16, b0_.deja_publique AS deja_publique_17, b0_.id_actualite_redirection AS id_actualite_redirection_18, b0_.site_internet AS site_internet_19, b0_.pour_en_savoir_plus AS pour_en_savoir_plus_20, b0_.societe_source AS societe_source_21, b0_.mots_cles AS mots_cles_22, b0_.a_la_une AS a_la_une_23, b0_.parution_franchises AS parution_franchises_24, b0_.a_la_une_du_jour AS a_la_une_du_jour_25, b0_.selection_we AS selection_we_26, b0_.a_la_une_accueil AS a_la_une_accueil_27, b0_.a_la_une_news_actu AS a_la_une_news_actu_28, b0_.utiliser_artviper AS utiliser_artviper_29, b0_.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_30, b0_.visibilite_flux AS visibilite_flux_31, b0_.personne_physique_impliquee AS personne_physique_impliquee_32, b0_.societe_impliquee AS societe_impliquee_33, b0_.fonds_implique AS fonds_implique_34, b0_.id_localisation AS id_localisation_35, b0_.id_secteur_activite AS id_secteur_activite_36, b0_.vignette AS vignette_37, b0_.vignette_small AS vignette_small_38, b0_.alerte_envoyee AS alerte_envoyee_39, b0_.id_participation AS id_participation_40, b0_.id_participation_temporaire AS id_participation_temporaire_41, b0_.id_operation_temporaire AS id_operation_temporaire_42, b0_.id_fonds_bot AS id_fonds_bot_43, b0_.souhaite_classement AS souhaite_classement_44, b0_.souhaite_reseau AS souhaite_reseau_45, b0_.souhaite_prestation AS souhaite_prestation_46, b0_.souhaite_nom_reseau AS souhaite_nom_reseau_47, b0_.autorisation_blog AS autorisation_blog_48, b0_.contact_validation AS contact_validation_49, b0_.commentaires_blog AS commentaires_blog_50, b0_.apparition_classement AS apparition_classement_51, b0_.classement_reseau AS classement_reseau_52, b0_.classement_prestation AS classement_prestation_53, b0_.id_reseau AS id_reseau_54, b0_.suivi_classement AS suivi_classement_55, b0_.is_description_html AS is_description_html_56, b0_.is_forum_active AS is_forum_active_57, b0_.actu_ess AS actu_ess_58, b0_.suivi_actualite AS suivi_actualite_59, b0_.date_validation AS date_validation_60, b0_.indexe_google AS indexe_google_61 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_fonds_bot = '674' AND b0_.mode_actualite = 'publique';

SELECT
  b0_.id_actualite AS id_actualite_0
FROM
  fusacq_dbo.buzz_actualites b0_
  INNER JOIN fusacq_dbo.buzz_roles b1_ ON (
    b0_.id_operation = b1_.id_operation
  )
WHERE
  b1_.id_type_role = 3
  AND b1_.id_acteur = ?
  AND b0_.mode_actualite = 'publique'

SELECT b0_.id_actualite AS id_actualite_0 FROM fusacq_dbo.buzz_actualites b0_ INNER JOIN fusacq_dbo.buzz_roles b1_ ON (b0_.id_operation = b1_.id_operation) WHERE b1_.id_type_role = 3 AND b1_.id_acteur = '674' AND b0_.mode_actualite = 'publique';

SELECT
  b0_.id_actualite AS id_actualite_0
FROM
  fusacq_dbo.buzz_actualites b0_
WHERE
  b0_.id_fonds_bot = ?
  AND b0_.mode_actualite = 'publique'

SELECT b0_.id_actualite AS id_actualite_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_fonds_bot = '674' AND b0_.mode_actualite = 'publique';

SELECT
  s0_.id_gestionnaire_fonds AS id_gestionnaire_fonds_0,
  s0_.nom_societe AS nom_societe_1,
  s0_.nom_contact AS nom_contact_2,
  s0_.id_pays AS id_pays_3,
  s0_.id_region AS id_region_4,
  s0_.adresse_societe AS adresse_societe_5,
  s0_.ville_societe AS ville_societe_6,
  s0_.code_postal_societe AS code_postal_societe_7,
  s0_.telephone AS telephone_8,
  s0_.indicatif AS indicatif_9,
  COUNT(s1_.id_societe) AS sclr_10,
  MAX(l2_.date_investissement) AS sclr_11,
  s0_.site_internet AS site_internet_12,
  s0_.mail_contact AS mail_contact_13
FROM
  fusacq_dbo.societe_gestionnaire_fonds s0_
  INNER JOIN fusacq_dbo.lien_participations_fonds l2_ ON (
    l2_.id_gestionnaire_fonds = s0_.id_gestionnaire_fonds
  )
  INNER JOIN fusacq_dbo.societes s1_ ON (
    s1_.id_societe = l2_.id_participation
  )
WHERE
  s1_.mode_participation = 'publique'
  AND l2_.mode = 'publique'
  AND s0_.mode = 'publique'
  AND s1_.mode_societe = 'publique'
  AND s0_.stade_investissement LIKE '%4%'
GROUP BY
  s0_.id_gestionnaire_fonds
ORDER BY
  sclr_10 DESC,
  s0_.id_gestionnaire_fonds DESC
LIMIT
  1 OFFSET 1

SELECT s0_.id_gestionnaire_fonds AS id_gestionnaire_fonds_0, s0_.nom_societe AS nom_societe_1, s0_.nom_contact AS nom_contact_2, s0_.id_pays AS id_pays_3, s0_.id_region AS id_region_4, s0_.adresse_societe AS adresse_societe_5, s0_.ville_societe AS ville_societe_6, s0_.code_postal_societe AS code_postal_societe_7, s0_.telephone AS telephone_8, s0_.indicatif AS indicatif_9, COUNT(s1_.id_societe) AS sclr_10, MAX(l2_.date_investissement) AS sclr_11, s0_.site_internet AS site_internet_12, s0_.mail_contact AS mail_contact_13 FROM fusacq_dbo.societe_gestionnaire_fonds s0_ INNER JOIN fusacq_dbo.lien_participations_fonds l2_ ON (l2_.id_gestionnaire_fonds = s0_.id_gestionnaire_fonds) INNER JOIN fusacq_dbo.societes s1_ ON (s1_.id_societe = l2_.id_participation) WHERE s1_.mode_participation = 'publique' AND l2_.mode = 'publique' AND s0_.mode = 'publique' AND s1_.mode_societe = 'publique' AND s0_.stade_investissement LIKE '%4%' GROUP BY s0_.id_gestionnaire_fonds ORDER BY sclr_10 DESC, s0_.id_gestionnaire_fonds DESC LIMIT 1 OFFSET 1;

SELECT
  COUNT(
    DISTINCT l0_.id_lien_participations_fonds
  ) AS sclr_0
FROM
  fusacq_dbo.societes s1_
  INNER JOIN fusacq_dbo.lien_participations_fonds l0_ ON (
    s1_.id_societe = l0_.id_participation
  )
  INNER JOIN fusacq_dbo.societe_gestionnaire_fonds s2_ ON (
    l0_.id_gestionnaire_fonds = s2_.id_gestionnaire_fonds
  )
WHERE
  l0_.id_gestionnaire_fonds = ?
  AND (
    l0_.mode = 'publique'
    AND s1_.mode_participation = 'publique'
    AND s1_.mode_societe = 'publique'
  )
  AND s2_.mode = 'publique'

SELECT COUNT(DISTINCT l0_.id_lien_participations_fonds) AS sclr_0 FROM fusacq_dbo.societes s1_ INNER JOIN fusacq_dbo.lien_participations_fonds l0_ ON (s1_.id_societe = l0_.id_participation) INNER JOIN fusacq_dbo.societe_gestionnaire_fonds s2_ ON (l0_.id_gestionnaire_fonds = s2_.id_gestionnaire_fonds) WHERE l0_.id_gestionnaire_fonds = '674' AND (l0_.mode = 'publique' AND s1_.mode_participation = 'publique' AND s1_.mode_societe = 'publique') AND s2_.mode = 'publique';