Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.nom AS nom_3,
  t0.prenom AS prenom_4,
  t0.roles AS roles_5,
  t0.password AS password_6,
  t0.internal_ref AS internal_ref_7,
  t0.origin_id AS origin_id_8,
  t0.parent_origin_id AS parent_origin_id_9,
  t0.picto AS picto_10,
  t0.parent_id AS parent_id_11,
  t0.point_of_sale_id AS point_of_sale_id_12,
  t0.role_app_id AS role_app_id_13,
  t0.organisation_id AS organisation_id_14
FROM
  user t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.nom AS nom_3, t0.prenom AS prenom_4, t0.roles AS roles_5, t0.password AS password_6, t0.internal_ref AS internal_ref_7, t0.origin_id AS origin_id_8, t0.parent_origin_id AS parent_origin_id_9, t0.picto AS picto_10, t0.parent_id AS parent_id_11, t0.point_of_sale_id AS point_of_sale_id_12, t0.role_app_id AS role_app_id_13, t0.organisation_id AS organisation_id_14 FROM user t0 WHERE t0.email = 'liteyear@nomad.fr' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.code AS code_4,
  t0.operator_id AS operator_id_5,
  t0.organisation_id AS organisation_id_6
FROM
  point_of_sale t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.code AS code_4, t0.operator_id AS operator_id_5, t0.organisation_id AS organisation_id_6 FROM point_of_sale t0 WHERE t0.id = '4' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.nom AS nom_3,
  t0.description AS description_4,
  t0.operator_id AS operator_id_5
FROM
  etat_production t0
WHERE
  t0.nom = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.description AS description_4, t0.operator_id AS operator_id_5 FROM etat_production t0 WHERE t0.nom = 'Racco KO' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.nom AS nom_3,
  t0.description AS description_4,
  t0.operator_id AS operator_id_5
FROM
  etat_production t0
WHERE
  t0.nom = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.description AS description_4, t0.operator_id AS operator_id_5 FROM etat_production t0 WHERE t0.nom = 'Raccorde' LIMIT 1;

SELECT
  AVG(s0_.note_satisfaction) AS sclr_0
FROM
  satisfaction_client s0_
  LEFT JOIN production p1_ ON s0_.production_id = p1_.id
  LEFT JOIN cluster c2_ ON p1_.cluster_id = c2_.id
WHERE
  MONTH(s0_.date_contrat) = ?
  AND YEAR(s0_.date_contrat) = ?
  AND s0_.cod_poin_vent = ?
  AND p1_.category_id IN (?, ?, ?)

SELECT AVG(s0_.note_satisfaction) AS sclr_0 FROM satisfaction_client s0_ LEFT JOIN production p1_ ON s0_.production_id = p1_.id LEFT JOIN cluster c2_ ON p1_.cluster_id = c2_.id WHERE MONTH(s0_.date_contrat) = 1 AND YEAR(s0_.date_contrat) = 2026 AND s0_.cod_poin_vent = '1053520' AND p1_.category_id IN (1, 2, 3);

SELECT
  COUNT(p0_.id) AS sclr_0
FROM
  production p0_
  LEFT JOIN point_of_sale p1_ ON p0_.point_of_sale_id = p1_.id
  LEFT JOIN cluster c2_ ON p0_.cluster_id = c2_.id
WHERE
  p0_.point_of_sale_id = ?
  AND MONTH(p0_.date_vente_valid_b) = ?
  AND YEAR(p0_.date_vente_valid_b) = ?
  AND p0_.category_id IN (?, ?, ?)
ORDER BY
  sclr_0 DESC

SELECT COUNT(p0_.id) AS sclr_0 FROM production p0_ LEFT JOIN point_of_sale p1_ ON p0_.point_of_sale_id = p1_.id LEFT JOIN cluster c2_ ON p0_.cluster_id = c2_.id WHERE p0_.point_of_sale_id = 4 AND MONTH(p0_.date_vente_valid_b) = 1 AND YEAR(p0_.date_vente_valid_b) = 2026 AND p0_.category_id IN (1, 2, 3) ORDER BY sclr_0 DESC;

SELECT
  COUNT(p0_.id) AS sclr_0
FROM
  production p0_
  LEFT JOIN point_of_sale p1_ ON p0_.point_of_sale_id = p1_.id
  LEFT JOIN cluster c2_ ON p0_.cluster_id = c2_.id
