i am getting this...
Code: Select all
SQL-ERR '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 E.Archived = 0 )' at line 1', statement was 'select count(E.Id) as EventCount from Monitors as M inner join Events as E on (M.Id = E.MonitorId) where 1 and ( 86 >= 65% and E.Archived = 0 )'