SELECT SUM(IF(currency_id = 0, SUM, 0))                                                     AS totalRub,

       SUM(IF(payments.currency_id = 0,
              round(payments.SUM / r.rate, 2), 0))                                          AS totalRubConvert,
       SUM(IF(currency_id = 1, SUM, 0))                                                     AS totalUsd,
       SUM(IF(currency_id = 2, SUM, 0))                                                     AS totalEur,
       SUM(IF(currency_id = 3, SUM, 0))                                                     AS totalUah,
       SUM(IF(currency_id = 0 AND paid = '0', SUM, 0))                                      AS Rub,
       SUM(IF(payments.currency_id = 0 AND paid = '0', round(payments.SUM / r.rate, 2), 0)) AS RubConvert,
       SUM(IF(currency_id = 1 AND paid = '0', SUM, 0))                                      AS Usd,
       SUM(IF(currency_id = 2 AND paid = '0', SUM, 0))                                      AS Eur,
       SUM(IF(currency_id = 3 AND paid = '0', SUM, 0))                                      AS Uah
FROM `payments`
         INNER JOIN rates r ON DATE(payments.TIME) = DATE(r.datetime)
WHERE r.`index` = 'USD';

SELECT SUM(IF(currency_id = 0, SUM, 0))                AS totalRub,
       SUM(IF(currency_id = 1, SUM, 0))                AS totalUsd,
       SUM(IF(currency_id = 2, SUM, 0))                AS totalEur,
       SUM(IF(currency_id = 3, SUM, 0))                AS totalUah,
       SUM(IF(currency_id = 0 AND paid = '0', SUM, 0)) AS Rub,

       SUM(IF(currency_id = 1 AND paid = '0', SUM, 0)) AS Usd,
       SUM(IF(currency_id = 2 AND paid = '0', SUM, 0)) AS Eur,
       SUM(IF(currency_id = 3 AND paid = '0', SUM, 0)) AS Uah
FROM `payments`;

SELECT SUM(`convert`) AS `convert`
FROM (SELECT DISTINCT DATE, SUM, round(SUM / rate, 2) AS `convert`, rate
      FROM (SELECT SUM(SUM) AS SUM, DATE(TIME) AS DATE, COUNT(id) AS COUNT
            FROM payments
            WHERE paid = '0'
            GROUP BY DATE(TIME)) AS p,
           rates r
      WHERE (r.datetime >= concat(p.DATE, ' 00:00:00') AND r.datetime <= concat(p.DATE, ' 23:59:59'))) AS tab;

SELECT SUM(SUM)
FROM payments
WHERE paid = '0'
DELETE
FROM rates
WHERE id > 450

SELECT SUM(IF(currency_id = 0, SUM, 0))                                  AS totalRub,
       SUM(IF(currency_id = 1, SUM, 0))                                  AS totalUsd,
       SUM(IF(currency_id = 2, SUM, 0))                                  AS totalEur,
       SUM(IF(currency_id = 3, SUM, 0))                                  AS totalUah,
       (SELECT SUM(`convert`) AS `convert`
        FROM (SELECT DISTINCT DATE, SUM, round(SUM / rate, 2) AS `convert`
              FROM (SELECT SUM(SUM) AS SUM, DATE(TIME) AS DATE, COUNT(id) AS COUNT
                    FROM payments
                    GROUP BY DATE(TIME)) AS p,
                   rates r
              WHERE (r.datetime >= concat(p.DATE, ' 00:00:00') AND
                     r.datetime <= concat(p.DATE, ' 23:59:59'))) AS tab) AS totalRubConvert,
       (SELECT SUM(`convert`) AS `convert`
        FROM (SELECT DISTINCT DATE, SUM, round(SUM / rate, 2) AS `convert`
              FROM (SELECT SUM(SUM) AS SUM, DATE(TIME) AS DATE, COUNT(id) AS COUNT
                    FROM payments
                    WHERE paid = '0'
                    GROUP BY DATE(TIME)) AS p,
                   rates r
              WHERE (r.datetime >= concat(p.DATE, ' 00:00:00') AND
                     r.datetime <= concat(p.DATE, ' 23:59:59'))) AS tab) AS RubConvert,
       SUM(IF(currency_id = 0 AND paid = '0', SUM, 0))                   AS Rub,
       SUM(IF(currency_id = 1 AND paid = '0', SUM, 0))                   AS Usd,
       SUM(IF(currency_id = 2 AND paid = '0', SUM, 0))                   AS Eur,
       SUM(IF(currency_id = 3 AND paid = '0', SUM, 0))                   AS Uah