WHERE
  p0_.point_of_sale_id = ?
  AND MONTH(p0_.date_cmd_a) = ?
  AND YEAR(p0_.date_cmd_a) = ?
  AND p0_.product_id IN (
    150, 262, 264, 266, 334, 335, 341, 344,
    345, 379, 441, 442, 443, 444
  )
ORDER BY
  sclr_0 DESC

SELECT COUNT(p0_.id) AS sclr_0 FROM production p0_ LEFT JOIN point_of_sale p1_ ON p0_.point_of_sale_id = p1_.id LEFT JOIN cluster c2_ ON p0_.cluster_id = c2_.id WHERE p0_.point_of_sale_id = 4 AND MONTH(p0_.date_cmd_a) = 1 AND YEAR(p0_.date_cmd_a) = 2026 AND p0_.product_id IN (150, 262, 264, 266, 334, 335, 341, 344, 345, 379, 441, 442, 443, 444) ORDER BY sclr_0 DESC;

SELECT
  COUNT(p0_.id) AS sclr_0
FROM
  production p0_
  LEFT JOIN point_of_sale p1_ ON p0_.point_of_sale_id = p1_.id
  LEFT JOIN cluster c2_ ON p0_.cluster_id = c2_.id
WHERE
  p0_.point_of_sale_id = ?
  AND MONTH(p0_.date_cmd_a) = ?
  AND YEAR(p0_.date_cmd_a) = ?
  AND p0_.date_racc IS NOT NULL
  AND (
    p0_.category_id IN (1, 3)
    OR (
      p0_.category_id IN (31)
      AND p0_.product_id IN (
        150, 262, 264, 266, 334, 335, 341, 344,
        345, 379, 441, 442, 443, 444
      )
    )
  )
ORDER BY
  sclr_0 DESC

SELECT COUNT(p0_.id) AS sclr_0 FROM production p0_ LEFT JOIN point_of_sale p1_ ON p0_.point_of_sale_id = p1_.id LEFT JOIN cluster c2_ ON p0_.cluster_id = c2_.id WHERE p0_.point_of_sale_id = 4 AND MONTH(p0_.date_cmd_a) = 1 AND YEAR(p0_.date_cmd_a) = 2026 AND p0_.date_racc IS NOT NULL AND (p0_.category_id IN (1, 3) OR (p0_.category_id IN (31) AND p0_.product_id IN (150, 262, 264, 266, 334, 335, 341, 344, 345, 379, 441, 442, 443, 444))) ORDER BY sclr_0 DESC;

SELECT
  COUNT(p0_.id) AS sclr_0
FROM
  production p0_
  LEFT JOIN point_of_sale p1_ ON p0_.point_of_sale_id = p1_.id
  LEFT JOIN cluster c2_ ON p0_.cluster_id = c2_.id
WHERE
  p0_.point_of_sale_id = ?
  AND MONTH(p0_.date_cmd_a) = ?
  AND YEAR(p0_.date_cmd_a) = ?
  AND p0_.date_racc IS NOT NULL
  AND (
    p0_.category_id IN (1, 2, 3)
    OR p0_.product_id IN (
      150, 262, 264, 266, 334, 335, 341, 344,
      345, 379, 441, 442, 443, 444
    )
  )
ORDER BY
  sclr_0 DESC

SELECT COUNT(p0_.id) AS sclr_0 FROM production p0_ LEFT JOIN point_of_sale p1_ ON p0_.point_of_sale_id = p1_.id LEFT JOIN cluster c2_ ON p0_.cluster_id = c2_.id WHERE p0_.point_of_sale_id = 4 AND MONTH(p0_.date_cmd_a) = 1 AND YEAR(p0_.date_cmd_a) = 2026 AND p0_.date_racc IS NOT NULL AND (p0_.category_id IN (1, 2, 3) OR p0_.product_id IN (150, 262, 264, 266, 334, 335, 341, 344, 345, 379, 441, 442, 443, 444)) ORDER BY sclr_0 DESC;

SELECT
  COUNT(p0_.id) AS sclr_0
FROM
  production p0_
  LEFT JOIN point_of_sale p1_ ON p0_.point_of_sale_id = p1_.id
  LEFT JOIN cluster c2_ ON p0_.cluster_id = c2_.id
