Errant query: SELECT
id,
name,
IFNULL(kg/coeff,0) as kg_for_pc,
IFNULL(coeff_rep, 1) as coeff_rep,
(SELECT name FROM dic_prod_category WHERE id=category_id) as category_name,
(SELECT SUM((SELECT SUM(qty/IFNULL(coeff_rep,0)) FROM doc_invoice_list WHERE invoice_id=t2.id AND product_id=t1.id)) FROM doc_invoice t2 WHERE curdate=CURDATE() AND status<6 AND (base_id=0 OR (SELECT supervisor_id FROM dic_base WHERE id=base_id)=0)) as m1,
(SELECT SUM((SELECT SUM(qty/IFNULL(coeff_rep,0)) FROM doc_invoice_list WHERE invoice_id=t2.id AND product_id=t1.id)) FROM doc_invoice t2 WHERE curdate=DATE_SUB(CURDATE(), INTERVAL 1 DAY) AND status<6 AND (base_id=0 OR (SELECT supervisor_id FROM dic_base WHERE id=base_id)=0)) as m2,
(SELECT SUM((SELECT SUM(qty/IFNULL(coeff_rep,0)) FROM doc_invoice_list WHERE invoice_id=t2.id AND product_id=t1.id)) FROM doc_invoice t2 WHERE curdate=DATE_SUB(CURDATE(), INTERVAL 2 DAY) AND status<6 AND (base_id=0 OR (SELECT supervisor_id FROM dic_base WHERE id=base_id)=0)) as m3,
(SELECT COUNT(DISTINCT(SELECT client_id FROM doc_invoice_list WHERE invoice_id=t2.id AND product_id=t1.id)) FROM doc_invoice t2 WHERE curdate=DATE_SUB(CURDATE(), INTERVAL 1 DAY) AND status<6 AND (base_id=2183 OR (SELECT supervisor_id FROM dic_base WHERE id=base_id)=2183)) as m2_count
FROM dic_products t1 WHERE IFNULL(is_active,0)=1 AND supply_client_id in (1,10)
ORDER BY category_id, order_num