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
  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_.afficher_vendeur = 1
GROUP BY
  s0_.id_societe

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_.afficher_vendeur = 1 GROUP BY s0_.id_societe;

SELECT
  DISTINCT s0_.id_societe AS id_societe_0,
  s0_.date_dernier_investissement AS date_dernier_investissement_1,
  s0_.ca_n AS ca_n_2,
  s0_.id_societe AS id_societe_3
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_.afficher_vendeur = 1
GROUP BY
  s0_.id_societe
ORDER BY
  s0_.date_dernier_investissement DESC,
  s0_.ca_n DESC,
  s0_.id_societe DESC
LIMIT
  10 OFFSET 2030

SELECT DISTINCT s0_.id_societe AS id_societe_0, s0_.date_dernier_investissement AS date_dernier_investissement_1, s0_.ca_n AS ca_n_2, s0_.id_societe AS id_societe_3 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_.afficher_vendeur = 1 GROUP BY s0_.id_societe ORDER BY s0_.date_dernier_investissement DESC, s0_.ca_n DESC, s0_.id_societe DESC LIMIT 10 OFFSET 2030;

SELECT
  s0_.id_societe AS id_societe_0,
  s0_.id_societe_news AS id_societe_news_1,
  s0_.id_participation AS id_participation_2,
  s0_.mode_participation AS mode_participation_3,
  s0_.deja_publique AS deja_publique_4,
  s0_.raison_sociale AS raison_sociale_5,
  s0_.raison_sociale_formatee AS raison_sociale_formatee_6,
  s0_.nom_president AS nom_president_7,
  s0_.nom_directeur_general AS nom_directeur_general_8,
  s0_.adresse AS adresse_9,
  s0_.ville AS ville_10,
  s0_.code_postal AS code_postal_11,
  s0_.telephone AS telephone_12,
  s0_.fax AS fax_13,
  s0_.id_pays AS id_pays_14,
  s0_.devise AS devise_15,
  s0_.id_region AS id_region_16,
  s0_.filiales_bureaux AS filiales_bureaux_17,
  s0_.id_secteur_activite AS id_secteur_activite_18,
  s0_.id_secteur_activite_fonds AS id_secteur_activite_fonds_19,
  s0_.site_internet AS site_internet_20,
  s0_.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_21,
  s0_.mail_contact AS mail_contact_22,
  s0_.resume_activite AS resume_activite_23,
  s0_.description_activite AS description_activite_24,
  s0_.mots_cles AS mots_cles_25,
  s0_.strategie_developpement AS strategie_developpement_26,
  s0_.marge_brute_n AS marge_brute_n_27,
  s0_.resultat_exploitation_n AS resultat_exploitation_n_28,
  s0_.resultat_net_n AS resultat_net_n_29,
  s0_.ca_n AS ca_n_30,
  s0_.nb_personnes_n AS nb_personnes_n_31,
  s0_.annee_n AS annee_n_32,
  s0_.date_mise_a_jour AS date_mise_a_jour_33,
  s0_.fichier_joint AS fichier_joint_34,
  s0_.commentaire_interne AS commentaire_interne_35,
  s0_.societe_cotee AS societe_cotee_36,
  s0_.login_demande_publication AS login_demande_publication_37,
  s0_.date_relance AS date_relance_38,
  s0_.relance_mise_a_jour AS relance_mise_a_jour_39,
  s0_.numero_siren AS numero_siren_40,
  s0_.montant_total_investi AS montant_total_investi_41,
  s0_.capital_total_investisseur AS capital_total_investisseur_42,
  s0_.titre_newsletter AS titre_newsletter_43,
  s0_.resume_newsletter AS resume_newsletter_44,
  s0_.date_dernier_investissement AS date_dernier_investissement_45,
  s0_.type_profil_participation AS type_profil_participation_46,
  s0_.mode_societe AS mode_societe_47,
  s0_.utiliser_artviper AS utiliser_artviper_48,
  s0_.numero_siret AS numero_siret_49,
  s0_.code_naf AS code_naf_50,
  s0_.vignette AS vignette_51,
  s0_.vignette_small AS vignette_small_52,
  s0_.ca_n_inf AS ca_n_inf_53,
  s0_.ca_n_sup AS ca_n_sup_54,
  s0_.id_societe_mere AS id_societe_mere_55,
  s0_.date_maj_administrateur AS date_maj_administrateur_56,
  s0_.administrateur AS administrateur_57,
  s0_.etat_resume AS etat_resume_58,
  s0_.afficher_vendeur AS afficher_vendeur_59,
  s0_.afficher_acheteur AS afficher_acheteur_60
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_.afficher_vendeur = 1
  AND s0_.id_societe IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
GROUP BY
  s0_.id_societe
ORDER BY
  s0_.date_dernier_investissement DESC,
  s0_.ca_n DESC,
  s0_.id_societe DESC

