Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4 FROM user t0 WHERE t0.id = 22;

SELECT
  pdv.locat
FROM
  plande_p AS pl
  LEFT JOIN promesse AS pdv ON pdv.id = pl.pdv_id
WHERE
  pl.enabled = true
  AND pdv.recstatus != 'end'
  AND pl.restap > 0
GROUP BY
  pdv.locat;

SELECT pdv.locat
                    FROM plande_p AS pl
                    LEFT JOIN promesse AS pdv ON pdv.id = pl.pdv_id
                    WHERE pl.enabled = true
                    AND pdv.recstatus != 'end'
                    AND pl.restap > 0
                    GROUP BY pdv.locat;
        ;

SELECT
  *
FROM
  `treso_prevision` as t
where
  MONTH(t.date) = MONTH(
    CURDATE()
  )
  AND YEAR(t.date) = YEAR(
    CURDATE()
  );

SELECT * FROM `treso_prevision` as t
                where 
                MONTH(t.date) = MONTH(CURDATE())
                    AND YEAR(t.date) = YEAR(CURDATE());
                ;

SELECT
  SUM(pl.restap) AS total_restap
FROM
  promesse AS pdv
  LEFT JOIN plande_p AS pl ON pl.pdv_id = pdv.id
  AND pl.datedP BETWEEN DATE_FORMAT(
    DATE_SUB(
      CURDATE(),
      INTERVAL 1 MONTH
    ),
    '%Y-%m-01'
  )
  AND LAST_DAY(
    DATE_SUB(
      CURDATE(),
      INTERVAL 1 MONTH
    )
  )
  AND pl.restap > 0
WHERE
  pl.enabled = 1
  AND pdv.recstatus != 'end'
  AND pdv.enabled = 1;

SELECT SUM(pl.restap) AS total_restap
                    FROM promesse AS pdv
                    LEFT JOIN plande_p AS pl 
                        ON pl.pdv_id = pdv.id
                    AND pl.datedP BETWEEN DATE_FORMAT(DATE_SUB(CURDATE(), INTERVAL 1 MONTH), '%Y-%m-01')
                                        AND LAST_DAY(DATE_SUB(CURDATE(), INTERVAL 1 MONTH))
                    AND pl.restap > 0
                    WHERE pl.enabled = 1
                    AND pdv.recstatus != 'end'
                    AND pdv.enabled = 1;
                ;

SELECT
  SUM(pl.restap) AS total_restap
FROM
  promesse AS pdv
  LEFT JOIN plande_p AS pl ON pl.pdv_id = pdv.id
  AND pl.datedP BETWEEN DATE_FORMAT(
    CURDATE(),
    '%Y-%m-01'
  )
  AND LAST_DAY(
    CURDATE()
  )
  AND pl.restap > 0
WHERE
  pl.enabled = 1
  AND pdv.recstatus != 'end'
  AND pdv.enabled = 1
  AND EXISTS (
    SELECT
      1
    FROM
      plande_p pl2
    WHERE
      pl2.pdv_id = pdv.id
      AND pl2.restap > 0
      AND pl2.DatedP < DATE_FORMAT(
        CURDATE(),
        '%Y-%m-01'
      )
  );

SELECT SUM(pl.restap) AS total_restap
                    FROM promesse AS pdv
                    LEFT JOIN plande_p AS pl 
                        ON pl.pdv_id = pdv.id
                    AND pl.datedP BETWEEN DATE_FORMAT(CURDATE(), '%Y-%m-01')
                                        AND LAST_DAY(CURDATE())
                    AND pl.restap > 0
                    WHERE pl.enabled = 1
                    AND pdv.recstatus != 'end'
                    AND pdv.enabled = 1
                    AND EXISTS (
                        SELECT 1
                        FROM plande_p pl2
                        WHERE pl2.pdv_id = pdv.id
                        AND pl2.restap > 0
                        AND pl2.DatedP < DATE_FORMAT(CURDATE(), '%Y-%m-01')
                    )
                    ;
                ;

SELECT
  DISTINCT pl.pdv_id