WHERE
  p0_.point_of_sale_id = ?
  AND MONTH(p0_.date_cmd_a) = ?
  AND YEAR(p0_.date_cmd_a) = ?
  AND p0_.category_id IN (?, ?, ?)
  AND p0_.category_id IN (31, 32, 33, 48)
  AND p0_.date_racc IS NOT NULL
  AND p0_.product_id NOT IN (
    150, 262, 264, 266, 334, 335, 341, 344,
    345, 379, 441, 442, 443, 444
  )
ORDER BY
  sclr_0 DESC

SELECT COUNT(p0_.id) AS sclr_0 FROM production p0_ LEFT JOIN point_of_sale p1_ ON p0_.point_of_sale_id = p1_.id LEFT JOIN cluster c2_ ON p0_.cluster_id = c2_.id WHERE p0_.point_of_sale_id = 4 AND MONTH(p0_.date_cmd_a) = 1 AND YEAR(p0_.date_cmd_a) = 2026 AND p0_.category_id IN (31, 32, 33) AND p0_.category_id IN (31, 32, 33, 48) AND p0_.date_racc IS NOT NULL AND p0_.product_id NOT IN (150, 262, 264, 266, 334, 335, 341, 344, 345, 379, 441, 442, 443, 444) ORDER BY sclr_0 DESC;

SELECT
  COUNT(DISTINCT u0_.id) AS sclr_0
FROM
  production p1_
  LEFT JOIN cluster c2_ ON p1_.cluster_id = c2_.id
  LEFT JOIN point_of_sale p3_ ON p1_.point_of_sale_id = p3_.id
  LEFT JOIN user u0_ ON p1_.seller_id = u0_.id
WHERE
  p1_.point_of_sale_id = ?
  AND MONTH(p1_.date_vente_valid_b) = ?
  AND YEAR(p1_.date_vente_valid_b) = ?
  AND p1_.category_id IN (?, ?, ?)

SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM production p1_ LEFT JOIN cluster c2_ ON p1_.cluster_id = c2_.id LEFT JOIN point_of_sale p3_ ON p1_.point_of_sale_id = p3_.id LEFT JOIN user u0_ ON p1_.seller_id = u0_.id WHERE p1_.point_of_sale_id = 4 AND MONTH(p1_.date_vente_valid_b) = 1 AND YEAR(p1_.date_vente_valid_b) = 2026 AND p1_.category_id IN (1, 2, 3);

SELECT
  COUNT(p0_.id) / NULLIF(
    COUNT(DISTINCT u1_.id),
    0
  ) AS sclr_0
FROM
  production p0_
  LEFT JOIN point_of_sale p2_ ON p0_.point_of_sale_id = p2_.id
  LEFT JOIN cluster c3_ ON p0_.cluster_id = c3_.id
  LEFT JOIN user u1_ ON p0_.seller_id = u1_.id
WHERE
  p0_.point_of_sale_id = ?
  AND MONTH(p0_.date_vente_valid_b) = ?
  AND YEAR(p0_.date_vente_valid_b) = ?
  AND p0_.category_id IN (?, ?, ?)

SELECT COUNT(p0_.id) / NULLIF(COUNT(DISTINCT u1_.id), 0) AS sclr_0 FROM production p0_ LEFT JOIN point_of_sale p2_ ON p0_.point_of_sale_id = p2_.id LEFT JOIN cluster c3_ ON p0_.cluster_id = c3_.id LEFT JOIN user u1_ ON p0_.seller_id = u1_.id WHERE p0_.point_of_sale_id = 4 AND MONTH(p0_.date_vente_valid_b) = 1 AND YEAR(p0_.date_vente_valid_b) = 2026 AND p0_.category_id IN (1, 2, 3);

SELECT
  COUNT(p0_.id) AS sclr_0
FROM
  production p0_
  LEFT JOIN point_of_sale p1_ ON p0_.point_of_sale_id = p1_.id
  LEFT JOIN cluster c2_ ON p0_.cluster_id = c2_.id
WHERE
  p0_.point_of_sale_id = ?
  AND MONTH(p0_.date_vente_valid_b) = ?
  AND YEAR(p0_.date_vente_valid_b) = ?
  AND p0_.etat_id = ?
  AND p0_.category_id IN (?, ?, ?)