SELECT s0_.id_societe AS id_societe_0, s0_.id_societe_news AS id_societe_news_1, s0_.id_participation AS id_participation_2, s0_.mode_participation AS mode_participation_3, s0_.deja_publique AS deja_publique_4, s0_.raison_sociale AS raison_sociale_5, s0_.raison_sociale_formatee AS raison_sociale_formatee_6, s0_.nom_president AS nom_president_7, s0_.nom_directeur_general AS nom_directeur_general_8, s0_.adresse AS adresse_9, s0_.ville AS ville_10, s0_.code_postal AS code_postal_11, s0_.telephone AS telephone_12, s0_.fax AS fax_13, s0_.id_pays AS id_pays_14, s0_.devise AS devise_15, s0_.id_region AS id_region_16, s0_.filiales_bureaux AS filiales_bureaux_17, s0_.id_secteur_activite AS id_secteur_activite_18, s0_.id_secteur_activite_fonds AS id_secteur_activite_fonds_19, s0_.site_internet AS site_internet_20, s0_.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_21, s0_.mail_contact AS mail_contact_22, s0_.resume_activite AS resume_activite_23, s0_.description_activite AS description_activite_24, s0_.mots_cles AS mots_cles_25, s0_.strategie_developpement AS strategie_developpement_26, s0_.marge_brute_n AS marge_brute_n_27, s0_.resultat_exploitation_n AS resultat_exploitation_n_28, s0_.resultat_net_n AS resultat_net_n_29, s0_.ca_n AS ca_n_30, s0_.nb_personnes_n AS nb_personnes_n_31, s0_.annee_n AS annee_n_32, s0_.date_mise_a_jour AS date_mise_a_jour_33, s0_.fichier_joint AS fichier_joint_34, s0_.commentaire_interne AS commentaire_interne_35, s0_.societe_cotee AS societe_cotee_36, s0_.login_demande_publication AS login_demande_publication_37, s0_.date_relance AS date_relance_38, s0_.relance_mise_a_jour AS relance_mise_a_jour_39, s0_.numero_siren AS numero_siren_40, s0_.montant_total_investi AS montant_total_investi_41, s0_.capital_total_investisseur AS capital_total_investisseur_42, s0_.titre_newsletter AS titre_newsletter_43, s0_.resume_newsletter AS resume_newsletter_44, s0_.date_dernier_investissement AS date_dernier_investissement_45, s0_.type_profil_participation AS type_profil_participation_46, s0_.mode_societe AS mode_societe_47, s0_.utiliser_artviper AS utiliser_artviper_48, s0_.numero_siret AS numero_siret_49, s0_.code_naf AS code_naf_50, s0_.vignette AS vignette_51, s0_.vignette_small AS vignette_small_52, s0_.ca_n_inf AS ca_n_inf_53, s0_.ca_n_sup AS ca_n_sup_54, s0_.id_societe_mere AS id_societe_mere_55, s0_.date_maj_administrateur AS date_maj_administrateur_56, s0_.administrateur AS administrateur_57, s0_.etat_resume AS etat_resume_58, s0_.afficher_vendeur AS afficher_vendeur_59, s0_.afficher_acheteur AS afficher_acheteur_60 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_.afficher_vendeur = 1 AND s0_.id_societe IN (4942, 29325, 29882, 30639, 4878, 2376, 4782, 4789, 4842, 33098) GROUP BY s0_.id_societe ORDER BY s0_.date_dernier_investissement DESC, s0_.ca_n DESC, s0_.id_societe DESC;

