clubs

CASE 
	WHEN ( "position" >= 0 AND "position" <= 80 ) OR ( "position" >= 275 AND "position" <= 281 ) OR ( "position" > 298 AND "position" <= 324 ) 
	THEN  'AAC'
	WHEN ( "position" >= 81 AND "position" <= 126 ) OR ( "position" >= 128 AND "position" <= 131 )
	THEN  'Eerste Rivier'
	WHEN ( "position" >= 154 AND "position" <= 199 )
	THEN  'Midas Spartans'
	WHEN ( "position" >= 133 AND "position" <= 153 ) OR ( "position" >= 200 AND "position" <= 238 )
	THEN  'Nantes'
	WHEN ( "position" >= 239 AND "position" <= 256 ) OR ( "position" = 132 ) OR ( "position" = 127 ) OR ( "position" >= 258 AND "position" <= 261 )  OR ( "position" >= 265 AND "position" <= 250 )  OR ( "position" >= 239 AND "position" <= 274 ) 
	THEN  'Spartan Harriers'
	WHEN ( "position" = 257 ) OR ( "position" >= 262 AND "position" <= 264 ) OR ( "position" >= 282 AND "position" <= 297 ) 
	THEN  'Edgemead Runners'
END


captain

CASE
        WHEN ( "position" >= 0 AND "position" <= 80 ) OR ( "position" >= 275 AND "position" <= 281 ) OR ( "position" > 298 AND "position" <= 324 ) 
        THEN  ''
        WHEN ( "position" >= 81 AND "position" <= 126 ) OR ( "position" >= 128 AND "position" <= 131 )
        THEN  'Raphael Manual'
        WHEN ( "position" >= 154 AND "position" <= 199 )
        THEN  'Michael Schouw'
        WHEN ( "position" >= 133 AND "position" <= 153 ) OR ( "position" >= 200 AND "position" <= 238 )
        THEN  'Caroline Peters'
        WHEN ( "position" >= 239 AND "position" <= 256 ) OR ( "position" = 132 ) OR ( "position" = 127 ) OR ( "position" >= 258 AND "position" <= 261 )  OR ( "position" >= 265 AND "position" <= 250 )  OR ( "position" >= 239 AND "position" <= 274 ) 
        THEN  'Gavin Craig'
        WHEN ( "position" = 257 ) OR ( "position" >= 262 AND "position" <= 264 ) OR ( "position" >= 282 AND "position" <= 297 ) 
        THEN  'Stephan Roux'
END

captain_ph

CASE
        WHEN ( "position" >= 0 AND "position" <= 80 ) OR ( "position" >= 275 AND "position" <= 281 ) OR ( "position" > 298 AND "position" <= 324 ) 
        THEN  ''
        WHEN ( "position" >= 81 AND "position" <= 126 ) OR ( "position" >= 128 AND "position" <= 131 )
        THEN  '084-494-4525'
        WHEN ( "position" >= 154 AND "position" <= 199 )
        THEN  '083-635-1346'
        WHEN ( "position" >= 133 AND "position" <= 153 ) OR ( "position" >= 200 AND "position" <= 238 )
        THEN  '073-029-7879'
        WHEN ( "position" >= 239 AND "position" <= 256 ) OR ( "position" = 132 ) OR ( "position" = 127 ) OR ( "position" >= 258 AND "position" <= 261 )  OR ( "position" >= 265 AND "position" <= 250 )  OR ( "position" >= 239 AND "position" <= 274 ) 
        THEN  '076-569-6898'
        WHEN ( "position" = 257 ) OR ( "position" >= 262 AND "position" <= 264 ) OR ( "position" >= 282 AND "position" <= 297 ) 
        THEN  '082-433-0230'
END

email

CASE
        WHEN ( "position" >= 0 AND "position" <= 80 ) OR ( "position" >= 275 AND "position" <= 281 ) OR ( "position" > 298 AND "position" <= 324 ) 
        THEN  ''
        WHEN ( "position" >= 81 AND "position" <= 126 ) OR ( "position" >= 128 AND "position" <= 131 )
        THEN  'raphaeljm1@gmail.com'
        WHEN ( "position" >= 154 AND "position" <= 199 )
        THEN  'schouw.za@gmail.com'
        WHEN ( "position" >= 133 AND "position" <= 153 ) OR ( "position" >= 200 AND "position" <= 238 )
        THEN  'carolinepeters1964@gmail.com'
        WHEN ( "position" >= 239 AND "position" <= 256 ) OR ( "position" = 132 ) OR ( "position" = 127 ) OR ( "position" >= 258 AND "position" <= 261 )  OR ( "position" >= 265 AND "position" <= 250 )  OR ( "position" >= 239 AND "position" <= 274 ) 
        THEN  'gavinc@ctpflexibles.co.za'
        WHEN ( "position" = 257 ) OR ( "position" >= 262 AND "position" <= 264 ) OR ( "position" >= 282 AND "position" <= 297 ) 
        THEN  'raceconvener@edgemeaddrunners.org.za'
END
