Symfony Profiler

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,
  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
      history 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
          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
      -- Partie 2 : Catégorie 31 avec emails en catégorie 1 ou 3
    SELECT
      p2.titulaire_email,
      p2.date_cmd_a
    FROM
      history 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
          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
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 history 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) = 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
                -- Partie 2 : Catégorie 31 avec emails en catégorie 1 ou 3
                SELECT p2.titulaire_email, p2.date_cmd_a
                FROM history 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) = 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
            GROUP BY WEEK(result.date_cmd_a, 3)
            ORDER BY semaine
        ;

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 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 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 history 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) = 7
              AND YEAR(p.date_cmd_a) = 2025
         AND p.prise_existante_commande = 'NON';

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

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

SELECT
  COUNT(DISTINCT p.titulaire_email) AS total,
  WEEK(p.date_cmd_a, 3) AS semaine
FROM
  history 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 history p
            LEFT JOIN cluster c ON c.id = p.cluster_id
            WHERE p.point_of_sale_id = 4 AND MONTH(p.date_cmd_a) = 7 AND YEAR(p.date_cmd_a) = 2025 AND p.fixe_chainage IS NOT NULL AND p.category_id IN (31,32,33)
            GROUP BY semaine
        ;

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(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 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 history 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) = 7
              AND YEAR(p.date_cmd_a) = 2025
         AND p.portabilite = 'OUI';

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

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;

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) / 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(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 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 history 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) = 7
              AND YEAR(p.date_cmd_a) = 2025
         AND p.prise_saisie_commande = 'OUI';

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

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 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(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
  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 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(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.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 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 history 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) = 7
              AND YEAR(p.date_cmd_a) = 2025
         AND p.prise_saisie_commande = 'NON' AND p.prise_existante_commande = 'OUI';

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