SELECT
  l0_.id_lien_participations_fonds AS id_lien_participations_fonds_0,
  l0_.id_gestionnaire_fonds AS id_gestionnaire_fonds_1,
  l0_.id_fonds AS id_fonds_2,
  l0_.id_participation AS id_participation_3,
  l0_.id_personne AS id_personne_4,
  l0_.devise AS devise_5,
  l0_.capital_detenu AS capital_detenu_6,
  l0_.montant_investi AS montant_investi_7,
  l0_.montant_investi_devise AS montant_investi_devise_8,
  l0_.date_investissement AS date_investissement_9,
  l0_.date_mise_a_jour AS date_mise_a_jour_10,
  l0_.date_relance AS date_relance_11,
  l0_.relance_mise_a_jour AS relance_mise_a_jour_12,
  l0_.mode AS mode_13,
  l0_.login_demande_publication AS login_demande_publication_14,
  l0_.nom_exact_participation AS nom_exact_participation_15,
  l0_.date_passage_robot AS date_passage_robot_16,
  l0_.trouve_par_robot AS trouve_par_robot_17,
  l0_.nom_propose_par_robot AS nom_propose_par_robot_18,
  l0_.date_sortie AS date_sortie_19,
  l0_.date_demande_publication AS date_demande_publication_20,
  s1_.id_gestionnaire_fonds AS id_gestionnaire_fonds_21,
  s1_.mode AS mode_22,
  s1_.nom_societe AS nom_societe_23,
  s1_.adresse_societe AS adresse_societe_24,
  s1_.code_postal_societe AS code_postal_societe_25,
  s1_.ville_societe AS ville_societe_26,
  s1_.site_internet AS site_internet_27,
  s1_.nom_contact AS nom_contact_28,
  s1_.mail_contact AS mail_contact_29,
  s1_.telephone AS telephone_30,
  s1_.indicatif AS indicatif_31,
  s1_.fax AS fax_32,
  s1_.id_pays AS id_pays_33,
  s1_.devise AS devise_34,
  s1_.taux_change AS taux_change_35,
  s1_.id_region AS id_region_36,
  s1_.strategie_globale_investissement AS strategie_globale_investissement_37,
  s1_.strategie_investissement_en AS strategie_investissement_en_38,
  s1_.montant_investissement_min AS montant_investissement_min_39,
  s1_.montant_investissement_max AS montant_investissement_max_40,
  s1_.montant_investissement_min_devise AS montant_investissement_min_devise_41,
  s1_.montant_investissement_max_devise AS montant_investissement_max_devise_42,
  s1_.type_investissement AS type_investissement_43,
  s1_.stade_investissement AS stade_investissement_44,
  s1_.date_relance_respo AS date_relance_respo_45,
  s1_.date_valide_respo AS date_valide_respo_46,
  s1_.id_secteur_activite AS id_secteur_activite_47,
  s1_.mail_respon_maj AS mail_respon_maj_48,
  s1_.pays_ciblees AS pays_ciblees_49,
  s1_.regions_ciblees AS regions_ciblees_50,
  s1_.mail_maj_participation AS mail_maj_participation_51,
  s1_.date_relance_participation AS date_relance_participation_52,
  s1_.date_maj_responsable_participation AS date_maj_responsable_participation_53,
  s1_.date_action AS date_action_54,
  s1_.precision_nom AS precision_nom_55,
  s1_.id_gestionnaire_pere AS id_gestionnaire_pere_56,
  s1_.investissement_international AS investissement_international_57,
  s1_.repondu_international AS repondu_international_58,
  s1_.langue_utilisee AS langue_utilisee_59,
  s1_.utiliser_artviper AS utiliser_artviper_60
FROM
  fusacq_dbo.lien_participations_fonds l0_
  INNER JOIN fusacq_dbo.societe_gestionnaire_fonds s1_ ON (
    s1_.id_gestionnaire_fonds = l0_.id_gestionnaire_fonds
  )
WHERE
  l0_.id_participation = ?
  AND l0_.mode <> 'radie'
  AND l0_.mode <> 'sortie'
ORDER BY
  l0_.date_investissement DESC

SELECT l0_.id_lien_participations_fonds AS id_lien_participations_fonds_0, l0_.id_gestionnaire_fonds AS id_gestionnaire_fonds_1, l0_.id_fonds AS id_fonds_2, l0_.id_participation AS id_participation_3, l0_.id_personne AS id_personne_4, l0_.devise AS devise_5, l0_.capital_detenu AS capital_detenu_6, l0_.montant_investi AS montant_investi_7, l0_.montant_investi_devise AS montant_investi_devise_8, l0_.date_investissement AS date_investissement_9, l0_.date_mise_a_jour AS date_mise_a_jour_10, l0_.date_relance AS date_relance_11, l0_.relance_mise_a_jour AS relance_mise_a_jour_12, l0_.mode AS mode_13, l0_.login_demande_publication AS login_demande_publication_14, l0_.nom_exact_participation AS nom_exact_participation_15, l0_.date_passage_robot AS date_passage_robot_16, l0_.trouve_par_robot AS trouve_par_robot_17, l0_.nom_propose_par_robot AS nom_propose_par_robot_18, l0_.date_sortie AS date_sortie_19, l0_.date_demande_publication AS date_demande_publication_20, s1_.id_gestionnaire_fonds AS id_gestionnaire_fonds_21, s1_.mode AS mode_22, s1_.nom_societe AS nom_societe_23, s1_.adresse_societe AS adresse_societe_24, s1_.code_postal_societe AS code_postal_societe_25, s1_.ville_societe AS ville_societe_26, s1_.site_internet AS site_internet_27, s1_.nom_contact AS nom_contact_28, s1_.mail_contact AS mail_contact_29, s1_.telephone AS telephone_30, s1_.indicatif AS indicatif_31, s1_.fax AS fax_32, s1_.id_pays AS id_pays_33, s1_.devise AS devise_34, s1_.taux_change AS taux_change_35, s1_.id_region AS id_region_36, s1_.strategie_globale_investissement AS strategie_globale_investissement_37, s1_.strategie_investissement_en AS strategie_investissement_en_38, s1_.montant_investissement_min AS montant_investissement_min_39, s1_.montant_investissement_max AS montant_investissement_max_40, s1_.montant_investissement_min_devise AS montant_investissement_min_devise_41, s1_.montant_investissement_max_devise AS montant_investissement_max_devise_42, s1_.type_investissement AS type_investissement_43, s1_.stade_investissement AS stade_investissement_44, s1_.date_relance_respo AS date_relance_respo_45, s1_.date_valide_respo AS date_valide_respo_46, s1_.id_secteur_activite AS id_secteur_activite_47, s1_.mail_respon_maj AS mail_respon_maj_48, s1_.pays_ciblees AS pays_ciblees_49, s1_.regions_ciblees AS regions_ciblees_50, s1_.mail_maj_participation AS mail_maj_participation_51, s1_.date_relance_participation AS date_relance_participation_52, s1_.date_maj_responsable_participation AS date_maj_responsable_participation_53, s1_.date_action AS date_action_54, s1_.precision_nom AS precision_nom_55, s1_.id_gestionnaire_pere AS id_gestionnaire_pere_56, s1_.investissement_international AS investissement_international_57, s1_.repondu_international AS repondu_international_58, s1_.langue_utilisee AS langue_utilisee_59, s1_.utiliser_artviper AS utiliser_artviper_60 FROM fusacq_dbo.lien_participations_fonds l0_ INNER JOIN fusacq_dbo.societe_gestionnaire_fonds s1_ ON (s1_.id_gestionnaire_fonds = l0_.id_gestionnaire_fonds) WHERE l0_.id_participation = 4942 AND l0_.mode <> 'radie' AND l0_.mode <> 'sortie' ORDER BY l0_.date_investissement DESC;

