Symfony Profiler

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

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;

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
  COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0
FROM
  fusacq_dbo.annonces_vendeur a0_
WHERE
  (
    a0_.date_parution_initiale IS NOT NULL
    OR a0_.date_parution_initiale_elite IS NOT NULL
  )
  AND (
    a0_.mode_annonce = 'publique'
    OR a0_.mode_annonce = 'publique_elite'
  )
  AND a0_.tpe_pme = 'oui'
  AND a0_.statuts LIKE '99%'
  AND a0_.id_secteur_activite LIKE ?

SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE (a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL) AND (a0_.mode_annonce = 'publique' OR a0_.mode_annonce = 'publique_elite') AND a0_.tpe_pme = 'oui' AND a0_.statuts LIKE '99%' AND a0_.id_secteur_activite LIKE '399%';

SELECT
  COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0
FROM
  fusacq_dbo.annonces_vendeur a0_
WHERE
  a0_.date_parution_initiale IS NOT NULL
  AND a0_.mode_annonce = 'publique'
  AND a0_.tpe_pme = 'oui'
  AND a0_.id_secteur_activite LIKE ?

SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND a0_.id_secteur_activite LIKE '399%';

SELECT
  t0.id_secteur_activite AS id_secteur_activite_1,
  t0.nom_secteur_activite AS nom_secteur_activite_2,
  t0.obsolete AS obsolete_3,
  t0.id_secteur_activite_fonds AS id_secteur_activite_fonds_4,
  t0.site_partenaire AS site_partenaire_5,
  t0.ciblage_adserveur_fusacq AS ciblage_adserveur_fusacq_6,
  t0.id_secteur_activite_pere AS id_secteur_activite_pere_7,
  t0.nom_secteur_activite_pere AS nom_secteur_activite_pere_8,
  t0.mots_cles_secteur_activite AS mots_cles_secteur_activite_9,
  t0.nom_pour_TITLE AS nom_pour_TITLE_10,
  t0.rare AS rare_11,
  t0.recherche AS recherche_12,
  t0.image_filename AS image_filename_13
FROM
  fusacq_dbo.secteurs_activite t0
WHERE
  t0.id_secteur_activite = ?
LIMIT
  1

SELECT t0.id_secteur_activite AS id_secteur_activite_1, t0.nom_secteur_activite AS nom_secteur_activite_2, t0.obsolete AS obsolete_3, t0.id_secteur_activite_fonds AS id_secteur_activite_fonds_4, t0.site_partenaire AS site_partenaire_5, t0.ciblage_adserveur_fusacq AS ciblage_adserveur_fusacq_6, t0.id_secteur_activite_pere AS id_secteur_activite_pere_7, t0.nom_secteur_activite_pere AS nom_secteur_activite_pere_8, t0.mots_cles_secteur_activite AS mots_cles_secteur_activite_9, t0.nom_pour_TITLE AS nom_pour_TITLE_10, t0.rare AS rare_11, t0.recherche AS recherche_12, t0.image_filename AS image_filename_13 FROM fusacq_dbo.secteurs_activite t0 WHERE t0.id_secteur_activite = '3' LIMIT 1;

SELECT
  COUNT(
    DISTINCT a0_.id_annonce_acheteur
  ) AS sclr_0
FROM
  fusacq_dbo.annonces_acheteur a0_
WHERE
  a0_.date_parution_initiale IS NOT NULL
  AND a0_.mode_annonce = 'publique'
  AND a0_.tpe_pme = 'oui'
  AND a0_.type_raprochement = 'partenaire'
  AND a0_.id_secteur_activite LIKE ?

SELECT COUNT(DISTINCT a0_.id_annonce_acheteur) AS sclr_0 FROM fusacq_dbo.annonces_acheteur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND a0_.type_raprochement = 'partenaire' AND a0_.id_secteur_activite LIKE '399%';

SELECT
  DISTINCT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0
FROM
  fusacq_dbo.annonces_vendeur a0_
WHERE
  (
    a0_.date_parution_initiale IS NOT NULL
    OR a0_.date_parution_initiale_elite IS NOT NULL
  )
  AND (
    a0_.mode_annonce = 'publique'
    OR a0_.mode_annonce = 'publique_elite'
  )
  AND a0_.tpe_pme = 'oui'
  AND a0_.statuts NOT LIKE '99%'
  AND a0_.id_secteur_activite LIKE ?

SELECT DISTINCT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE (a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL) AND (a0_.mode_annonce = 'publique' OR a0_.mode_annonce = 'publique_elite') AND a0_.tpe_pme = 'oui' AND a0_.statuts NOT LIKE '99%' AND a0_.id_secteur_activite LIKE '3%';

SELECT
  DISTINCT a0_.id_annonce_vendeur AS id_annonce_vendeur_0,
  a0_.ca_n AS ca_n_1,
  a0_.id_annonce_vendeur AS id_annonce_vendeur_2
FROM
  fusacq_dbo.annonces_vendeur a0_
