Symfony Profiler

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

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
GROUP BY
  s0_.id_societe
ORDER BY
  s0_.ca_n DESC,
  s0_.date_dernier_investissement DESC,
  s0_.id_societe DESC
LIMIT
  1 OFFSET 1

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 GROUP BY s0_.id_societe ORDER BY s0_.ca_n DESC, s0_.date_dernier_investissement DESC, s0_.id_societe DESC LIMIT 1 OFFSET 1;

SELECT
  s0_.raison_sociale AS raison_sociale_0,
  s0_.id_societe AS id_societe_1,
  l1_.id_gestionnaire_fonds AS id_gestionnaire_fonds_2
FROM
  fusacq_dbo.societes s0_
  LEFT JOIN fusacq_dbo.lien_participations_fonds l1_ ON (
    s0_.id_societe = l1_.id_participation
  )
WHERE
  s0_.id_societe = ?
  AND l1_.id_gestionnaire_fonds <> ?
LIMIT
  10000

SELECT s0_.raison_sociale AS raison_sociale_0, s0_.id_societe AS id_societe_1, l1_.id_gestionnaire_fonds AS id_gestionnaire_fonds_2 FROM fusacq_dbo.societes s0_ LEFT JOIN fusacq_dbo.lien_participations_fonds l1_ ON (s0_.id_societe = l1_.id_participation) WHERE s0_.id_societe = '27186' AND l1_.id_gestionnaire_fonds <> 'null' LIMIT 10000;

SELECT
  t0.id_societe AS id_societe_1,
  t0.id_societe_news AS id_societe_news_2,
  t0.id_participation AS id_participation_3,
  t0.mode_participation AS mode_participation_4,
  t0.deja_publique AS deja_publique_5,
  t0.raison_sociale AS raison_sociale_6,
  t0.raison_sociale_formatee AS raison_sociale_formatee_7,
  t0.nom_president AS nom_president_8,
  t0.nom_directeur_general AS nom_directeur_general_9,
  t0.adresse AS adresse_10,
  t0.ville AS ville_11,
  t0.code_postal AS code_postal_12,
  t0.telephone AS telephone_13,
  t0.fax AS fax_14,
  t0.id_pays AS id_pays_15,
  t0.devise AS devise_16,
  t0.id_region AS id_region_17,
  t0.filiales_bureaux AS filiales_bureaux_18,
  t0.id_secteur_activite AS id_secteur_activite_19,
  t0.id_secteur_activite_fonds AS id_secteur_activite_fonds_20,
  t0.site_internet AS site_internet_21,
  t0.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_22,
  t0.mail_contact AS mail_contact_23,
  t0.resume_activite AS resume_activite_24,
  t0.description_activite AS description_activite_25,
  t0.mots_cles AS mots_cles_26,
  t0.strategie_developpement AS strategie_developpement_27,
  t0.marge_brute_n AS marge_brute_n_28,
  t0.resultat_exploitation_n AS resultat_exploitation_n_29,
  t0.resultat_net_n AS resultat_net_n_30,
  t0.ca_n AS ca_n_31,
  t0.nb_personnes_n AS nb_personnes_n_32,
  t0.annee_n AS annee_n_33,
  t0.date_mise_a_jour AS date_mise_a_jour_34,
  t0.fichier_joint AS fichier_joint_35,
  t0.commentaire_interne AS commentaire_interne_36,
  t0.societe_cotee AS societe_cotee_37,
  t0.login_demande_publication AS login_demande_publication_38,
  t0.date_relance AS date_relance_39,
  t0.relance_mise_a_jour AS relance_mise_a_jour_40,
  t0.numero_siren AS numero_siren_41,
  t0.montant_total_investi AS montant_total_investi_42,
  t0.capital_total_investisseur AS capital_total_investisseur_43,
  t0.titre_newsletter AS titre_newsletter_44,
  t0.resume_newsletter AS resume_newsletter_45,
  t0.date_dernier_investissement AS date_dernier_investissement_46,
  t0.type_profil_participation AS type_profil_participation_47,
  t0.mode_societe AS mode_societe_48,
  t0.utiliser_artviper AS utiliser_artviper_49,
  t0.numero_siret AS numero_siret_50,
  t0.code_naf AS code_naf_51,
  t0.vignette AS vignette_52,
  t0.vignette_small AS vignette_small_53,
  t0.ca_n_inf AS ca_n_inf_54,
  t0.ca_n_sup AS ca_n_sup_55,
  t0.id_societe_mere AS id_societe_mere_56,
  t0.date_maj_administrateur AS date_maj_administrateur_57,
  t0.administrateur AS administrateur_58,
  t0.etat_resume AS etat_resume_59,
  t0.afficher_vendeur AS afficher_vendeur_60,
  t0.afficher_acheteur AS afficher_acheteur_61
FROM
  fusacq_dbo.societes t0
WHERE
  t0.id_societe = ?
LIMIT
  1