SELECT
  l0_.id_lien_participations_fonds AS id_lien_participations_fonds_0,
  l0_.id_gestionnaire_fonds AS id_gestionnaire_fonds_1,
  l0_.id_fonds AS id_fonds_2,
  l0_.id_participation AS id_participation_3,
  l0_.id_personne AS id_personne_4,
  l0_.devise AS devise_5,
  l0_.capital_detenu AS capital_detenu_6,
  l0_.montant_investi AS montant_investi_7,
  l0_.montant_investi_devise AS montant_investi_devise_8,
  l0_.date_investissement AS date_investissement_9,
  l0_.date_mise_a_jour AS date_mise_a_jour_10,
  l0_.date_relance AS date_relance_11,
  l0_.relance_mise_a_jour AS relance_mise_a_jour_12,
  l0_.mode AS mode_13,
  l0_.login_demande_publication AS login_demande_publication_14,
  l0_.nom_exact_participation AS nom_exact_participation_15,
  l0_.date_passage_robot AS date_passage_robot_16,
  l0_.trouve_par_robot AS trouve_par_robot_17,
  l0_.nom_propose_par_robot AS nom_propose_par_robot_18,
  l0_.date_sortie AS date_sortie_19,
  l0_.date_demande_publication AS date_demande_publication_20,
  s1_.id_gestionnaire_fonds AS id_gestionnaire_fonds_21,
  s1_.mode AS mode_22,
  s1_.nom_societe AS nom_societe_23,
  s1_.adresse_societe AS adresse_societe_24,
  s1_.code_postal_societe AS code_postal_societe_25,
  s1_.ville_societe AS ville_societe_26,
  s1_.site_internet AS site_internet_27,
  s1_.nom_contact AS nom_contact_28,
  s1_.mail_contact AS mail_contact_29,
  s1_.telephone AS telephone_30,
  s1_.indicatif AS indicatif_31,
  s1_.fax AS fax_32,
  s1_.id_pays AS id_pays_33,
  s1_.devise AS devise_34,
  s1_.taux_change AS taux_change_35,
  s1_.id_region AS id_region_36,
  s1_.strategie_globale_investissement AS strategie_globale_investissement_37,
  s1_.strategie_investissement_en AS strategie_investissement_en_38,
  s1_.montant_investissement_min AS montant_investissement_min_39,
  s1_.montant_investissement_max AS montant_investissement_max_40,
  s1_.montant_investissement_min_devise AS montant_investissement_min_devise_41,
  s1_.montant_investissement_max_devise AS montant_investissement_max_devise_42,
  s1_.type_investissement AS type_investissement_43,
  s1_.stade_investissement AS stade_investissement_44,
  s1_.date_relance_respo AS date_relance_respo_45,
  s1_.date_valide_respo AS date_valide_respo_46,
  s1_.id_secteur_activite AS id_secteur_activite_47,
  s1_.mail_respon_maj AS mail_respon_maj_48,
  s1_.pays_ciblees AS pays_ciblees_49,
  s1_.regions_ciblees AS regions_ciblees_50,
  s1_.mail_maj_participation AS mail_maj_participation_51,
  s1_.date_relance_participation AS date_relance_participation_52,
  s1_.date_maj_responsable_participation AS date_maj_responsable_participation_53,
  s1_.date_action AS date_action_54,
  s1_.precision_nom AS precision_nom_55,
  s1_.id_gestionnaire_pere AS id_gestionnaire_pere_56,
  s1_.investissement_international AS investissement_international_57,
  s1_.repondu_international AS repondu_international_58,
  s1_.langue_utilisee AS langue_utilisee_59,
  s1_.utiliser_artviper AS utiliser_artviper_60
