339s

select BRIOAUD.V8_Usage_Event_Type.Name,BRIODB.V8_Subject.Name,V8_Usage_Event.STARTTIME,BRIOAUD.V8_Usage_Event.FINISHTIME,
BRIODB.V8_Container.NAME,(SELECT C.VALUE FROM
BRIOAUD.V8_Domain_Props C WHERE C.NAME='GSM HOST')

FROM
BRIOAUD.V8_Usage_Event_Type, BRIODB.V8_Subject, BRIOAUD.V8_Domain_Props, BRIOAUD.V8_Usage_Event
LEFT OUTER JOIN
BRIODB.V8_Container ON (BRIOAUD.V8_Usage_Event.Object_Uuid=BRIODB.V8_Container.Container_Uuid)
WHERE (BRIOAUD.V8_Usage_Event_Type.Type_Uuid=BRIOAUD.V8_Usage_Event.Type_Uuid
AND
BRIODB.V8_Subject.Subject_Id=BRIOAUD.V8_Usage_Event.Subject_Uuid) 
AND (VarLimit.Starttime AND BRIOAUD.V8_Domain_Props.Name='GSM HOST')
-------------------------------------------------------------------------------
156s

select BRIOAUD.V8_Usage_Event_Type.Name,BRIODB.V8_Subject.Name,BRIOAUD.V8_Usage_Event.STARTTIME,BRIOAUD.V8_Usage_Event.FINISHTIME,BRIODB.V8_Container.Name,
(SELECT C.VALUE FROM
BRIODB.V8_Domain_Props C WHERE C.NAME='GSM HOST')

FROM
BRIOAUD.V8_Usage_Event LEFT OUTER JOIN BRIODB.V8_Container
ON (BRIOAUD.V8_Usage_Event.Object_Uuid=BRIODB.V8_Container.Container_Uuid)
LEFT JOIN BRIOAUD.V8_Usage_Event_Type
ON (BRIOAUD.V8_Usage_Event_Type.Type_Uuid=BRIOAUD.V8_Usage_Event.Type_Uuid )
LEFT JOIN BRIODB.V8_Subject
ON (BRIODB.V8_Subject.Subject_Id=BRIOAUD.V8_Usage_Event.Subject_Uuid)
WHERE
BRIOAUD.V8_Usage_Event.Starttime  > current timestamp - 10  minutes