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 history h1_ ON s0_.history_id = h1_.id
  LEFT JOIN cluster c2_ ON h1_.cluster_id = c2_.id
WHERE
  MONTH(s0_.date_contrat) = ?
  AND YEAR(s0_.date_contrat) = ?
  AND s0_.cod_poin_vent = ?

SELECT AVG(s0_.note_satisfaction) AS sclr_0 FROM satisfaction_client s0_ LEFT JOIN history h1_ ON s0_.history_id = h1_.id LEFT JOIN cluster c2_ ON h1_.cluster_id = c2_.id WHERE MONTH(s0_.date_contrat) = 7 AND YEAR(s0_.date_contrat) = 2025 AND s0_.cod_poin_vent = '1053520';

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

SELECT COUNT(h0_.id) AS sclr_0 FROM history h0_ LEFT JOIN point_of_sale p1_ ON h0_.point_of_sale_id = p1_.id LEFT JOIN cluster c2_ ON h0_.cluster_id = c2_.id WHERE h0_.point_of_sale_id = 4 AND MONTH(h0_.date_vente_valid_b) = 7 AND YEAR(h0_.date_vente_valid_b) = 2025 ORDER BY sclr_0 DESC;

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

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

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

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

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

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

SELECT
  COUNT(h0_.id) AS sclr_0
FROM
  history h0_
  LEFT JOIN point_of_sale p1_ ON h0_.point_of_sale_id = p1_.id
  LEFT JOIN cluster c2_ ON h0_.cluster_id = c2_.id
WHERE
  h0_.point_of_sale_id = ?
  AND MONTH(h0_.date_cmd_a) = ?
  AND YEAR(h0_.date_cmd_a) = ?
  AND h0_.category_id IN (?, ?, ?)
  AND h0_.category_id IN (31, 32, 33, 48)
  AND h0_.date_racc IS NOT NULL
  AND h0_.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(h0_.id) AS sclr_0 FROM history h0_ LEFT JOIN point_of_sale p1_ ON h0_.point_of_sale_id = p1_.id LEFT JOIN cluster c2_ ON h0_.cluster_id = c2_.id WHERE h0_.point_of_sale_id = 4 AND MONTH(h0_.date_cmd_a) = 7 AND YEAR(h0_.date_cmd_a) = 2025 AND h0_.category_id IN (31, 32, 33) AND h0_.category_id IN (31, 32, 33, 48) AND h0_.date_racc IS NOT NULL AND h0_.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
  history h1_
  LEFT JOIN cluster c2_ ON h1_.cluster_id = c2_.id
  LEFT JOIN point_of_sale p3_ ON h1_.point_of_sale_id = p3_.id
  LEFT JOIN user u0_ ON h1_.seller_id = u0_.id
WHERE
  h1_.point_of_sale_id = ?
  AND MONTH(h1_.date_vente_valid_b) = ?
  AND YEAR(h1_.date_vente_valid_b) = ?

SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM history h1_ LEFT JOIN cluster c2_ ON h1_.cluster_id = c2_.id LEFT JOIN point_of_sale p3_ ON h1_.point_of_sale_id = p3_.id LEFT JOIN user u0_ ON h1_.seller_id = u0_.id WHERE h1_.point_of_sale_id = 4 AND MONTH(h1_.date_vente_valid_b) = 7 AND YEAR(h1_.date_vente_valid_b) = 2025;

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

SELECT COUNT(h0_.id) / NULLIF(COUNT(DISTINCT u1_.id), 0) AS sclr_0 FROM history h0_ LEFT JOIN point_of_sale p2_ ON h0_.point_of_sale_id = p2_.id LEFT JOIN cluster c3_ ON h0_.cluster_id = c3_.id LEFT JOIN user u1_ ON h0_.seller_id = u1_.id WHERE h0_.point_of_sale_id = 4 AND MONTH(h0_.date_vente_valid_b) = 7 AND YEAR(h0_.date_vente_valid_b) = 2025;

