Couldn't execute query [Request report data] You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '[ТекущаяНоменклатура] AND a299_val>='19700101' AND a299...' at line 10 ( SELECT SUM(a303.val * IF(a1003_val IS NULL, -1, 1)) 'Остаток' FROM misa a303 LEFT JOIN (misa r330 CROSS JOIN misa a330) ON r330.up=a303.id AND r330.val='330' AND a330.id=r330.t AND a330.t=282 LEFT JOIN (SELECT a299.id,a299.val a299_val,a1003.val a1003_val,a2891.val a2891_val FROM misa a299 /* We got an Array */ LEFT JOIN misa a1003 ON a1003.up=a299.id AND a1003.t=1003 LEFT JOIN misa a2891 ON a2891.up=a299.id AND a2891.t=2891 WHERE a299.t=299 ) a299 ON a303.up=a299.id WHERE a303.up!=0 AND length(a303.val)!=0 AND a303.t=303 AND a330.val =[ТекущаяНоменклатура] AND a299_val>='19700101' AND a299_val<='[ТекущаяДата]' AND (a299_val!='[ТекущаяДата]' OR a299_val IS NULL) AND (a2891_val IS NULL OR a2891_val IS NULL) ; )