z10025 - viertal-4.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=4
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 |
3 | 5 | W | 2 C | +2 | 3 | 12 | 4 | 50 | 130 | 570 | ||
4 | 5 | W | 2 C | +2 | 11 | 4 | 4 | 50 | 130 | 570 | ||
6 | 3 | E | 1 NT | +2 | 10 | 6 | 3 | 60 | 150 | 510 | ||
5 | 3 | W | 2 C | +2 | 5 | 9 | 4 | 50 | 130 | 570 | ||
2 | 1 | E | 3 NT | = | 8 | 2 | 3 | 310 | 400 | 1510 | ||
1 | 1 | S | 4 S | -1 | 1 | 7 | -50 | 300 | -50 | -50 | ||
spel =2 | ||||||||||||
tafel | ronde | NS/EW | NZ contract | OW contract | resultaat | NS | - | OW | # | bonus | punten | totaal |
3 | 5 | W | 3 NT | -2 | 3 | 12 | -100 | 310 | -100 | -100 | ||
4 | 5 | W | 3 NT | -2 | 11 | 4 | -100 | 310 | -100 | -100 | ||
6 | 3 | W | 3 NT | -2 | 10 | 6 | -100 | 310 | -100 | -100 | ||
5 | 3 | W | 3 NT | -2 | 5 | 9 | -100 | 310 | -100 | -100 | ||
2 | 1 | E | 3 NT | -2 | 8 | 2 | -100 | 310 | -100 | -100 | ||
1 | 1 | N | 3 S | +2 | 1 | 7 | 5 | 50 | 200 | 1050 | ||
spel =3 | ||||||||||||
tafel | ronde | NS/EW | NZ contract | OW contract | resultaat | NS | - | OW | # | bonus | punten | totaal |
4 | 5 | S | 4 S | -1 | 11 | 4 | -50 | 300 | -50 | -50 | ||
3 | 5 | S | 4 S | = | 3 | 12 | 4 | 300 | 420 | 1980 | ||
5 | 3 | S | 4 S | = | 5 | 9 | 4 | 300 | 420 | 1980 | ||
6 | 3 | S | 4 S | = | 10 | 6 | 4 | 300 | 420 | 1980 | ||
2 | 1 | S | 4 S | = | 8 | 2 | 4 | 300 | 420 | 1980 | ||
1 | 1 | E | 3 H | +1 | 1 | 7 | 4 | 50 | 170 | 730 | ||
spel =4 | ||||||||||||
tafel | ronde | NS/EW | NZ contract | OW contract | resultaat | NS | - | OW | # | bonus | punten | totaal |
4 | 5 | N | 3 D | = | 11 | 4 | 3 | 50 | 110 | 380 | ||
3 | 5 | N | 1 NT | = | 3 | 12 | 1 | 60 | 90 | 150 | ||
5 | 3 | N | 1 NT | +1 | 5 | 9 | 2 | 60 | 120 | 300 | ||
6 | 3 | S | 2 S | +2 | 10 | 6 | 4 | 50 | 170 | 730 | ||
2 | 1 | S | 2 S | +2 | 8 | 2 | 4 | 50 | 170 | 730 | ||
1 | 1 | W | 3 NT | +1 | 1 | 7 | 4 | 510 | 630 | 3030 | ||
spel =5 | ||||||||||||
tafel | ronde | NS/EW | NZ contract | OW contract | resultaat | NS | - | OW | # | bonus | punten | totaal |
3 | 6 | N | 4 S | +1 | 3 | 8 | 5 | 500 | 650 | 3750 | ||
4 | 6 | N | 4 S | +1 | 7 | 4 | 5 | 500 | 650 | 3750 | ||
6 | 4 | N | 4 S | = | 11 | 6 | 4 | 500 | 620 | 2980 | ||
5 | 4 | N | 4 S | +1 | 5 | 12 | 5 | 500 | 650 | 3750 | ||
1 | 2 | N | 4 S | = | 1 | 9 | 4 | 500 | 620 | 2980 | ||
2 | 2 | N | 4 S | +1 | 10 | 2 | 5 | 500 | 650 | 3750 | ||
spel =6 | ||||||||||||
tafel | ronde | NS/EW | NZ contract | OW contract | resultaat | NS | - | OW | # | bonus | punten | totaal |
3 | 6 | S | 4 H | +2 | 3 | 8 | 6 | 300 | 480 | 3180 | ||
4 | 6 | N | 4 H | +2 | 7 | 4 | 6 | 300 | 480 | 3180 | ||
6 | 4 | S | 6 H | = | 11 | 6 | 6 | 1000 | 1180 | 8080 | ||
5 | 4 | S | 4 H | +2 | 5 | 12 | 6 | 300 | 480 | 3180 | ||
1 | 2 | N | 4 H | +3 | 1 | 9 | 7 | 300 | 510 | 3870 | ||
2 | 2 | S | 4 H | +2 | 10 | 2 | 6 | 300 | 480 | 3180 | ||
spel =7 | ||||||||||||
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 | N | 2 H | +2 | 3 | 8 | 4 | 50 | 170 | 730 | ||
5 | 4 | S | 2 H | +2 | 5 | 12 | 4 | 50 | 170 | 730 | ||
6 | 4 | N | 2 H | +2 | 11 | 6 | 4 | 50 | 170 | 730 | ||
2 | 2 | N | 3 H | +1 | 10 | 2 | 4 | 50 | 170 | 730 | ||
1 | 2 | N | 2 H | +1 | 1 | 9 | 3 | 50 | 140 | 470 | ||
spel =8 | ||||||||||||
tafel | ronde | NS/EW | NZ contract | OW contract | resultaat | NS | - | OW | # | bonus | punten | totaal |
4 | 6 | S | 1 NT | +3 | 7 | 4 | 4 | 60 | 180 | 780 | ||
3 | 6 | S | 1 NT | +3 | 3 | 8 | 4 | 60 | 180 | 780 | ||
5 | 4 | N | 3 D | +1 | 5 | 12 | 4 | 50 | 130 | 570 | ||
6 | 4 | N | 3 D | +1 | 11 | 6 | 4 | 50 | 130 | 570 | ||
2 | 2 | N | 1 NT | +3 | 10 | 2 | 4 | 60 | 180 | 780 | ||
1 | 2 | S | 3 NT | +2 | 1 | 9 | 5 | 310 | 460 | 2610 | ||
spel =9 | ||||||||||||
tafel | ronde | NS/EW | NZ contract | OW contract | resultaat | NS | - | OW | # | bonus | punten | totaal |
6 | 5 | E | 1 NT | -1 | 7 | 6 | -100 | 60 | -100 | -100 | ||
5 | 5 | W | 1 C | = | 5 | 8 | 1 | 50 | 70 | 120 | ||
2 | 3 | S | 2 S | = | 12 | 2 | 2 | 50 | 110 | 270 | ||
1 | 3 | E | 1 NT | = | 1 | 11 | 1 | 60 | 90 | 150 | ||
4 | 1 | N | 2 S | -1 | 10 | 4 | -50 | 50 | -50 | -50 | ||
3 | 1 | E | 1 NT | -1 | 3 | 9 | -100 | 60 | -100 | -100 | ||
spel =10 | ||||||||||||
tafel | ronde | NS/EW | NZ contract | OW contract | resultaat | NS | - | OW | # | bonus | punten | totaal |
6 | 5 | N | 1 NT | = | 7 | 6 | 1 | 60 | 90 | 150 | ||
5 | 5 | S | 1 NT | -2 | 5 | 8 | -200 | 60 | -200 | -200 | ||
2 | 3 | S | 1 NT | -3 | 12 | 2 | -300 | 60 | -300 | -300 | ||
1 | 3 | S | 1 NT | -1 | 1 | 11 | -100 | 60 | -100 | -100 | ||
4 | 1 | S | 1 NT | -1 | 10 | 4 | -100 | 60 | -100 | -100 | ||
3 | 1 | S | 1 D | = | 3 | 9 | 1 | 50 | 70 | 120 | ||
spel =11 | ||||||||||||
tafel | ronde | NS/EW | NZ contract | OW contract | resultaat | NS | - | OW | # | bonus | punten | totaal |
5 | 5 | W | 2 H | = | 5 | 8 | 2 | 50 | 110 | 270 | ||
6 | 5 | W | 3 H | -1 | 7 | 6 | -50 | 50 | -50 | -50 | ||
1 | 3 | S | 3 S | -2 | 1 | 11 | -100 | 50 | -100 | -100 | ||
2 | 3 | W | 3 H | = | 12 | 2 | 3 | 50 | 140 | 470 | ||
3 | 1 | W | 2 H | = | 3 | 9 | 2 | 50 | 110 | 270 | ||
4 | 1 | W | 2 H | +1 | 10 | 4 | 3 | 50 | 140 | 470 | ||
spel =12 | ||||||||||||
tafel | ronde | NS/EW | NZ contract | OW contract | resultaat | NS | - | OW | # | bonus | punten | totaal |
5 | 5 | S | 2 H | = | 5 | 8 | 2 | 50 | 110 | 270 | ||
6 | 5 | S | 2 H | -1 | 7 | 6 | -100 | 50 | -100 | -100 | ||
1 | 3 | W | 3 C | -1 | 1 | 11 | -50 | 50 | -50 | -50 | ||
2 | 3 | W | 3 C | -1 | 12 | 2 | -50 | 50 | -50 | -50 | ||
3 | 1 | W | 3 C | -1 | 3 | 9 | -50 | 50 | -50 | -50 | ||
4 | 1 | S | 3 H | -3 | 10 | 4 | -300 | 50 | -300 | -300 | ||
spel =13 | ||||||||||||
tafel | ronde | NS/EW | NZ contract | OW contract | resultaat | NS | - | OW | # | bonus | punten | totaal |
6 | 6 | S | 4 S | +2 | 9 | 6 | 6 | 500 | 680 | 4580 | ||
5 | 6 | S | 4 S | = | 5 | 10 | 4 | 500 | 620 | 2980 | ||
1 | 4 | S | 4 S | = | 1 | 8 | 4 | 500 | 620 | 2980 GEDOUBLEERD -RESULTAAT=1AAMTAL=-200 | ||
2 | 4 | S | 6 S x | -1 | 7 | 2 | -200 | 1000 | -200 | -200 | ||
4 | 2 | S | 6 S | -2 | 12 | 4 | -200 | 1000 | -200 | -200 | ||
3 | 2 | S | 4 S | = | 3 | 11 | 4 | 500 | 620 | 2980 | ||
spel =14 | ||||||||||||
tafel | ronde | NS/EW | NZ contract | OW contract | resultaat | NS | - | OW | # | bonus | punten | totaal |
6 | 6 | S | 2 NT | -1 | 9 | 6 | -50 | 60 | -50 | -50 | ||
5 | 6 | S | 3 NT | +1 | 5 | 10 | 4 | 310 | 430 | 2030 | ||
1 | 4 | S | 3 NT | -3 | 1 | 8 | -150 | 310 | -150 | -150 | ||
2 | 4 | S | 3 NT | = | 7 | 2 | 3 | 310 | 400 | 1510 | ||
4 | 2 | S | 3 NT | -2 | 12 | 4 | -100 | 310 | -100 | -100 | ||
3 | 2 | S | 2 NT | -1 | 3 | 11 | -50 | 60 | -50 | -50 | ||
spel =15 | ||||||||||||
tafel | ronde | NS/EW | NZ contract | OW contract | resultaat | NS | - | OW | # | bonus | punten | totaal |
5 | 6 | N | 1 NT | +2 | 5 | 10 | 3 | 60 | 150 | 510 | ||
6 | 6 | N | 1 NT | = | 9 | 6 | 1 | 60 | 90 | 150 | ||
2 | 4 | N | 1 NT | = | 7 | 2 | 1 | 60 | 90 | 150 | ||
1 | 4 | N | 1 NT | +1 | 1 | 8 | 2 | 60 | 120 | 300 | ||
3 | 2 | N | 1 NT | +1 | 3 | 11 | 2 | 60 | 120 | 300 | ||
4 | 2 | N | 1 NT | +1 | 12 | 4 | 2 | 60 | 120 | 300 | ||
spel =16 | ||||||||||||
tafel | ronde | NS/EW | NZ contract | OW contract | resultaat | NS | - | OW | # | bonus | punten | totaal |
5 | 6 | S | 3 NT | +1 | 5 | 10 | 4 | 310 | 430 | 2030 | ||
6 | 6 | S | 4 S | = | 9 | 6 | 4 | 300 | 420 | 1980 | ||
2 | 4 | S | 3 NT | -2 | 7 | 2 | -100 | 310 | -100 | -100 | ||
1 | 4 | S | 3 NT | = | 1 | 8 | 3 | 310 | 400 | 1510 | ||
3 | 2 | S | 3 NT | +1 | 3 | 11 | 4 | 310 | 430 | 2030 | ||
4 | 2 | S | 3 NT | -2 | 12 | 4 | -100 | 310 | -100 | -100 | ||
spel =17 | ||||||||||||
tafel | ronde | NS/EW | NZ contract | OW contract | resultaat | NS | - | OW | # | bonus | punten | totaal |
1 | 5 | N | 2 S | = | 1 | 10 | 2 | 50 | 110 | 270 | ||
2 | 5 | N | 2 S | -1 | 9 | 2 | -50 | 50 | -50 | -50 | ||
4 | 3 | E | 2 D | +2 | 8 | 4 | 4 | 50 | 130 | 570 | ||
3 | 3 | E | 2 D | +2 | 3 | 7 | 4 | 50 | 130 | 570 | ||
6 | 1 | E | 2 D | +3 | 12 | 6 | 5 | 50 | 150 | 800 | ||
5 | 1 | E | 3 H | -1 | 5 | 11 | -50 | 50 | -50 | -50 | ||
spel =18 | ||||||||||||
tafel | ronde | NS/EW | NZ contract | OW contract | resultaat | NS | - | OW | # | bonus | punten | totaal |
1 | 5 | S | 4 H | +2 | 1 | 10 | 6 | 500 | 680 | 4580 | ||
2 | 5 | S | 4 H | +1 | 9 | 2 | 5 | 500 | 650 | 3750 | ||
4 | 3 | S | 4 H | +2 | 8 | 4 | 6 | 500 | 680 | 4580 | ||
3 | 3 | S | 4 H | +2 | 3 | 7 | 6 | 500 | 680 | 4580 | ||
6 | 1 | S | 4 H | +1 | 12 | 6 | 5 | 500 | 650 | 3750 | ||
5 | 1 | S | 4 H | +2 | 5 | 11 | 6 | 500 | 680 | 4580 | ||
spel =19 | ||||||||||||
tafel | ronde | NS/EW | NZ contract | OW contract | resultaat | NS | - | OW | # | bonus | punten | totaal |
2 | 5 | W | 2 S | = | 9 | 2 | 2 | 50 | 110 | 270 | ||
1 | 5 | W | 2 S | -2 | 1 | 10 | -200 | 50 | -200 | -200 | ||
3 | 3 | E | 2 NT | -1 | 3 | 7 | -100 | 60 | -100 | -100 | ||
4 | 3 | N | 2 D | +1 | 8 | 4 | 3 | 50 | 110 | 380 | ||
5 | 1 | E | 2 NT | -3 | 5 | 11 | -300 | 60 | -300 | -300 | ||
6 | 1 | E | 2 NT | -1 | 12 | 6 | -100 | 60 | -100 | -100 | ||
spel =20 | ||||||||||||
tafel | ronde | NS/EW | NZ contract | OW contract | resultaat | NS | - | OW | # | bonus | punten | totaal |
2 | 5 | W | 2 S | -1 | 9 | 2 | -100 | 50 | -100 | -100 | ||
1 | 5 | W | 2 S | = | 1 | 10 | 2 | 50 | 110 | 270 | ||
3 | 3 | W | 2 S | +1 | 3 | 7 | 3 | 50 | 140 | 470 | ||
4 | 3 | W | 2 S | -1 | 8 | 4 | -100 | 50 | -100 | -100 | ||
5 | 1 | W | 2 S | -1 | 5 | 11 | -100 | 50 | -100 | -100 | ||
5 | 1 | W | 2 S | -1 | 5 | 11 | -100 | 50 | -100 | -100 | ||
6 | 1 | W | 2 S | = | 12 | 6 | 2 | 50 | 110 | 270 | ||
spel =21 | ||||||||||||
tafel | ronde | NS/EW | NZ contract | OW contract | resultaat | NS | - | OW | # | bonus | punten | totaal |
1 | 6 | N | 2 D | = | 1 | 12 | 2 | 50 | 90 | 230 | ||
2 | 6 | N | 3 S | +1 | 11 | 2 | 4 | 50 | 170 | 730 | ||
3 | 4 | E | 4 H | -2 | 3 | 10 | -100 | 300 | -100 | -100 | ||
4 | 4 | E | 4 H | +1 | 9 | 4 | 5 | 300 | 450 | 2550 | ||
6 | 2 | E | 4 H | +1 | 8 | 6 | 5 | 300 | 450 | 2550 | ||
5 | 2 | E | 4 H | +1 | 5 | 7 | 5 | 300 | 450 | 2550 | ||
spel =22 | ||||||||||||
tafel | ronde | NS/EW | NZ contract | OW contract | resultaat | NS | - | OW | # | bonus | punten | totaal |
1 | 6 | E | 2 S | -2 | 1 | 12 | -200 | 50 | -200 | -200 | ||
2 | 6 | E | 2 S | -2 | 11 | 2 | -200 | 50 | -200 | -200 | ||
3 | 4 | E | 2 S | -2 | 3 | 10 | -200 | 50 | -200 | -200 | ||
4 | 4 | W | 2 NT | -4 | 9 | 4 | -400 | 60 | -400 | -400 | ||
6 | 2 | S | 3 NT | -1 | 8 | 6 | -50 | 310 | -50 | -50 | ||
5 | 2 | E | 2 S | -2 | 5 | 7 | -200 | 50 | -200 | -200 | ||
spel =23 | ||||||||||||
tafel | ronde | NS/EW | NZ contract | OW contract | resultaat | NS | - | OW | # | bonus | punten | totaal |
2 | 6 | N | 3 S | +1 | 11 | 2 | 4 | 50 | 170 | 730 | ||
1 | 6 | N | 3 S | = | 1 | 12 | 3 | 50 | 140 | 470 | ||
4 | 4 | N | 4 S | -1 | 9 | 4 | -100 | 500 | -100 | -100 | ||
3 | 4 | N | 4 S | = | 3 | 10 | 4 | 500 | 620 | 2980 | ||
5 | 2 | N | 4 S | -1 | 5 | 7 | -100 | 500 | -100 | -100 | ||
6 | 2 | N | 4 S | -1 | 8 | 6 | -100 | 500 | -100 | -100 | ||
spel =24 | ||||||||||||
tafel | ronde | NS/EW | NZ contract | OW contract | resultaat | NS | - | OW | # | bonus | punten | totaal |
2 | 6 | N | 2 S | -2 | 11 | 2 | -100 | 50 | -100 | -100 | ||
1 | 6 | E | 3 NT | = | 1 | 12 | 3 | 310 | 400 | 1510 | ||
4 | 4 | E | 3 NT | +1 | 9 | 4 | 4 | 310 | 430 | 2030 | ||
3 | 4 | E | 3 NT | -3 | 3 | 10 | -150 | 310 | -150 | -150 | ||
5 | 2 | E | 3 NT | +1 | 5 | 7 | 4 | 310 | 430 | 2030 | ||
6 | 2 | E | 3 NT | +1 | 8 | 6 | 4 | 310 | 430 | 2030 |