SELECT COUNT(p0_.id) AS sclr_0 FROM production p0_ LEFT JOIN point_of_sale p1_ ON p0_.point_of_sale_id = p1_.id LEFT JOIN cluster c2_ ON p0_.cluster_id = c2_.id WHERE p0_.point_of_sale_id = 4 AND MONTH(p0_.date_vente_valid_b) = 1 AND YEAR(p0_.date_vente_valid_b) = 2026 AND p0_.etat_id = 2 AND p0_.category_id IN (1, 2, 3);

SELECT
  SUM(n0_.vv) AS sclr_0
FROM
  nmd_objectif_clusters n0_
WHERE
  n0_.cpv = ?
  AND n0_.mois = ?
  AND n0_.year = ?

SELECT SUM(n0_.vv) AS sclr_0 FROM nmd_objectif_clusters n0_ WHERE n0_.cpv = '1053520' AND n0_.mois = 1 AND n0_.year = 2026;

SELECT
  COUNT(p0_.id) AS sclr_0
FROM
  production p0_
  LEFT JOIN point_of_sale p1_ ON p0_.point_of_sale_id = p1_.id
  LEFT JOIN cluster c2_ ON p0_.cluster_id = c2_.id
WHERE
  p0_.point_of_sale_id = ?
  AND MONTH(p0_.date_vente_valid_b) = ?
  AND YEAR(p0_.date_vente_valid_b) = ?
  AND p0_.date_vente_valid_b <= ?
  AND p0_.category_id IN (?, ?, ?)

SELECT COUNT(p0_.id) AS sclr_0 FROM production p0_ LEFT JOIN point_of_sale p1_ ON p0_.point_of_sale_id = p1_.id LEFT JOIN cluster c2_ ON p0_.cluster_id = c2_.id WHERE p0_.point_of_sale_id = 4 AND MONTH(p0_.date_vente_valid_b) = 1 AND YEAR(p0_.date_vente_valid_b) = 2026 AND p0_.date_vente_valid_b <= '2026-02-10 10:37:39' AND p0_.category_id IN (1, 2, 3);

SELECT
  COUNT(
    DISTINCT DAY(p.date_vente_valid_b)
  )
FROM
  production p
WHERE
  p.point_of_sale_id = :pointOfSale
  AND MONTH(p.date_vente_valid_b) = :mois
  AND YEAR(p.date_vente_valid_b) = :annee
  AND DAYOFWEEK(p.date_vente_valid_b) >= 2
  AND DAYOFWEEK(p.date_vente_valid_b) <= 6 -- Jours de travail (lundi à vendredi)
  AND p.date_vente_valid_b <= CURDATE() -- Jusqu'à aujourd'hui
  AND p.category_id IN (:cat0, :cat1, :cat2)

SELECT COUNT(DISTINCT DAY(p.date_vente_valid_b))
        FROM production p
        WHERE p.point_of_sale_id = 4
        AND MONTH(p.date_vente_valid_b) = 1
        AND YEAR(p.date_vente_valid_b) = 2026
        AND DAYOFWEEK(p.date_vente_valid_b) >= 2 AND DAYOFWEEK(p.date_vente_valid_b) <= 6  -- Jours de travail (lundi à vendredi)
        AND p.date_vente_valid_b <= CURDATE()  -- Jusqu'à aujourd'hui
     AND p.category_id IN (:cat0,:cat1,:cat2);

SELECT
  COUNT(p0_.id) AS sclr_0
FROM
  production p0_
  LEFT JOIN point_of_sale p1_ ON p0_.point_of_sale_id = p1_.id
  LEFT JOIN cluster c2_ ON p0_.cluster_id = c2_.id
WHERE
  p0_.point_of_sale_id = ?
  AND MONTH(p0_.date_vente_valid_b) = ?
  AND YEAR(p0_.date_vente_valid_b) = ?
  AND p0_.date_vente_valid_b <= ?
  AND p0_.category_id IN (?, ?, ?)

SELECT COUNT(p0_.id) AS sclr_0 FROM production p0_ LEFT JOIN point_of_sale p1_ ON p0_.point_of_sale_id = p1_.id LEFT JOIN cluster c2_ ON p0_.cluster_id = c2_.id WHERE p0_.point_of_sale_id = 4 AND MONTH(p0_.date_vente_valid_b) = 1 AND YEAR(p0_.date_vente_valid_b) = 2026 AND p0_.date_vente_valid_b <= '2026-02-10 10:37:39' AND p0_.category_id IN (1, 2, 3);