SELECT
  COUNT(h0_.id) AS sclr_0
FROM
  history h0_
  LEFT JOIN point_of_sale p1_ ON h0_.point_of_sale_id = p1_.id
  LEFT JOIN cluster c2_ ON h0_.cluster_id = c2_.id
WHERE
  h0_.point_of_sale_id = ?
  AND MONTH(h0_.date_vente_valid_b) = ?
  AND YEAR(h0_.date_vente_valid_b) = ?
  AND h0_.etat_id = ?

SELECT COUNT(h0_.id) AS sclr_0 FROM history h0_ LEFT JOIN point_of_sale p1_ ON h0_.point_of_sale_id = p1_.id LEFT JOIN cluster c2_ ON h0_.cluster_id = c2_.id WHERE h0_.point_of_sale_id = 4 AND MONTH(h0_.date_vente_valid_b) = 7 AND YEAR(h0_.date_vente_valid_b) = 2025 AND h0_.etat_id = 2;

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 = 7 AND n0_.year = 2025;

SELECT
  COUNT(h0_.id) AS sclr_0
FROM
  history h0_
  LEFT JOIN point_of_sale p1_ ON h0_.point_of_sale_id = p1_.id
  LEFT JOIN cluster c2_ ON h0_.cluster_id = c2_.id
WHERE
  h0_.point_of_sale_id = ?
  AND MONTH(h0_.date_vente_valid_b) = ?
  AND YEAR(h0_.date_vente_valid_b) = ?
  AND h0_.date_vente_valid_b <= ?

SELECT COUNT(h0_.id) AS sclr_0 FROM history h0_ LEFT JOIN point_of_sale p1_ ON h0_.point_of_sale_id = p1_.id LEFT JOIN cluster c2_ ON h0_.cluster_id = c2_.id WHERE h0_.point_of_sale_id = 4 AND MONTH(h0_.date_vente_valid_b) = 7 AND YEAR(h0_.date_vente_valid_b) = 2025 AND h0_.date_vente_valid_b <= '2026-02-10 10:37:43';

SELECT
  COUNT(
    DISTINCT DAY(p.date_vente_valid_b)
  )
FROM
  history 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

SELECT COUNT(DISTINCT DAY(p.date_vente_valid_b))
        FROM history p
        WHERE p.point_of_sale_id = 4
        AND MONTH(p.date_vente_valid_b) = 7
        AND YEAR(p.date_vente_valid_b) = 2025
        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
    ;

SELECT
  COUNT(h0_.id) AS sclr_0
FROM
  history h0_
  LEFT JOIN point_of_sale p1_ ON h0_.point_of_sale_id = p1_.id
  LEFT JOIN cluster c2_ ON h0_.cluster_id = c2_.id
WHERE
  h0_.point_of_sale_id = ?
  AND MONTH(h0_.date_vente_valid_b) = ?
  AND YEAR(h0_.date_vente_valid_b) = ?
  AND h0_.date_vente_valid_b <= ?

SELECT COUNT(h0_.id) AS sclr_0 FROM history h0_ LEFT JOIN point_of_sale p1_ ON h0_.point_of_sale_id = p1_.id LEFT JOIN cluster c2_ ON h0_.cluster_id = c2_.id WHERE h0_.point_of_sale_id = 4 AND MONTH(h0_.date_vente_valid_b) = 7 AND YEAR(h0_.date_vente_valid_b) = 2025 AND h0_.date_vente_valid_b <= '2026-02-10 10:37:43';

SELECT
  COUNT(
    DISTINCT DAY(p.date_vente_valid_b)
  )
FROM
  history 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

SELECT COUNT(DISTINCT DAY(p.date_vente_valid_b))
        FROM history p
        WHERE p.point_of_sale_id = 4
        AND MONTH(p.date_vente_valid_b) = 7
        AND YEAR(p.date_vente_valid_b) = 2025
        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
    ;

SELECT
  COUNT(h0_.id) AS sclr_0
