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

SELECT COUNT(DISTINCT DAY(p.date_vente_valid_b))
        FROM production p
        WHERE p.point_of_sale_id = 1
        AND MONTH(p.date_vente_valid_b) = 2
        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
    ;

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_.organisation_id = ?

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 = 1 AND MONTH(p0_.date_vente_valid_b) = 2 AND YEAR(p0_.date_vente_valid_b) = 2026 AND p0_.date_vente_valid_b <= '2026-02-10 10:36:45' AND p0_.organisation_id = '1';

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.organisation_id = :organisationId
  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 = 1
              AND p.category_id IN (1,3)
              AND MONTH(p.date_cmd_a) = 2
              AND YEAR(p.date_cmd_a) = 2026
         AND p.organisation_id = 1 AND p.prise_existante_commande = 'NON';

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
      )
      AND p1.organisation_id = :organisationId
    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
      )
      AND p2.organisation_id = :organisationId
  ) 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 = 1
                  AND MONTH(p1.date_cmd_a) = 2
                  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 = 1
                        AND MONTH(p_sub1.date_cmd_a) = 2
                        AND YEAR(p_sub1.date_cmd_a) = 2026
                  )
         AND p1.organisation_id = '1'
                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 = 1
                  AND MONTH(p2.date_cmd_a) = 2
                  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 = 1
                        AND MONTH(p_sub2.date_cmd_a) = 2
                        AND YEAR(p_sub2.date_cmd_a) = 2026
                  )
         AND p2.organisation_id = '1') 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
      )
      AND p1.organisation_id = :organisationId
    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
      )
      AND p2.organisation_id = :organisationId
  ) 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 = 1
                  AND MONTH(p1.date_cmd_a) = 2
                  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 = 1
                        AND MONTH(p_sub1.date_cmd_a) = 2
                        AND YEAR(p_sub1.date_cmd_a) = 2026
                  )
         AND p1.organisation_id = '1'
                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 = 1
                  AND MONTH(p2.date_cmd_a) = 2
                  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 = 1
                        AND MONTH(p_sub2.date_cmd_a) = 2
                        AND YEAR(p_sub2.date_cmd_a) = 2026
                  )
         AND p2.organisation_id = '1'
            ) AS result
            GROUP BY WEEK(result.date_cmd_a, 3)
            ORDER 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 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 p.organisation_id = :organisationId
  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 = 1
          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 p.organisation_id = '1' AND MONTH(p.date_vente_valid_b) = 2 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 p.organisation_id = :organisationId
  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 = 1
          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 p.organisation_id = '1' AND MONTH(p.date_cmd_a) = 2 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 (?, ?, ?)
  AND p0_.organisation_id = ?
  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 = 1 AND MONTH(p0_.date_cmd_a) = 2 AND YEAR(p0_.date_cmd_a) = 2026 AND p0_.category_id IN (31, 32, 33) AND p0_.organisation_id = '1' 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 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)
  AND p0_.organisation_id = ?

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 = 1 AND MONTH(p0_.date_cmd_a) = 2 AND YEAR(p0_.date_cmd_a) = 2026 AND p0_.fixe_chainage IS NOT NULL AND p0_.category_id IN (31, 32, 33) AND p0_.organisation_id = '1';

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 p.organisation_id = :organisationId
  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 = 1
          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 p.organisation_id = '1' AND MONTH(p.date_cmd_a) = 2 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_.organisation_id = ?
  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 = 1 AND MONTH(p0_.date_cmd_a) = 2 AND YEAR(p0_.date_cmd_a) = 2026 AND p0_.organisation_id = '1' 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_.organisation_id = ?
  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 = 1 AND MONTH(p0_.date_cmd_a) = 2 AND YEAR(p0_.date_cmd_a) = 2026 AND p0_.organisation_id = '1' 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(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.organisation_id = :organisationId
  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 = 1
              AND p.category_id IN (1,3)
              AND MONTH(p.date_cmd_a) = 2
              AND YEAR(p.date_cmd_a) = 2026
         AND p.organisation_id = 1 AND p.prise_saisie_commande = 'NON' AND p.prise_existante_commande = 'OUI';

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

SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM production p1_ LEFT JOIN cluster c2_ ON p1_.cluster_id = c2_.id LEFT JOIN user u0_ ON p1_.seller_id = u0_.id WHERE p1_.organisation_id = '1' AND MONTH(p1_.date_vente_valid_b) = 2 AND YEAR(p1_.date_vente_valid_b) = 2026;

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_.organisation_id = ?

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 = 1 AND MONTH(p0_.date_vente_valid_b) = 2 AND YEAR(p0_.date_vente_valid_b) = 2026 AND p0_.organisation_id = '1';

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_.organisation_id = ?
  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 = 1 AND MONTH(p0_.date_cmd_a) = 2 AND YEAR(p0_.date_cmd_a) = 2026 AND p0_.organisation_id = '1' 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(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.organisation_id = :organisationId
  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 = 1
          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.organisation_id = '1' AND MONTH(p.date_cmd_a) = 2 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 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.organisation_id = :organisationId
  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 = 1
              AND p.category_id IN (1,3)
              AND MONTH(p.date_cmd_a) = 2
              AND YEAR(p.date_cmd_a) = 2026
         AND p.organisation_id = 1 AND p.portabilite = 'OUI';

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_.organisation_id = ?
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 = 1 AND MONTH(p0_.date_vente_valid_b) = 2 AND YEAR(p0_.date_vente_valid_b) = 2026 AND p0_.organisation_id = '1' ORDER BY sclr_0 DESC;

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 = '1031097' AND n0_.mois = 2 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_.etat_id = ?
  AND p0_.organisation_id = ?

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 = 1 AND MONTH(p0_.date_vente_valid_b) = 2 AND YEAR(p0_.date_vente_valid_b) = 2026 AND p0_.etat_id = 2 AND p0_.organisation_id = '1';

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 p.organisation_id = :organisationId
  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 = 1 AND p.organisation_id = '1' AND MONTH(p.date_cmd_a) = 2 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.organisation_id = :organisationId
  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 = 1
              AND p.category_id IN (1,3)
              AND MONTH(p.date_cmd_a) = 2
              AND YEAR(p.date_cmd_a) = 2026
         AND p.organisation_id = 1 AND p.prise_saisie_commande = 'OUI';

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_.organisation_id = ?
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 = 1 AND MONTH(p0_.date_cmd_a) = 2 AND YEAR(p0_.date_cmd_a) = 2026 AND p0_.category_id IN (1, 3) AND p0_.organisation_id = '1' ORDER BY sclr_0 DESC;

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 p1_.organisation_id = ?

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) = 2 AND YEAR(s0_.date_contrat) = 2026 AND p1_.organisation_id = '1';