SELECT
  COUNT(
    DISTINCT DAY(p.date_vente_valid_b)
  )
FROM
  production p
WHERE
  p.point_of_sale_id = :pointOfSale
  AND MONTH(p.date_vente_valid_b) = :mois
  AND YEAR(p.date_vente_valid_b) = :annee
  AND DAYOFWEEK(p.date_vente_valid_b) >= 2
  AND DAYOFWEEK(p.date_vente_valid_b) <= 6 -- Jours de travail (lundi à vendredi)
  AND p.date_vente_valid_b <= CURDATE() -- Jusqu'à aujourd'hui
  AND p.category_id IN (:cat0, :cat1, :cat2)

SELECT COUNT(DISTINCT DAY(p.date_vente_valid_b))
        FROM production p
        WHERE p.point_of_sale_id = 4
        AND MONTH(p.date_vente_valid_b) = 1
        AND YEAR(p.date_vente_valid_b) = 2026
        AND DAYOFWEEK(p.date_vente_valid_b) >= 2 AND DAYOFWEEK(p.date_vente_valid_b) <= 6  -- Jours de travail (lundi à vendredi)
        AND p.date_vente_valid_b <= CURDATE()  -- Jusqu'à aujourd'hui
     AND p.category_id IN (:cat0,:cat1,:cat2);

SELECT
  COUNT(p0_.id) AS sclr_0
FROM
  production p0_
  LEFT JOIN point_of_sale p1_ ON p0_.point_of_sale_id = p1_.id
  LEFT JOIN cluster c2_ ON p0_.cluster_id = c2_.id
WHERE
  p0_.point_of_sale_id = ?
  AND MONTH(p0_.date_vente_valid_b) = ?
  AND YEAR(p0_.date_vente_valid_b) = ?
  AND p0_.date_vente_valid_b <= ?
  AND p0_.category_id IN (?, ?, ?)

SELECT COUNT(p0_.id) AS sclr_0 FROM production p0_ LEFT JOIN point_of_sale p1_ ON p0_.point_of_sale_id = p1_.id LEFT JOIN cluster c2_ ON p0_.cluster_id = c2_.id WHERE p0_.point_of_sale_id = 4 AND MONTH(p0_.date_vente_valid_b) = 1 AND YEAR(p0_.date_vente_valid_b) = 2026 AND p0_.date_vente_valid_b <= '2026-02-10 10:37:39' AND p0_.category_id IN (1, 2, 3);

SELECT
  COUNT(
    DISTINCT DAY(p.date_vente_valid_b)
  )
FROM
  production p
WHERE
  p.point_of_sale_id = :pointOfSale
  AND MONTH(p.date_vente_valid_b) = :mois
  AND YEAR(p.date_vente_valid_b) = :annee
  AND DAYOFWEEK(p.date_vente_valid_b) >= 2
  AND DAYOFWEEK(p.date_vente_valid_b) <= 6 -- Jours de travail (lundi à vendredi)
  AND p.date_vente_valid_b <= CURDATE() -- Jusqu'à aujourd'hui
  AND p.category_id IN (:cat0, :cat1, :cat2)

SELECT COUNT(DISTINCT DAY(p.date_vente_valid_b))
        FROM production p
        WHERE p.point_of_sale_id = 4
        AND MONTH(p.date_vente_valid_b) = 1
        AND YEAR(p.date_vente_valid_b) = 2026
        AND DAYOFWEEK(p.date_vente_valid_b) >= 2 AND DAYOFWEEK(p.date_vente_valid_b) <= 6  -- Jours de travail (lundi à vendredi)
        AND p.date_vente_valid_b <= CURDATE()  -- Jusqu'à aujourd'hui
     AND p.category_id IN (:cat0,:cat1,:cat2);

SELECT
  COUNT(DISTINCT result.titulaire_email) AS total_vente
