69 lines
3.8 KiB
Plaintext
69 lines
3.8 KiB
Plaintext
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
|