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 8 (
SELECT SUM(CAST(a303.val AS DOUBLE)) 'Остаток'
FROM pechenkin a303
   LEFT JOIN (pechenkin r330 CROSS JOIN pechenkin 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
  FROM pechenkin a299 /* We got an Array */
    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)      ; )