31050:20100910:182033.364 [Z3005] Query failed: [-1] ORA-00933: SQL command not properly ended
[SELECT s.serviceid FROM services as s, services_links as sl WHERE s.serviceid = sl.serviceupid AND NOT(s.triggerid IS NULL) GROUP BY s.serviceid]
31050:20100910:182033.364 [Z3005] Query failed: [-1] ORA-00933: SQL command not properly ended
[SELECT s.serviceid,s.algorithm,s.triggerid FROM services AS s WHERE s.serviceid NOT IN (SELECT DISTINCT sl.serviceupid FROM services_links AS sl)]
31050:20100910:182033.364 [Z3005] Query failed: [-1] ORA-00933: SQL command not properly ended
[SELECT MAX(sl.servicedownid) as serviceid, sl.serviceupid FROM services_links AS sl WHERE sl.servicedownid NOT IN (select distinct sl.serviceupid from services_links as sl) GROUP BY sl.serviceupid]