FROM
  plande_p AS pl
  LEFT JOIN promesse AS pdv ON pdv.id = pl.pdv_id
WHERE
  pl.enabled = TRUE
  AND pdv.recstatus != 'end'
  AND pdv.enabled = 1
  AND COALESCE(
    (
      SELECT
        SUM(pl2.restap)
      FROM
        plande_p pl2
      WHERE
        pl2.pdv_id = pdv.id
        AND pl2.DatedP BETWEEN DATE_FORMAT(
          DATE_SUB(
            DATE_FORMAT(
              CURDATE(),
              '%Y-%m-01'
            ),
            INTERVAL 1 MONTH
          ),
          '%Y-%m-01'
        )
        AND LAST_DAY(
          DATE_SUB(
            DATE_FORMAT(
              CURDATE(),
              '%Y-%m-01'
            ),
            INTERVAL 1 MONTH
          )
        )
    ),
    0
  ) = 0
  AND NOT EXISTS (
    SELECT
      1
    FROM
      plande_p pl3
    WHERE
      pl3.pdv_id = pdv.id
      AND pl3.datedP >= DATE_FORMAT(
        DATE_SUB(
          DATE_FORMAT(
            CURDATE(),
            '%Y-%m-01'
          ),
          INTERVAL 2 MONTH
        ),
        '%Y-%m-01'
      )
      AND pl3.datedP < DATE_FORMAT(
        DATE_FORMAT(
          CURDATE(),
          '%Y-%m-01'
        ),
        '%Y-%m-01'
      )
      AND pl3.date_t IS NOT NULL
      AND (
        YEAR(pl3.date_t) > YEAR(pl3.datedP)
        OR MONTH(pl3.date_t) > MONTH(pl3.datedP)
      )
  )

SELECT DISTINCT pl.pdv_id
            FROM plande_p AS pl
            LEFT JOIN promesse AS pdv ON pdv.id = pl.pdv_id
            WHERE pl.enabled = TRUE
            AND pdv.recstatus != 'end'
            AND pdv.enabled = 1
            AND COALESCE((
                SELECT SUM(pl2.restap)
                FROM plande_p pl2
                WHERE pl2.pdv_id = pdv.id
                AND pl2.DatedP BETWEEN DATE_FORMAT(DATE_SUB(DATE_FORMAT(CURDATE(), '%Y-%m-01'), INTERVAL 1 MONTH), '%Y-%m-01')
                                    AND LAST_DAY(DATE_SUB(DATE_FORMAT(CURDATE(), '%Y-%m-01'), INTERVAL 1 MONTH))
            ), 0) = 0
            AND NOT EXISTS (
                SELECT 1
                FROM plande_p pl3
                WHERE pl3.pdv_id = pdv.id
                AND pl3.datedP >= DATE_FORMAT(DATE_SUB(DATE_FORMAT(CURDATE(), '%Y-%m-01'), INTERVAL 2 MONTH), '%Y-%m-01')
                AND pl3.datedP < DATE_FORMAT(DATE_FORMAT(CURDATE(), '%Y-%m-01'), '%Y-%m-01')
                AND pl3.date_t IS NOT NULL
                AND (
                    YEAR(pl3.date_t) > YEAR(pl3.datedP)
                    OR MONTH(pl3.date_t) > MONTH(pl3.datedP)
                )
            )
        ;

SELECT
  DISTINCT pl.pdv_id
FROM
  plande_p AS pl
  LEFT JOIN promesse AS pdv ON pdv.id = pl.pdv_id
