Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.token AS token_2
FROM
  bdd_api t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.token AS token_2 FROM bdd_api t0 WHERE t0.id = 1;

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1,
  b0_.prix AS prix_2,
  b0_.date_debut AS date_debut_3,
  b0_.date_fin AS date_fin_4
FROM
  bdd_ticket_repas b0_
WHERE
  b0_.date_debut <= ?
  AND b0_.date_fin >= ?

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.prix AS prix_2, b0_.date_debut AS date_debut_3, b0_.date_fin AS date_fin_4 FROM bdd_ticket_repas b0_ WHERE b0_.date_debut <= '2025-09-30 00:00:00' AND b0_.date_fin >= '2024-10-01 00:00:00';

SELECT
  s0_.id AS id_0,
  s0_.signature AS signature_1,
  s0_.numero_bon_commande AS numero_bon_commande_2,
  s0_.filename AS filename_3,
  s0_.date_signature AS date_signature_4,
  s0_.signature_filename AS signature_filename_5,
  s0_.dossier AS dossier_6,
  s0_.statut AS statut_7,
  s0_.facture AS facture_8,
  s0_.statut_non_facture AS statut_non_facture_9,
  s0_.created_at AS created_at_10,
  s0_.type_quantite AS type_quantite_11,
  s0_.formation_pu_ht AS formation_pu_ht_12,
  s0_.remise_ht AS remise_ht_13,
  s0_.type_quantite_materiel AS type_quantite_materiel_14,
  s0_.type_quantite_deplacement AS type_quantite_deplacement_15,
  s0_.type_quantite_document AS type_quantite_document_16,
  s0_.materiel_pu_ht AS materiel_pu_ht_17,
  s0_.deplacement_pu_ht AS deplacement_pu_ht_18,
  s0_.document_pu_ht AS document_pu_ht_19,
  s0_.dossier_pu_ht AS dossier_pu_ht_20,
  count(s1_.id) AS sclr_21,
  f2_.nombre_jour AS nombre_jour_22,
  s3_.date_start AS date_start_23,
  s0_.session_id AS session_id_24,
  s0_.client_id AS client_id_25
FROM
  session_client_order s0_
  LEFT JOIN sessions s4_ ON s0_.session_id = s4_.id
  LEFT JOIN session_dates s3_ ON s4_.id = s3_.session_id
  LEFT JOIN formations f2_ ON s4_.formation_id = f2_.id
  LEFT JOIN session_stagiaire s1_ ON s0_.id = s1_.session_client_order_id
  LEFT JOIN facture f5_ ON s0_.id = f5_.session_order_client_id
WHERE
  s0_.statut_non_facture IS NULL
  AND s3_.dernier_jour = 1
  AND (
    s3_.date_start BETWEEN ?
    AND ?
  )
  AND s1_.statut_id <= 3
  AND f5_.id IS NULL
GROUP BY
  s0_.id

SELECT s0_.id AS id_0, s0_.signature AS signature_1, s0_.numero_bon_commande AS numero_bon_commande_2, s0_.filename AS filename_3, s0_.date_signature AS date_signature_4, s0_.signature_filename AS signature_filename_5, s0_.dossier AS dossier_6, s0_.statut AS statut_7, s0_.facture AS facture_8, s0_.statut_non_facture AS statut_non_facture_9, s0_.created_at AS created_at_10, s0_.type_quantite AS type_quantite_11, s0_.formation_pu_ht AS formation_pu_ht_12, s0_.remise_ht AS remise_ht_13, s0_.type_quantite_materiel AS type_quantite_materiel_14, s0_.type_quantite_deplacement AS type_quantite_deplacement_15, s0_.type_quantite_document AS type_quantite_document_16, s0_.materiel_pu_ht AS materiel_pu_ht_17, s0_.deplacement_pu_ht AS deplacement_pu_ht_18, s0_.document_pu_ht AS document_pu_ht_19, s0_.dossier_pu_ht AS dossier_pu_ht_20, count(s1_.id) AS sclr_21, f2_.nombre_jour AS nombre_jour_22, s3_.date_start AS date_start_23, s0_.session_id AS session_id_24, s0_.client_id AS client_id_25 FROM session_client_order s0_ LEFT JOIN sessions s4_ ON s0_.session_id = s4_.id LEFT JOIN session_dates s3_ ON s4_.id = s3_.session_id LEFT JOIN formations f2_ ON s4_.formation_id = f2_.id LEFT JOIN session_stagiaire s1_ ON s0_.id = s1_.session_client_order_id LEFT JOIN facture f5_ ON s0_.id = f5_.session_order_client_id WHERE s0_.statut_non_facture IS NULL AND s3_.dernier_jour = 1 AND (s3_.date_start BETWEEN '2024-10-01 00:00:00' AND '2025-09-30 00:00:00') AND s1_.statut_id <= 3 AND f5_.id IS NULL GROUP BY s0_.id;

