SELECT object
CLUSTER *
FROM { UNION( SELECT object
CLUSTER * ALIAS OBJ1
FROM { SELECT t
CLUSTER *
FROM video_source }
SELECT object
CLUSTER * ALIAS OBJ2
FROM { SELECT t
CLUSTER *
FROM flood_meter } ) }
WHERE OBJ1.type='car' AND OBJ2.type = 'starting_flood'
AND OBJ1.t = OBJ2.t - 5 }
WHERE object.type= 'car'