FROM
  (
    SELECT
      p1.titulaire_email
    FROM
      production p1
      LEFT JOIN cluster c1 ON c1.id = p1.cluster_id
    WHERE
      p1.category_id = :cat1
      AND p1.point_of_sale_id = :pointOfSale
      AND MONTH(p1.date_cmd_a) = :mois
      AND YEAR(p1.date_cmd_a) = :annee
      AND p1.titulaire_email IN (
        SELECT
          DISTINCT p_sub1.titulaire_email
        FROM
          production p_sub1
        WHERE
          p_sub1.category_id = 1
          AND p_sub1.point_of_sale_id = :pointOfSale
          AND MONTH(p_sub1.date_cmd_a) = :mois
          AND YEAR(p_sub1.date_cmd_a) = :annee
      )
    UNION
    SELECT
      p2.titulaire_email
    FROM
      production p2
      LEFT JOIN cluster c2 ON c2.id = p2.cluster_id
    WHERE
      p2.category_id = :cat2
      AND p2.point_of_sale_id = :pointOfSale
      AND MONTH(p2.date_cmd_a) = :mois
      AND YEAR(p2.date_cmd_a) = :annee
      AND p2.titulaire_email IN (
        SELECT
          DISTINCT p_sub2.titulaire_email
        FROM
          production p_sub2
        WHERE
          p_sub2.category_id IN (1, 3)
          AND p_sub2.point_of_sale_id = :pointOfSale
          AND MONTH(p_sub2.date_cmd_a) = :mois
          AND YEAR(p_sub2.date_cmd_a) = :annee
      )
  ) AS result

SELECT COUNT(DISTINCT result.titulaire_email) AS total_vente
            FROM (
                SELECT p1.titulaire_email
                FROM production p1
                LEFT JOIN cluster c1 ON c1.id=p1.cluster_id
                WHERE p1.category_id = 32
                  AND p1.point_of_sale_id = 4
                  AND MONTH(p1.date_cmd_a) = 1
                  AND YEAR(p1.date_cmd_a) = 2026
                  AND p1.titulaire_email IN (
                      SELECT DISTINCT p_sub1.titulaire_email
                      FROM production p_sub1
                      WHERE p_sub1.category_id = 1
                        AND p_sub1.point_of_sale_id = 4
                        AND MONTH(p_sub1.date_cmd_a) = 1
                        AND YEAR(p_sub1.date_cmd_a) = 2026
                  )
        
                UNION
                SELECT p2.titulaire_email
                FROM production p2
                LEFT JOIN cluster c2 ON c2.id=p2.cluster_id
                WHERE p2.category_id = 31
                  AND p2.point_of_sale_id = 4
                  AND MONTH(p2.date_cmd_a) = 1
                  AND YEAR(p2.date_cmd_a) = 2026
                  AND p2.titulaire_email IN (
                      SELECT DISTINCT p_sub2.titulaire_email
                      FROM production p_sub2
                      WHERE p_sub2.category_id IN (1, 3)
                        AND p_sub2.point_of_sale_id = 4
                        AND MONTH(p_sub2.date_cmd_a) = 1
                        AND YEAR(p_sub2.date_cmd_a) = 2026
                  )
        ) AS result;

SELECT
  COUNT(DISTINCT p0_.titulaire_email) AS sclr_0
FROM
  production p0_
  LEFT JOIN cluster c1_ ON p0_.cluster_id = c1_.id
WHERE
  p0_.point_of_sale_id = ?
  AND MONTH(p0_.date_cmd_a) = ?
  AND YEAR(p0_.date_cmd_a) = ?
  AND p0_.fixe_chainage IS NOT NULL
  AND p0_.category_id IN (31, 32, 33)

SELECT COUNT(DISTINCT p0_.titulaire_email) AS sclr_0 FROM production p0_ LEFT JOIN cluster c1_ ON p0_.cluster_id = c1_.id WHERE p0_.point_of_sale_id = 4 AND MONTH(p0_.date_cmd_a) = 1 AND YEAR(p0_.date_cmd_a) = 2026 AND p0_.fixe_chainage IS NOT NULL AND p0_.category_id IN (31, 32, 33);

SELECT
  COUNT(DISTINCT p.id) AS total_vente
FROM
  production p
  LEFT JOIN point_of_sale po ON p.point_of_sale_id = po.id
  LEFT JOIN cluster c ON p.cluster_id = c.id