SELECT
  SUM(
    CASE WHEN f0_.statut = 1 THEN
      f1_.ht
    ELSE
      0
    END
  ) AS sclr_0,
  SUM(
    CASE WHEN f0_.statut = 2 THEN
      f1_.ht
    ELSE
      0
    END
  ) AS sclr_1,
  SUM(
    CASE WHEN f0_.statut = 3 THEN
      f1_.ht
    ELSE
      0
    END
  ) AS sclr_2,
  SUM(f1_.ht) AS sclr_3
FROM
  session_client_order s2_
  LEFT JOIN sessions s3_ ON s2_.session_id = s3_.id
  LEFT JOIN session_dates s4_ ON s3_.id = s4_.session_id
  LEFT JOIN facture f0_ ON s2_.id = f0_.session_order_client_id
  LEFT JOIN facture_prestation f1_ ON f0_.id = f1_.facture_id
WHERE
  (
    s3_.etat BETWEEN 1
    AND 3
  )
  AND s4_.dernier_jour = 1
  AND (
    s4_.date_start BETWEEN ?
    AND ?
  )
  AND SUBSTRING(
    s4_.date_start
    FROM
      6 FOR 2
  ) = ?

SELECT SUM(CASE WHEN f0_.statut = 1 THEN f1_.ht ELSE 0 END) AS sclr_0, SUM(CASE WHEN f0_.statut = 2 THEN f1_.ht ELSE 0 END) AS sclr_1, SUM(CASE WHEN f0_.statut = 3 THEN f1_.ht ELSE 0 END) AS sclr_2, SUM(f1_.ht) AS sclr_3 FROM session_client_order s2_ LEFT JOIN sessions s3_ ON s2_.session_id = s3_.id LEFT JOIN session_dates s4_ ON s3_.id = s4_.session_id LEFT JOIN facture f0_ ON s2_.id = f0_.session_order_client_id LEFT JOIN facture_prestation f1_ ON f0_.id = f1_.facture_id WHERE (s3_.etat BETWEEN 1 AND 3) AND s4_.dernier_jour = 1 AND (s4_.date_start BETWEEN '2024-10-01 00:00:00' AND '2025-09-30 00:00:00') AND SUBSTRING(s4_.date_start FROM 6 FOR 2) = '10';

SELECT
  SUM(
    CASE WHEN f0_.statut = 1 THEN
      f1_.ht
    ELSE
      0
    END
  ) AS sclr_0,
  SUM(
    CASE WHEN f0_.statut = 2 THEN
      f1_.ht
    ELSE
      0
    END
  ) AS sclr_1,
  SUM(
    CASE WHEN f0_.statut = 3 THEN
      f1_.ht
    ELSE
      0
    END
  ) AS sclr_2,
  SUM(f1_.ht) AS sclr_3
FROM
  session_client_order s2_
  LEFT JOIN sessions s3_ ON s2_.session_id = s3_.id
  LEFT JOIN session_dates s4_ ON s3_.id = s4_.session_id
  LEFT JOIN facture f0_ ON s2_.id = f0_.session_order_client_id
  LEFT JOIN facture_prestation f1_ ON f0_.id = f1_.facture_id