FROM
  fusacq_dbo.lien_participations_fonds l0_
  INNER JOIN fusacq_dbo.societe_gestionnaire_fonds s1_ ON (
    s1_.id_gestionnaire_fonds = l0_.id_gestionnaire_fonds
  )
WHERE
  l0_.id_participation = ?
  AND l0_.mode <> 'radie'
  AND l0_.mode <> 'sortie'
ORDER BY
  l0_.date_investissement DESC

SELECT l0_.id_lien_participations_fonds AS id_lien_participations_fonds_0, l0_.id_gestionnaire_fonds AS id_gestionnaire_fonds_1, l0_.id_fonds AS id_fonds_2, l0_.id_participation AS id_participation_3, l0_.id_personne AS id_personne_4, l0_.devise AS devise_5, l0_.capital_detenu AS capital_detenu_6, l0_.montant_investi AS montant_investi_7, l0_.montant_investi_devise AS montant_investi_devise_8, l0_.date_investissement AS date_investissement_9, l0_.date_mise_a_jour AS date_mise_a_jour_10, l0_.date_relance AS date_relance_11, l0_.relance_mise_a_jour AS relance_mise_a_jour_12, l0_.mode AS mode_13, l0_.login_demande_publication AS login_demande_publication_14, l0_.nom_exact_participation AS nom_exact_participation_15, l0_.date_passage_robot AS date_passage_robot_16, l0_.trouve_par_robot AS trouve_par_robot_17, l0_.nom_propose_par_robot AS nom_propose_par_robot_18, l0_.date_sortie AS date_sortie_19, l0_.date_demande_publication AS date_demande_publication_20, s1_.id_gestionnaire_fonds AS id_gestionnaire_fonds_21, s1_.mode AS mode_22, s1_.nom_societe AS nom_societe_23, s1_.adresse_societe AS adresse_societe_24, s1_.code_postal_societe AS code_postal_societe_25, s1_.ville_societe AS ville_societe_26, s1_.site_internet AS site_internet_27, s1_.nom_contact AS nom_contact_28, s1_.mail_contact AS mail_contact_29, s1_.telephone AS telephone_30, s1_.indicatif AS indicatif_31, s1_.fax AS fax_32, s1_.id_pays AS id_pays_33, s1_.devise AS devise_34, s1_.taux_change AS taux_change_35, s1_.id_region AS id_region_36, s1_.strategie_globale_investissement AS strategie_globale_investissement_37, s1_.strategie_investissement_en AS strategie_investissement_en_38, s1_.montant_investissement_min AS montant_investissement_min_39, s1_.montant_investissement_max AS montant_investissement_max_40, s1_.montant_investissement_min_devise AS montant_investissement_min_devise_41, s1_.montant_investissement_max_devise AS montant_investissement_max_devise_42, s1_.type_investissement AS type_investissement_43, s1_.stade_investissement AS stade_investissement_44, s1_.date_relance_respo AS date_relance_respo_45, s1_.date_valide_respo AS date_valide_respo_46, s1_.id_secteur_activite AS id_secteur_activite_47, s1_.mail_respon_maj AS mail_respon_maj_48, s1_.pays_ciblees AS pays_ciblees_49, s1_.regions_ciblees AS regions_ciblees_50, s1_.mail_maj_participation AS mail_maj_participation_51, s1_.date_relance_participation AS date_relance_participation_52, s1_.date_maj_responsable_participation AS date_maj_responsable_participation_53, s1_.date_action AS date_action_54, s1_.precision_nom AS precision_nom_55, s1_.id_gestionnaire_pere AS id_gestionnaire_pere_56, s1_.investissement_international AS investissement_international_57, s1_.repondu_international AS repondu_international_58, s1_.langue_utilisee AS langue_utilisee_59, s1_.utiliser_artviper AS utiliser_artviper_60 FROM fusacq_dbo.lien_participations_fonds l0_ INNER JOIN fusacq_dbo.societe_gestionnaire_fonds s1_ ON (s1_.id_gestionnaire_fonds = l0_.id_gestionnaire_fonds) WHERE l0_.id_participation = 29325 AND l0_.mode <> 'radie' AND l0_.mode <> 'sortie' ORDER BY l0_.date_investissement DESC;