WHERE
  p.point_of_sale_id = :pointOfSale
  AND p.date_resiliation IS NOT NULL
  AND p.date_racc IS NOT NULL
  AND DATEDIFF(p.date_racc, p.date_resiliation) > -31
  AND (
    p.category_id NOT IN (2, 31, 32, 33, 48)
    OR p.product_id IN(
      150, 262, 264, 266, 334, 335, 341, 344,
      345, 379
    )
  )
  AND MONTH(p.date_vente_valid_b) = :mois
  AND YEAR(p.date_vente_valid_b) = :annee

SELECT COUNT(DISTINCT p.id) AS total_vente
        FROM production p
        LEFT JOIN point_of_sale po ON p.point_of_sale_id = po.id
        LEFT JOIN cluster c ON p.cluster_id = c.id
        WHERE p.point_of_sale_id = 4
          AND p.date_resiliation IS NOT NULL
          AND p.date_racc IS NOT NULL
          AND DATEDIFF(p.date_racc, p.date_resiliation) > -31
          AND (p.category_id NOT IN (2, 31, 32, 33,48) OR p.product_id IN(150,262,264,266,334,335,341,344,345,379))
         AND MONTH(p.date_vente_valid_b) = 1 AND YEAR(p.date_vente_valid_b) = 2026;

SELECT
  COUNT(DISTINCT p.id) AS total_vente
FROM
  production p
  LEFT JOIN point_of_sale po ON p.point_of_sale_id = po.id
  LEFT JOIN cluster c ON p.cluster_id = c.id
WHERE
  p.point_of_sale_id = :pointOfSale
  AND p.date_resiliation IS NOT NULL
  AND p.date_racc IS NOT NULL
  AND DATEDIFF(p.date_racc, p.date_resiliation) > -31
  AND (
    p.category_id NOT IN (2, 31, 32, 33, 48)
    OR p.product_id IN(
      150, 262, 264, 266, 334, 335, 341, 344,
      345, 379
    )
  )
  AND MONTH(p.date_cmd_a) = :mois
  AND YEAR(p.date_cmd_a) = :annee

SELECT COUNT(DISTINCT p.id) AS total_vente
        FROM production p
        LEFT JOIN point_of_sale po ON p.point_of_sale_id = po.id
        LEFT JOIN cluster c ON p.cluster_id = c.id
        WHERE p.point_of_sale_id = 4
          AND p.date_resiliation IS NOT NULL
          AND p.date_racc IS NOT NULL
          AND DATEDIFF(p.date_racc, p.date_resiliation) > -31
          AND (p.category_id NOT IN (2, 31, 32, 33,48) OR p.product_id IN(150,262,264,266,334,335,341,344,345,379))
         AND MONTH(p.date_cmd_a) = 1 AND YEAR(p.date_cmd_a) = 2026;

SELECT
  COUNT(DISTINCT p.id) AS total_vente
FROM
  production p
  LEFT JOIN point_of_sale po ON p.point_of_sale_id = po.id
  LEFT JOIN cluster c ON p.cluster_id = c.id
WHERE
  p.point_of_sale_id = :pointOfSale
  AND p.date_resiliation IS NOT NULL
  AND p.date_racc IS NOT NULL
  AND DATEDIFF(p.date_racc, p.date_resiliation) > -31
  AND (
    p.category_id IN(1, 3)
    OR (
      p.category_id IN(31)
      AND p.product_id IN(
        150, 262, 264, 266, 334, 335, 341, 344,
        345, 379, 441, 442, 443, 444
      )
    )
  )
  AND MONTH(p.date_cmd_a) = :mois
  AND YEAR(p.date_cmd_a) = :annee

SELECT COUNT(DISTINCT p.id) AS total_vente
        FROM production p
        LEFT JOIN point_of_sale po ON p.point_of_sale_id = po.id
        LEFT JOIN cluster c ON p.cluster_id = c.id
        WHERE p.point_of_sale_id = 4
          AND p.date_resiliation IS NOT NULL
          AND p.date_racc IS NOT NULL
          AND DATEDIFF(p.date_racc, p.date_resiliation) > -31
         AND 
		  (
            p.category_id IN(1,3) 
            OR 
            ( 
                p.category_id IN(31) AND p.product_id IN(150, 262, 264, 266, 334, 335, 341, 344, 345, 379,441,442,443,444)
            ) )
         AND MONTH(p.date_cmd_a) = 1 AND YEAR(p.date_cmd_a) = 2026;

