Wrong query on Monitoring->IT Services page for Oracle DB

SQL error [ORA-00907: missing right parenthesis] in [SELECT sa.serviceid,sa.value FROM (SELECT MAX(sa3.servicealarmid) AS servicealarmid FROM (SELECT sa2.serviceid,MAX(sa2.clock) AS clock FROM service_alarms sa2 WHERE sa2.clock<'1360225390' AND (sa2.serviceid BETWEEN '11' AND '15' OR sa2.serviceid BETWEEN '20' AND '28' OR sa2.serviceid BETWEEN '30' AND '36' OR sa2.serviceid BETWEEN '43' AND '53' OR sa2.serviceid IN ('37','2','5','6','9','29','38','39','42','41')) GROUP BY sa2.serviceid) AS ss JOIN service_alarms sa3 ON sa3.serviceid = ss.serviceid and sa3.clock = ss.clock GROUP BY sa3.serviceid) AS ss2 JOIN service_alarms sa ON sa.servicealarmid = ss2.servicealarmid]
ocifetchinto(): ORA-24374: define not done before fetch or execute and fetch [include/db.inc.php:582]