SELECT
  l0_.id_lien_participations_fonds AS id_lien_participations_fonds_0,
  l0_.id_gestionnaire_fonds AS id_gestionnaire_fonds_1,
  l0_.id_fonds AS id_fonds_2,
  l0_.id_participation AS id_participation_3,
  l0_.id_personne AS id_personne_4,
  l0_.devise AS devise_5,
  l0_.capital_detenu AS capital_detenu_6,
  l0_.montant_investi AS montant_investi_7,
  l0_.montant_investi_devise AS montant_investi_devise_8,
  l0_.date_investissement AS date_investissement_9,
  l0_.date_mise_a_jour AS date_mise_a_jour_10,
  l0_.date_relance AS date_relance_11,
  l0_.relance_mise_a_jour AS relance_mise_a_jour_12,
  l0_.mode AS mode_13,
  l0_.login_demande_publication AS login_demande_publication_14,
  l0_.nom_exact_participation AS nom_exact_participation_15,
  l0_.date_passage_robot AS date_passage_robot_16,
  l0_.trouve_par_robot AS trouve_par_robot_17,
  l0_.nom_propose_par_robot AS nom_propose_par_robot_18,
  l0_.date_sortie AS date_sortie_19,
  l0_.date_demande_publication AS date_demande_publication_20,
  s1_.id_gestionnaire_fonds AS id_gestionnaire_fonds_21,
  s1_.mode AS mode_22,
  s1_.nom_societe AS nom_societe_23,
  s1_.adresse_societe AS adresse_societe_24,
  s1_.code_postal_societe AS code_postal_societe_25,
  s1_.ville_societe AS ville_societe_26,
  s1_.site_internet AS site_internet_27,
  s1_.nom_contact AS nom_contact_28,
  s1_.mail_contact AS mail_contact_29,
  s1_.telephone AS telephone_30,
  s1_.indicatif AS indicatif_31,
  s1_.fax AS fax_32,
  s1_.id_pays AS id_pays_33,
  s1_.devise AS devise_34,
  s1_.taux_change AS taux_change_35,
  s1_.id_region AS id_region_36,
  s1_.strategie_globale_investissement AS strategie_globale_investissement_37,
  s1_.strategie_investissement_en AS strategie_investissement_en_38,
  s1_.montant_investissement_min AS montant_investissement_min_39,
  s1_.montant_investissement_max AS montant_investissement_max_40,
  s1_.montant_investissement_min_devise AS montant_investissement_min_devise_41,
  s1_.montant_investissement_max_devise AS montant_investissement_max_devise_42,
  s1_.type_investissement AS type_investissement_43,
  s1_.stade_investissement AS stade_investissement_44,
  s1_.date_relance_respo AS date_relance_respo_45,
  s1_.date_valide_respo AS date_valide_respo_46,
  s1_.id_secteur_activite AS id_secteur_activite_47,
  s1_.mail_respon_maj AS mail_respon_maj_48,
  s1_.pays_ciblees AS pays_ciblees_49,
  s1_.regions_ciblees AS regions_ciblees_50,
  s1_.mail_maj_participation AS mail_maj_participation_51,
  s1_.date_relance_participation AS date_relance_participation_52,
  s1_.date_maj_responsable_participation AS date_maj_responsable_participation_53,
  s1_.date_action AS date_action_54,
  s1_.precision_nom AS precision_nom_55,
  s1_.id_gestionnaire_pere AS id_gestionnaire_pere_56,
  s1_.investissement_international AS investissement_international_57,
  s1_.repondu_international AS repondu_international_58,
  s1_.langue_utilisee AS langue_utilisee_59,
  s1_.utiliser_artviper AS utiliser_artviper_60
FROM
  fusacq_dbo.lien_participations_fonds l0_
  INNER JOIN fusacq_dbo.societe_gestionnaire_fonds s1_ ON (
    s1_.id_gestionnaire_fonds = l0_.id_gestionnaire_fonds
  )
WHERE
  l0_.id_participation = ?
  AND l0_.mode <> 'radie'
  AND l0_.mode <> 'sortie'
ORDER BY
  l0_.date_investissement DESC

