 | | |
| |
FALK-DEBUG:db_default:FALK
db_default:FALK
login:, bid:
Kein Cookie
db_default:FALK
Jetzt: 1371669520
Cache:
Anfangszeit: 1371669520.614
MP LOGGED_IN:
PHP_SELF::/Ergebnisse/Saison/1950 SCRIPT_URL:/Ergebnisse/Saison/1950
URL:Ergebnisse:6:
URL:Saison:1:
URL: http://f1.statistiker.org/Ergebnisse/Saison index: 2 selbst: Ergebnisse/Weltmeisterschaften Header: Ergebnisse/Weltmeisterschaften_h
Ergebnisse
select * from f1_Wetter_de
wm_entscheidung - Maxpunkte:540
select f1_Rennen, rDatum <= now() as vorbei from f1_Rennen where f1_Saison = 1950 order by f1_Rennen desc
select f1_Person.f1_Person, sum(punkte) as summe, (punkte)/60 as hr, sum(k = 1) as 1p, sum(k = 2) as 2p, sum(k = 3) as 3p, sum(k = 4) as 4p, sum(k = 5) as 5p, sum(k = 6) as 6p, sum(k = 7) as 7p, sum(k = 8) as 8p, sum(k = 9) as 9p, sum(k = 10) as 10p, sum(k = 11) as 11p, sum(k = 12) as 12p from f1_Rennergebnis left join f1_Rennen using(f1_Rennen) left join f1_Person on f1_Person.f1_Person = f1_Rennergebnis.f1_Person where f1_Saison =1950 and f1_Rennen.f1_Rennen <= 6 group by f1_Person.f1_Person order by summe desc, 1p desc, 2p desc, 3p desc, 4p desc, 5p desc, 6p desc, 7p desc, 8p desc, 9p desc, 10p desc, 11p desc, 12p desc limit 2
6: Zweiter: 33 -> 24 vs. Erster: 26
select f1_Person.f1_Person, sum(wmpunkte) as summe, (punkte)/60 as hr, sum(k = 1) as 1p, sum(k = 2) as 2p, sum(k = 3) as 3p, sum(k = 4) as 4p, sum(k = 5) as 5p, sum(k = 6) as 6p, sum(k = 7) as 7p, sum(k = 8) as 8p, sum(k = 9) as 9p, sum(k = 10) as 10p, sum(k = 11) as 11p, sum(k = 12) as 12p from f1_Rennergebnis left join f1_Rennen using(f1_Rennen) left join f1_Person on f1_Person.f1_Person = f1_Rennergebnis.f1_Person where f1_Saison =1950 group by f1_Person.f1_Person order by summe desc, 1p desc, 2p desc, 3p desc, 4p desc, 5p desc, 6p desc, 7p desc, 8p desc, 9p desc, 10p desc, 11p desc, 12p desc limit 1
update f1_InSaison set tmp_wmpos=1 where f1_Saison=1950 and wer=14
update f1_Person set tmp_wms=-1 where f1_Person=14
WM-Entscheidung:7
select min(f1_Rennen) from f1_Rennen where f1_Saison=1950
update f1_Saison set tmp_wm_entscheidung = 7 where f1_Saison=1950
update f1_Rennergebnis set tmp_wm_entscheidung = "" where f1_Rennen = 7 and f1_Person=14
select ausgang, parse_u is not null as pu, f1_Ort.f1_Ort, f1_Rennen.tmp_nrinsaison, f1_Rennen.f1_Rennen, f1_Rennen.ausgang, son_wetter, DATE_FORMAT(f1_Rennen.rDatum, "%Y-%m-%d") as datum, f1_Strecke.name as streckenname from f1_Rennen left join f1_Strecke using (f1_Strecke) left join f1_Ort using (f1_Ort) where f1_Saison = 1950 order by f1_Rennen.f1_Rennen
Kein passender Alias für "55" (Typ:o) gefunden!
Kein passender Alias für "7" (Typ:o) gefunden!
Kein passender Alias für "62" (Typ:o) gefunden!
Kein passender Alias für "56" (Typ:o) gefunden!
Kein passender Alias für "57" (Typ:o) gefunden!
Kein passender Alias für "59" (Typ:o) gefunden!
Kein passender Alias für "31" (Typ:o) gefunden!
select concat(vorname, " ", nachname) as n, sum(wmpunkte) as summe, sum(k = 1) as 1p, sum(k = 2) as 2p, sum(k = 3) as 3p, sum(k = 4) as 4p, sum(k = 5) as 5p, sum(k = 6) as 6p, sum(k = 7) as 7p, sum(k = 8) as 8p, sum(k = 9) as 9p, sum(k = 10) as 10p, sum(k = 11) as 11p, sum(k = 12) as 12p from f1_Rennergebnis left join f1_Rennen using(f1_Rennen) left join f1_Person on f1_Person.f1_Person = f1_Rennergebnis.f1_Person where f1_Saison =1950 group by f1_Person.f1_Person order by summe desc, 1p desc, 2p desc, 3p desc, 4p desc, 5p desc, 6p desc, 7p desc, 8p desc, 9p desc, 10p desc, 11p desc, 12p desc
wmtab: wmupdate:1
select count(*) from f1_InSaison where tmp_wmpos = 0 and f1_Saison=1950
select f1_Person, upper(f1_Rennen.gpid) as id, tmp_team, f1_Rennen.f1_Rennen, wmpunkte, punkte, k from f1_Rennergebnis left join f1_Rennen using (f1_Rennen) where f1_Saison = 1950 order by f1_Rennen.f1_Rennen, k desc
Kein passender Alias für "55" (Typ:o) gefunden!
Kein passender Alias für "7" (Typ:o) gefunden!
Kein passender Alias für "62" (Typ:o) gefunden!
Kein passender Alias für "56" (Typ:o) gefunden!
Kein passender Alias für "57" (Typ:o) gefunden!
Kein passender Alias für "59" (Typ:o) gefunden!
Kein passender Alias für "31" (Typ:o) gefunden!
select vorname, nachname, f1_Person.f1_Person, sum(wmpunkte) as summe, sum(k = 1) as 1p, sum(k = 2) as 2p, sum(k = 3) as 3p, sum(k = 4) as 4p, sum(k = 5) as 5p, sum(k = 6) as 6p, sum(k = 7) as 7p, sum(k = 8) as 8p, sum(k = 9) as 9p, sum(k = 10) as 10p, sum(k = 11) as 11p, sum(k = 12) as 12p, sum(k = 13) as 13p, sum(k = 14) as 14p, sum(k = 15) as 15p, sum(k = 16) as 16p, sum(k = 17) as 17p, sum(k = 18) as 18p, sum(k = 19) as 19p, sum(k = 20) as 20p from f1_Rennergebnis left join f1_Rennen using(f1_Rennen) left join f1_Person on f1_Person.f1_Person = f1_Rennergebnis.f1_Person where f1_Saison =1950 group by f1_Person.f1_Person order by summe desc, 1p desc, 2p desc, 3p desc, 4p desc, 5p desc, 6p desc, 7p desc, 8p desc, 9p desc, 10p desc, 11p desc, 12p desc, 13p desc, 14p desc, 15p desc, 16p desc, 17p desc, 18p desc, 19p desc, 20p desc
update f1_InSaison set tmp_wmpos = 1 where wer = 14 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 2 where wer = 13 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 3 where wer = 12 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 4 where wer = 37 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 5 where wer = 1 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 6 where wer = 564 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 7 where wer = 385 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 8 where wer = 3 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 9 where wer = 47 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 10 where wer = 7 and f1_Saison=1950
Kein passender Alias für "852" (Typ:p) gefunden!
update f1_InSaison set tmp_wmpos = 11 where wer = 852 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 12 where wer = 31 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 13 where wer = 40 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 14 where wer = 17 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 15 where wer = 42 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 16 where wer = 27 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 17 where wer = 344 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 18 where wer = 11 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 19 where wer = 4 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 20 where wer = 6 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 21 where wer = 221 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 22 where wer = 147 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 23 where wer = 19 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 24 where wer = 16 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 25 where wer = 45 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 26 where wer = 34 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 27 where wer = 754 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 28 where wer = 8 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 29 where wer = 297 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 30 where wer = 21 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 31 where wer = 30 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 32 where wer = 24 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 33 where wer = 39 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 34 where wer = 230 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 35 where wer = 20 and f1_Saison=1950
Kein passender Alias für "861" (Typ:p) gefunden!
update f1_InSaison set tmp_wmpos = 36 where wer = 861 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 37 where wer = 10 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 38 where wer = 5 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 39 where wer = 295 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 40 where wer = 15 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 41 where wer = 41 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 42 where wer = 299 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 43 where wer = 209 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 44 where wer = 359 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 45 where wer = 504 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 46 where wer = 640 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 47 where wer = 369 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 48 where wer = 249 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 49 where wer = 503 and f1_Saison=1950
Kein passender Alias für "183" (Typ:p) gefunden!
update f1_InSaison set tmp_wmpos = 50 where wer = 183 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 51 where wer = 759 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 52 where wer = 799 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 53 where wer = 22 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 54 where wer = 43 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 55 where wer = 766 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 56 where wer = 460 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 57 where wer = 321 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 58 where wer = 708 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 59 where wer = 819 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 60 where wer = 32 and f1_Saison=1950
Kein passender Alias für "633" (Typ:p) gefunden!
update f1_InSaison set tmp_wmpos = 61 where wer = 633 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 62 where wer = 366 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 63 where wer = 803 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 64 where wer = 23 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 65 where wer = 33 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 66 where wer = 839 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 67 where wer = 386 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 68 where wer = 817 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 69 where wer = 254 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 70 where wer = 9 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 71 where wer = 516 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 72 where wer = 845 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 73 where wer = 658 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 74 where wer = 302 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 75 where wer = 791 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 76 where wer = 26 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 77 where wer = 533 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 78 where wer = 751 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 79 where wer = 400 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 80 where wer = 315 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 81 where wer = 854 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 82 where wer = 87 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 83 where wer = 114 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 84 where wer = 607 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 85 where wer = 198 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 86 where wer = 18 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 87 where wer = 827 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 88 where wer = 122 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 89 where wer = 38 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 90 where wer = 401 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 91 where wer = 812 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 92 where wer = 423 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 93 where wer = 793 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 94 where wer = 89 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 95 where wer = 29 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 96 where wer = 808 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 97 where wer = 25 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 98 where wer = 44 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 99 where wer = 801 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 100 where wer = 389 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 101 where wer = 464 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 102 where wer = 28 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 103 where wer = 868 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 104 where wer = 46 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 105 where wer = 820 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 106 where wer = 606 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 107 where wer = 2 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 108 where wer = 36 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 109 where wer = 347 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 110 where wer = 305 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 111 where wer = 35 and f1_Saison=1950
Kein passender Alias für "55" (Typ:o) gefunden!
Kein passender Alias für "7" (Typ:o) gefunden!
Kein passender Alias für "62" (Typ:o) gefunden!
Kein passender Alias für "56" (Typ:o) gefunden!
Kein passender Alias für "57" (Typ:o) gefunden!
Kein passender Alias für "59" (Typ:o) gefunden!
Kein passender Alias für "31" (Typ:o) gefunden!
select f1_Firma.kurzname, tmp_team, sum(punkte) as summe, sum(k = 1) as 1p, sum(k = 2) as 2p, sum(k = 3) as 3p, sum(k = 4) as 4p, sum(k = 5) as 5p, sum(k = 6) as 6p, sum(k = 7) as 7p, sum(k = 8) as 8p, sum(k = 9) as 9p, sum(k = 10) as 10p, sum(k = 11) as 11p, sum(k = 12) as 12p, sum(k = 13) as 13p, sum(k = 14) as 14p, sum(k = 15) as 15p, sum(k = 16) as 16p, sum(k = 17) as 17p, sum(k = 18) as 18p, sum(k = 19) as 19p, sum(k = 20) as 20p from f1_Rennergebnis left join f1_Rennen using(f1_Rennen) left join f1_Firma on f1_Firma.f1_Firma = tmp_team where f1_Saison =1950 group by tmp_team order by summe desc, 1p desc, 2p desc, 3p desc, 4p desc, 5p desc, 6p desc, 7p desc, 8p desc, 9p desc, 10p desc, 11p desc, 12p desc, 13p desc, 14p desc, 15p desc, 16p desc, 17p desc, 18p desc, 19p desc, 20p desc
update f1_InSaison set tmp_wmpos = 1 where wer = -130 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 2 where wer = -246 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 3 where wer = -306 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 4 where wer = -88 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 5 where wer = -11 and f1_Saison=1950
Kein passender Alias für "-304" (Typ:f) gefunden!
update f1_InSaison set tmp_wmpos = 6 where wer = -304 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 7 where wer = -305 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 8 where wer = -310 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 9 where wer = -302 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 10 where wer = -60 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 11 where wer = -113 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 12 where wer = -274 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 13 where wer = -241 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 14 where wer = -40 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 15 where wer = -311 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 16 where wer = -314 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 17 where wer = -269 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 18 where wer = -153 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 19 where wer = -77 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 20 where wer = -287 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 21 where wer = -312 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 22 where wer = -309 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 23 where wer = -162 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 24 where wer = -209 and f1_Saison=1950
Kein passender Alias für "-16" (Typ:f) gefunden!
update f1_InSaison set tmp_wmpos = 25 where wer = -16 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 26 where wer = -131 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 27 where wer = -262 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 28 where wer = -173 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 29 where wer = -101 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 30 where wer = -66 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 31 where wer = -45 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 32 where wer = -91 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 33 where wer = -20 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 34 where wer = -117 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 35 where wer = -81 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 36 where wer = -47 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 37 where wer = -105 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 38 where wer = -24 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 39 where wer = -71 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 40 where wer = -53 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 41 where wer = -307 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 42 where wer = -28 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 43 where wer = -315 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 44 where wer = -303 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 45 where wer = -94 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 46 where wer = -308 and f1_Saison=1950
Kein passender Alias für "-5" (Typ:f) gefunden!
update f1_InSaison set tmp_wmpos = 47 where wer = -5 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 48 where wer = -107 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 49 where wer = -82 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 50 where wer = -50 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 51 where wer = -316 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 52 where wer = -301 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 53 where wer = -32 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 54 where wer = -1 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 55 where wer = -119 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 56 where wer = -159 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 57 where wer = -69 and f1_Saison=1950
update f1_InSaison set tmp_wmpos = 58 where wer = -313 and f1_Saison=1950