SELECT * FROM (SELECT   e.* FROM events e WHERE EXISTS (SELECT NULL FROM functions f,items i,hosts_groups hgg JOIN rights r ON r.id=hgg.groupid AND (r.groupid BETWEEN :"SYS_B_00" AND :"SYS_B_01" OR r.groupid IN (:"SYS_B_02",:"SYS_B_03",:"SYS_B_04")) WHERE e.objectid=f.triggerid AND f.itemid=i.itemid AND i.hostid=hgg.hostid GROUP BY f.triggerid HAVING MIN(r.permission)>:"SYS_B_05" AND MAX(r.permission)>=:"SYS_B_06") AND e.object=:"SYS_B_07" AND e.source=:"SYS_B_08" ORDER BY e.clock) WHERE rownum BETWEEN :"SYS_B_09" AND :"SYS_B_10"