WHERE
  pl.enabled = TRUE
  AND pdv.recstatus != 'end'
  AND pdv.enabled = 1
  AND COALESCE(
    (
      SELECT
        SUM(pl2.restap)
      FROM
        plande_p pl2
      WHERE
        pl2.pdv_id = pdv.id
        AND pl2.DatedP BETWEEN DATE_FORMAT(
          DATE_ADD(
            DATE_FORMAT(
              CURDATE(),
              '%Y-%m-01'
            ),
            INTERVAL 1 MONTH
          ),
          '%Y-%m-01'
        )
        AND LAST_DAY(
          DATE_ADD(
            DATE_FORMAT(
              CURDATE(),
              '%Y-%m-01'
            ),
            INTERVAL 3 MONTH
          )
        )
    ),
    0
  ) < COALESCE(
    (
      SELECT
        SUM(pl2.montant)
      FROM
        plande_p pl2
      WHERE
        pl2.pdv_id = pdv.id
        AND pl2.DatedP BETWEEN DATE_FORMAT(
          DATE_ADD(
            DATE_FORMAT(
              CURDATE(),
              '%Y-%m-01'
            ),
            INTERVAL 1 MONTH
          ),
          '%Y-%m-01'
        )
        AND LAST_DAY(
          DATE_ADD(
            DATE_FORMAT(
              CURDATE(),
              '%Y-%m-01'
            ),
            INTERVAL 3 MONTH
          )
        )
    ),
    0
  )

SELECT DISTINCT pl.pdv_id
            FROM plande_p AS pl
            LEFT JOIN promesse AS pdv ON pdv.id = pl.pdv_id
            WHERE pl.enabled = TRUE
            AND pdv.recstatus != 'end'
            AND pdv.enabled = 1
            AND COALESCE((
                SELECT SUM(pl2.restap)
                FROM plande_p pl2
                WHERE pl2.pdv_id = pdv.id
                AND pl2.DatedP BETWEEN DATE_FORMAT(DATE_ADD(DATE_FORMAT(CURDATE(), '%Y-%m-01'), INTERVAL 1 MONTH), '%Y-%m-01')
                                    AND LAST_DAY(DATE_ADD(DATE_FORMAT(CURDATE(), '%Y-%m-01'), INTERVAL 3 MONTH))
            ), 0) < COALESCE((
                SELECT SUM(pl2.montant)
                FROM plande_p pl2
                WHERE pl2.pdv_id = pdv.id
                AND pl2.DatedP BETWEEN DATE_FORMAT(DATE_ADD(DATE_FORMAT(CURDATE(), '%Y-%m-01'), INTERVAL 1 MONTH), '%Y-%m-01')
                                    AND LAST_DAY(DATE_ADD(DATE_FORMAT(CURDATE(), '%Y-%m-01'), INTERVAL 3 MONTH))
            ), 0)
        ;

