Symfony Profiler

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 result.titulaire_email) AS total,
  WEEK(result.date_cmd_a, 3) AS semaine
FROM
  (
    -- Partie 1 : Catégorie 32 avec emails en catégorie 1
    SELECT
      p1.titulaire_email,
      p1.date_cmd_a
    FROM
      production p1
      LEFT JOIN cluster c1 ON p1.cluster_id = c1.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
      -- Partie 2 : Catégorie 31 avec emails en catégorie 1 ou 3
    SELECT
      p2.titulaire_email,
      p2.date_cmd_a
    FROM
      production p2
      LEFT JOIN cluster c2 ON p2.cluster_id = c2.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
GROUP BY
  WEEK(result.date_cmd_a, 3)
ORDER BY
  semaine

SELECT 
                COUNT(DISTINCT result.titulaire_email) AS total, 
                WEEK(result.date_cmd_a, 3) AS semaine
            FROM (
                -- Partie 1 : Catégorie 32 avec emails en catégorie 1
                SELECT p1.titulaire_email, p1.date_cmd_a
                FROM production p1
                LEFT JOIN cluster c1 ON p1.cluster_id = c1.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
                -- Partie 2 : Catégorie 31 avec emails en catégorie 1 ou 3
                SELECT p2.titulaire_email, p2.date_cmd_a
                FROM production p2
                LEFT JOIN cluster c2 ON p2.cluster_id = c2.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
            GROUP BY WEEK(result.date_cmd_a, 3)
            ORDER BY semaine
        ;

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(p.id) AS total_vente,
  p.identity_ctrl
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.identity_ctrl IS NOT NULL
  AND MONTH(p.date_vente_valid_b) = :mois
  AND YEAR(p.date_vente_valid_b) = :annee
GROUP BY
  p.identity_ctrl

SELECT COUNT(p.id) AS total_vente, p.identity_ctrl
        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.identity_ctrl IS NOT NULL 
         
     AND MONTH(p.date_vente_valid_b) = 1 AND YEAR(p.date_vente_valid_b) = 2026 GROUP BY p.identity_ctrl ;

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(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) 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_.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_.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(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(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 c.id = p.cluster_id
WHERE
  p.point_of_sale_id = :pointOfSale
  AND p.category_id IN (1, 3)
  AND MONTH(p.date_cmd_a) = :mois
  AND YEAR(p.date_cmd_a) = :annee
  AND p.prise_existante_commande = :opt

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 c.id =p.cluster_id
        
            WHERE p.point_of_sale_id = 4
              AND p.category_id IN (1,3)
              AND MONTH(p.date_cmd_a) = 1
              AND YEAR(p.date_cmd_a) = 2026
         AND p.prise_existante_commande = 'NON';

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
  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;

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)
  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 
        )
     AND MONTH(p.date_vente_valid_b) = 1 AND YEAR(p.date_vente_valid_b) = 2026;

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) = ?

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;

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 NOT IN (2)
  AND MONTH(p.date_cmd_a) = :mois
  AND YEAR(p.date_cmd_a) = :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 NOT IN (2)
          AND MONTH(p.date_cmd_a) = 1
          AND YEAR(p.date_cmd_a) = 2026
    ;

SELECT
  COUNT(DISTINCT p.titulaire_email) AS total,
  WEEK(p.date_cmd_a, 3) AS semaine
FROM
  production p
  LEFT JOIN cluster c ON c.id = p.cluster_id
WHERE
  p.point_of_sale_id = :pointOfSale
  AND MONTH(p.date_cmd_a) = :mois
  AND YEAR(p.date_cmd_a) = :annee
  AND p.fixe_chainage IS NOT NULL
  AND p.category_id IN (:cat0, :cat1, :cat2)
GROUP BY
  semaine

SELECT COUNT(DISTINCT p.titulaire_email) AS total, WEEK(p.date_cmd_a,3) AS semaine
            FROM production p
            LEFT JOIN cluster c ON c.id = p.cluster_id
            WHERE p.point_of_sale_id = 4 AND MONTH(p.date_cmd_a) = 1 AND YEAR(p.date_cmd_a) = 2026 AND p.fixe_chainage IS NOT NULL AND p.category_id IN (31,32,33)
            GROUP BY semaine
        ;

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 c.id = p.cluster_id
WHERE
  p.point_of_sale_id = :pointOfSale
  AND p.category_id IN (1, 3)
  AND MONTH(p.date_cmd_a) = :mois
  AND YEAR(p.date_cmd_a) = :annee
  AND p.prise_saisie_commande = :opt
  AND p.prise_existante_commande = :opt2

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 c.id =p.cluster_id
        
            WHERE p.point_of_sale_id = 4
              AND p.category_id IN (1,3)
              AND MONTH(p.date_cmd_a) = 1
              AND YEAR(p.date_cmd_a) = 2026
         AND p.prise_saisie_commande = 'NON' AND p.prise_existante_commande = 'OUI';

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 c.id = p.cluster_id
WHERE
  p.point_of_sale_id = :pointOfSale
  AND p.category_id IN (1, 3)
  AND MONTH(p.date_cmd_a) = :mois
  AND YEAR(p.date_cmd_a) = :annee
  AND p.portabilite = :opt

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 c.id =p.cluster_id
        
            WHERE p.point_of_sale_id = 4
              AND p.category_id IN (1,3)
              AND MONTH(p.date_cmd_a) = 1
              AND YEAR(p.date_cmd_a) = 2026
         AND p.portabilite = 'OUI';

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 c.id = p.cluster_id
WHERE
  p.point_of_sale_id = :pointOfSale
  AND p.category_id IN (1, 3)
  AND MONTH(p.date_cmd_a) = :mois
  AND YEAR(p.date_cmd_a) = :annee
  AND p.prise_saisie_commande = :opt

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 c.id =p.cluster_id
        
            WHERE p.point_of_sale_id = 4
              AND p.category_id IN (1,3)
              AND MONTH(p.date_cmd_a) = 1
              AND YEAR(p.date_cmd_a) = 2026
         AND p.prise_saisie_commande = 'OUI';

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 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 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 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(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 (?, ?)
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 (1, 3) ORDER BY sclr_0 DESC;