WHERE
  (
    s3_.etat BETWEEN 1
    AND 3
  )
  AND s4_.dernier_jour = 1
  AND (
    s4_.date_start BETWEEN ?
    AND ?
  )
  AND SUBSTRING(
    s4_.date_start
    FROM
      6 FOR 2
  ) = ?

SELECT SUM(CASE WHEN f0_.statut = 1 THEN f1_.ht ELSE 0 END) AS sclr_0, SUM(CASE WHEN f0_.statut = 2 THEN f1_.ht ELSE 0 END) AS sclr_1, SUM(CASE WHEN f0_.statut = 3 THEN f1_.ht ELSE 0 END) AS sclr_2, SUM(f1_.ht) AS sclr_3 FROM session_client_order s2_ LEFT JOIN sessions s3_ ON s2_.session_id = s3_.id LEFT JOIN session_dates s4_ ON s3_.id = s4_.session_id LEFT JOIN facture f0_ ON s2_.id = f0_.session_order_client_id LEFT JOIN facture_prestation f1_ ON f0_.id = f1_.facture_id WHERE (s3_.etat BETWEEN 1 AND 3) AND s4_.dernier_jour = 1 AND (s4_.date_start BETWEEN '2024-10-01 00:00:00' AND '2025-09-30 00:00:00') AND SUBSTRING(s4_.date_start FROM 6 FOR 2) = '11';

SELECT
  SUM(
    CASE WHEN f0_.statut = 1 THEN
      f1_.ht
    ELSE
      0
    END
  ) AS sclr_0,
  SUM(
    CASE WHEN f0_.statut = 2 THEN
      f1_.ht
    ELSE
      0
    END
  ) AS sclr_1,
  SUM(
    CASE WHEN f0_.statut = 3 THEN
      f1_.ht
    ELSE
      0
    END
  ) AS sclr_2,
  SUM(f1_.ht) AS sclr_3
FROM
  session_client_order s2_
  LEFT JOIN sessions s3_ ON s2_.session_id = s3_.id
  LEFT JOIN session_dates s4_ ON s3_.id = s4_.session_id
  LEFT JOIN facture f0_ ON s2_.id = f0_.session_order_client_id
  LEFT JOIN facture_prestation f1_ ON f0_.id = f1_.facture_id
WHERE
  (
    s3_.etat BETWEEN 1
    AND 3
  )
  AND s4_.dernier_jour = 1
  AND (
    s4_.date_start BETWEEN ?
    AND ?
  )
  AND SUBSTRING(
    s4_.date_start
    FROM
      6 FOR 2
  ) = ?

SELECT SUM(CASE WHEN f0_.statut = 1 THEN f1_.ht ELSE 0 END) AS sclr_0, SUM(CASE WHEN f0_.statut = 2 THEN f1_.ht ELSE 0 END) AS sclr_1, SUM(CASE WHEN f0_.statut = 3 THEN f1_.ht ELSE 0 END) AS sclr_2, SUM(f1_.ht) AS sclr_3 FROM session_client_order s2_ LEFT JOIN sessions s3_ ON s2_.session_id = s3_.id LEFT JOIN session_dates s4_ ON s3_.id = s4_.session_id LEFT JOIN facture f0_ ON s2_.id = f0_.session_order_client_id LEFT JOIN facture_prestation f1_ ON f0_.id = f1_.facture_id WHERE (s3_.etat BETWEEN 1 AND 3) AND s4_.dernier_jour = 1 AND (s4_.date_start BETWEEN '2024-10-01 00:00:00' AND '2025-09-30 00:00:00') AND SUBSTRING(s4_.date_start FROM 6 FOR 2) = '12';

SELECT
  SUM(
    CASE WHEN f0_.statut = 1 THEN
      f1_.ht
    ELSE
      0
    END
  ) AS sclr_0,
  SUM(
    CASE WHEN f0_.statut = 2 THEN
      f1_.ht
    ELSE
      0
    END
  ) AS sclr_1,
  SUM(
    CASE WHEN f0_.statut = 3 THEN
      f1_.ht
    ELSE
      0
    END
  ) AS sclr_2,
  SUM(f1_.ht) AS sclr_3
