z7.bwsUPDATE receiveddata SET CONTRACT='P' where CONTRACT='PASS'update scorekaart set nz_contract=NULL,OW_contract=NULL,NZ_punten=NULL,OW_punten=null,resultaat=null where comp_ronde=1
0select count (id) as maxt from receiveddata where remarks='Result erased'
spel =1 | ||||||||||||
tafel | ronde | NS/EW | NZ contract | OW contract | resultaat | NS | - | OW | # | bonus | punten | totaal |
4 | 5 | E | 4 H | = | 11 | 4 | 4 | 300 | 420 | 1980 | ||
3 | 5 | W | 2 NT | +1 | 3 | 12 | 3 | 60 | 150 | 510 | ||
6 | 3 | W | 3 H | +1 | 10 | 6 | 4 | 50 | 170 | 730 | ||
5 | 3 | W | 3 NT | -2 | 5 | 9 | -100 | 310 | -100 | -100 | ||
2 | 1 | E | 4 H | = | 8 | 2 | 4 | 300 | 420 | 1980 | ||
1 | 1 | E | 3 H | +1 | 1 | 7 | 4 | 50 | 170 | 730 | ||
spel =2 | ||||||||||||
tafel | ronde | NS/EW | NZ contract | OW contract | resultaat | NS | - | OW | # | bonus | punten | totaal |
4 | 5 | N | 1 NT | -2 | 11 | 4 | -200 | 60 | -200 | -200 | ||
3 | 5 | S | 3 S | -1 | 3 | 12 | -100 | 50 | -100 | -100 | ||
6 | 3 | N | 1 NT | -1 | 10 | 6 | -100 | 60 | -100 | -100 | ||
5 | 3 | S | 2 S | = | 5 | 9 | 2 | 50 | 110 | 270 | ||
2 | 1 | W | 3 H | -1 | 8 | 2 | -50 | 50 | -50 | -50 | ||
1 | 1 | N | 2 S | -1 | 1 | 7 | -100 | 50 | -100 | -100 | ||
spel =3 | ||||||||||||
tafel | ronde | NS/EW | NZ contract | OW contract | resultaat | NS | - | OW | # | bonus | punten | totaal |
3 | 5 | S | 2 NT | -1 | 3 | 12 | -50 | 60 | -50 | -50 | ||
4 | 5 | S | 2 NT | -1 | 11 | 4 | -50 | 60 | -50 | -50 | ||
5 | 3 | S | 2 NT | +1 | 5 | 9 | 3 | 60 | 150 | 510 | ||
6 | 3 | N | 2 NT | -1 | 10 | 6 | -50 | 60 | -50 | -50 | ||
1 | 1 | S | 2 NT | -3 | 1 | 7 | -150 | 60 | -150 | -150 | ||
2 | 1 | N | 2 NT | = | 8 | 2 | 2 | 60 | 120 | 300 | ||
spel =4 | ||||||||||||
tafel | ronde | NS/EW | NZ contract | OW contract | resultaat | NS | - | OW | # | bonus | punten | totaal |
3 | 5 | S | 3 NT | = | 3 | 12 | 3 | 510 | 600 | 2310 | ||
4 | 5 | S | 1 D | +1 | 11 | 4 | 2 | 50 | 90 | 230 | ||
5 | 3 | S | 1 C | +1 | 5 | 9 | 2 | 50 | 90 | 230 | ||
6 | 3 | S | 1 D | +3 | 10 | 6 | 4 | 50 | 130 | 570 | ||
1 | 1 | N | 1 D | +2 | 1 | 7 | 3 | 50 | 110 | 380 | ||
2 | 1 | S | 1 D | +2 | 8 | 2 | 3 | 50 | 110 | 380 | ||
spel =5 | ||||||||||||
tafel | ronde | NS/EW | NZ contract | OW contract | resultaat | NS | - | OW | # | bonus | punten | totaal |
4 | 6 | W | 4 H | = | 7 | 4 | 4 | 300 | 420 | 1980 | ||
3 | 6 | N | 3 S | -1 | 3 | 8 | -100 | 50 | -100 | -100 | ||
6 | 4 | N | 2 S | = | 11 | 6 | 2 | 50 | 110 | 270 | ||
5 | 4 | N | 3 S | -3 | 5 | 12 | -300 | 50 | -300 | -300 | ||
2 | 2 | W | 4 H | -1 | 10 | 2 | -50 | 300 | -50 | -50 | ||
1 | 2 | W | 4 H | = | 1 | 9 | 4 | 300 | 420 | 1980 | ||
spel =6 | ||||||||||||
tafel | ronde | NS/EW | NZ contract | OW contract | resultaat | NS | - | OW | # | bonus | punten | totaal |
4 | 6 | N | 2 H | +2 | 7 | 4 | 4 | 50 | 170 | 730 | ||
3 | 6 | S | 3 H | +1 | 3 | 8 | 4 | 50 | 170 | 730 | ||
6 | 4 | S | 4 H | = | 11 | 6 | 4 | 300 | 420 | 1980 | ||
5 | 4 | S | 3 H | +1 | 5 | 12 | 4 | 50 | 170 | 730 | ||
2 | 2 | S | 3 H | +1 | 10 | 2 | 4 | 50 | 170 | 730 | ||
1 | 2 | S | 2 H | +2 | 1 | 9 | 4 | 50 | 170 | 730 | ||
spel =7 | ||||||||||||
tafel | ronde | NS/EW | NZ contract | OW contract | resultaat | NS | - | OW | # | bonus | punten | totaal |
3 | 6 | E | 2 H | = | 3 | 8 | 2 | 50 | 110 | 270 | ||
4 | 6 | E | 2 H | = | 7 | 4 | 2 | 50 | 110 | 270 | ||
5 | 4 | E | 3 H | -2 | 5 | 12 | -200 | 50 | -200 | -200 | ||
6 | 4 | E | 3 H | -1 | 11 | 6 | -100 | 50 | -100 | -100 | ||
1 | 2 | E | 3 NT | -1 | 1 | 9 | -100 | 510 | -100 | -100 | ||
2 | 2 | E | 2 NT | +1 | 10 | 2 | 3 | 60 | 150 | 510 | ||
spel =8 | ||||||||||||
tafel | ronde | NS/EW | NZ contract | OW contract | resultaat | NS | - | OW | # | bonus | punten | totaal |
3 | 6 | W | 4 H | -1 | 3 | 8 | -50 | 300 | -50 | -50 | ||
4 | 6 | W | 4 H | = | 7 | 4 | 4 | 300 | 420 | 1980 | ||
5 | 4 | W | 4 H | = | 5 | 12 | 4 | 300 | 420 | 1980 | ||
6 | 4 | W | 4 H | -1 | 11 | 6 | -50 | 300 | -50 | -50 | ||
1 | 2 | W | 4 H | = | 1 | 9 | 4 | 300 | 420 | 1980 | ||
2 | 2 | W | 4 H | = | 10 | 2 | 4 | 300 | 420 | 1980 | ||
spel =9 | ||||||||||||
tafel | ronde | NS/EW | NZ contract | OW contract | resultaat | NS | - | OW | # | bonus | punten | totaal |
6 | 5 | S | 2 D | +1 | 7 | 6 | 3 | 50 | 110 | 380 | ||
5 | 5 | E | 2 C | +1 | 5 | 8 | 3 | 50 | 110 | 380 | ||
2 | 3 | N | 2 H | -3 | 12 | 2 | -150 | 50 | -150 | -150 | ||
1 | 3 | S | 1 NT | -3 | 1 | 11 | -150 | 60 | -150 | -150 | ||
4 | 1 | W | 3 C | = | 10 | 4 | 3 | 50 | 110 | 380 | ||
3 | 1 | S | 2 D | = | 3 | 9 | 2 | 50 | 90 | 230 | ||
spel =10 | ||||||||||||
tafel | ronde | NS/EW | NZ contract | OW contract | resultaat | NS | - | OW | # | bonus | punten | totaal |
6 | 5 | E | 3 NT | +2 | 7 | 6 | 5 | 510 | 660 | 3810 | ||
5 | 5 | W | 3 NT | = | 5 | 8 | 3 | 510 | 600 | 2310 | ||
2 | 3 | E | 3 NT | = | 12 | 2 | 3 | 510 | 600 | 2310 | ||
1 | 3 | E | 3 NT | +3 | 1 | 11 | 6 | 510 | 690 | 4650 | ||
4 | 1 | E | 3 NT | +2 | 10 | 4 | 5 | 510 | 660 | 3810 | ||
3 | 1 | W | 3 NT | = | 3 | 9 | 3 | 510 | 600 | 2310 | ||
spel =11 | ||||||||||||
tafel | ronde | NS/EW | NZ contract | OW contract | resultaat | NS | - | OW | # | bonus | punten | totaal |
5 | 5 | S | 3 NT | +2 | 5 | 8 | 5 | 310 | 460 | 2610 | ||
6 | 5 | N | 3 NT | = | 7 | 6 | 3 | 310 | 400 | 1510 | ||
1 | 3 | N | 3 NT | +2 | 1 | 11 | 5 | 310 | 460 | 2610 | ||
2 | 3 | N | 6 NT | -1 | 12 | 2 | -50 | 310 | -50 | -50 | ||
3 | 1 | N | 6 D | -1 | 3 | 9 | -50 | 800 | -50 | -50 | ||
4 | 1 | S | 5 D | = | 10 | 4 | 5 | 300 | 400 | 2300 | ||
spel =12 | ||||||||||||
tafel | ronde | NS/EW | NZ contract | OW contract | resultaat | NS | - | OW | # | bonus | punten | totaal |
5 | 5 | S | 3 S | -1 | 5 | 8 | -100 | 50 | -100 | -100 | ||
6 | 5 | N | 2 S | +1 | 7 | 6 | 3 | 50 | 140 | 470 | ||
1 | 3 | S | 4 S | -1 | 1 | 11 | -100 | 500 | -100 | -100 | ||
2 | 3 | N | 3 NT | -3 | 12 | 2 | -300 | 510 | -300 | -300 | ||
3 | 1 | S | 3 S | +1 | 3 | 9 | 4 | 50 | 170 | 730 | ||
4 | 1 | N | 3 NT | = | 10 | 4 | 3 | 510 | 600 | 2310 | ||
spel =13 | ||||||||||||
tafel | ronde | NS/EW | NZ contract | OW contract | resultaat | NS | - | OW | # | bonus | punten | totaal |
5 | 6 | N | 2 S | +1 | 5 | 10 | 3 | 50 | 140 | 470 | ||
6 | 6 | N | 2 S | -1 | 9 | 6 | -100 | 50 | -100 | -100 | ||
2 | 4 | N | 2 S | = | 7 | 2 | 2 | 50 | 110 | 270 | ||
1 | 4 | S | 2 S | +1 | 1 | 8 | 3 | 50 | 140 | 470 | ||
4 | 2 | N | 2 S | +1 | 12 | 4 | 3 | 50 | 140 | 470 | ||
3 | 2 | N | 2 S | +1 | 3 | 11 | 3 | 50 | 140 | 470 | ||
spel =14 | ||||||||||||
tafel | ronde | NS/EW | NZ contract | OW contract | resultaat | NS | - | OW | # | bonus | punten | totaal |
5 | 6 | N | 1 S | = | 5 | 10 | 1 | 50 | 80 | 130 | ||
6 | 6 | S | 2 H | = | 9 | 6 | 2 | 50 | 110 | 270 | ||
2 | 4 | S | 2 H | +3 | 7 | 2 | 5 | 50 | 200 | 1050 | ||
1 | 4 | S | 2 H | +2 | 1 | 8 | 4 | 50 | 170 | 730 | ||
4 | 2 | S | 2 H | = | 12 | 4 | 2 | 50 | 110 | 270 | ||
3 | 2 | S | 2 H | +2 | 3 | 11 | 4 | 50 | 170 | 730 | ||
spel =15 | ||||||||||||
tafel | ronde | NS/EW | NZ contract | OW contract | resultaat | NS | - | OW | # | bonus | punten | totaal -100NZW4 S 2-100 |
6 | 6 | W | 4 S | -2 | 9 | 6 | -100 | 300 | -100 | -100 -100NZW4 S 2-100 | ||
5 | 6 | W | 4 S | -2 | 5 | 10 | -100 | 300 | -100 | -100 -100NZW4 S 2-100 | ||
1 | 4 | W | 4 S | -2 | 1 | 8 | -100 | 300 | -100 | -100 -50NZW3 S 2-50 | ||
2 | 4 | W | 3 S | -1 | 7 | 2 | -50 | 50 | -50 | -50 -100NZW4 S 2-100 | ||
3 | 2 | W | 4 S | -2 | 3 | 11 | -100 | 300 | -100 | -100 -100NZW4 S 2-100 | ||
4 | 2 | W | 4 S | -2 | 12 | 4 | -100 | 300 | -100 | -100 | ||
spel =16 | ||||||||||||
tafel | ronde | NS/EW | NZ contract | OW contract | resultaat | NS | - | OW | # | bonus | punten | totaal |
6 | 6 | W | 3 NT | +1 | 9 | 6 | 4 | 510 | 630 | 3030 | ||
5 | 6 | W | 3 NT | +2 | 5 | 10 | 5 | 510 | 660 | 3810 | ||
1 | 4 | E | 3 NT | +2 | 1 | 8 | 5 | 510 | 660 | 3810 | ||
2 | 4 | W | 3 NT | +2 | 7 | 2 | 5 | 510 | 660 | 3810 | ||
3 | 2 | E | 3 NT | = | 3 | 11 | 3 | 510 | 600 | 2310 | ||
4 | 2 | E | 4 NT | +1 | 12 | 4 | 5 | 510 | 660 | 3810 | ||
spel =17 | ||||||||||||
tafel | ronde | NS/EW | NZ contract | OW contract | resultaat | NS | - | OW | # | bonus | punten | totaal |
2 | 5 | N | 3 NT | +1 | 9 | 2 | 4 | 310 | 430 | 2030 | ||
1 | 5 | W | 1 S | = | 1 | 10 | 1 | 50 | 80 | 130 | ||
4 | 3 | N | 3 C | -1 | 8 | 4 | -50 | 50 | -50 | -50 | ||
3 | 3 | N | 1 NT | +1 | 3 | 7 | 2 | 60 | 120 | 300 | ||
5 | 1 | N | 2 NT | +1 | 5 | 11 | 3 | 60 | 150 | 510 | ||
6 | 1 | S | 1 NT | -2 | 12 | 6 | -100 | 60 | -100 | -100 | ||
spel =18 | ||||||||||||
tafel | ronde | NS/EW | NZ contract | OW contract | resultaat | NS | - | OW | # | bonus | punten | totaal |
2 | 5 | E | 4 S | -1 | 9 | 2 | -50 | 300 | -50 | -50 | ||
1 | 5 | E | 4 S | = | 1 | 10 | 4 | 300 | 420 | 1980 | ||
4 | 3 | E | 4 S | = | 8 | 4 | 4 | 300 | 420 | 1980 | ||
3 | 3 | E | 3 NT | -1 | 3 | 7 | -50 | 310 | -50 | -50 | ||
5 | 1 | E | 4 S | +1 | 5 | 11 | 5 | 300 | 450 | 2550 | ||
6 | 1 | E | 4 S | +1 | 12 | 6 | 5 | 300 | 450 | 2550 | ||
spel =19 | ||||||||||||
tafel | ronde | NS/EW | NZ contract | OW contract | resultaat | NS | - | OW | # | bonus | punten | totaal |
1 | 5 | W | 3 NT | = | 1 | 10 | 3 | 510 | 600 | 2310 | ||
2 | 5 | E | 2 NT | +1 | 9 | 2 | 3 | 60 | 150 | 510 | ||
3 | 3 | E | 2 NT | +1 | 3 | 7 | 3 | 60 | 150 | 510 | ||
4 | 3 | E | 3 NT | +1 | 8 | 4 | 4 | 510 | 630 | 3030 | ||
6 | 1 | E | 3 NT | +1 | 12 | 6 | 4 | 510 | 630 | 3030 | ||
5 | 1 | W | 1 NT | +4 | 5 | 11 | 5 | 60 | 210 | 1110 | ||
spel =20 | ||||||||||||
tafel | ronde | NS/EW | NZ contract | OW contract | resultaat | NS | - | OW | # | bonus | punten | totaal |
1 | 5 | S | 5 S | -2 | 1 | 10 | -200 | 500 | -200 | -200 | ||
2 | 5 | S | 3 S | = | 9 | 2 | 3 | 50 | 140 | 470 | ||
3 | 3 | N | 3 NT | = | 3 | 7 | 3 | 510 | 600 | 2310 | ||
4 | 3 | S | 4 H | -1 | 8 | 4 | -100 | 500 | -100 | -100 | ||
6 | 1 | S | 4 S | -1 | 12 | 6 | -100 | 500 | -100 | -100 GEDOUBLEERD -RESULTAAT=2AAMTAL=-500 | ||
5 | 1 | W | 4 C x | -2 | 5 | 11 | -500 | 50 | -500 | -500 | ||
spel =21 | ||||||||||||
tafel | ronde | NS/EW | NZ contract | OW contract | resultaat | NS | - | OW | # | bonus | punten | totaal |
1 | 6 | S | 3 H | = | 1 | 12 | 3 | 50 | 140 | 470 | ||
2 | 6 | N | 3 NT | +2 | 11 | 2 | 5 | 510 | 660 | 3810 | ||
4 | 4 | S | 4 H | -1 | 9 | 4 | -100 | 500 | -100 | -100 | ||
3 | 4 | N | 3 NT | -4 | 3 | 10 | -400 | 510 | -400 | -400 | ||
6 | 2 | S | 3 H | -2 | 8 | 6 | -200 | 50 | -200 | -200 | ||
5 | 2 | S | 4 H | -2 | 5 | 7 | -200 | 500 | -200 | -200 | ||
spel =22 | ||||||||||||
tafel | ronde | NS/EW | NZ contract | OW contract | resultaat | NS | - | OW | # | bonus | punten | totaal |
1 | 6 | W | 3 NT | = | 1 | 12 | 3 | 510 | 600 | 2310 | ||
2 | 6 | W | 3 NT | = | 11 | 2 | 3 | 510 | 600 | 2310 | ||
4 | 4 | E | 3 NT | = | 9 | 4 | 3 | 510 | 600 | 2310 | ||
3 | 4 | W | 3 NT | = | 3 | 10 | 3 | 510 | 600 | 2310 | ||
6 | 2 | W | 3 NT | = | 8 | 6 | 3 | 510 | 600 | 2310 | ||
5 | 2 | W | 3 NT | = | 5 | 7 | 3 | 510 | 600 | 2310 | ||
spel =23 | ||||||||||||
tafel | ronde | NS/EW | NZ contract | OW contract | resultaat | NS | - | OW | # | bonus | punten | totaal |
2 | 6 | N | 1 NT | +1 | 11 | 2 | 2 | 60 | 120 | 300 | ||
1 | 6 | N | 3 NT | +2 | 1 | 12 | 5 | 510 | 660 | 3810 | ||
3 | 4 | N | 3 NT | +3 | 3 | 10 | 6 | 510 | 690 | 4650 | ||
4 | 4 | N | 3 NT | +2 | 9 | 4 | 5 | 510 | 660 | 3810 | ||
5 | 2 | N | 3 NT | +3 | 5 | 7 | 6 | 510 | 690 | 4650 | ||
6 | 2 | N | 3 NT | +2 | 8 | 6 | 5 | 510 | 660 | 3810 | ||
spel =24 | ||||||||||||
tafel | ronde | NS/EW | NZ contract | OW contract | resultaat | NS | - | OW | # | bonus | punten | totaal |
2 | 6 | W | 2 H | +1 | 11 | 2 | 3 | 50 | 140 | 470 | ||
1 | 6 | E | 2 S | = | 1 | 12 | 2 | 50 | 110 | 270 GEDOUBLEERD -RESULTAAT=2AAMTAL=-300 | ||
3 | 4 | E | 3 S x | -2 | 3 | 10 | -300 | 50 | -300 | -300 | ||
4 | 4 | E | 3 S | -1 | 9 | 4 | -50 | 50 | -50 | -50 | ||
5 | 2 | E | 4 S | -2 | 5 | 7 | -100 | 300 | -100 | -100 | ||
6 | 2 | E | 3 S | -1 | 8 | 6 | -50 | 50 | -50 | -50 |