SELECT
  COUNT(DISTINCT p.id) AS total_vente
FROM
  production p
  LEFT JOIN point_of_sale po ON p.point_of_sale_id = po.id
  LEFT JOIN cluster c ON p.cluster_id = c.id
WHERE
  p.point_of_sale_id = :pointOfSale
  AND p.date_resiliation IS NOT NULL
  AND p.date_racc IS NOT NULL
  AND DATEDIFF(p.date_racc, p.date_resiliation) > -31
  AND p.category_id IN(31, 32, 33, 48)
  AND MONTH(p.date_cmd_a) = :mois
  AND YEAR(p.date_cmd_a) = :annee

SELECT COUNT(DISTINCT p.id) AS total_vente
        FROM production p
        LEFT JOIN point_of_sale po ON p.point_of_sale_id = po.id
        LEFT JOIN cluster c ON p.cluster_id = c.id
        WHERE p.point_of_sale_id = 4
          AND p.date_resiliation IS NOT NULL
          AND p.date_racc  IS NOT NULL
          AND DATEDIFF(p.date_racc , p.date_resiliation) > -31
          AND p.category_id IN(31,32,33,48) 
     AND MONTH(p.date_cmd_a) = 1 AND YEAR(p.date_cmd_a) = 2026;

SELECT
  COUNT(DISTINCT p.id) AS total_vente
FROM
  production p
  LEFT JOIN point_of_sale po ON p.point_of_sale_id = po.id
  LEFT JOIN cluster c ON p.cluster_id = c.id
WHERE
  p.point_of_sale_id = :pointOfSale
  AND p.date_resiliation IS NOT NULL
  AND p.date_racc IS NOT NULL
  AND DATEDIFF(p.date_racc, p.date_resiliation) > -31
  AND p.category_id IN(31, 32, 33, 48)
  AND p.product_id NOT IN (
    150, 262, 264, 266, 334, 335, 341, 344,
    345, 379, 441, 442, 443, 444
  )
  AND MONTH(p.date_cmd_a) = :mois
  AND YEAR(p.date_cmd_a) = :annee

SELECT COUNT(DISTINCT p.id) AS total_vente
        FROM production p
        LEFT JOIN point_of_sale po ON p.point_of_sale_id = po.id
        LEFT JOIN cluster c ON p.cluster_id = c.id
        WHERE p.point_of_sale_id = 4
          AND p.date_resiliation IS NOT NULL
          AND p.date_racc  IS NOT NULL
          AND DATEDIFF(p.date_racc , p.date_resiliation) > -31
          AND p.category_id IN(31,32,33,48) 
     AND p.product_id NOT IN (150, 262, 264, 266, 334, 335, 341, 344, 345, 379,441,442,443,444) AND MONTH(p.date_cmd_a) = 1 AND YEAR(p.date_cmd_a) = 2026;

SELECT
  COUNT(DISTINCT p.titulaire_email) AS total_vente
FROM
  production p
  LEFT JOIN point_of_sale po ON p.point_of_sale_id = po.id
  LEFT JOIN cluster c ON p.cluster_id = c.id
WHERE
  p.point_of_sale_id = :pointOfSale
  AND p.category_id IN (
    SELECT
      DISTINCT(id)
    FROM
      category_product
    WHERE
      parent_category_id = 4
  )
  AND (
    p.fixe_chainage IS NOT NULL
    OR p.fixe_autre IS NOT NULL
  )
  AND MONTH(p.date_vente_valid_b) = :mois
  AND YEAR(p.date_vente_valid_b) = :annee

SELECT COUNT(DISTINCT p.titulaire_email) AS total_vente
        FROM production p
        LEFT JOIN point_of_sale po ON p.point_of_sale_id = po.id
        LEFT JOIN cluster c ON p.cluster_id = c.id
        WHERE p.point_of_sale_id = 4
          AND p.category_id IN (SELECT DISTINCT(id) FROM category_product WHERE parent_category_id =4)
          AND (
            p.fixe_chainage IS NOT NULL 
            OR p.fixe_autre IS NOT NULL
        )
     AND MONTH(p.date_vente_valid_b) = 1 AND YEAR(p.date_vente_valid_b) = 2026;