SELECT
  pdv.locat,
  SUM(
    CASE WHEN DATE_FORMAT(pl.DatedP, '%Y-%m') = DATE_FORMAT(
      DATE_ADD(
        DATE_FORMAT(
          CURDATE(),
          '%Y-%m-01'
        ),
        INTERVAL 1 MONTH
      ),
      '%Y-%m'
    ) THEN pl.restap ELSE 0 END
  ) AS `Apr-26`,
  SUM(
    CASE WHEN DATE_FORMAT(pl.DatedP, '%Y-%m') = DATE_FORMAT(
      DATE_ADD(
        DATE_FORMAT(
          CURDATE(),
          '%Y-%m-01'
        ),
        INTERVAL 2 MONTH
      ),
      '%Y-%m'
    ) THEN pl.restap ELSE 0 END
  ) AS `May-26`,
  SUM(
    CASE WHEN DATE_FORMAT(pl.DatedP, '%Y-%m') = DATE_FORMAT(
      DATE_ADD(
        DATE_FORMAT(
          CURDATE(),
          '%Y-%m-01'
        ),
        INTERVAL 3 MONTH
      ),
      '%Y-%m'
    ) THEN pl.restap ELSE 0 END
  ) AS `Jun-26`,
  SUM(
    CASE WHEN DATE_FORMAT(pl.DatedP, '%Y-%m') = DATE_FORMAT(
      DATE_ADD(
        DATE_FORMAT(
          CURDATE(),
          '%Y-%m-01'
        ),
        INTERVAL 4 MONTH
      ),
      '%Y-%m'
    ) THEN pl.restap ELSE 0 END
  ) AS `Jul-26`,
  SUM(
    CASE WHEN DATE_FORMAT(pl.DatedP, '%Y-%m') = DATE_FORMAT(
      DATE_ADD(
        DATE_FORMAT(
          CURDATE(),
          '%Y-%m-01'
        ),
        INTERVAL 5 MONTH
      ),
      '%Y-%m'
    ) THEN pl.restap ELSE 0 END
  ) AS `Aug-26`,
  SUM(
    CASE WHEN DATE_FORMAT(pl.DatedP, '%Y-%m') = DATE_FORMAT(
      DATE_ADD(
        DATE_FORMAT(
          CURDATE(),
          '%Y-%m-01'
        ),
        INTERVAL 6 MONTH
      ),
      '%Y-%m'
    ) THEN pl.restap ELSE 0 END
  ) AS `Sep-26`,
  SUM(
    CASE WHEN DATE_FORMAT(pl.DatedP, '%Y-%m') = DATE_FORMAT(
      DATE_ADD(
        DATE_FORMAT(
          CURDATE(),
          '%Y-%m-01'
        ),
        INTERVAL 7 MONTH
      ),
      '%Y-%m'
    ) THEN pl.restap ELSE 0 END
  ) AS `Oct-26`,
  SUM(
    CASE WHEN DATE_FORMAT(pl.DatedP, '%Y-%m') = DATE_FORMAT(
      DATE_ADD(
        DATE_FORMAT(
          CURDATE(),
          '%Y-%m-01'
        ),
        INTERVAL 8 MONTH
      ),
      '%Y-%m'
    ) THEN pl.restap ELSE 0 END
  ) AS `Nov-26`,
  SUM(
    CASE WHEN DATE_FORMAT(pl.DatedP, '%Y-%m') = DATE_FORMAT(
      DATE_ADD(
        DATE_FORMAT(
          CURDATE(),
          '%Y-%m-01'
        ),
        INTERVAL 9 MONTH
      ),
      '%Y-%m'
    ) THEN pl.restap ELSE 0 END
  ) AS `Dec-26`,
  SUM(
    CASE WHEN DATE_FORMAT(pl.DatedP, '%Y-%m') = DATE_FORMAT(
      DATE_ADD(
        DATE_FORMAT(
          CURDATE(),
          '%Y-%m-01'
        ),
        INTERVAL 10 MONTH
      ),
      '%Y-%m'
    ) THEN pl.restap ELSE 0 END
  ) AS `Jan-27`,
  SUM(
    CASE WHEN DATE_FORMAT(pl.DatedP, '%Y-%m') = DATE_FORMAT(
      DATE_ADD(
        DATE_FORMAT(
          CURDATE(),
          '%Y-%m-01'
        ),
        INTERVAL 11 MONTH
      ),
      '%Y-%m'
    ) THEN pl.restap ELSE 0 END
  ) AS `Feb-27`,
  SUM(
    CASE WHEN DATE_FORMAT(pl.DatedP, '%Y-%m') = DATE_FORMAT(
      DATE_ADD(
        DATE_FORMAT(
          CURDATE(),
          '%Y-%m-01'
        ),
        INTERVAL 12 MONTH
      ),
      '%Y-%m'
    ) THEN pl.restap ELSE 0 END
  ) AS `Mar-27`
FROM
  promesse pdv
  LEFT JOIN plande_p pl ON pl.pdv_id = pdv.id