SELECT t0.id_societe AS id_societe_1, t0.id_societe_news AS id_societe_news_2, t0.id_participation AS id_participation_3, t0.mode_participation AS mode_participation_4, t0.deja_publique AS deja_publique_5, t0.raison_sociale AS raison_sociale_6, t0.raison_sociale_formatee AS raison_sociale_formatee_7, t0.nom_president AS nom_president_8, t0.nom_directeur_general AS nom_directeur_general_9, t0.adresse AS adresse_10, t0.ville AS ville_11, t0.code_postal AS code_postal_12, t0.telephone AS telephone_13, t0.fax AS fax_14, t0.id_pays AS id_pays_15, t0.devise AS devise_16, t0.id_region AS id_region_17, t0.filiales_bureaux AS filiales_bureaux_18, t0.id_secteur_activite AS id_secteur_activite_19, t0.id_secteur_activite_fonds AS id_secteur_activite_fonds_20, t0.site_internet AS site_internet_21, t0.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_22, t0.mail_contact AS mail_contact_23, t0.resume_activite AS resume_activite_24, t0.description_activite AS description_activite_25, t0.mots_cles AS mots_cles_26, t0.strategie_developpement AS strategie_developpement_27, t0.marge_brute_n AS marge_brute_n_28, t0.resultat_exploitation_n AS resultat_exploitation_n_29, t0.resultat_net_n AS resultat_net_n_30, t0.ca_n AS ca_n_31, t0.nb_personnes_n AS nb_personnes_n_32, t0.annee_n AS annee_n_33, t0.date_mise_a_jour AS date_mise_a_jour_34, t0.fichier_joint AS fichier_joint_35, t0.commentaire_interne AS commentaire_interne_36, t0.societe_cotee AS societe_cotee_37, t0.login_demande_publication AS login_demande_publication_38, t0.date_relance AS date_relance_39, t0.relance_mise_a_jour AS relance_mise_a_jour_40, t0.numero_siren AS numero_siren_41, t0.montant_total_investi AS montant_total_investi_42, t0.capital_total_investisseur AS capital_total_investisseur_43, t0.titre_newsletter AS titre_newsletter_44, t0.resume_newsletter AS resume_newsletter_45, t0.date_dernier_investissement AS date_dernier_investissement_46, t0.type_profil_participation AS type_profil_participation_47, t0.mode_societe AS mode_societe_48, t0.utiliser_artviper AS utiliser_artviper_49, t0.numero_siret AS numero_siret_50, t0.code_naf AS code_naf_51, t0.vignette AS vignette_52, t0.vignette_small AS vignette_small_53, t0.ca_n_inf AS ca_n_inf_54, t0.ca_n_sup AS ca_n_sup_55, t0.id_societe_mere AS id_societe_mere_56, t0.date_maj_administrateur AS date_maj_administrateur_57, t0.administrateur AS administrateur_58, t0.etat_resume AS etat_resume_59, t0.afficher_vendeur AS afficher_vendeur_60, t0.afficher_acheteur AS afficher_acheteur_61 FROM fusacq_dbo.societes t0 WHERE t0.id_societe = '27186' LIMIT 1;

SELECT
  DISTINCT b0_.id_operation AS id_operation_0,
  b1_.id_actualite AS id_actualite_1,
  b2_.id_actualite_principale AS id_actualite_principale_2,
  b1_.date_mise_en_ligne AS date_mise_en_ligne_3,
  b1_.titre_actualite AS titre_actualite_4,
  b1_.provenance_flux_actualite AS provenance_flux_actualite_5,
  b1_.autorisation_blog AS autorisation_blog_6
FROM
  fusacq_dbo.buzz_roles b0_
  LEFT JOIN fusacq_dbo.buzz_operations b2_ ON (
    b0_.id_operation = b2_.id_operation
  )
  LEFT JOIN fusacq_dbo.buzz_actualites b1_ ON (
    b0_.id_operation = b1_.id_operation
  )
WHERE
  (
    (
      b0_.id_acteur = ?
      AND b0_.table_sql_acteur = 'societes_news'
    )
    OR (
      b0_.id_acteur_passif = ?
      AND b0_.table_sql_acteur_passif = 'societes_news'
    )
  )
  AND b1_.mode_actualite = 'publique'
  AND b1_.date_mise_en_ligne <= 20260403161211
ORDER BY
  b1_.date_mise_en_ligne DESC

SELECT DISTINCT b0_.id_operation AS id_operation_0, b1_.id_actualite AS id_actualite_1, b2_.id_actualite_principale AS id_actualite_principale_2, b1_.date_mise_en_ligne AS date_mise_en_ligne_3, b1_.titre_actualite AS titre_actualite_4, b1_.provenance_flux_actualite AS provenance_flux_actualite_5, b1_.autorisation_blog AS autorisation_blog_6 FROM fusacq_dbo.buzz_roles b0_ LEFT JOIN fusacq_dbo.buzz_operations b2_ ON (b0_.id_operation = b2_.id_operation) LEFT JOIN fusacq_dbo.buzz_actualites b1_ ON (b0_.id_operation = b1_.id_operation) WHERE ((b0_.id_acteur = 27186 AND b0_.table_sql_acteur = 'societes_news') OR (b0_.id_acteur_passif = 27186 AND b0_.table_sql_acteur_passif = 'societes_news')) AND b1_.mode_actualite = 'publique' AND b1_.date_mise_en_ligne <= 20260403161211 ORDER BY b1_.date_mise_en_ligne 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 = '27186' 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'
    OR 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 = '27186' AND (l0_.mode = 'radie' OR l0_.mode = 'sortie') ORDER BY l0_.date_investissement DESC;