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)     ; )