WHERE
  pl.enabled = TRUE
  AND pdv.recstatus != 'end'
  AND pl.DatedP >= DATE_FORMAT(
    DATE_ADD(
      DATE_FORMAT(
        CURDATE(),
        '%Y-%m-01'
      ),
      INTERVAL 1 MONTH
    ),
    '%Y-%m-01'
  )
  AND pl.DatedP < DATE_FORMAT(
    DATE_ADD(
      DATE_FORMAT(
        CURDATE(),
        '%Y-%m-01'
      ),
      INTERVAL 13 MONTH
    ),
    '%Y-%m-01'
  )
  AND pdv.id IN (
    939, 971, 989, 1022, 1047, 1057, 1065,
    1068, 1071, 1072, 1073, 1074, 1077,
    1098, 1102, 1110, 1115, 1119, 1136,
    1139, 1141, 1144, 1146, 1150, 1159,
    1160, 1161, 1162, 1163, 1165, 1171,
    1176, 1186, 1189, 1191, 1193, 1196,
    1197, 1198, 1204, 1206, 1208, 1211,
    1212, 1214, 1219, 1220, 1226, 1227,
    1230, 1231, 1233, 1235, 1236, 1238,
    1241, 1242, 1245, 1248, 1249, 1255,
    1258, 1261, 1262, 1265, 1266, 1268,
    1269, 1270, 1272, 1273, 1277, 1278,
    1279, 1280, 1281, 1282, 1283, 1284,
    1049, 1056, 1078, 1079, 1080, 1081,
    1083, 1100, 1104, 1130, 1151, 1154,
    1158, 1166, 1167, 1168, 1169, 1170,
    1173, 1178, 1188, 1207, 1224, 1232,
    1240, 1246
  )
GROUP BY
  pdv.locat

SELECT pdv.locat, 
                SUM(CASE WHEN DATE_FORMAT(pl.DatedP, '%Y-%m') = DATE_FORMAT(DATE_ADD(DATE_FORMAT(CURDATE(), '%Y-%m-01'), INTERVAL 1 MONTH), '%Y-%m')
                        THEN pl.restap ELSE 0 END) AS `Apr-26`
            , 
                SUM(CASE WHEN DATE_FORMAT(pl.DatedP, '%Y-%m') = DATE_FORMAT(DATE_ADD(DATE_FORMAT(CURDATE(), '%Y-%m-01'), INTERVAL 2 MONTH), '%Y-%m')
                        THEN pl.restap ELSE 0 END) AS `May-26`
            , 
                SUM(CASE WHEN DATE_FORMAT(pl.DatedP, '%Y-%m') = DATE_FORMAT(DATE_ADD(DATE_FORMAT(CURDATE(), '%Y-%m-01'), INTERVAL 3 MONTH), '%Y-%m')
                        THEN pl.restap ELSE 0 END) AS `Jun-26`
            , 
                SUM(CASE WHEN DATE_FORMAT(pl.DatedP, '%Y-%m') = DATE_FORMAT(DATE_ADD(DATE_FORMAT(CURDATE(), '%Y-%m-01'), INTERVAL 4 MONTH), '%Y-%m')
                        THEN pl.restap ELSE 0 END) AS `Jul-26`
            , 
                SUM(CASE WHEN DATE_FORMAT(pl.DatedP, '%Y-%m') = DATE_FORMAT(DATE_ADD(DATE_FORMAT(CURDATE(), '%Y-%m-01'), INTERVAL 5 MONTH), '%Y-%m')
                        THEN pl.restap ELSE 0 END) AS `Aug-26`
            , 
                SUM(CASE WHEN DATE_FORMAT(pl.DatedP, '%Y-%m') = DATE_FORMAT(DATE_ADD(DATE_FORMAT(CURDATE(), '%Y-%m-01'), INTERVAL 6 MONTH), '%Y-%m')
                        THEN pl.restap ELSE 0 END) AS `Sep-26`
            , 
                SUM(CASE WHEN DATE_FORMAT(pl.DatedP, '%Y-%m') = DATE_FORMAT(DATE_ADD(DATE_FORMAT(CURDATE(), '%Y-%m-01'), INTERVAL 7 MONTH), '%Y-%m')
                        THEN pl.restap ELSE 0 END) AS `Oct-26`
            , 
                SUM(CASE WHEN DATE_FORMAT(pl.DatedP, '%Y-%m') = DATE_FORMAT(DATE_ADD(DATE_FORMAT(CURDATE(), '%Y-%m-01'), INTERVAL 8 MONTH), '%Y-%m')
                        THEN pl.restap ELSE 0 END) AS `Nov-26`
            , 
                SUM(CASE WHEN DATE_FORMAT(pl.DatedP, '%Y-%m') = DATE_FORMAT(DATE_ADD(DATE_FORMAT(CURDATE(), '%Y-%m-01'), INTERVAL 9 MONTH), '%Y-%m')
                        THEN pl.restap ELSE 0 END) AS `Dec-26`
            , 
                SUM(CASE WHEN DATE_FORMAT(pl.DatedP, '%Y-%m') = DATE_FORMAT(DATE_ADD(DATE_FORMAT(CURDATE(), '%Y-%m-01'), INTERVAL 10 MONTH), '%Y-%m')
                        THEN pl.restap ELSE 0 END) AS `Jan-27`
            , 
                SUM(CASE WHEN DATE_FORMAT(pl.DatedP, '%Y-%m') = DATE_FORMAT(DATE_ADD(DATE_FORMAT(CURDATE(), '%Y-%m-01'), INTERVAL 11 MONTH), '%Y-%m')
                        THEN pl.restap ELSE 0 END) AS `Feb-27`
            , 
                SUM(CASE WHEN DATE_FORMAT(pl.DatedP, '%Y-%m') = DATE_FORMAT(DATE_ADD(DATE_FORMAT(CURDATE(), '%Y-%m-01'), INTERVAL 12 MONTH), '%Y-%m')
                        THEN pl.restap ELSE 0 END) AS `Mar-27`
            
            FROM promesse pdv
            LEFT JOIN plande_p pl ON pl.pdv_id = pdv.id
            WHERE pl.enabled = TRUE
            AND pdv.recstatus != 'end'
            AND pl.DatedP >= DATE_FORMAT(DATE_ADD(DATE_FORMAT(CURDATE(), '%Y-%m-01'), INTERVAL 1 MONTH), '%Y-%m-01')
            AND pl.DatedP < DATE_FORMAT(DATE_ADD(DATE_FORMAT(CURDATE(), '%Y-%m-01'), INTERVAL 13 MONTH), '%Y-%m-01')
            AND pdv.id IN (939,971,989,1022,1047,1057,1065,1068,1071,1072,1073,1074,1077,1098,1102,1110,1115,1119,1136,1139,1141,1144,1146,1150,1159,1160,1161,1162,1163,1165,1171,1176,1186,1189,1191,1193,1196,1197,1198,1204,1206,1208,1211,1212,1214,1219,1220,1226,1227,1230,1231,1233,1235,1236,1238,1241,1242,1245,1248,1249,1255,1258,1261,1262,1265,1266,1268,1269,1270,1272,1273,1277,1278,1279,1280,1281,1282,1283,1284,1049,1056,1078,1079,1080,1081,1083,1100,1104,1130,1151,1154,1158,1166,1167,1168,1169,1170,1173,1178,1188,1207,1224,1232,1240,1246)
            GROUP BY pdv.locat
        ;

