SELECT SQL_CALC_FOUND_ROWS
    p.`id1c` AS id1c,
    r.option_id AS option_id,
    p.`products_model` AS products_model,
    p.`reliz_firm_id` AS competitor_firm,
    r.`firm_id` AS my_firm,
    MIN(rc.`zak_price`) AS competitor_price,
    r.`zak_price` AS your_price,
    p.`products_id` AS products_id,
    (CAST(p.`num_reserv` AS SIGNED) - CAST((sk.num + sk.num_prihod) AS SIGNED)) AS num_reserv,
    (SELECT
            SUM(`sells_orders`)
        FROM
            `sotm_product_sell_stat_month`
        WHERE
            `stat_date` = ADDDATE(CURDATE(), INTERVAL - 1 DAY)
                AND `period` = 'month'
                AND `id1c` = p.id1c) AS sales_month,
    fp.`name` AS competitor_firm_name,
    (CAST(rc.`zak_price` AS SIGNED) - CAST(r.`zak_price` AS SIGNED)) AS change_price,
    cod.`code` AS code,
    sl.`name_price` AS name_price,
    NULL AS price_reduced,
    NULL AS number_days_set
FROM
    products AS p
        LEFT JOIN
    products_sklad AS sk ON (sk.`id1c` = p.`id1c`
        AND sk.`option_id` = 0
        AND sk.`sklad` = '000000001')
        LEFT JOIN
    products_reliz_firm AS fp ON (fp.id = p.reliz_firm_id),
    products_reliz AS rc,
    products_reliz AS r
        LEFT JOIN
    products_reliz_firm AS f ON (f.id = r.firm_id)
        LEFT JOIN
    products_reliz_firm_group AS fg ON (fg.firm_id = f.id)
        LEFT JOIN
    crm_priceparser_slovar AS sl ON (sl.id = r.slovar_id)
        LEFT JOIN
    crm_priceparser_slovar_code AS cod ON (cod.slovar_id = r.slovar_id
        AND cod.firm_id = r.firm_id)
WHERE
    r.`firm_id` = '557'
        AND r.`id1c` = p.`id1c`
        AND r.`status` = 1
        AND rc.`status` = 1
        AND p.`reliz_firm_id` != r.firm_id
        AND rc.`id1c` = p.`id1c`
        AND rc.firm_id = p.`reliz_firm_id`
        AND 0 = 0
GROUP BY r.`id1c` , rc.`id1c`
HAVING competitor_price