**********************************************************
@Name('Scaped') 	
select point , dorsal , NTimeSeconds as ntimeseconds 
from RunnerEvent.win:length_batch(2)
where ((Select NTimeSeconds from RunnerEvent.std:lastevent())-(select NTimeSeconds from RunnerEvent.std:firstevent()))>30";

**********************************************************
@Name('TheWall') 
select r3.point as point, r3.dorsal as dorsal, r3.NTimeSeconds as ntimeseconds 
from pattern [(every r1 = RunnerEvent(r1.point=25))->
		      (every r2 = RunnerEvent((r2.dorsal=r1.dorsal) and (r2.point=30)))->
		      (every r3 = RunnerEvent((r3.dorsal=r2.dorsal) and (r3.point=35) and 
		                  ((r3.NTimeSeconds-r2.NTimeSeconds)>((r2.NTimeSeconds-r1.NTimeSeconds)+60))))]";

**********************************************************
@Name('NegativeSplit') 
select r3.point as point, r3.dorsal as dorsal, r3.NTimeSeconds as ntimeseconds 
from pattern [(every r2 = RunnerEvent(r2.point=21.097))->
		      (every r3 = RunnerEvent((r3.dorsal=r2.dorsal) and (r3.point=42.195) and 
		                  ((r3.NTimeSeconds-r2.NTimeSeconds)<=(r2.NTimeSeconds))))]";

**********************************************************
@Name('Finisher')
select point, dorsal, NTimeSeconds as ntimeseconds 
from RunnerEvent where point=42.195"; 

**********************************************************
@Name('Optimal')
select point , dorsal , ntimeseconds  
from NegativeSplit 
where not exists (select dorsal from TheWall.win:time(100 sec) where dorsal=NegativeSplit.dorsal);

**********************************************************
@Name('Cheated')
select point, dorsal, ntimeseconds 
from Finisher
where not exists (select dorsal from RunnerEvent.win:time(100 sec) where dorsal=Finisher.dorsal and RunnerEvent.point=21.097);

**********************************************************
@Name('Record')
select point, dorsal, ntimeseconds 
from Finisher 
where Finisher.ntimeseconds<7418 and not exists (select dorsal from Cheated.win:time(100 sec) where dorsal=Finisher.dorsal);