SELECT
  SUM(pl.restap) AS montant
FROM
  promesse AS pdv
  LEFT JOIN plande_p AS pl ON pl.pdv_id = pdv.id
  AND YEAR(pl.DatedP) = YEAR(
    CURDATE()
  )
  AND MONTH(pl.DatedP) = MONTH(
    CURDATE()
  )
WHERE
  pl.enabled = TRUE
  AND pdv.recstatus != 'end'
  AND pdv.locat = ?
  AND pl.tendance != 'M+'

SELECT 

                SUM(pl.restap) AS montant

                FROM promesse AS pdv

                LEFT JOIN plande_p AS pl 
                    ON pl.pdv_id = pdv.id
                    AND YEAR(pl.DatedP) = YEAR(CURDATE())
                    AND MONTH(pl.DatedP) = MONTH(CURDATE())

                WHERE pl.enabled = TRUE
                AND pdv.recstatus != 'end'
                AND pdv.locat = 'AMBATOBE ILAFY ABE'
                AND pl.tendance != 'M+'

        ;

SELECT
  SUM(pl.restap) AS montant
FROM
  promesse AS pdv
  LEFT JOIN plande_p AS pl ON pl.pdv_id = pdv.id
  AND YEAR(pl.DatedP) = YEAR(
    CURDATE()
  )
  AND MONTH(pl.DatedP) = MONTH(
    CURDATE()
  )