FROM
  session_client_order s2_
  LEFT JOIN sessions s3_ ON s2_.session_id = s3_.id
  LEFT JOIN session_dates s4_ ON s3_.id = s4_.session_id
  LEFT JOIN facture f0_ ON s2_.id = f0_.session_order_client_id
  LEFT JOIN facture_prestation f1_ ON f0_.id = f1_.facture_id
WHERE
  (
    s3_.etat BETWEEN 1
    AND 3
  )
  AND s4_.dernier_jour = 1
  AND (
    s4_.date_start BETWEEN ?
    AND ?
  )
  AND SUBSTRING(
    s4_.date_start
    FROM
      6 FOR 2
  ) = ?

SELECT SUM(CASE WHEN f0_.statut = 1 THEN f1_.ht ELSE 0 END) AS sclr_0, SUM(CASE WHEN f0_.statut = 2 THEN f1_.ht ELSE 0 END) AS sclr_1, SUM(CASE WHEN f0_.statut = 3 THEN f1_.ht ELSE 0 END) AS sclr_2, SUM(f1_.ht) AS sclr_3 FROM session_client_order s2_ LEFT JOIN sessions s3_ ON s2_.session_id = s3_.id LEFT JOIN session_dates s4_ ON s3_.id = s4_.session_id LEFT JOIN facture f0_ ON s2_.id = f0_.session_order_client_id LEFT JOIN facture_prestation f1_ ON f0_.id = f1_.facture_id WHERE (s3_.etat BETWEEN 1 AND 3) AND s4_.dernier_jour = 1 AND (s4_.date_start BETWEEN '2024-10-01 00:00:00' AND '2025-09-30 00:00:00') AND SUBSTRING(s4_.date_start FROM 6 FOR 2) = '01';

SELECT
  SUM(
    CASE WHEN f0_.statut = 1 THEN
      f1_.ht
    ELSE
      0
    END
  ) AS sclr_0,
  SUM(
    CASE WHEN f0_.statut = 2 THEN
      f1_.ht
    ELSE
      0
    END
  ) AS sclr_1,
  SUM(
    CASE WHEN f0_.statut = 3 THEN
      f1_.ht
    ELSE
      0
    END
  ) AS sclr_2,
  SUM(f1_.ht) AS sclr_3
FROM
  session_client_order s2_
  LEFT JOIN sessions s3_ ON s2_.session_id = s3_.id
  LEFT JOIN session_dates s4_ ON s3_.id = s4_.session_id
  LEFT JOIN facture f0_ ON s2_.id = f0_.session_order_client_id
  LEFT JOIN facture_prestation f1_ ON f0_.id = f1_.facture_id
WHERE
  (
    s3_.etat BETWEEN 1
    AND 3
  )
  AND s4_.dernier_jour = 1
  AND (
    s4_.date_start BETWEEN ?
    AND ?
  )
  AND SUBSTRING(
    s4_.date_start
    FROM
      6 FOR 2
  ) = ?

SELECT SUM(CASE WHEN f0_.statut = 1 THEN f1_.ht ELSE 0 END) AS sclr_0, SUM(CASE WHEN f0_.statut = 2 THEN f1_.ht ELSE 0 END) AS sclr_1, SUM(CASE WHEN f0_.statut = 3 THEN f1_.ht ELSE 0 END) AS sclr_2, SUM(f1_.ht) AS sclr_3 FROM session_client_order s2_ LEFT JOIN sessions s3_ ON s2_.session_id = s3_.id LEFT JOIN session_dates s4_ ON s3_.id = s4_.session_id LEFT JOIN facture f0_ ON s2_.id = f0_.session_order_client_id LEFT JOIN facture_prestation f1_ ON f0_.id = f1_.facture_id WHERE (s3_.etat BETWEEN 1 AND 3) AND s4_.dernier_jour = 1 AND (s4_.date_start BETWEEN '2024-10-01 00:00:00' AND '2025-09-30 00:00:00') AND SUBSTRING(s4_.date_start FROM 6 FOR 2) = '02';

