SELECT date, segment, category, brand_id, brand, order_id, customer_id, statusid, status, SUM(profit) profit, SUM(revenue) revenue, SUM(count) qnt
FROM(
	SELECT
	op.id,
	DATE(o.date_create) date,
	si.dok_izdelie_id izdelieid,
	dp.name_ru segment,
	IF(si.name_short IS NULL, "(Not_Set)", si.name_short) category,
	pa.art_num SKU,
	IF(in_price_for_1 = 0, op.out_price_for_1*0.3*count, IF(op.in_price_for_1/op.out_price_for_1 > 5,(op.out_price_for_1-pa.price_sredn)*op.count,(op.out_price_for_1-op.in_price_for_1)*op.count)) profit,
-- есть старый баг, в котором цена закупки = 0, в таком случае профит считаю как 30% от ревеню
	op.in_price_for_1,
	op.out_price_for_1*op.count revenue,
op.count,
	oc.order_id,
	os.id statusid,
	os.what status,
	o.customer_id,
	pa.brand_id,
	ba.NAME_BRANDS brand
	FROM
	yii_doc.orders o
	LEFT JOIN yii_doc.order_status os on os.id=o.order_status_id
	LEFT JOIN yii_doc.order_cars oc ON o.id = oc.order_id
	LEFT JOIN yii_doc.order_product op ON oc.id = op.car_id
	LEFT JOIN yii_doc.prices_all pa ON op.price_all_id = pa.id
	LEFT JOIN yii_doc.dok_ga dg ON pa.pa_ga_id = dg.GA_ID
	LEFT JOIN yii_doc.brand_all ba ON pa.brand_id = ba.id
	LEFT JOIN yii_doc.dok_razdel dr ON dg.parent_id = dr.id
	LEFT JOIN yii_doc.dok_izdelie di ON dr.parent_id = di.id
	LEFT JOIN yii_doc.dok_podrubrica dp ON dp.id=di.parent_id
	LEFT JOIN yii_doc.seo_izdelie si on di.id=si.dok_izdelie_id
	WHERE o.date_create BETWEEN "2019-01-01" and DATE_ADD(CURRENT_DATE(),INTERVAL -WEEKDAY(CURRENT_DATE()) day)
        AND op.active = 1                                              -- товар не отменен в чеке
        AND o.order_status_id NOT IN (1, 15)
	AND di.grand_parent_id=9
	GROUP BY op.id, date, category, si.name_short, dp.name_ru, pa.art_num, profit, 	op.in_price_for_1, revenue, op.count, oc.order_id, os.id, os.what, o.customer_id, pa.brand_id, ba.NAME_BRANDS
) raw
GROUP BY date, segment, category, brand_id, brand, order_id, customer_id, statusid, status