WHERE
  pl.enabled = TRUE
  AND pdv.recstatus != 'end'
  AND pdv.locat = ?
  AND pl.tendance != 'M+'

SELECT 

                SUM(pl.restap) AS montant

                FROM promesse AS pdv

                LEFT JOIN plande_p AS pl 
                    ON pl.pdv_id = pdv.id
                    AND YEAR(pl.DatedP) = YEAR(CURDATE())
                    AND MONTH(pl.DatedP) = MONTH(CURDATE())

                WHERE pl.enabled = TRUE
                AND pdv.recstatus != 'end'
                AND pdv.locat = 'ILAFY - ILF'
                AND pl.tendance != 'M+'

        ;

SELECT
  SUM(pl.restap) AS montant
FROM
  promesse AS pdv
  LEFT JOIN plande_p AS pl ON pl.pdv_id = pdv.id
  AND YEAR(pl.DatedP) = YEAR(
    CURDATE()
  )
  AND MONTH(pl.DatedP) = MONTH(
    CURDATE()
  )
WHERE
  pl.enabled = TRUE
  AND pdv.recstatus != 'end'
  AND pdv.locat = ?
  AND pl.tendance != 'M+'

SELECT 

                SUM(pl.restap) AS montant

                FROM promesse AS pdv

                LEFT JOIN plande_p AS pl 
                    ON pl.pdv_id = pdv.id
                    AND YEAR(pl.DatedP) = YEAR(CURDATE())
                    AND MONTH(pl.DatedP) = MONTH(CURDATE())

                WHERE pl.enabled = TRUE
                AND pdv.recstatus != 'end'
                AND pdv.locat = 'VONTOVORONA VTR'
                AND pl.tendance != 'M+'

        ;

SELECT
  SUM(pl.restap) AS montant
FROM
  promesse AS pdv
  LEFT JOIN plande_p AS pl ON pl.pdv_id = pdv.id
  AND YEAR(pl.DatedP) = YEAR(
    CURDATE()
  )
  AND MONTH(pl.DatedP) = MONTH(
    CURDATE()
  )
WHERE
  pl.enabled = TRUE
  AND pdv.recstatus != 'end'
  AND pdv.locat = ?
  AND pl.tendance != 'M+'

SELECT 

                SUM(pl.restap) AS montant

                FROM promesse AS pdv

                LEFT JOIN plande_p AS pl 
                    ON pl.pdv_id = pdv.id
                    AND YEAR(pl.DatedP) = YEAR(CURDATE())
                    AND MONTH(pl.DatedP) = MONTH(CURDATE())

                WHERE pl.enabled = TRUE
                AND pdv.recstatus != 'end'
                AND pdv.locat = 'BETSIZARAINA BTS'
                AND pl.tendance != 'M+'

        ;

SELECT
  SUM(pl.restap) AS montant
FROM
  promesse AS pdv
  LEFT JOIN plande_p AS pl ON pl.pdv_id = pdv.id
  AND YEAR(pl.DatedP) = YEAR(
    CURDATE()
  )
  AND MONTH(pl.DatedP) = MONTH(
    CURDATE()
  )
WHERE
  pl.enabled = TRUE
  AND pdv.recstatus != 'end'
  AND pdv.locat = ?
  AND pl.tendance != 'M+'

SELECT 

                SUM(pl.restap) AS montant

                FROM promesse AS pdv

                LEFT JOIN plande_p AS pl 
                    ON pl.pdv_id = pdv.id
                    AND YEAR(pl.DatedP) = YEAR(CURDATE())
                    AND MONTH(pl.DatedP) = MONTH(CURDATE())

                WHERE pl.enabled = TRUE
                AND pdv.recstatus != 'end'
                AND pdv.locat = 'BETSIZARAINA'
                AND pl.tendance != 'M+'

        ;

SELECT
  SUM(pl.restap) AS montant