SELECT
  SUM(
    CASE WHEN f0_.statut = 1 THEN
      f1_.ht
    ELSE
      0
    END
  ) AS sclr_0,
  SUM(
    CASE WHEN f0_.statut = 2 THEN
      f1_.ht
    ELSE
      0
    END
  ) AS sclr_1,
  SUM(
    CASE WHEN f0_.statut = 3 THEN
      f1_.ht
    ELSE
      0
    END
  ) AS sclr_2,
  SUM(f1_.ht) AS sclr_3
FROM
  session_client_order s2_
  LEFT JOIN sessions s3_ ON s2_.session_id = s3_.id
  LEFT JOIN session_dates s4_ ON s3_.id = s4_.session_id
  LEFT JOIN facture f0_ ON s2_.id = f0_.session_order_client_id
  LEFT JOIN facture_prestation f1_ ON f0_.id = f1_.facture_id
WHERE
  (
    s3_.etat BETWEEN 1
    AND 3
  )
  AND s4_.dernier_jour = 1
  AND (
    s4_.date_start BETWEEN ?
    AND ?
  )
  AND SUBSTRING(
    s4_.date_start
    FROM
      6 FOR 2
  ) = ?

SELECT SUM(CASE WHEN f0_.statut = 1 THEN f1_.ht ELSE 0 END) AS sclr_0, SUM(CASE WHEN f0_.statut = 2 THEN f1_.ht ELSE 0 END) AS sclr_1, SUM(CASE WHEN f0_.statut = 3 THEN f1_.ht ELSE 0 END) AS sclr_2, SUM(f1_.ht) AS sclr_3 FROM session_client_order s2_ LEFT JOIN sessions s3_ ON s2_.session_id = s3_.id LEFT JOIN session_dates s4_ ON s3_.id = s4_.session_id LEFT JOIN facture f0_ ON s2_.id = f0_.session_order_client_id LEFT JOIN facture_prestation f1_ ON f0_.id = f1_.facture_id WHERE (s3_.etat BETWEEN 1 AND 3) AND s4_.dernier_jour = 1 AND (s4_.date_start BETWEEN '2024-10-01 00:00:00' AND '2025-09-30 00:00:00') AND SUBSTRING(s4_.date_start FROM 6 FOR 2) = '03';

SELECT
  SUM(
    CASE WHEN f0_.statut = 1 THEN
      f1_.ht
    ELSE
      0
    END
  ) AS sclr_0,
  SUM(
    CASE WHEN f0_.statut = 2 THEN
      f1_.ht
    ELSE
      0
    END
  ) AS sclr_1,
  SUM(
    CASE WHEN f0_.statut = 3 THEN
      f1_.ht
    ELSE
      0
    END
  ) AS sclr_2,
  SUM(f1_.ht) AS sclr_3
FROM
  session_client_order s2_
  LEFT JOIN sessions s3_ ON s2_.session_id = s3_.id
  LEFT JOIN session_dates s4_ ON s3_.id = s4_.session_id
  LEFT JOIN facture f0_ ON s2_.id = f0_.session_order_client_id
  LEFT JOIN facture_prestation f1_ ON f0_.id = f1_.facture_id
WHERE
  (
    s3_.etat BETWEEN 1
    AND 3
  )
  AND s4_.dernier_jour = 1
  AND (
    s4_.date_start BETWEEN ?
    AND ?
  )
  AND SUBSTRING(
    s4_.date_start
    FROM
      6 FOR 2
  ) = ?

