| 1 |
21.17 ms |
SELECT t0.id_valorisation AS id_valorisation_1, t0.id_annonce_vendeur AS id_annonce_vendeur_2, t0.id_secteur_activite AS id_secteur_activite_3, t0.login_deposant AS login_deposant_4, t0.mode AS mode_5, t0.date_modification AS date_modification_6, t0.date_mise_en_ligne AS date_mise_en_ligne_7, t0.deja_publique AS deja_publique_8, t0.numero_siret AS numero_siret_9, t0.numero_siren AS numero_siren_10, t0.date_creation_societe AS date_creation_societe_11, t0.id_pays AS id_pays_12, t0.id_region AS id_region_13, t0.id_departement AS id_departement_14, t0.description_activite AS description_activite_15, t0.redressement_judiciaire AS redressement_judiciaire_16, t0.societe_difficulte AS societe_difficulte_17, t0.id_raison_cession AS id_raison_cession_18, t0.type_cedant AS type_cedant_19, t0.age_cedant AS age_cedant_20, t0.annee_n AS annee_n_21, t0.ca_n AS ca_n_22, t0.marge_brute_n AS marge_brute_n_23, t0.resultat_exploitation_n AS resultat_exploitation_n_24, t0.resultat_net_n AS resultat_net_n_25, t0.nb_personnes_n AS nb_personnes_n_26, t0.retraitement_des_comptes AS retraitement_des_comptes_27, t0.complement_retraitement_des_comptes AS complement_retraitement_des_comptes_28, t0.ca_nmoinsdeux AS ca_nmoinsdeux_29, t0.marge_brute_nmoinsdeux AS marge_brute_nmoinsdeux_30, t0.resultat_exploitation_nmoinsdeux AS resultat_exploitation_nmoinsdeux_31, t0.resultat_net_nmoinsdeux AS resultat_net_nmoinsdeux_32, t0.nb_personnes_nmoinsdeux AS nb_personnes_nmoinsdeux_33, t0.ca_nmoinsun AS ca_nmoinsun_34, t0.marge_brute_nmoinsun AS marge_brute_nmoinsun_35, t0.resultat_exploitation_nmoinsun AS resultat_exploitation_nmoinsun_36, t0.resultat_net_nmoinsun AS resultat_net_nmoinsun_37, t0.nb_personnes_nmoinsun AS nb_personnes_nmoinsun_38, t0.fonds_propres AS fonds_propres_39, t0.endettement_net_n AS endettement_net_n_40, t0.dettes_financieres AS dettes_financieres_41, t0.tresorerie_disponible AS tresorerie_disponible_42, t0.participation_salaries AS participation_salaries_43, t0.ca_retraite AS ca_retraite_44, t0.marge_brute_retraite AS marge_brute_retraite_45, t0.resultat_exploitation_retraite AS resultat_exploitation_retraite_46, t0.resultat_net_retraite AS resultat_net_retraite_47, t0.fonds_propres_retraite AS fonds_propres_retraite_48, t0.endettement_net_retraite AS endettement_net_retraite_49, t0.dettes_financieres_retraite AS dettes_financieres_retraite_50, t0.tresorerie_disponible_retraite AS tresorerie_disponible_retraite_51, t0.participation_salaries_retraite AS participation_salaries_retraite_52, t0.nb_personnes_retraite AS nb_personnes_retraite_53, t0.ca_n_affichage AS ca_n_affichage_54, t0.marge_brute_n_affichage AS marge_brute_n_affichage_55, t0.resultat_exploitation_n_affichage AS resultat_exploitation_n_affichage_56, t0.resultat_net_n_affichage AS resultat_net_n_affichage_57, t0.nb_personnes_n_affichage AS nb_personnes_n_affichage_58, t0.ca_nmoinsdeux_affichage AS ca_nmoinsdeux_affichage_59, t0.marge_brute_nmoinsdeux_affichage AS marge_brute_nmoinsdeux_affichage_60, t0.resultat_exploitation_nmoinsdeux_affichage AS resultat_exploitation_nmoinsdeux_affichage_61, t0.resultat_net_nmoinsdeux_affichage AS resultat_net_nmoinsdeux_affichage_62, t0.nb_personnes_nmoinsdeux_affichage AS nb_personnes_nmoinsdeux_affichage_63, t0.ca_nmoinsun_affichage AS ca_nmoinsun_affichage_64, t0.marge_brute_nmoinsun_affichage AS marge_brute_nmoinsun_affichage_65, t0.resultat_exploitation_nmoinsun_affichage AS resultat_exploitation_nmoinsun_affichage_66, t0.resultat_net_nmoinsun_affichage AS resultat_net_nmoinsun_affichage_67, t0.nb_personnes_nmoinsun_affichage AS nb_personnes_nmoinsun_affichage_68, t0.fonds_propres_affichage AS fonds_propres_affichage_69, t0.endettement_net_n_affichage AS endettement_net_n_affichage_70, t0.dettes_financieres_affichage AS dettes_financieres_affichage_71, t0.tresorerie_disponible_affichage AS tresorerie_disponible_affichage_72, t0.participation_salaries_affichage AS participation_salaries_affichage_73, t0.ca_retraite_affichage AS ca_retraite_affichage_74, t0.marge_brute_retraite_affichage AS marge_brute_retraite_affichage_75, t0.resultat_exploitation_retraite_affichage AS resultat_exploitation_retraite_affichage_76, t0.resultat_net_retraite_affichage AS resultat_net_retraite_affichage_77, t0.fonds_propres_retraite_affichage AS fonds_propres_retraite_affichage_78, t0.endettement_net_retraite_affichage AS endettement_net_retraite_affichage_79, t0.dettes_financieres_retraite_affichage AS dettes_financieres_retraite_affichage_80, t0.tresorerie_disponible_retraite_affichage AS tresorerie_disponible_retraite_affichage_81, t0.participation_salaries_retraite_affichage AS participation_salaries_retraite_affichage_82, t0.nb_personnes_retraite_affichage AS nb_personnes_retraite_affichage_83, t0.EBE_n AS EBE_n_84, t0.EBE_nmoinsun AS EBE_nmoinsun_85, t0.EBE_nmoinsdeux AS EBE_nmoinsdeux_86, t0.EBE_retraite AS EBE_retraite_87, t0.EBE_n_affichage AS EBE_n_affichage_88, t0.EBE_nmoinsun_affichage AS EBE_nmoinsun_affichage_89, t0.EBE_nmoinsdeux_affichage AS EBE_nmoinsdeux_affichage_90, t0.EBE_retraite_affichage AS EBE_retraite_affichage_91, t0.opportunites_developpement AS opportunites_developpement_92, t0.date_mois_operation AS date_mois_operation_93, t0.duree_totale_operation AS duree_totale_operation_94, t0.nb_acheteurs_potentiels AS nb_acheteurs_potentiels_95, t0.duree_negociations AS duree_negociations_96, t0.prix_vente AS prix_vente_97, t0.prix_vente_locaux AS prix_vente_locaux_98, t0.autres_frais AS autres_frais_99, t0.description_autres_frais AS description_autres_frais_100, t0.complement_multiples AS complement_multiples_101, t0.complement_methodes AS complement_methodes_102, t0.comparatif_prix_valorisation AS comparatif_prix_valorisation_103, t0.commentaire_prix AS commentaire_prix_104, t0.reprise_100_pourcents AS reprise_100_pourcents_105, t0.pourcentage_titres_repris AS pourcentage_titres_repris_106, t0.type_rachat AS type_rachat_107, t0.complement_montage AS complement_montage_108, t0.earn_out AS earn_out_109, t0.complement_earn_out AS complement_earn_out_110, t0.montant_garantie AS montant_garantie_111, t0.duree_garantie AS duree_garantie_112, t0.garantie_garantie AS garantie_garantie_113, t0.complement_garantie AS complement_garantie_114, t0.apports_fonds_propres_acquereur AS apports_fonds_propres_acquereur_115, t0.apports_fonds_propres_investisseur AS apports_fonds_propres_investisseur_116, t0.montant_finance_dette AS montant_finance_dette_117, t0.taux_bancaire AS taux_bancaire_118, t0.duree_financement AS duree_financement_119, t0.id_banque AS id_banque_120, t0.pret_oseo AS pret_oseo_121, t0.complement_pret_oseo AS complement_pret_oseo_122, t0.garantie_oseo AS garantie_oseo_123, t0.complement_garantie_oseo AS complement_garantie_oseo_124, t0.pret_honneur AS pret_honneur_125, t0.complement_pret_honneur AS complement_pret_honneur_126, t0.autre_financement AS autre_financement_127, t0.complement_autre_financement AS complement_autre_financement_128, t0.credit_vendeur AS credit_vendeur_129, t0.montant_credit_vendeur AS montant_credit_vendeur_130, t0.commentaire_credit_vendeur AS commentaire_credit_vendeur_131, t0.cedant_reste_dans_entreprise AS cedant_reste_dans_entreprise_132, t0.accompagnement_par_cedant AS accompagnement_par_cedant_133, t0.duree_accompagnement_par_cedant AS duree_accompagnement_par_cedant_134, t0.qui_verse_commission AS qui_verse_commission_135, t0.complement_operation AS complement_operation_136, t0.acquereur_meme_pays AS acquereur_meme_pays_137, t0.acquereur_meme_region AS acquereur_meme_region_138, t0.acquereur_meme_departement AS acquereur_meme_departement_139, t0.type_acquereur AS type_acquereur_140, t0.societe_meme_secteur AS societe_meme_secteur_141, t0.ca_societe_acquereur AS ca_societe_acquereur_142, t0.nb_personnes_societe_acquereur AS nb_personnes_societe_acquereur_143, t0.repreneur_meme_secteur AS repreneur_meme_secteur_144, t0.age_repreneur AS age_repreneur_145, t0.contact AS contact_146, t0.telephone_contact AS telephone_contact_147, t0.indicatif_telephone_contact AS indicatif_telephone_contact_148, t0.email_contact AS email_contact_149, t0.titre_valorisation AS titre_valorisation_150, t0.mots_cles AS mots_cles_151, t0.description_publique AS description_publique_152, t0.suivi AS suivi_153, t0.certification_fusacq AS certification_fusacq_154, t0.code_naf_oseo_nouveau AS code_naf_oseo_nouveau_155, t0.affichage_multiples AS affichage_multiples_156 FROM valorisations t0 WHERE t0.id_valorisation = ? LIMIT 1
SELECT
t0.id_valorisation AS id_valorisation_1,
t0.id_annonce_vendeur AS id_annonce_vendeur_2,
t0.id_secteur_activite AS id_secteur_activite_3,
t0.login_deposant AS login_deposant_4,
t0.mode AS mode_5,
t0.date_modification AS date_modification_6,
t0.date_mise_en_ligne AS date_mise_en_ligne_7,
t0.deja_publique AS deja_publique_8,
t0.numero_siret AS numero_siret_9,
t0.numero_siren AS numero_siren_10,
t0.date_creation_societe AS date_creation_societe_11,
t0.id_pays AS id_pays_12,
t0.id_region AS id_region_13,
t0.id_departement AS id_departement_14,
t0.description_activite AS description_activite_15,
t0.redressement_judiciaire AS redressement_judiciaire_16,
t0.societe_difficulte AS societe_difficulte_17,
t0.id_raison_cession AS id_raison_cession_18,
t0.type_cedant AS type_cedant_19,
t0.age_cedant AS age_cedant_20,
t0.annee_n AS annee_n_21,
t0.ca_n AS ca_n_22,
t0.marge_brute_n AS marge_brute_n_23,
t0.resultat_exploitation_n AS resultat_exploitation_n_24,
t0.resultat_net_n AS resultat_net_n_25,
t0.nb_personnes_n AS nb_personnes_n_26,
t0.retraitement_des_comptes AS retraitement_des_comptes_27,
t0.complement_retraitement_des_comptes AS complement_retraitement_des_comptes_28,
t0.ca_nmoinsdeux AS ca_nmoinsdeux_29,
t0.marge_brute_nmoinsdeux AS marge_brute_nmoinsdeux_30,
t0.resultat_exploitation_nmoinsdeux AS resultat_exploitation_nmoinsdeux_31,
t0.resultat_net_nmoinsdeux AS resultat_net_nmoinsdeux_32,
t0.nb_personnes_nmoinsdeux AS nb_personnes_nmoinsdeux_33,
t0.ca_nmoinsun AS ca_nmoinsun_34,
t0.marge_brute_nmoinsun AS marge_brute_nmoinsun_35,
t0.resultat_exploitation_nmoinsun AS resultat_exploitation_nmoinsun_36,
t0.resultat_net_nmoinsun AS resultat_net_nmoinsun_37,
t0.nb_personnes_nmoinsun AS nb_personnes_nmoinsun_38,
t0.fonds_propres AS fonds_propres_39,
t0.endettement_net_n AS endettement_net_n_40,
t0.dettes_financieres AS dettes_financieres_41,
t0.tresorerie_disponible AS tresorerie_disponible_42,
t0.participation_salaries AS participation_salaries_43,
t0.ca_retraite AS ca_retraite_44,
t0.marge_brute_retraite AS marge_brute_retraite_45,
t0.resultat_exploitation_retraite AS resultat_exploitation_retraite_46,
t0.resultat_net_retraite AS resultat_net_retraite_47,
t0.fonds_propres_retraite AS fonds_propres_retraite_48,
t0.endettement_net_retraite AS endettement_net_retraite_49,
t0.dettes_financieres_retraite AS dettes_financieres_retraite_50,
t0.tresorerie_disponible_retraite AS tresorerie_disponible_retraite_51,
t0.participation_salaries_retraite AS participation_salaries_retraite_52,
t0.nb_personnes_retraite AS nb_personnes_retraite_53,
t0.ca_n_affichage AS ca_n_affichage_54,
t0.marge_brute_n_affichage AS marge_brute_n_affichage_55,
t0.resultat_exploitation_n_affichage AS resultat_exploitation_n_affichage_56,
t0.resultat_net_n_affichage AS resultat_net_n_affichage_57,
t0.nb_personnes_n_affichage AS nb_personnes_n_affichage_58,
t0.ca_nmoinsdeux_affichage AS ca_nmoinsdeux_affichage_59,
t0.marge_brute_nmoinsdeux_affichage AS marge_brute_nmoinsdeux_affichage_60,
t0.resultat_exploitation_nmoinsdeux_affichage AS resultat_exploitation_nmoinsdeux_affichage_61,
t0.resultat_net_nmoinsdeux_affichage AS resultat_net_nmoinsdeux_affichage_62,
t0.nb_personnes_nmoinsdeux_affichage AS nb_personnes_nmoinsdeux_affichage_63,
t0.ca_nmoinsun_affichage AS ca_nmoinsun_affichage_64,
t0.marge_brute_nmoinsun_affichage AS marge_brute_nmoinsun_affichage_65,
t0.resultat_exploitation_nmoinsun_affichage AS resultat_exploitation_nmoinsun_affichage_66,
t0.resultat_net_nmoinsun_affichage AS resultat_net_nmoinsun_affichage_67,
t0.nb_personnes_nmoinsun_affichage AS nb_personnes_nmoinsun_affichage_68,
t0.fonds_propres_affichage AS fonds_propres_affichage_69,
t0.endettement_net_n_affichage AS endettement_net_n_affichage_70,
t0.dettes_financieres_affichage AS dettes_financieres_affichage_71,
t0.tresorerie_disponible_affichage AS tresorerie_disponible_affichage_72,
t0.participation_salaries_affichage AS participation_salaries_affichage_73,
t0.ca_retraite_affichage AS ca_retraite_affichage_74,
t0.marge_brute_retraite_affichage AS marge_brute_retraite_affichage_75,
t0.resultat_exploitation_retraite_affichage AS resultat_exploitation_retraite_affichage_76,
t0.resultat_net_retraite_affichage AS resultat_net_retraite_affichage_77,
t0.fonds_propres_retraite_affichage AS fonds_propres_retraite_affichage_78,
t0.endettement_net_retraite_affichage AS endettement_net_retraite_affichage_79,
t0.dettes_financieres_retraite_affichage AS dettes_financieres_retraite_affichage_80,
t0.tresorerie_disponible_retraite_affichage AS tresorerie_disponible_retraite_affichage_81,
t0.participation_salaries_retraite_affichage AS participation_salaries_retraite_affichage_82,
t0.nb_personnes_retraite_affichage AS nb_personnes_retraite_affichage_83,
t0.EBE_n AS EBE_n_84,
t0.EBE_nmoinsun AS EBE_nmoinsun_85,
t0.EBE_nmoinsdeux AS EBE_nmoinsdeux_86,
t0.EBE_retraite AS EBE_retraite_87,
t0.EBE_n_affichage AS EBE_n_affichage_88,
t0.EBE_nmoinsun_affichage AS EBE_nmoinsun_affichage_89,
t0.EBE_nmoinsdeux_affichage AS EBE_nmoinsdeux_affichage_90,
t0.EBE_retraite_affichage AS EBE_retraite_affichage_91,
t0.opportunites_developpement AS opportunites_developpement_92,
t0.date_mois_operation AS date_mois_operation_93,
t0.duree_totale_operation AS duree_totale_operation_94,
t0.nb_acheteurs_potentiels AS nb_acheteurs_potentiels_95,
t0.duree_negociations AS duree_negociations_96,
t0.prix_vente AS prix_vente_97,
t0.prix_vente_locaux AS prix_vente_locaux_98,
t0.autres_frais AS autres_frais_99,
t0.description_autres_frais AS description_autres_frais_100,
t0.complement_multiples AS complement_multiples_101,
t0.complement_methodes AS complement_methodes_102,
t0.comparatif_prix_valorisation AS comparatif_prix_valorisation_103,
t0.commentaire_prix AS commentaire_prix_104,
t0.reprise_100_pourcents AS reprise_100_pourcents_105,
t0.pourcentage_titres_repris AS pourcentage_titres_repris_106,
t0.type_rachat AS type_rachat_107,
t0.complement_montage AS complement_montage_108,
t0.earn_out AS earn_out_109,
t0.complement_earn_out AS complement_earn_out_110,
t0.montant_garantie AS montant_garantie_111,
t0.duree_garantie AS duree_garantie_112,
t0.garantie_garantie AS garantie_garantie_113,
t0.complement_garantie AS complement_garantie_114,
t0.apports_fonds_propres_acquereur AS apports_fonds_propres_acquereur_115,
t0.apports_fonds_propres_investisseur AS apports_fonds_propres_investisseur_116,
t0.montant_finance_dette AS montant_finance_dette_117,
t0.taux_bancaire AS taux_bancaire_118,
t0.duree_financement AS duree_financement_119,
t0.id_banque AS id_banque_120,
t0.pret_oseo AS pret_oseo_121,
t0.complement_pret_oseo AS complement_pret_oseo_122,
t0.garantie_oseo AS garantie_oseo_123,
t0.complement_garantie_oseo AS complement_garantie_oseo_124,
t0.pret_honneur AS pret_honneur_125,
t0.complement_pret_honneur AS complement_pret_honneur_126,
t0.autre_financement AS autre_financement_127,
t0.complement_autre_financement AS complement_autre_financement_128,
t0.credit_vendeur AS credit_vendeur_129,
t0.montant_credit_vendeur AS montant_credit_vendeur_130,
t0.commentaire_credit_vendeur AS commentaire_credit_vendeur_131,
t0.cedant_reste_dans_entreprise AS cedant_reste_dans_entreprise_132,
t0.accompagnement_par_cedant AS accompagnement_par_cedant_133,
t0.duree_accompagnement_par_cedant AS duree_accompagnement_par_cedant_134,
t0.qui_verse_commission AS qui_verse_commission_135,
t0.complement_operation AS complement_operation_136,
t0.acquereur_meme_pays AS acquereur_meme_pays_137,
t0.acquereur_meme_region AS acquereur_meme_region_138,
t0.acquereur_meme_departement AS acquereur_meme_departement_139,
t0.type_acquereur AS type_acquereur_140,
t0.societe_meme_secteur AS societe_meme_secteur_141,
t0.ca_societe_acquereur AS ca_societe_acquereur_142,
t0.nb_personnes_societe_acquereur AS nb_personnes_societe_acquereur_143,
t0.repreneur_meme_secteur AS repreneur_meme_secteur_144,
t0.age_repreneur AS age_repreneur_145,
t0.contact AS contact_146,
t0.telephone_contact AS telephone_contact_147,
t0.indicatif_telephone_contact AS indicatif_telephone_contact_148,
t0.email_contact AS email_contact_149,
t0.titre_valorisation AS titre_valorisation_150,
t0.mots_cles AS mots_cles_151,
t0.description_publique AS description_publique_152,
t0.suivi AS suivi_153,
t0.certification_fusacq AS certification_fusacq_154,
t0.code_naf_oseo_nouveau AS code_naf_oseo_nouveau_155,
t0.affichage_multiples AS affichage_multiples_156
FROM
valorisations t0
WHERE
t0.id_valorisation = ?
LIMIT
1
SELECT t0.id_valorisation AS id_valorisation_1, t0.id_annonce_vendeur AS id_annonce_vendeur_2, t0.id_secteur_activite AS id_secteur_activite_3, t0.login_deposant AS login_deposant_4, t0.mode AS mode_5, t0.date_modification AS date_modification_6, t0.date_mise_en_ligne AS date_mise_en_ligne_7, t0.deja_publique AS deja_publique_8, t0.numero_siret AS numero_siret_9, t0.numero_siren AS numero_siren_10, t0.date_creation_societe AS date_creation_societe_11, t0.id_pays AS id_pays_12, t0.id_region AS id_region_13, t0.id_departement AS id_departement_14, t0.description_activite AS description_activite_15, t0.redressement_judiciaire AS redressement_judiciaire_16, t0.societe_difficulte AS societe_difficulte_17, t0.id_raison_cession AS id_raison_cession_18, t0.type_cedant AS type_cedant_19, t0.age_cedant AS age_cedant_20, t0.annee_n AS annee_n_21, t0.ca_n AS ca_n_22, t0.marge_brute_n AS marge_brute_n_23, t0.resultat_exploitation_n AS resultat_exploitation_n_24, t0.resultat_net_n AS resultat_net_n_25, t0.nb_personnes_n AS nb_personnes_n_26, t0.retraitement_des_comptes AS retraitement_des_comptes_27, t0.complement_retraitement_des_comptes AS complement_retraitement_des_comptes_28, t0.ca_nmoinsdeux AS ca_nmoinsdeux_29, t0.marge_brute_nmoinsdeux AS marge_brute_nmoinsdeux_30, t0.resultat_exploitation_nmoinsdeux AS resultat_exploitation_nmoinsdeux_31, t0.resultat_net_nmoinsdeux AS resultat_net_nmoinsdeux_32, t0.nb_personnes_nmoinsdeux AS nb_personnes_nmoinsdeux_33, t0.ca_nmoinsun AS ca_nmoinsun_34, t0.marge_brute_nmoinsun AS marge_brute_nmoinsun_35, t0.resultat_exploitation_nmoinsun AS resultat_exploitation_nmoinsun_36, t0.resultat_net_nmoinsun AS resultat_net_nmoinsun_37, t0.nb_personnes_nmoinsun AS nb_personnes_nmoinsun_38, t0.fonds_propres AS fonds_propres_39, t0.endettement_net_n AS endettement_net_n_40, t0.dettes_financieres AS dettes_financieres_41, t0.tresorerie_disponible AS tresorerie_disponible_42, t0.participation_salaries AS participation_salaries_43, t0.ca_retraite AS ca_retraite_44, t0.marge_brute_retraite AS marge_brute_retraite_45, t0.resultat_exploitation_retraite AS resultat_exploitation_retraite_46, t0.resultat_net_retraite AS resultat_net_retraite_47, t0.fonds_propres_retraite AS fonds_propres_retraite_48, t0.endettement_net_retraite AS endettement_net_retraite_49, t0.dettes_financieres_retraite AS dettes_financieres_retraite_50, t0.tresorerie_disponible_retraite AS tresorerie_disponible_retraite_51, t0.participation_salaries_retraite AS participation_salaries_retraite_52, t0.nb_personnes_retraite AS nb_personnes_retraite_53, t0.ca_n_affichage AS ca_n_affichage_54, t0.marge_brute_n_affichage AS marge_brute_n_affichage_55, t0.resultat_exploitation_n_affichage AS resultat_exploitation_n_affichage_56, t0.resultat_net_n_affichage AS resultat_net_n_affichage_57, t0.nb_personnes_n_affichage AS nb_personnes_n_affichage_58, t0.ca_nmoinsdeux_affichage AS ca_nmoinsdeux_affichage_59, t0.marge_brute_nmoinsdeux_affichage AS marge_brute_nmoinsdeux_affichage_60, t0.resultat_exploitation_nmoinsdeux_affichage AS resultat_exploitation_nmoinsdeux_affichage_61, t0.resultat_net_nmoinsdeux_affichage AS resultat_net_nmoinsdeux_affichage_62, t0.nb_personnes_nmoinsdeux_affichage AS nb_personnes_nmoinsdeux_affichage_63, t0.ca_nmoinsun_affichage AS ca_nmoinsun_affichage_64, t0.marge_brute_nmoinsun_affichage AS marge_brute_nmoinsun_affichage_65, t0.resultat_exploitation_nmoinsun_affichage AS resultat_exploitation_nmoinsun_affichage_66, t0.resultat_net_nmoinsun_affichage AS resultat_net_nmoinsun_affichage_67, t0.nb_personnes_nmoinsun_affichage AS nb_personnes_nmoinsun_affichage_68, t0.fonds_propres_affichage AS fonds_propres_affichage_69, t0.endettement_net_n_affichage AS endettement_net_n_affichage_70, t0.dettes_financieres_affichage AS dettes_financieres_affichage_71, t0.tresorerie_disponible_affichage AS tresorerie_disponible_affichage_72, t0.participation_salaries_affichage AS participation_salaries_affichage_73, t0.ca_retraite_affichage AS ca_retraite_affichage_74, t0.marge_brute_retraite_affichage AS marge_brute_retraite_affichage_75, t0.resultat_exploitation_retraite_affichage AS resultat_exploitation_retraite_affichage_76, t0.resultat_net_retraite_affichage AS resultat_net_retraite_affichage_77, t0.fonds_propres_retraite_affichage AS fonds_propres_retraite_affichage_78, t0.endettement_net_retraite_affichage AS endettement_net_retraite_affichage_79, t0.dettes_financieres_retraite_affichage AS dettes_financieres_retraite_affichage_80, t0.tresorerie_disponible_retraite_affichage AS tresorerie_disponible_retraite_affichage_81, t0.participation_salaries_retraite_affichage AS participation_salaries_retraite_affichage_82, t0.nb_personnes_retraite_affichage AS nb_personnes_retraite_affichage_83, t0.EBE_n AS EBE_n_84, t0.EBE_nmoinsun AS EBE_nmoinsun_85, t0.EBE_nmoinsdeux AS EBE_nmoinsdeux_86, t0.EBE_retraite AS EBE_retraite_87, t0.EBE_n_affichage AS EBE_n_affichage_88, t0.EBE_nmoinsun_affichage AS EBE_nmoinsun_affichage_89, t0.EBE_nmoinsdeux_affichage AS EBE_nmoinsdeux_affichage_90, t0.EBE_retraite_affichage AS EBE_retraite_affichage_91, t0.opportunites_developpement AS opportunites_developpement_92, t0.date_mois_operation AS date_mois_operation_93, t0.duree_totale_operation AS duree_totale_operation_94, t0.nb_acheteurs_potentiels AS nb_acheteurs_potentiels_95, t0.duree_negociations AS duree_negociations_96, t0.prix_vente AS prix_vente_97, t0.prix_vente_locaux AS prix_vente_locaux_98, t0.autres_frais AS autres_frais_99, t0.description_autres_frais AS description_autres_frais_100, t0.complement_multiples AS complement_multiples_101, t0.complement_methodes AS complement_methodes_102, t0.comparatif_prix_valorisation AS comparatif_prix_valorisation_103, t0.commentaire_prix AS commentaire_prix_104, t0.reprise_100_pourcents AS reprise_100_pourcents_105, t0.pourcentage_titres_repris AS pourcentage_titres_repris_106, t0.type_rachat AS type_rachat_107, t0.complement_montage AS complement_montage_108, t0.earn_out AS earn_out_109, t0.complement_earn_out AS complement_earn_out_110, t0.montant_garantie AS montant_garantie_111, t0.duree_garantie AS duree_garantie_112, t0.garantie_garantie AS garantie_garantie_113, t0.complement_garantie AS complement_garantie_114, t0.apports_fonds_propres_acquereur AS apports_fonds_propres_acquereur_115, t0.apports_fonds_propres_investisseur AS apports_fonds_propres_investisseur_116, t0.montant_finance_dette AS montant_finance_dette_117, t0.taux_bancaire AS taux_bancaire_118, t0.duree_financement AS duree_financement_119, t0.id_banque AS id_banque_120, t0.pret_oseo AS pret_oseo_121, t0.complement_pret_oseo AS complement_pret_oseo_122, t0.garantie_oseo AS garantie_oseo_123, t0.complement_garantie_oseo AS complement_garantie_oseo_124, t0.pret_honneur AS pret_honneur_125, t0.complement_pret_honneur AS complement_pret_honneur_126, t0.autre_financement AS autre_financement_127, t0.complement_autre_financement AS complement_autre_financement_128, t0.credit_vendeur AS credit_vendeur_129, t0.montant_credit_vendeur AS montant_credit_vendeur_130, t0.commentaire_credit_vendeur AS commentaire_credit_vendeur_131, t0.cedant_reste_dans_entreprise AS cedant_reste_dans_entreprise_132, t0.accompagnement_par_cedant AS accompagnement_par_cedant_133, t0.duree_accompagnement_par_cedant AS duree_accompagnement_par_cedant_134, t0.qui_verse_commission AS qui_verse_commission_135, t0.complement_operation AS complement_operation_136, t0.acquereur_meme_pays AS acquereur_meme_pays_137, t0.acquereur_meme_region AS acquereur_meme_region_138, t0.acquereur_meme_departement AS acquereur_meme_departement_139, t0.type_acquereur AS type_acquereur_140, t0.societe_meme_secteur AS societe_meme_secteur_141, t0.ca_societe_acquereur AS ca_societe_acquereur_142, t0.nb_personnes_societe_acquereur AS nb_personnes_societe_acquereur_143, t0.repreneur_meme_secteur AS repreneur_meme_secteur_144, t0.age_repreneur AS age_repreneur_145, t0.contact AS contact_146, t0.telephone_contact AS telephone_contact_147, t0.indicatif_telephone_contact AS indicatif_telephone_contact_148, t0.email_contact AS email_contact_149, t0.titre_valorisation AS titre_valorisation_150, t0.mots_cles AS mots_cles_151, t0.description_publique AS description_publique_152, t0.suivi AS suivi_153, t0.certification_fusacq AS certification_fusacq_154, t0.code_naf_oseo_nouveau AS code_naf_oseo_nouveau_155, t0.affichage_multiples AS affichage_multiples_156 FROM valorisations t0 WHERE t0.id_valorisation = 29 LIMIT 1;
|
| 2 |
75.18 ms |
SELECT t0_.id_translation AS id_translation_0, t0_.md5_fr AS md5_fr_1, t0_.texte_fr AS texte_fr_2, t0_.contexte_fr AS contexte_fr_3, t0_.md5_en AS md5_en_4, t0_.texte_en AS texte_en_5, t0_.contexte_en AS contexte_en_6, t0_.md5_fr_ca AS md5_fr_ca_7, t0_.texte_fr_ca AS texte_fr_ca_8, t0_.contexte_fr_ca AS contexte_fr_ca_9, t0_.md5_generique AS md5_generique_10, t0_.texte_generique AS texte_generique_11, t0_.contexte_generique AS contexte_generique_12, t0_.md5_es AS md5_es_13, t0_.texte_es AS texte_es_14, t0_.contexte_es AS contexte_es_15, t0_.md5_de AS md5_de_16, t0_.texte_de AS texte_de_17, t0_.contexte_de AS contexte_de_18, t0_.md5_nl AS md5_nl_19, t0_.texte_nl AS texte_nl_20, t0_.contexte_nl AS contexte_nl_21, t0_.md5_it AS md5_it_22, t0_.texte_it AS texte_it_23, t0_.contexte_it AS contexte_it_24, t0_.etat_en AS etat_en_25, t0_.etat_es AS etat_es_26, t0_.etat_de AS etat_de_27, t0_.etat_nl AS etat_nl_28, t0_.etat_it AS etat_it_29, t0_.etat_fr_ca AS etat_fr_ca_30, t0_.traduit_deepl AS traduit_deepl_31, t0_.created_at AS created_at_32, t0_.page_url AS page_url_33, t0_.etat_fr_ch AS etat_fr_ch_34, t0_.md5_fr_ch AS md5_fr_ch_35, t0_.texte_fr_ch AS texte_fr_ch_36, t0_.contexte_fr_ch AS contexte_fr_ch_37 FROM partage_dbo.translation t1_, partage_dbo.translation t0_ WHERE t0_.md5_generique = ?
Parameters: [
"99d296ee97bba91fec07ae3439f4ff83"
]
SELECT t0_.id_translation AS id_translation_0, t0_.md5_fr AS md5_fr_1, t0_.texte_fr AS texte_fr_2, t0_.contexte_fr AS contexte_fr_3, t0_.md5_en AS md5_en_4, t0_.texte_en AS texte_en_5, t0_.contexte_en AS contexte_en_6, t0_.md5_fr_ca AS md5_fr_ca_7, t0_.texte_fr_ca AS texte_fr_ca_8, t0_.contexte_fr_ca AS contexte_fr_ca_9, t0_.md5_generique AS md5_generique_10, t0_.texte_generique AS texte_generique_11, t0_.contexte_generique AS contexte_generique_12, t0_.md5_es AS md5_es_13, t0_.texte_es AS texte_es_14, t0_.contexte_es AS contexte_es_15, t0_.md5_de AS md5_de_16, t0_.texte_de AS texte_de_17, t0_.contexte_de AS contexte_de_18, t0_.md5_nl AS md5_nl_19, t0_.texte_nl AS texte_nl_20, t0_.contexte_nl AS contexte_nl_21, t0_.md5_it AS md5_it_22, t0_.texte_it AS texte_it_23, t0_.contexte_it AS contexte_it_24, t0_.etat_en AS etat_en_25, t0_.etat_es AS etat_es_26, t0_.etat_de AS etat_de_27, t0_.etat_nl AS etat_nl_28, t0_.etat_it AS etat_it_29, t0_.etat_fr_ca AS etat_fr_ca_30, t0_.traduit_deepl AS traduit_deepl_31, t0_.created_at AS created_at_32, t0_.page_url AS page_url_33, t0_.etat_fr_ch AS etat_fr_ch_34, t0_.md5_fr_ch AS md5_fr_ch_35, t0_.texte_fr_ch AS texte_fr_ch_36, t0_.contexte_fr_ch AS contexte_fr_ch_37 FROM partage_dbo.translation t1_, partage_dbo.translation t0_ WHERE t0_.md5_generique = '99d296ee97bba91fec07ae3439f4ff83';
|