Дебитор-кредитор на утро
Errant query: SELECT client_id,
(SELECT name FROM dic_base WHERE id=(SELECT base_id FROM dic_clients WHERE id=client_id)) as base_name,
(SELECT name FROM dic_clients WHERE id=client_id) as client_name,
-1*SUM(summ_nal) as summ2,
(SELECT itog_summ FROM doc_invoice WHERE client_id=trs_debcred.client_id AND dolg_is=1 ORDER BY curdate DESC LIMIT 0, 1) as ob1,
(SELECT itog_summ FROM doc_invoice WHERE client_id=trs_debcred.client_id AND dolg_is=1 ORDER BY curdate DESC LIMIT 1, 1) as ob2,
(SELECT itog_summ FROM doc_invoice WHERE client_id=trs_debcred.client_id AND dolg_is=1 ORDER BY curdate DESC LIMIT 2, 1) as ob3,
(SELECT curdate FROM doc_invoice WHERE client_id=trs_debcred.client_id AND dolg_is=1 AND curdate0
GROUP BY client_id HAVING ABS(IFNULL(SUM(summ_nal),0))>100
ORDER BY (SELECT base_id FROM dic_clients WHERE id=client_id);