SELECT SUM(CASE WHEN f0_.statut = 1 THEN f1_.ht ELSE 0 END) AS sclr_0, SUM(CASE WHEN f0_.statut = 2 THEN f1_.ht ELSE 0 END) AS sclr_1, SUM(CASE WHEN f0_.statut = 3 THEN f1_.ht ELSE 0 END) AS sclr_2, SUM(f1_.ht) AS sclr_3 FROM session_client_order s2_ LEFT JOIN sessions s3_ ON s2_.session_id = s3_.id LEFT JOIN session_dates s4_ ON s3_.id = s4_.session_id LEFT JOIN facture f0_ ON s2_.id = f0_.session_order_client_id LEFT JOIN facture_prestation f1_ ON f0_.id = f1_.facture_id WHERE (s3_.etat BETWEEN 1 AND 3) AND s4_.dernier_jour = 1 AND (s4_.date_start BETWEEN '2024-10-01 00:00:00' AND '2025-09-30 00:00:00') AND SUBSTRING(s4_.date_start FROM 6 FOR 2) = '04';

SELECT
  SUM(
    CASE WHEN f0_.statut = 1 THEN
      f1_.ht
    ELSE
      0
    END
  ) AS sclr_0,
  SUM(
    CASE WHEN f0_.statut = 2 THEN
      f1_.ht
    ELSE
      0
    END
  ) AS sclr_1,
  SUM(
    CASE WHEN f0_.statut = 3 THEN
      f1_.ht
    ELSE
      0
    END
  ) AS sclr_2,
  SUM(f1_.ht) AS sclr_3
FROM
  session_client_order s2_
  LEFT JOIN sessions s3_ ON s2_.session_id = s3_.id
  LEFT JOIN session_dates s4_ ON s3_.id = s4_.session_id
  LEFT JOIN facture f0_ ON s2_.id = f0_.session_order_client_id
  LEFT JOIN facture_prestation f1_ ON f0_.id = f1_.facture_id
WHERE
  (
    s3_.etat BETWEEN 1
    AND 3
  )
  AND s4_.dernier_jour = 1
  AND (
    s4_.date_start BETWEEN ?
    AND ?
  )
  AND SUBSTRING(
    s4_.date_start
    FROM
      6 FOR 2
  ) = ?

SELECT SUM(CASE WHEN f0_.statut = 1 THEN f1_.ht ELSE 0 END) AS sclr_0, SUM(CASE WHEN f0_.statut = 2 THEN f1_.ht ELSE 0 END) AS sclr_1, SUM(CASE WHEN f0_.statut = 3 THEN f1_.ht ELSE 0 END) AS sclr_2, SUM(f1_.ht) AS sclr_3 FROM session_client_order s2_ LEFT JOIN sessions s3_ ON s2_.session_id = s3_.id LEFT JOIN session_dates s4_ ON s3_.id = s4_.session_id LEFT JOIN facture f0_ ON s2_.id = f0_.session_order_client_id LEFT JOIN facture_prestation f1_ ON f0_.id = f1_.facture_id WHERE (s3_.etat BETWEEN 1 AND 3) AND s4_.dernier_jour = 1 AND (s4_.date_start BETWEEN '2024-10-01 00:00:00' AND '2025-09-30 00:00:00') AND SUBSTRING(s4_.date_start FROM 6 FOR 2) = '05';

SELECT
  SUM(
    CASE WHEN f0_.statut = 1 THEN
      f1_.ht
    ELSE
      0
    END
  ) AS sclr_0,
  SUM(
    CASE WHEN f0_.statut = 2 THEN
      f1_.ht
    ELSE
      0
    END
  ) AS sclr_1,
  SUM(
    CASE WHEN f0_.statut = 3 THEN
      f1_.ht
    ELSE
      0
    END
  ) AS sclr_2,
  SUM(f1_.ht) AS sclr_3
FROM
  session_client_order s2_
  LEFT JOIN sessions s3_ ON s2_.session_id = s3_.id
  LEFT JOIN session_dates s4_ ON s3_.id = s4_.session_id
  LEFT JOIN facture f0_ ON s2_.id = f0_.session_order_client_id
  LEFT JOIN facture_prestation f1_ ON f0_.id = f1_.facture_id