FROM
  promesse AS pdv
  LEFT JOIN plande_p AS pl ON pl.pdv_id = pdv.id
  AND YEAR(pl.DatedP) = YEAR(
    CURDATE()
  )
  AND MONTH(pl.DatedP) = MONTH(
    CURDATE()
  )
WHERE
  pl.enabled = TRUE
  AND pdv.recstatus != 'end'
  AND pdv.locat = ?
  AND pl.tendance != 'M+'

SELECT 

                SUM(pl.restap) AS montant

                FROM promesse AS pdv

                LEFT JOIN plande_p AS pl 
                    ON pl.pdv_id = pdv.id
                    AND YEAR(pl.DatedP) = YEAR(CURDATE())
                    AND MONTH(pl.DatedP) = MONTH(CURDATE())

                WHERE pl.enabled = TRUE
                AND pdv.recstatus != 'end'
                AND pdv.locat = 'PALACE MI'
                AND pl.tendance != 'M+'

        ;

SELECT
  SUM(pl.restap) AS montant
FROM
  promesse AS pdv
  LEFT JOIN plande_p AS pl ON pl.pdv_id = pdv.id
  AND YEAR(pl.DatedP) = YEAR(
    CURDATE()
  )
  AND MONTH(pl.DatedP) = MONTH(
    CURDATE()
  )
WHERE
  pl.enabled = TRUE
  AND pdv.recstatus != 'end'
  AND pdv.locat = ?
  AND pl.tendance != 'M+'

SELECT 

                SUM(pl.restap) AS montant

                FROM promesse AS pdv

                LEFT JOIN plande_p AS pl 
                    ON pl.pdv_id = pdv.id
                    AND YEAR(pl.DatedP) = YEAR(CURDATE())
                    AND MONTH(pl.DatedP) = MONTH(CURDATE())

                WHERE pl.enabled = TRUE
                AND pdv.recstatus != 'end'
                AND pdv.locat = 'EX_ABZ'
                AND pl.tendance != 'M+'

        ;

SELECT
  SUM(pl.restap) AS montant
FROM
  promesse AS pdv
  LEFT JOIN plande_p AS pl ON pl.pdv_id = pdv.id
  AND YEAR(pl.DatedP) = YEAR(
    CURDATE()
  )
  AND MONTH(pl.DatedP) = MONTH(
    CURDATE()
  )
WHERE
  pl.enabled = TRUE
  AND pdv.recstatus != 'end'
  AND pdv.locat = ?
  AND pl.tendance != 'M+'

SELECT 

                SUM(pl.restap) AS montant

                FROM promesse AS pdv

                LEFT JOIN plande_p AS pl 
                    ON pl.pdv_id = pdv.id
                    AND YEAR(pl.DatedP) = YEAR(CURDATE())
                    AND MONTH(pl.DatedP) = MONTH(CURDATE())

                WHERE pl.enabled = TRUE
                AND pdv.recstatus != 'end'
                AND pdv.locat = 'EX_AMV'
                AND pl.tendance != 'M+'

        ;

SELECT
  SUM(pl.restap) AS montant
FROM
  promesse AS pdv
  LEFT JOIN plande_p AS pl ON pl.pdv_id = pdv.id
  AND YEAR(pl.DatedP) = YEAR(
    CURDATE()
  )
  AND MONTH(pl.DatedP) = MONTH(
    CURDATE()
  )
WHERE
  pl.enabled = TRUE
  AND pdv.recstatus != 'end'
  AND pdv.locat = ?
  AND pl.tendance != 'M+'

SELECT 

                SUM(pl.restap) AS montant

                FROM promesse AS pdv

                LEFT JOIN plande_p AS pl 
                    ON pl.pdv_id = pdv.id
                    AND YEAR(pl.DatedP) = YEAR(CURDATE())
                    AND MONTH(pl.DatedP) = MONTH(CURDATE())

                WHERE pl.enabled = TRUE
                AND pdv.recstatus != 'end'
                AND pdv.locat = 'IMERIKASININA CO'
                AND pl.tendance != 'M+'

        ;