SELECT l0_.id_lien_participations_fonds AS id_lien_participations_fonds_0, l0_.id_gestionnaire_fonds AS id_gestionnaire_fonds_1, l0_.id_fonds AS id_fonds_2, l0_.id_participation AS id_participation_3, l0_.id_personne AS id_personne_4, l0_.devise AS devise_5, l0_.capital_detenu AS capital_detenu_6, l0_.montant_investi AS montant_investi_7, l0_.montant_investi_devise AS montant_investi_devise_8, l0_.date_investissement AS date_investissement_9, l0_.date_mise_a_jour AS date_mise_a_jour_10, l0_.date_relance AS date_relance_11, l0_.relance_mise_a_jour AS relance_mise_a_jour_12, l0_.mode AS mode_13, l0_.login_demande_publication AS login_demande_publication_14, l0_.nom_exact_participation AS nom_exact_participation_15, l0_.date_passage_robot AS date_passage_robot_16, l0_.trouve_par_robot AS trouve_par_robot_17, l0_.nom_propose_par_robot AS nom_propose_par_robot_18, l0_.date_sortie AS date_sortie_19, l0_.date_demande_publication AS date_demande_publication_20, s1_.id_gestionnaire_fonds AS id_gestionnaire_fonds_21, s1_.mode AS mode_22, s1_.nom_societe AS nom_societe_23, s1_.adresse_societe AS adresse_societe_24, s1_.code_postal_societe AS code_postal_societe_25, s1_.ville_societe AS ville_societe_26, s1_.site_internet AS site_internet_27, s1_.nom_contact AS nom_contact_28, s1_.mail_contact AS mail_contact_29, s1_.telephone AS telephone_30, s1_.indicatif AS indicatif_31, s1_.fax AS fax_32, s1_.id_pays AS id_pays_33, s1_.devise AS devise_34, s1_.taux_change AS taux_change_35, s1_.id_region AS id_region_36, s1_.strategie_globale_investissement AS strategie_globale_investissement_37, s1_.strategie_investissement_en AS strategie_investissement_en_38, s1_.montant_investissement_min AS montant_investissement_min_39, s1_.montant_investissement_max AS montant_investissement_max_40, s1_.montant_investissement_min_devise AS montant_investissement_min_devise_41, s1_.montant_investissement_max_devise AS montant_investissement_max_devise_42, s1_.type_investissement AS type_investissement_43, s1_.stade_investissement AS stade_investissement_44, s1_.date_relance_respo AS date_relance_respo_45, s1_.date_valide_respo AS date_valide_respo_46, s1_.id_secteur_activite AS id_secteur_activite_47, s1_.mail_respon_maj AS mail_respon_maj_48, s1_.pays_ciblees AS pays_ciblees_49, s1_.regions_ciblees AS regions_ciblees_50, s1_.mail_maj_participation AS mail_maj_participation_51, s1_.date_relance_participation AS date_relance_participation_52, s1_.date_maj_responsable_participation AS date_maj_responsable_participation_53, s1_.date_action AS date_action_54, s1_.precision_nom AS precision_nom_55, s1_.id_gestionnaire_pere AS id_gestionnaire_pere_56, s1_.investissement_international AS investissement_international_57, s1_.repondu_international AS repondu_international_58, s1_.langue_utilisee AS langue_utilisee_59, s1_.utiliser_artviper AS utiliser_artviper_60 FROM fusacq_dbo.lien_participations_fonds l0_ INNER JOIN fusacq_dbo.societe_gestionnaire_fonds s1_ ON (s1_.id_gestionnaire_fonds = l0_.id_gestionnaire_fonds) WHERE l0_.id_participation = 29882 AND l0_.mode <> 'radie' AND l0_.mode <> 'sortie' ORDER BY l0_.date_investissement DESC;

SELECT
  l0_.id_lien_participations_fonds AS id_lien_participations_fonds_0,
  l0_.id_gestionnaire_fonds AS id_gestionnaire_fonds_1,
  l0_.id_fonds AS id_fonds_2,
  l0_.id_participation AS id_participation_3,
  l0_.id_personne AS id_personne_4,
  l0_.devise AS devise_5,
  l0_.capital_detenu AS capital_detenu_6,
  l0_.montant_investi AS montant_investi_7,
  l0_.montant_investi_devise AS montant_investi_devise_8,
  l0_.date_investissement AS date_investissement_9,
  l0_.date_mise_a_jour AS date_mise_a_jour_10,
  l0_.date_relance AS date_relance_11,
  l0_.relance_mise_a_jour AS relance_mise_a_jour_12,
  l0_.mode AS mode_13,
  l0_.login_demande_publication AS login_demande_publication_14,
  l0_.nom_exact_participation AS nom_exact_participation_15,
  l0_.date_passage_robot AS date_passage_robot_16,
  l0_.trouve_par_robot AS trouve_par_robot_17,
  l0_.nom_propose_par_robot AS nom_propose_par_robot_18,
  l0_.date_sortie AS date_sortie_19,
  l0_.date_demande_publication AS date_demande_publication_20,
  s1_.id_gestionnaire_fonds AS id_gestionnaire_fonds_21,
  s1_.mode AS mode_22,
  s1_.nom_societe AS nom_societe_23,
  s1_.adresse_societe AS adresse_societe_24,
  s1_.code_postal_societe AS code_postal_societe_25,
  s1_.ville_societe AS ville_societe_26,
  s1_.site_internet AS site_internet_27,
  s1_.nom_contact AS nom_contact_28,
  s1_.mail_contact AS mail_contact_29,
  s1_.telephone AS telephone_30,
  s1_.indicatif AS indicatif_31,
  s1_.fax AS fax_32,
  s1_.id_pays AS id_pays_33,
  s1_.devise AS devise_34,
  s1_.taux_change AS taux_change_35,
  s1_.id_region AS id_region_36,
  s1_.strategie_globale_investissement AS strategie_globale_investissement_37,
  s1_.strategie_investissement_en AS strategie_investissement_en_38,
  s1_.montant_investissement_min AS montant_investissement_min_39,
  s1_.montant_investissement_max AS montant_investissement_max_40,
  s1_.montant_investissement_min_devise AS montant_investissement_min_devise_41,
  s1_.montant_investissement_max_devise AS montant_investissement_max_devise_42,
  s1_.type_investissement AS type_investissement_43,
  s1_.stade_investissement AS stade_investissement_44,
  s1_.date_relance_respo AS date_relance_respo_45,
  s1_.date_valide_respo AS date_valide_respo_46,
  s1_.id_secteur_activite AS id_secteur_activite_47,
  s1_.mail_respon_maj AS mail_respon_maj_48,
  s1_.pays_ciblees AS pays_ciblees_49,
  s1_.regions_ciblees AS regions_ciblees_50,
  s1_.mail_maj_participation AS mail_maj_participation_51,
  s1_.date_relance_participation AS date_relance_participation_52,
  s1_.date_maj_responsable_participation AS date_maj_responsable_participation_53,
  s1_.date_action AS date_action_54,
  s1_.precision_nom AS precision_nom_55,
  s1_.id_gestionnaire_pere AS id_gestionnaire_pere_56,
  s1_.investissement_international AS investissement_international_57,
  s1_.repondu_international AS repondu_international_58,
  s1_.langue_utilisee AS langue_utilisee_59,
  s1_.utiliser_artviper AS utiliser_artviper_60