WHERE
  (
    s3_.etat BETWEEN 1
    AND 3
  )
  AND s4_.dernier_jour = 1
  AND (
    s4_.date_start BETWEEN ?
    AND ?
  )
  AND SUBSTRING(
    s4_.date_start
    FROM
      6 FOR 2
  ) = ?

SELECT SUM(CASE WHEN f0_.statut = 1 THEN f1_.ht ELSE 0 END) AS sclr_0, SUM(CASE WHEN f0_.statut = 2 THEN f1_.ht ELSE 0 END) AS sclr_1, SUM(CASE WHEN f0_.statut = 3 THEN f1_.ht ELSE 0 END) AS sclr_2, SUM(f1_.ht) AS sclr_3 FROM session_client_order s2_ LEFT JOIN sessions s3_ ON s2_.session_id = s3_.id LEFT JOIN session_dates s4_ ON s3_.id = s4_.session_id LEFT JOIN facture f0_ ON s2_.id = f0_.session_order_client_id LEFT JOIN facture_prestation f1_ ON f0_.id = f1_.facture_id WHERE (s3_.etat BETWEEN 1 AND 3) AND s4_.dernier_jour = 1 AND (s4_.date_start BETWEEN '2024-10-01 00:00:00' AND '2025-09-30 00:00:00') AND SUBSTRING(s4_.date_start FROM 6 FOR 2) = '06';

SELECT
  SUM(
    CASE WHEN f0_.statut = 1 THEN
      f1_.ht
    ELSE
      0
    END
  ) AS sclr_0,
  SUM(
    CASE WHEN f0_.statut = 2 THEN
      f1_.ht
    ELSE
      0
    END
  ) AS sclr_1,
  SUM(
    CASE WHEN f0_.statut = 3 THEN
      f1_.ht
    ELSE
      0
    END
  ) AS sclr_2,
  SUM(f1_.ht) AS sclr_3
FROM
  session_client_order s2_
  LEFT JOIN sessions s3_ ON s2_.session_id = s3_.id
  LEFT JOIN session_dates s4_ ON s3_.id = s4_.session_id
  LEFT JOIN facture f0_ ON s2_.id = f0_.session_order_client_id
  LEFT JOIN facture_prestation f1_ ON f0_.id = f1_.facture_id
WHERE
  (
    s3_.etat BETWEEN 1
    AND 3
  )
  AND s4_.dernier_jour = 1
  AND (
    s4_.date_start BETWEEN ?
    AND ?
  )
  AND SUBSTRING(
    s4_.date_start
    FROM
      6 FOR 2
  ) = ?

SELECT SUM(CASE WHEN f0_.statut = 1 THEN f1_.ht ELSE 0 END) AS sclr_0, SUM(CASE WHEN f0_.statut = 2 THEN f1_.ht ELSE 0 END) AS sclr_1, SUM(CASE WHEN f0_.statut = 3 THEN f1_.ht ELSE 0 END) AS sclr_2, SUM(f1_.ht) AS sclr_3 FROM session_client_order s2_ LEFT JOIN sessions s3_ ON s2_.session_id = s3_.id LEFT JOIN session_dates s4_ ON s3_.id = s4_.session_id LEFT JOIN facture f0_ ON s2_.id = f0_.session_order_client_id LEFT JOIN facture_prestation f1_ ON f0_.id = f1_.facture_id WHERE (s3_.etat BETWEEN 1 AND 3) AND s4_.dernier_jour = 1 AND (s4_.date_start BETWEEN '2024-10-01 00:00:00' AND '2025-09-30 00:00:00') AND SUBSTRING(s4_.date_start FROM 6 FOR 2) = '07';

SELECT
  SUM(
    CASE WHEN f0_.statut = 1 THEN
      f1_.ht
    ELSE
      0
    END
  ) AS sclr_0,
  SUM(
    CASE WHEN f0_.statut = 2 THEN
      f1_.ht
    ELSE
      0
    END
  ) AS sclr_1,
  SUM(
    CASE WHEN f0_.statut = 3 THEN
      f1_.ht
    ELSE
      0
    END
  ) AS sclr_2,
  SUM(f1_.ht) AS sclr_3
