Сегодня
Errant query: SELECT
id,
name,
(SELECT SUM((SELECT SUM(kg) FROM doc_invoice_list WHERE invoice_id=t2.id AND (SELECT category_id FROM dic_products WHERE id=product_id)=1)) FROM doc_invoice t2 WHERE curdate=CURDATE() AND status<6 AND base_id=t1.id) as m1,
(SELECT SUM((SELECT SUM(kg) FROM doc_invoice_list WHERE invoice_id=t2.id AND (SELECT category_id FROM dic_products WHERE id=product_id)=2)) FROM doc_invoice t2 WHERE curdate=CURDATE() AND status<6 AND base_id=t1.id) as m2,
(SELECT SUM((SELECT SUM(qty) FROM doc_invoice_list WHERE invoice_id=t2.id AND (SELECT category_id FROM dic_products WHERE id=product_id)=3)) FROM doc_invoice t2 WHERE curdate=CURDATE() AND status<6 AND base_id=t1.id) as m3
FROM dic_base t1 WHERE IFNULL(is_active,0)=1 AND supervisor_id=0
ORDER BY id