WHERE
  (
    a0_.date_parution_initiale IS NOT NULL
    OR a0_.date_parution_initiale_elite IS NOT NULL
  )
  AND (
    a0_.mode_annonce = 'publique'
    OR a0_.mode_annonce = 'publique_elite'
  )
  AND a0_.tpe_pme = 'oui'
  AND a0_.statuts NOT LIKE '99%'
  AND a0_.id_secteur_activite LIKE ?
ORDER BY
  a0_.ca_n DESC,
  a0_.id_annonce_vendeur DESC
LIMIT
  10 OFFSET 230

SELECT DISTINCT a0_.id_annonce_vendeur AS id_annonce_vendeur_0, a0_.ca_n AS ca_n_1, a0_.id_annonce_vendeur AS id_annonce_vendeur_2 FROM fusacq_dbo.annonces_vendeur a0_ WHERE (a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL) AND (a0_.mode_annonce = 'publique' OR a0_.mode_annonce = 'publique_elite') AND a0_.tpe_pme = 'oui' AND a0_.statuts NOT LIKE '99%' AND a0_.id_secteur_activite LIKE '3%' ORDER BY a0_.ca_n DESC, a0_.id_annonce_vendeur DESC LIMIT 10 OFFSET 230;

SELECT
  COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0
FROM
  fusacq_dbo.annonces_vendeur a0_
WHERE
  (
    a0_.date_parution_initiale IS NOT NULL
    OR a0_.date_parution_initiale_elite IS NOT NULL
  )
  AND (
    a0_.mode_annonce = 'publique'
    OR a0_.mode_annonce = 'publique_elite'
  )
  AND a0_.tpe_pme = 'oui'
  AND a0_.id_period_annonce_prioritaire <> ''
  AND a0_.id_period_annonce_prioritaire IS NOT NULL
  AND a0_.etat_annonce_prioritaire = 'active'
  AND a0_.id_secteur_activite LIKE ?
ORDER BY
  a0_.date_debut_annonce_prioritaire ASC