FROM
  session_client_order s2_
  LEFT JOIN sessions s3_ ON s2_.session_id = s3_.id
  LEFT JOIN session_dates s4_ ON s3_.id = s4_.session_id
  LEFT JOIN facture f0_ ON s2_.id = f0_.session_order_client_id
  LEFT JOIN facture_prestation f1_ ON f0_.id = f1_.facture_id
WHERE
  (
    s3_.etat BETWEEN 1
    AND 3
  )
  AND s4_.dernier_jour = 1
  AND (
    s4_.date_start BETWEEN ?
    AND ?
  )
  AND SUBSTRING(
    s4_.date_start
    FROM
      6 FOR 2
  ) = ?

SELECT SUM(CASE WHEN f0_.statut = 1 THEN f1_.ht ELSE 0 END) AS sclr_0, SUM(CASE WHEN f0_.statut = 2 THEN f1_.ht ELSE 0 END) AS sclr_1, SUM(CASE WHEN f0_.statut = 3 THEN f1_.ht ELSE 0 END) AS sclr_2, SUM(f1_.ht) AS sclr_3 FROM session_client_order s2_ LEFT JOIN sessions s3_ ON s2_.session_id = s3_.id LEFT JOIN session_dates s4_ ON s3_.id = s4_.session_id LEFT JOIN facture f0_ ON s2_.id = f0_.session_order_client_id LEFT JOIN facture_prestation f1_ ON f0_.id = f1_.facture_id WHERE (s3_.etat BETWEEN 1 AND 3) AND s4_.dernier_jour = 1 AND (s4_.date_start BETWEEN '2024-10-01 00:00:00' AND '2025-09-30 00:00:00') AND SUBSTRING(s4_.date_start FROM 6 FOR 2) = '08';

SELECT
  SUM(
    CASE WHEN f0_.statut = 1 THEN
      f1_.ht
    ELSE
      0
    END
  ) AS sclr_0,
  SUM(
    CASE WHEN f0_.statut = 2 THEN
      f1_.ht
    ELSE
      0
    END
  ) AS sclr_1,
  SUM(
    CASE WHEN f0_.statut = 3 THEN
      f1_.ht
    ELSE
      0
    END
  ) AS sclr_2,
  SUM(f1_.ht) AS sclr_3
FROM
  session_client_order s2_
  LEFT JOIN sessions s3_ ON s2_.session_id = s3_.id
  LEFT JOIN session_dates s4_ ON s3_.id = s4_.session_id
  LEFT JOIN facture f0_ ON s2_.id = f0_.session_order_client_id
  LEFT JOIN facture_prestation f1_ ON f0_.id = f1_.facture_id
WHERE
  (
    s3_.etat BETWEEN 1
    AND 3
  )
  AND s4_.dernier_jour = 1
  AND (
    s4_.date_start BETWEEN ?
    AND ?
  )
  AND SUBSTRING(
    s4_.date_start
    FROM
      6 FOR 2
  ) = ?

SELECT SUM(CASE WHEN f0_.statut = 1 THEN f1_.ht ELSE 0 END) AS sclr_0, SUM(CASE WHEN f0_.statut = 2 THEN f1_.ht ELSE 0 END) AS sclr_1, SUM(CASE WHEN f0_.statut = 3 THEN f1_.ht ELSE 0 END) AS sclr_2, SUM(f1_.ht) AS sclr_3 FROM session_client_order s2_ LEFT JOIN sessions s3_ ON s2_.session_id = s3_.id LEFT JOIN session_dates s4_ ON s3_.id = s4_.session_id LEFT JOIN facture f0_ ON s2_.id = f0_.session_order_client_id LEFT JOIN facture_prestation f1_ ON f0_.id = f1_.facture_id WHERE (s3_.etat BETWEEN 1 AND 3) AND s4_.dernier_jour = 1 AND (s4_.date_start BETWEEN '2024-10-01 00:00:00' AND '2025-09-30 00:00:00') AND SUBSTRING(s4_.date_start FROM 6 FOR 2) = '09';