FROM `payments`


SELECT SUM(IF(currency_id = 0, SUM, 0))                                  AS totalRub,
       SUM(IF(currency_id = 1, SUM, 0))                                  AS totalUsd,
       SUM(IF(currency_id = 2, SUM, 0))                                  AS totalEur,
       SUM(IF(currency_id = 3, SUM, 0))                                  AS totalUah,
       (SELECT SUM(`convert`) AS `convert`
        FROM (SELECT DISTINCT DATE, SUM, round(SUM / rate, 2) AS `convert`
              FROM (SELECT SUM(SUM) AS SUM, DATE(TIME) AS DATE, COUNT(id) AS COUNT
                    FROM payments
                    WHERE currency_id = 0
                    GROUP BY DATE(TIME)) AS p,
                   rates r
              WHERE (r.datetime >= concat(p.DATE, ' 00:00:00') AND
                     r.datetime <= concat(p.DATE, ' 23:59:59'))) AS tab) AS totalRubConvert,
       (SELECT SUM(`convert`) AS `convert`
        FROM (SELECT DISTINCT DATE, SUM, round(SUM / rate, 2) AS `convert`
              FROM (SELECT SUM(SUM) AS SUM, DATE(TIME) AS DATE, COUNT(id) AS COUNT
                    FROM payments
                    WHERE currency_id = 0
                      AND paid = '0'
                    GROUP BY DATE(TIME)) AS p,
                   rates r
              WHERE (r.datetime >= concat(p.DATE, ' 00:00:00') AND
                     r.datetime <= concat(p.DATE, ' 23:59:59'))) AS tab) AS RubConvert,
       SUM(IF(currency_id = 0 AND paid = '0', SUM, 0))                   AS Rub,
       SUM(IF(currency_id = 1 AND paid = '0', SUM, 0))                   AS Usd,
       SUM(IF(currency_id = 2 AND paid = '0', SUM, 0))                   AS Eur,
       SUM(IF(currency_id = 3 AND paid = '0', SUM, 0))                   AS Uah
FROM `payments`

SELECT *
FROM `rates`
WHERE `index` = 'USD'
  AND DATE(datetime) IN ('2020-01-20', '2019-12-20')



SELECT id,
       payment_type                                    AS paymentType,
       SUM(IF(currency_id = 0, SUM, 0))                AS totalRub,
       SUM(IF(currency_id = 1, SUM, 0))                AS totalUsd,
       SUM(IF(currency_id = 2, SUM, 0))                AS totalEur,
       SUM(IF(currency_id = 3, SUM, 0))                AS totalUah,
       SUM(IF(currency_id = 0 AND paid = '0', SUM, 0)) AS Rub,
       SUM(IF(currency_id = 1 AND paid = '0', SUM, 0)) AS Usd,
       SUM(IF(currency_id = 2 AND paid = '0', SUM, 0)) AS Eur,
       SUM(IF(currency_id = 3 AND paid = '0', SUM, 0)) AS Uah
FROM `payments`
WHERE `paid` = '0'
GROUP BY `paymentType`;

SELECT SUM(SUM), payment_type
FROM payments
WHERE paid = '0'
  AND currency_id = 0
GROUP BY payment_type;

SELECT id, SUM(SUM), payment_type, DATE(TIME)
FROM payments
WHERE currency_id = 0
  AND paid = '0'
GROUP BY DATE(TIME)


SELECT round(Rub / rate, 2) AS `convert`, tab.*, rate
FROM (SELECT payment_type                                    AS paymentType,
             DATE(TIME)                                      AS DATE,
             currency_id,
             SUM(IF(currency_id = 0 AND paid = '0', SUM, 0)) AS Rub,
             SUM(IF(currency_id = 1 AND paid = '0', SUM, 0)) AS Usd,
             SUM(IF(currency_id = 2 AND paid = '0', SUM, 0)) AS Eur,
             SUM(IF(currency_id = 3 AND paid = '0', SUM, 0)) AS Uah
      FROM `payments`
      WHERE `paid` = '0'
      GROUP BY currency_id, DATE(TIME), payment_type
     ) AS tab
         LEFT JOIN rates r ON DATE(r.datetime) = DATE(tab.DATE)