SELECT COUNT(DISTINCT a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE (a0_.date_parution_initiale IS NOT NULL OR a0_.date_parution_initiale_elite IS NOT NULL) AND (a0_.mode_annonce = 'publique' OR a0_.mode_annonce = 'publique_elite') AND a0_.tpe_pme = 'oui' AND a0_.id_period_annonce_prioritaire <> '' AND a0_.id_period_annonce_prioritaire IS NOT NULL AND a0_.etat_annonce_prioritaire = 'active' AND a0_.id_secteur_activite LIKE '3%' ORDER BY a0_.date_debut_annonce_prioritaire ASC;

SELECT
  c0_.id_commande AS id_commande_0,
  c0_.etat AS etat_1,
  c0_.id_cpte_utilisateur AS id_cpte_utilisateur_2,
  c0_.date_validation AS date_validation_3,
  c0_.montant_total AS montant_total_4,
  c0_.total_taxe AS total_taxe_5,
  c0_.mode_reglement AS mode_reglement_6,
  c0_.date_facturation AS date_facturation_7,
  c0_.date_livraison AS date_livraison_8,
  c0_.id_facture AS id_facture_9,
  c0_.id_commande_forfait AS id_commande_forfait_10,
  c0_.remuneration_partenaire AS remuneration_partenaire_11,
  c0_.com_from_site_partenaire AS com_from_site_partenaire_12,
  c0_.date_relance AS date_relance_13,
  c0_.date_virement_cheque AS date_virement_cheque_14,
  c0_.date_rapprochement_cb AS date_rapprochement_cb_15,
  c0_.suivi_qualite AS suivi_qualite_16,
  c0_.societe_facturation AS societe_facturation_17,
  c0_.adresse AS adresse_18,
  c0_.code_postal AS code_postal_19,
  c0_.ville AS ville_20,
  c0_.pays AS pays_21,
  c0_.id_pays_commande AS id_pays_commande_22,
  c0_.date_lancer_suivi_qualite AS date_lancer_suivi_qualite_23,
  c0_.ref_facture AS ref_facture_24,
  c0_.tva_intracommunautaire AS tva_intracommunautaire_25,
  c0_.raison_ht AS raison_ht_26
FROM
  fusacq_dbo.commandes c0_
  INNER JOIN fusacq_dbo.details_commande d1_ ON (
    d1_.id_commande = c0_.id_commande
  )
WHERE
  d1_.id_annonce = 88481
  AND d1_.type_annonce = 'vendeur'
  AND c0_.etat = 'information_transmise'
  AND c0_.date_livraison >= 20260403

SELECT c0_.id_commande AS id_commande_0, c0_.etat AS etat_1, c0_.id_cpte_utilisateur AS id_cpte_utilisateur_2, c0_.date_validation AS date_validation_3, c0_.montant_total AS montant_total_4, c0_.total_taxe AS total_taxe_5, c0_.mode_reglement AS mode_reglement_6, c0_.date_facturation AS date_facturation_7, c0_.date_livraison AS date_livraison_8, c0_.id_facture AS id_facture_9, c0_.id_commande_forfait AS id_commande_forfait_10, c0_.remuneration_partenaire AS remuneration_partenaire_11, c0_.com_from_site_partenaire AS com_from_site_partenaire_12, c0_.date_relance AS date_relance_13, c0_.date_virement_cheque AS date_virement_cheque_14, c0_.date_rapprochement_cb AS date_rapprochement_cb_15, c0_.suivi_qualite AS suivi_qualite_16, c0_.societe_facturation AS societe_facturation_17, c0_.adresse AS adresse_18, c0_.code_postal AS code_postal_19, c0_.ville AS ville_20, c0_.pays AS pays_21, c0_.id_pays_commande AS id_pays_commande_22, c0_.date_lancer_suivi_qualite AS date_lancer_suivi_qualite_23, c0_.ref_facture AS ref_facture_24, c0_.tva_intracommunautaire AS tva_intracommunautaire_25, c0_.raison_ht AS raison_ht_26 FROM fusacq_dbo.commandes c0_ INNER JOIN fusacq_dbo.details_commande d1_ ON (d1_.id_commande = c0_.id_commande) WHERE d1_.id_annonce = 88481 AND d1_.type_annonce = 'vendeur' AND c0_.etat = 'information_transmise' AND c0_.date_livraison >= 20260403;

SELECT
  c0_.id_commande AS id_commande_0,
  c0_.etat AS etat_1,
  c0_.id_cpte_utilisateur AS id_cpte_utilisateur_2,
  c0_.date_validation AS date_validation_3,
  c0_.montant_total AS montant_total_4,
  c0_.total_taxe AS total_taxe_5,
  c0_.mode_reglement AS mode_reglement_6,
  c0_.date_facturation AS date_facturation_7,
  c0_.date_livraison AS date_livraison_8,
  c0_.id_facture AS id_facture_9,
  c0_.id_commande_forfait AS id_commande_forfait_10,
  c0_.remuneration_partenaire AS remuneration_partenaire_11,
  c0_.com_from_site_partenaire AS com_from_site_partenaire_12,
  c0_.date_relance AS date_relance_13,
  c0_.date_virement_cheque AS date_virement_cheque_14,
  c0_.date_rapprochement_cb AS date_rapprochement_cb_15,
  c0_.suivi_qualite AS suivi_qualite_16,
  c0_.societe_facturation AS societe_facturation_17,
  c0_.adresse AS adresse_18,
  c0_.code_postal AS code_postal_19,
  c0_.ville AS ville_20,
  c0_.pays AS pays_21,
  c0_.id_pays_commande AS id_pays_commande_22,
  c0_.date_lancer_suivi_qualite AS date_lancer_suivi_qualite_23,
  c0_.ref_facture AS ref_facture_24,
  c0_.tva_intracommunautaire AS tva_intracommunautaire_25,
  c0_.raison_ht AS raison_ht_26
FROM
  fusacq_dbo.commandes c0_
  INNER JOIN fusacq_dbo.details_commande d1_ ON (
    d1_.id_commande = c0_.id_commande
  )
WHERE
  d1_.id_annonce = 88481
  AND d1_.type_annonce = 'vendeur'
  AND c0_.etat = 'information_transmise'

SELECT c0_.id_commande AS id_commande_0, c0_.etat AS etat_1, c0_.id_cpte_utilisateur AS id_cpte_utilisateur_2, c0_.date_validation AS date_validation_3, c0_.montant_total AS montant_total_4, c0_.total_taxe AS total_taxe_5, c0_.mode_reglement AS mode_reglement_6, c0_.date_facturation AS date_facturation_7, c0_.date_livraison AS date_livraison_8, c0_.id_facture AS id_facture_9, c0_.id_commande_forfait AS id_commande_forfait_10, c0_.remuneration_partenaire AS remuneration_partenaire_11, c0_.com_from_site_partenaire AS com_from_site_partenaire_12, c0_.date_relance AS date_relance_13, c0_.date_virement_cheque AS date_virement_cheque_14, c0_.date_rapprochement_cb AS date_rapprochement_cb_15, c0_.suivi_qualite AS suivi_qualite_16, c0_.societe_facturation AS societe_facturation_17, c0_.adresse AS adresse_18, c0_.code_postal AS code_postal_19, c0_.ville AS ville_20, c0_.pays AS pays_21, c0_.id_pays_commande AS id_pays_commande_22, c0_.date_lancer_suivi_qualite AS date_lancer_suivi_qualite_23, c0_.ref_facture AS ref_facture_24, c0_.tva_intracommunautaire AS tva_intracommunautaire_25, c0_.raison_ht AS raison_ht_26 FROM fusacq_dbo.commandes c0_ INNER JOIN fusacq_dbo.details_commande d1_ ON (d1_.id_commande = c0_.id_commande) WHERE d1_.id_annonce = 88481 AND d1_.type_annonce = 'vendeur' AND c0_.etat = 'information_transmise';

SELECT
  c0_.id_commande AS id_commande_0,
  c0_.etat AS etat_1,
  c0_.id_cpte_utilisateur AS id_cpte_utilisateur_2,
  c0_.date_validation AS date_validation_3,
  c0_.montant_total AS montant_total_4,
  c0_.total_taxe AS total_taxe_5,
  c0_.mode_reglement AS mode_reglement_6,
  c0_.date_facturation AS date_facturation_7,
  c0_.date_livraison AS date_livraison_8,
  c0_.id_facture AS id_facture_9,
  c0_.id_commande_forfait AS id_commande_forfait_10,
  c0_.remuneration_partenaire AS remuneration_partenaire_11,
  c0_.com_from_site_partenaire AS com_from_site_partenaire_12,
  c0_.date_relance AS date_relance_13,
  c0_.date_virement_cheque AS date_virement_cheque_14,
  c0_.date_rapprochement_cb AS date_rapprochement_cb_15,
  c0_.suivi_qualite AS suivi_qualite_16,
  c0_.societe_facturation AS societe_facturation_17,
  c0_.adresse AS adresse_18,
  c0_.code_postal AS code_postal_19,
  c0_.ville AS ville_20,
  c0_.pays AS pays_21,
  c0_.id_pays_commande AS id_pays_commande_22,
  c0_.date_lancer_suivi_qualite AS date_lancer_suivi_qualite_23,
  c0_.ref_facture AS ref_facture_24,
  c0_.tva_intracommunautaire AS tva_intracommunautaire_25,
  c0_.raison_ht AS raison_ht_26
FROM
  fusacq_dbo.commandes c0_
  INNER JOIN fusacq_dbo.details_commande d1_ ON (
    d1_.id_commande = c0_.id_commande
  )
WHERE
  d1_.id_annonce = 89464
  AND d1_.type_annonce = 'vendeur'
  AND c0_.etat = 'information_transmise'
  AND c0_.date_livraison >= 20260403

SELECT c0_.id_commande AS id_commande_0, c0_.etat AS etat_1, c0_.id_cpte_utilisateur AS id_cpte_utilisateur_2, c0_.date_validation AS date_validation_3, c0_.montant_total AS montant_total_4, c0_.total_taxe AS total_taxe_5, c0_.mode_reglement AS mode_reglement_6, c0_.date_facturation AS date_facturation_7, c0_.date_livraison AS date_livraison_8, c0_.id_facture AS id_facture_9, c0_.id_commande_forfait AS id_commande_forfait_10, c0_.remuneration_partenaire AS remuneration_partenaire_11, c0_.com_from_site_partenaire AS com_from_site_partenaire_12, c0_.date_relance AS date_relance_13, c0_.date_virement_cheque AS date_virement_cheque_14, c0_.date_rapprochement_cb AS date_rapprochement_cb_15, c0_.suivi_qualite AS suivi_qualite_16, c0_.societe_facturation AS societe_facturation_17, c0_.adresse AS adresse_18, c0_.code_postal AS code_postal_19, c0_.ville AS ville_20, c0_.pays AS pays_21, c0_.id_pays_commande AS id_pays_commande_22, c0_.date_lancer_suivi_qualite AS date_lancer_suivi_qualite_23, c0_.ref_facture AS ref_facture_24, c0_.tva_intracommunautaire AS tva_intracommunautaire_25, c0_.raison_ht AS raison_ht_26 FROM fusacq_dbo.commandes c0_ INNER JOIN fusacq_dbo.details_commande d1_ ON (d1_.id_commande = c0_.id_commande) WHERE d1_.id_annonce = 89464 AND d1_.type_annonce = 'vendeur' AND c0_.etat = 'information_transmise' AND c0_.date_livraison >= 20260403;

SELECT
  c0_.id_commande AS id_commande_0,
  c0_.etat AS etat_1,
  c0_.id_cpte_utilisateur AS id_cpte_utilisateur_2,
  c0_.date_validation AS date_validation_3,
  c0_.montant_total AS montant_total_4,
  c0_.total_taxe AS total_taxe_5,
  c0_.mode_reglement AS mode_reglement_6,
  c0_.date_facturation AS date_facturation_7,
  c0_.date_livraison AS date_livraison_8,
  c0_.id_facture AS id_facture_9,
  c0_.id_commande_forfait AS id_commande_forfait_10,
  c0_.remuneration_partenaire AS remuneration_partenaire_11,
  c0_.com_from_site_partenaire AS com_from_site_partenaire_12,
  c0_.date_relance AS date_relance_13,
  c0_.date_virement_cheque AS date_virement_cheque_14,
  c0_.date_rapprochement_cb AS date_rapprochement_cb_15,
  c0_.suivi_qualite AS suivi_qualite_16,
  c0_.societe_facturation AS societe_facturation_17,
  c0_.adresse AS adresse_18,
  c0_.code_postal AS code_postal_19,
  c0_.ville AS ville_20,
  c0_.pays AS pays_21,
  c0_.id_pays_commande AS id_pays_commande_22,
  c0_.date_lancer_suivi_qualite AS date_lancer_suivi_qualite_23,
  c0_.ref_facture AS ref_facture_24,
  c0_.tva_intracommunautaire AS tva_intracommunautaire_25,
  c0_.raison_ht AS raison_ht_26
FROM
  fusacq_dbo.commandes c0_
  INNER JOIN fusacq_dbo.details_commande d1_ ON (
    d1_.id_commande = c0_.id_commande
  )
WHERE
  d1_.id_annonce = 87520
  AND d1_.type_annonce = 'vendeur'
  AND c0_.etat = 'information_transmise'
  AND c0_.date_livraison >= 20260403

SELECT c0_.id_commande AS id_commande_0, c0_.etat AS etat_1, c0_.id_cpte_utilisateur AS id_cpte_utilisateur_2, c0_.date_validation AS date_validation_3, c0_.montant_total AS montant_total_4, c0_.total_taxe AS total_taxe_5, c0_.mode_reglement AS mode_reglement_6, c0_.date_facturation AS date_facturation_7, c0_.date_livraison AS date_livraison_8, c0_.id_facture AS id_facture_9, c0_.id_commande_forfait AS id_commande_forfait_10, c0_.remuneration_partenaire AS remuneration_partenaire_11, c0_.com_from_site_partenaire AS com_from_site_partenaire_12, c0_.date_relance AS date_relance_13, c0_.date_virement_cheque AS date_virement_cheque_14, c0_.date_rapprochement_cb AS date_rapprochement_cb_15, c0_.suivi_qualite AS suivi_qualite_16, c0_.societe_facturation AS societe_facturation_17, c0_.adresse AS adresse_18, c0_.code_postal AS code_postal_19, c0_.ville AS ville_20, c0_.pays AS pays_21, c0_.id_pays_commande AS id_pays_commande_22, c0_.date_lancer_suivi_qualite AS date_lancer_suivi_qualite_23, c0_.ref_facture AS ref_facture_24, c0_.tva_intracommunautaire AS tva_intracommunautaire_25, c0_.raison_ht AS raison_ht_26 FROM fusacq_dbo.commandes c0_ INNER JOIN fusacq_dbo.details_commande d1_ ON (d1_.id_commande = c0_.id_commande) WHERE d1_.id_annonce = 87520 AND d1_.type_annonce = 'vendeur' AND c0_.etat = 'information_transmise' AND c0_.date_livraison >= 20260403;

SELECT
  c0_.id_commande AS id_commande_0,
  c0_.etat AS etat_1,
  c0_.id_cpte_utilisateur AS id_cpte_utilisateur_2,
  c0_.date_validation AS date_validation_3,
  c0_.montant_total AS montant_total_4,
  c0_.total_taxe AS total_taxe_5,
  c0_.mode_reglement AS mode_reglement_6,
  c0_.date_facturation AS date_facturation_7,
  c0_.date_livraison AS date_livraison_8,
  c0_.id_facture AS id_facture_9,
  c0_.id_commande_forfait AS id_commande_forfait_10,
  c0_.remuneration_partenaire AS remuneration_partenaire_11,
  c0_.com_from_site_partenaire AS com_from_site_partenaire_12,
  c0_.date_relance AS date_relance_13,
  c0_.date_virement_cheque AS date_virement_cheque_14,
  c0_.date_rapprochement_cb AS date_rapprochement_cb_15,
  c0_.suivi_qualite AS suivi_qualite_16,
  c0_.societe_facturation AS societe_facturation_17,
  c0_.adresse AS adresse_18,
  c0_.code_postal AS code_postal_19,
  c0_.ville AS ville_20,
  c0_.pays AS pays_21,
  c0_.id_pays_commande AS id_pays_commande_22,
  c0_.date_lancer_suivi_qualite AS date_lancer_suivi_qualite_23,
  c0_.ref_facture AS ref_facture_24,
  c0_.tva_intracommunautaire AS tva_intracommunautaire_25,
  c0_.raison_ht AS raison_ht_26
FROM
  fusacq_dbo.commandes c0_
  INNER JOIN fusacq_dbo.details_commande d1_ ON (
    d1_.id_commande = c0_.id_commande
  )
WHERE
  d1_.id_annonce = 87949
  AND d1_.type_annonce = 'vendeur'
  AND c0_.etat = 'information_transmise'
  AND c0_.date_livraison >= 20260403

SELECT c0_.id_commande AS id_commande_0, c0_.etat AS etat_1, c0_.id_cpte_utilisateur AS id_cpte_utilisateur_2, c0_.date_validation AS date_validation_3, c0_.montant_total AS montant_total_4, c0_.total_taxe AS total_taxe_5, c0_.mode_reglement AS mode_reglement_6, c0_.date_facturation AS date_facturation_7, c0_.date_livraison AS date_livraison_8, c0_.id_facture AS id_facture_9, c0_.id_commande_forfait AS id_commande_forfait_10, c0_.remuneration_partenaire AS remuneration_partenaire_11, c0_.com_from_site_partenaire AS com_from_site_partenaire_12, c0_.date_relance AS date_relance_13, c0_.date_virement_cheque AS date_virement_cheque_14, c0_.date_rapprochement_cb AS date_rapprochement_cb_15, c0_.suivi_qualite AS suivi_qualite_16, c0_.societe_facturation AS societe_facturation_17, c0_.adresse AS adresse_18, c0_.code_postal AS code_postal_19, c0_.ville AS ville_20, c0_.pays AS pays_21, c0_.id_pays_commande AS id_pays_commande_22, c0_.date_lancer_suivi_qualite AS date_lancer_suivi_qualite_23, c0_.ref_facture AS ref_facture_24, c0_.tva_intracommunautaire AS tva_intracommunautaire_25, c0_.raison_ht AS raison_ht_26 FROM fusacq_dbo.commandes c0_ INNER JOIN fusacq_dbo.details_commande d1_ ON (d1_.id_commande = c0_.id_commande) WHERE d1_.id_annonce = 87949 AND d1_.type_annonce = 'vendeur' AND c0_.etat = 'information_transmise' AND c0_.date_livraison >= 20260403;

SELECT
  c0_.id_commande AS id_commande_0,
  c0_.etat AS etat_1,
  c0_.id_cpte_utilisateur AS id_cpte_utilisateur_2,
  c0_.date_validation AS date_validation_3,
  c0_.montant_total AS montant_total_4,
  c0_.total_taxe AS total_taxe_5,
  c0_.mode_reglement AS mode_reglement_6,
  c0_.date_facturation AS date_facturation_7,
  c0_.date_livraison AS date_livraison_8,
  c0_.id_facture AS id_facture_9,
  c0_.id_commande_forfait AS id_commande_forfait_10,
  c0_.remuneration_partenaire AS remuneration_partenaire_11,
  c0_.com_from_site_partenaire AS com_from_site_partenaire_12,
  c0_.date_relance AS date_relance_13,
  c0_.date_virement_cheque AS date_virement_cheque_14,
  c0_.date_rapprochement_cb AS date_rapprochement_cb_15,
  c0_.suivi_qualite AS suivi_qualite_16,
  c0_.societe_facturation AS societe_facturation_17,
  c0_.adresse AS adresse_18,
  c0_.code_postal AS code_postal_19,
  c0_.ville AS ville_20,
  c0_.pays AS pays_21,
  c0_.id_pays_commande AS id_pays_commande_22,
  c0_.date_lancer_suivi_qualite AS date_lancer_suivi_qualite_23,
  c0_.ref_facture AS ref_facture_24,
  c0_.tva_intracommunautaire AS tva_intracommunautaire_25,
  c0_.raison_ht AS raison_ht_26
FROM
  fusacq_dbo.commandes c0_
  INNER JOIN fusacq_dbo.details_commande d1_ ON (
    d1_.id_commande = c0_.id_commande
  )
WHERE
  d1_.id_annonce = 88409
  AND d1_.type_annonce = 'vendeur'
  AND c0_.etat = 'information_transmise'

SELECT c0_.id_commande AS id_commande_0, c0_.etat AS etat_1, c0_.id_cpte_utilisateur AS id_cpte_utilisateur_2, c0_.date_validation AS date_validation_3, c0_.montant_total AS montant_total_4, c0_.total_taxe AS total_taxe_5, c0_.mode_reglement AS mode_reglement_6, c0_.date_facturation AS date_facturation_7, c0_.date_livraison AS date_livraison_8, c0_.id_facture AS id_facture_9, c0_.id_commande_forfait AS id_commande_forfait_10, c0_.remuneration_partenaire AS remuneration_partenaire_11, c0_.com_from_site_partenaire AS com_from_site_partenaire_12, c0_.date_relance AS date_relance_13, c0_.date_virement_cheque AS date_virement_cheque_14, c0_.date_rapprochement_cb AS date_rapprochement_cb_15, c0_.suivi_qualite AS suivi_qualite_16, c0_.societe_facturation AS societe_facturation_17, c0_.adresse AS adresse_18, c0_.code_postal AS code_postal_19, c0_.ville AS ville_20, c0_.pays AS pays_21, c0_.id_pays_commande AS id_pays_commande_22, c0_.date_lancer_suivi_qualite AS date_lancer_suivi_qualite_23, c0_.ref_facture AS ref_facture_24, c0_.tva_intracommunautaire AS tva_intracommunautaire_25, c0_.raison_ht AS raison_ht_26 FROM fusacq_dbo.commandes c0_ INNER JOIN fusacq_dbo.details_commande d1_ ON (d1_.id_commande = c0_.id_commande) WHERE d1_.id_annonce = 88409 AND d1_.type_annonce = 'vendeur' AND c0_.etat = 'information_transmise';

SELECT
  c0_.id_commande AS id_commande_0,
  c0_.etat AS etat_1,
  c0_.id_cpte_utilisateur AS id_cpte_utilisateur_2,
  c0_.date_validation AS date_validation_3,
  c0_.montant_total AS montant_total_4,
  c0_.total_taxe AS total_taxe_5,
  c0_.mode_reglement AS mode_reglement_6,
  c0_.date_facturation AS date_facturation_7,
  c0_.date_livraison AS date_livraison_8,
  c0_.id_facture AS id_facture_9,
  c0_.id_commande_forfait AS id_commande_forfait_10,
  c0_.remuneration_partenaire AS remuneration_partenaire_11,
  c0_.com_from_site_partenaire AS com_from_site_partenaire_12,
  c0_.date_relance AS date_relance_13,
  c0_.date_virement_cheque AS date_virement_cheque_14,
  c0_.date_rapprochement_cb AS date_rapprochement_cb_15,
  c0_.suivi_qualite AS suivi_qualite_16,
  c0_.societe_facturation AS societe_facturation_17,
  c0_.adresse AS adresse_18,
  c0_.code_postal AS code_postal_19,
  c0_.ville AS ville_20,
  c0_.pays AS pays_21,
  c0_.id_pays_commande AS id_pays_commande_22,
  c0_.date_lancer_suivi_qualite AS date_lancer_suivi_qualite_23,
  c0_.ref_facture AS ref_facture_24,
  c0_.tva_intracommunautaire AS tva_intracommunautaire_25,
  c0_.raison_ht AS raison_ht_26
FROM
  fusacq_dbo.commandes c0_
  INNER JOIN fusacq_dbo.details_commande d1_ ON (
    d1_.id_commande = c0_.id_commande
  )
WHERE
  d1_.id_annonce = 88409
  AND d1_.type_annonce = 'vendeur'
  AND c0_.etat = 'information_transmise'
  AND c0_.date_livraison >= 20260403

SELECT c0_.id_commande AS id_commande_0, c0_.etat AS etat_1, c0_.id_cpte_utilisateur AS id_cpte_utilisateur_2, c0_.date_validation AS date_validation_3, c0_.montant_total AS montant_total_4, c0_.total_taxe AS total_taxe_5, c0_.mode_reglement AS mode_reglement_6, c0_.date_facturation AS date_facturation_7, c0_.date_livraison AS date_livraison_8, c0_.id_facture AS id_facture_9, c0_.id_commande_forfait AS id_commande_forfait_10, c0_.remuneration_partenaire AS remuneration_partenaire_11, c0_.com_from_site_partenaire AS com_from_site_partenaire_12, c0_.date_relance AS date_relance_13, c0_.date_virement_cheque AS date_virement_cheque_14, c0_.date_rapprochement_cb AS date_rapprochement_cb_15, c0_.suivi_qualite AS suivi_qualite_16, c0_.societe_facturation AS societe_facturation_17, c0_.adresse AS adresse_18, c0_.code_postal AS code_postal_19, c0_.ville AS ville_20, c0_.pays AS pays_21, c0_.id_pays_commande AS id_pays_commande_22, c0_.date_lancer_suivi_qualite AS date_lancer_suivi_qualite_23, c0_.ref_facture AS ref_facture_24, c0_.tva_intracommunautaire AS tva_intracommunautaire_25, c0_.raison_ht AS raison_ht_26 FROM fusacq_dbo.commandes c0_ INNER JOIN fusacq_dbo.details_commande d1_ ON (d1_.id_commande = c0_.id_commande) WHERE d1_.id_annonce = 88409 AND d1_.type_annonce = 'vendeur' AND c0_.etat = 'information_transmise' AND c0_.date_livraison >= 20260403;

SELECT
  c0_.id_commande AS id_commande_0,
  c0_.etat AS etat_1,
  c0_.id_cpte_utilisateur AS id_cpte_utilisateur_2,
  c0_.date_validation AS date_validation_3,
  c0_.montant_total AS montant_total_4,
  c0_.total_taxe AS total_taxe_5,
  c0_.mode_reglement AS mode_reglement_6,
  c0_.date_facturation AS date_facturation_7,
  c0_.date_livraison AS date_livraison_8,
  c0_.id_facture AS id_facture_9,
  c0_.id_commande_forfait AS id_commande_forfait_10,
  c0_.remuneration_partenaire AS remuneration_partenaire_11,
  c0_.com_from_site_partenaire AS com_from_site_partenaire_12,
  c0_.date_relance AS date_relance_13,
  c0_.date_virement_cheque AS date_virement_cheque_14,
  c0_.date_rapprochement_cb AS date_rapprochement_cb_15,
  c0_.suivi_qualite AS suivi_qualite_16,
  c0_.societe_facturation AS societe_facturation_17,
  c0_.adresse AS adresse_18,
  c0_.code_postal AS code_postal_19,
  c0_.ville AS ville_20,
  c0_.pays AS pays_21,
  c0_.id_pays_commande AS id_pays_commande_22,
  c0_.date_lancer_suivi_qualite AS date_lancer_suivi_qualite_23,
  c0_.ref_facture AS ref_facture_24,
  c0_.tva_intracommunautaire AS tva_intracommunautaire_25,
  c0_.raison_ht AS raison_ht_26
FROM
  fusacq_dbo.commandes c0_
  INNER JOIN fusacq_dbo.details_commande d1_ ON (
    d1_.id_commande = c0_.id_commande
  )
WHERE
  d1_.id_annonce = 88902
  AND d1_.type_annonce = 'vendeur'
  AND c0_.etat = 'information_transmise'
  AND c0_.date_livraison >= 20260403

SELECT c0_.id_commande AS id_commande_0, c0_.etat AS etat_1, c0_.id_cpte_utilisateur AS id_cpte_utilisateur_2, c0_.date_validation AS date_validation_3, c0_.montant_total AS montant_total_4, c0_.total_taxe AS total_taxe_5, c0_.mode_reglement AS mode_reglement_6, c0_.date_facturation AS date_facturation_7, c0_.date_livraison AS date_livraison_8, c0_.id_facture AS id_facture_9, c0_.id_commande_forfait AS id_commande_forfait_10, c0_.remuneration_partenaire AS remuneration_partenaire_11, c0_.com_from_site_partenaire AS com_from_site_partenaire_12, c0_.date_relance AS date_relance_13, c0_.date_virement_cheque AS date_virement_cheque_14, c0_.date_rapprochement_cb AS date_rapprochement_cb_15, c0_.suivi_qualite AS suivi_qualite_16, c0_.societe_facturation AS societe_facturation_17, c0_.adresse AS adresse_18, c0_.code_postal AS code_postal_19, c0_.ville AS ville_20, c0_.pays AS pays_21, c0_.id_pays_commande AS id_pays_commande_22, c0_.date_lancer_suivi_qualite AS date_lancer_suivi_qualite_23, c0_.ref_facture AS ref_facture_24, c0_.tva_intracommunautaire AS tva_intracommunautaire_25, c0_.raison_ht AS raison_ht_26 FROM fusacq_dbo.commandes c0_ INNER JOIN fusacq_dbo.details_commande d1_ ON (d1_.id_commande = c0_.id_commande) WHERE d1_.id_annonce = 88902 AND d1_.type_annonce = 'vendeur' AND c0_.etat = 'information_transmise' AND c0_.date_livraison >= 20260403;

SELECT
  c0_.id_commande AS id_commande_0,
  c0_.etat AS etat_1,
  c0_.id_cpte_utilisateur AS id_cpte_utilisateur_2,
  c0_.date_validation AS date_validation_3,
  c0_.montant_total AS montant_total_4,
  c0_.total_taxe AS total_taxe_5,
  c0_.mode_reglement AS mode_reglement_6,
  c0_.date_facturation AS date_facturation_7,
  c0_.date_livraison AS date_livraison_8,
  c0_.id_facture AS id_facture_9,
  c0_.id_commande_forfait AS id_commande_forfait_10,
  c0_.remuneration_partenaire AS remuneration_partenaire_11,
  c0_.com_from_site_partenaire AS com_from_site_partenaire_12,
  c0_.date_relance AS date_relance_13,
  c0_.date_virement_cheque AS date_virement_cheque_14,
  c0_.date_rapprochement_cb AS date_rapprochement_cb_15,
  c0_.suivi_qualite AS suivi_qualite_16,
  c0_.societe_facturation AS societe_facturation_17,
  c0_.adresse AS adresse_18,
  c0_.code_postal AS code_postal_19,
  c0_.ville AS ville_20,
  c0_.pays AS pays_21,
  c0_.id_pays_commande AS id_pays_commande_22,
  c0_.date_lancer_suivi_qualite AS date_lancer_suivi_qualite_23,
  c0_.ref_facture AS ref_facture_24,
  c0_.tva_intracommunautaire AS tva_intracommunautaire_25,
  c0_.raison_ht AS raison_ht_26
FROM
  fusacq_dbo.commandes c0_
  INNER JOIN fusacq_dbo.details_commande d1_ ON (
    d1_.id_commande = c0_.id_commande
  )
WHERE
  d1_.id_annonce = 88047
  AND d1_.type_annonce = 'vendeur'
  AND c0_.etat = 'information_transmise'
  AND c0_.date_livraison >= 20260403

SELECT c0_.id_commande AS id_commande_0, c0_.etat AS etat_1, c0_.id_cpte_utilisateur AS id_cpte_utilisateur_2, c0_.date_validation AS date_validation_3, c0_.montant_total AS montant_total_4, c0_.total_taxe AS total_taxe_5, c0_.mode_reglement AS mode_reglement_6, c0_.date_facturation AS date_facturation_7, c0_.date_livraison AS date_livraison_8, c0_.id_facture AS id_facture_9, c0_.id_commande_forfait AS id_commande_forfait_10, c0_.remuneration_partenaire AS remuneration_partenaire_11, c0_.com_from_site_partenaire AS com_from_site_partenaire_12, c0_.date_relance AS date_relance_13, c0_.date_virement_cheque AS date_virement_cheque_14, c0_.date_rapprochement_cb AS date_rapprochement_cb_15, c0_.suivi_qualite AS suivi_qualite_16, c0_.societe_facturation AS societe_facturation_17, c0_.adresse AS adresse_18, c0_.code_postal AS code_postal_19, c0_.ville AS ville_20, c0_.pays AS pays_21, c0_.id_pays_commande AS id_pays_commande_22, c0_.date_lancer_suivi_qualite AS date_lancer_suivi_qualite_23, c0_.ref_facture AS ref_facture_24, c0_.tva_intracommunautaire AS tva_intracommunautaire_25, c0_.raison_ht AS raison_ht_26 FROM fusacq_dbo.commandes c0_ INNER JOIN fusacq_dbo.details_commande d1_ ON (d1_.id_commande = c0_.id_commande) WHERE d1_.id_annonce = 88047 AND d1_.type_annonce = 'vendeur' AND c0_.etat = 'information_transmise' AND c0_.date_livraison >= 20260403;