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
  s0_.session_client_order_id AS sclr_0,
  COUNT(s0_.id) AS sclr_1
FROM
  session_stagiaire s0_
WHERE
  s0_.session_client_order_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?
  )
  AND s0_.repas_id IS NOT NULL
  AND s0_.statut_id <> 4
GROUP BY
  s0_.session_client_order_id

SELECT s0_.session_client_order_id AS sclr_0, COUNT(s0_.id) AS sclr_1 FROM session_stagiaire s0_ WHERE s0_.session_client_order_id IN (2219, 2220, 2233, 2326, 2339, 2344, 2362, 2363, 2364, 2365, 2366, 2367, 2369, 2373, 2374, 2375, 2376, 2382, 2383, 2384, 2385, 2387, 2388, 2389, 2393, 2394, 2395, 2399, 2400, 2401, 2402, 2403, 2404, 2405, 2406, 2407, 2408, 2409, 2410, 2412, 2413, 2414, 2415, 2416, 2417, 2418, 2419) AND s0_.repas_id IS NOT NULL AND s0_.statut_id <> 4 GROUP BY s0_.session_client_order_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';