FROM
  fusacq_dbo.lien_participations_fonds l0_
  INNER JOIN fusacq_dbo.societe_gestionnaire_fonds s1_ ON (
    s1_.id_gestionnaire_fonds = l0_.id_gestionnaire_fonds
  )
WHERE
  l0_.id_participation = ?
  AND l0_.mode <> 'radie'
  AND l0_.mode <> 'sortie'
ORDER BY
  l0_.date_investissement DESC

SELECT l0_.id_lien_participations_fonds AS id_lien_participations_fonds_0, l0_.id_gestionnaire_fonds AS id_gestionnaire_fonds_1, l0_.id_fonds AS id_fonds_2, l0_.id_participation AS id_participation_3, l0_.id_personne AS id_personne_4, l0_.devise AS devise_5, l0_.capital_detenu AS capital_detenu_6, l0_.montant_investi AS montant_investi_7, l0_.montant_investi_devise AS montant_investi_devise_8, l0_.date_investissement AS date_investissement_9, l0_.date_mise_a_jour AS date_mise_a_jour_10, l0_.date_relance AS date_relance_11, l0_.relance_mise_a_jour AS relance_mise_a_jour_12, l0_.mode AS mode_13, l0_.login_demande_publication AS login_demande_publication_14, l0_.nom_exact_participation AS nom_exact_participation_15, l0_.date_passage_robot AS date_passage_robot_16, l0_.trouve_par_robot AS trouve_par_robot_17, l0_.nom_propose_par_robot AS nom_propose_par_robot_18, l0_.date_sortie AS date_sortie_19, l0_.date_demande_publication AS date_demande_publication_20, s1_.id_gestionnaire_fonds AS id_gestionnaire_fonds_21, s1_.mode AS mode_22, s1_.nom_societe AS nom_societe_23, s1_.adresse_societe AS adresse_societe_24, s1_.code_postal_societe AS code_postal_societe_25, s1_.ville_societe AS ville_societe_26, s1_.site_internet AS site_internet_27, s1_.nom_contact AS nom_contact_28, s1_.mail_contact AS mail_contact_29, s1_.telephone AS telephone_30, s1_.indicatif AS indicatif_31, s1_.fax AS fax_32, s1_.id_pays AS id_pays_33, s1_.devise AS devise_34, s1_.taux_change AS taux_change_35, s1_.id_region AS id_region_36, s1_.strategie_globale_investissement AS strategie_globale_investissement_37, s1_.strategie_investissement_en AS strategie_investissement_en_38, s1_.montant_investissement_min AS montant_investissement_min_39, s1_.montant_investissement_max AS montant_investissement_max_40, s1_.montant_investissement_min_devise AS montant_investissement_min_devise_41, s1_.montant_investissement_max_devise AS montant_investissement_max_devise_42, s1_.type_investissement AS type_investissement_43, s1_.stade_investissement AS stade_investissement_44, s1_.date_relance_respo AS date_relance_respo_45, s1_.date_valide_respo AS date_valide_respo_46, s1_.id_secteur_activite AS id_secteur_activite_47, s1_.mail_respon_maj AS mail_respon_maj_48, s1_.pays_ciblees AS pays_ciblees_49, s1_.regions_ciblees AS regions_ciblees_50, s1_.mail_maj_participation AS mail_maj_participation_51, s1_.date_relance_participation AS date_relance_participation_52, s1_.date_maj_responsable_participation AS date_maj_responsable_participation_53, s1_.date_action AS date_action_54, s1_.precision_nom AS precision_nom_55, s1_.id_gestionnaire_pere AS id_gestionnaire_pere_56, s1_.investissement_international AS investissement_international_57, s1_.repondu_international AS repondu_international_58, s1_.langue_utilisee AS langue_utilisee_59, s1_.utiliser_artviper AS utiliser_artviper_60 FROM fusacq_dbo.lien_participations_fonds l0_ INNER JOIN fusacq_dbo.societe_gestionnaire_fonds s1_ ON (s1_.id_gestionnaire_fonds = l0_.id_gestionnaire_fonds) WHERE l0_.id_participation = 30639 AND l0_.mode <> 'radie' AND l0_.mode <> 'sortie' ORDER BY l0_.date_investissement DESC;