FROM
  history h0_
  LEFT JOIN point_of_sale p1_ ON h0_.point_of_sale_id = p1_.id
  LEFT JOIN cluster c2_ ON h0_.cluster_id = c2_.id
WHERE
  h0_.point_of_sale_id = ?
  AND MONTH(h0_.date_vente_valid_b) = ?
  AND YEAR(h0_.date_vente_valid_b) = ?
  AND h0_.date_vente_valid_b <= ?

SELECT COUNT(h0_.id) AS sclr_0 FROM history h0_ LEFT JOIN point_of_sale p1_ ON h0_.point_of_sale_id = p1_.id LEFT JOIN cluster c2_ ON h0_.cluster_id = c2_.id WHERE h0_.point_of_sale_id = 4 AND MONTH(h0_.date_vente_valid_b) = 7 AND YEAR(h0_.date_vente_valid_b) = 2025 AND h0_.date_vente_valid_b <= '2026-02-10 10:37:43';

SELECT
  COUNT(
    DISTINCT DAY(p.date_vente_valid_b)
  )
FROM
  history 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

SELECT COUNT(DISTINCT DAY(p.date_vente_valid_b))
        FROM history p
        WHERE p.point_of_sale_id = 4
        AND MONTH(p.date_vente_valid_b) = 7
        AND YEAR(p.date_vente_valid_b) = 2025
        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
    ;

SELECT
  COUNT(DISTINCT result.titulaire_email) AS total_vente
FROM
  (
    SELECT
      p1.titulaire_email
    FROM
      history 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
          history 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
      history 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
          history 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 history 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) = 7
                  AND YEAR(p1.date_cmd_a) = 2025
                  AND p1.titulaire_email IN (
                      SELECT DISTINCT p_sub1.titulaire_email
                      FROM history p_sub1
                      WHERE p_sub1.category_id = 1
                        AND p_sub1.point_of_sale_id = 4
                        AND MONTH(p_sub1.date_cmd_a) = 7
                        AND YEAR(p_sub1.date_cmd_a) = 2025
                  )
        
                UNION
                SELECT p2.titulaire_email
                FROM history 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) = 7
                  AND YEAR(p2.date_cmd_a) = 2025
                  AND p2.titulaire_email IN (
                      SELECT DISTINCT p_sub2.titulaire_email
                      FROM history 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) = 7
                        AND YEAR(p_sub2.date_cmd_a) = 2025
                  )
        ) AS result;

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

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

SELECT
  COUNT(DISTINCT p.id) AS total_vente
FROM
  history 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 history 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) = 7 AND YEAR(p.date_vente_valid_b) = 2025;

SELECT
  COUNT(DISTINCT p.id) AS total_vente
FROM
  history 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 history 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) = 7 AND YEAR(p.date_cmd_a) = 2025;

SELECT
  COUNT(DISTINCT p.id) AS total_vente
FROM
  history 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 history 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) = 7 AND YEAR(p.date_cmd_a) = 2025;

SELECT
  COUNT(DISTINCT p.id) AS total_vente
FROM
  history 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 history 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) = 7 AND YEAR(p.date_cmd_a) = 2025;

SELECT
  COUNT(DISTINCT p.id) AS total_vente
FROM
  history 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 history 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) = 7 AND YEAR(p.date_cmd_a) = 2025;

SELECT
  COUNT(DISTINCT p.titulaire_email) AS total_vente
FROM
  history 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 history 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) = 7 AND YEAR(p.date_vente_valid_b) = 2025;

SELECT
  COUNT(DISTINCT p.titulaire_email) AS total_vente
FROM
  history 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)
  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 history 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 
        )
     AND MONTH(p.date_vente_valid_b) = 7 AND YEAR(p.date_vente_valid_b) = 2025;

SELECT
  COUNT(DISTINCT p.titulaire_email) AS total_vente
FROM
  history 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 NOT IN (2)
  AND MONTH(p.date_cmd_a) = :mois
  AND YEAR(p.date_cmd_a) = :annee