L
Size: a a a
ЕК
ЕК
SELECT `id`, SUM(`sum`) as `sum`, SUM(`cash`) as `cash`, SUM(`no_cash`) as `no_cash`, `report_day`, `company_type` FROM `pay_in` WHERE `report_day` IN (SELECT DISTINCT `report_day` FROM `pay_in` WHERE 1) AND `company_type` = 0 GROUP BY `report_day`
UNION
SELECT `id`, SUM(`sum`) as `sum`, SUM(`cash`) as `cash`, SUM(`no_cash`) as `no_cash`, `report_day`, `company_type` FROM `pay_in` WHERE `report_day` IN (SELECT DISTINCT `report_day` FROM `pay_in` WHERE 1) AND `company_type` = 1 GROUP BY `report_day`
UNION
SELECT `id`, SUM(`sum`) as `sum`, SUM(`cash`) as `cash`, SUM(`no_cash`) as `no_cash`, `report_day`, `company_type` FROM `pay_in` WHERE `report_day` IN (SELECT DISTINCT `report_day` FROM `pay_in` WHERE 1) AND `company_type` = 2 GROUP BY `report_day`
ЕК
ЕК
SELECT `id`, SUM(`sum`) as `sum`, SUM(`cash`) as `cash`, SUM(`no_cash`) as `no_cash`, `report_day`, `company_type` FROM `pay_in` WHERE `report_day` IN (SELECT DISTINCT `report_day` FROM `pay_in` WHERE 1) GROUP BY `report_day`, `company_type`
ЕК
L
NI
NI
NI