illiquid stat grid

SELECT
    dp.product_id AS product_id,
    c.categories_name AS categories_name,
    sp.product_name AS product_name,
    p.products_price AS products_price,
    p.zak_price AS zak_price,
    p.products_price - p.zak_price AS addition,
    CAST(sk.num AS SIGNED) - CAST(sk.num_otpravlen AS SIGNED) AS free_sklad,
    DATEDIFF(NOW(), sk.date_last_prihod) AS days_on_sklad,
    DATEDIFF(NOW(), sk.date_last_prihod) + cds.value AS total_days,
    DATEDIFF(NOW(), last_buy.date) AS days_last_buy,
    cds.value AS sell_out,
    p.manual_price AS manual_price,
    IF(sp.zvanie = 'sales', 1, 0) AS is_sale,
    (CAST(sk.num AS SIGNED) - CAST(sk.num_otpravlen AS SIGNED)) * p.zak_price AS sklad_sum,
    rrc.value AS rrc,
    man.man_id AS man_id,
    CONCAT(man.firstname, ' ', man.lastname) AS manager,
    cat.long_sklad_days AS long_sklad_days,
    it.value AS illiquid_type
FROM
    sotm_id1c_default_product as dp
        INNER JOIN
    sotm_id1c as id1c ON dp.id1c = id1c.id1c
        LEFT JOIN
    crm_priceparser_zakaz as last_zak ON id1c.last_zakaz_id = last_zak.id
        INNER JOIN
    products_to_categories as pc ON pc.products_id = dp.product_id
        INNER JOIN
    categories AS cat ON cat.categories_id = pc.categories_id
        INNER JOIN
    managers AS man ON man.man_id = IFNULL(last_zak.man_id, cat.ostatki_man_id)
        INNER JOIN
    sotm_categories as c ON c.categories_id = pc.categories_id
        INNER JOIN
    products as p ON p.products_id = dp.product_id
        INNER JOIN
    sotm_products as sp ON sp.products_id = dp.product_id
        INNER JOIN
    products_sklad as sk ON sk.id1c = dp.id1c AND sk.sklad = '000000001' AND sk.option_id = 0
        LEFT JOIN
    products_dates as last_buy ON last_buy.field = 'last_buy' AND last_buy.id1c = p.id1c
        INNER JOIN
    products_property as cds ON cds.id1c = dp.id1c AND cds.param = 'count_days_for_sale'
        INNER JOIN
    products_property as it ON it.id1c = dp.id1c AND it.param = 'illiquid_type'
        LEFT JOIN
    crm_priceparser_slovar_rrc as rrc ON rrc.id1c = p.id1c
WHERE
    sk.sklad_rests > 0 AND 0 = 0
GROUP BY dp.id1c
ORDER BY (CAST(sk.num AS SIGNED) - CAST(sk.num_otpravlen AS SIGNED)) * p.zak_price DESC