db_default:FALK
db_switch: prog: f1stat, type=m, sub:"", ro: 0
prog="f1stat": Connect to MySQL Database on /clx/sys/fifo/mysql.sock...
db_default:FALK
login:, bid:
No Cookie
db_default:FALK
Jetzt: 1550473991
Cache:
Anfangszeit: 1550473991.8934
MP LOGGED_IN:
PHP_SELF::/rezultaty/sezon/1962 SCRIPT_URL:/rezultaty/sezon/1962
URL:rezultaty:6:
URL:sezon:1:
### URL: //rezultaty/sezon index: 2 Skript: "Ergebnisse/Weltmeisterschaften.php" Header: "Ergebnisse/Weltmeisterschaften_h.php"
результаты
select * from f1_Wetter_ru; -- 0.175 msselect 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 = 1962 order by f1_Rennen.f1_Rennen; -- 0.339 ms
Kein passender Alias für "64" (Typ:o) gefunden!
Kein passender Alias für "7" (Typ:o) gefunden!
Kein passender Alias für "57" (Typ:o) gefunden!
Kein passender Alias für "10" (Typ:o) gefunden!
Kein passender Alias für "66" (Typ:o) gefunden!
Kein passender Alias für "31" (Typ:o) gefunden!
Kein passender Alias für "73" (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 =1962 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; -- 1.641 ms
Kein passender Alias für "74" (Typ:o) gefunden!
wmtab: wmupdate:1
select count(*) from f1_InSaison where tmp_wmpos = 0 and f1_Saison=1962; -- 0.382 msselect 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 = 1962 order by f1_Rennen.f1_Rennen, k desc; -- 0.699 ms
Kein passender Alias für "64" (Typ:o) gefunden!
Kein passender Alias für "7" (Typ:o) gefunden!
Kein passender Alias für "57" (Typ:o) gefunden!
Kein passender Alias für "10" (Typ:o) gefunden!
Kein passender Alias für "66" (Typ:o) gefunden!
Kein passender Alias für "31" (Typ:o) gefunden!
Kein passender Alias für "73" (Typ:o) gefunden!
Kein passender Alias für "74" (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 =1962 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; -- 1.897 msupdate f1_InSaison set tmp_wmpos = 1 where wer = 379 and f1_Saison=1962; -- 0.236 msupdate f1_InSaison set tmp_wmpos = 2 where wer = 223 and f1_Saison=1962; -- 0.201 msupdate f1_InSaison set tmp_wmpos = 3 where wer = 506 and f1_Saison=1962; -- 0.179 msupdate f1_InSaison set tmp_wmpos = 4 where wer = 702 and f1_Saison=1962; -- 0.161 msupdate f1_InSaison set tmp_wmpos = 5 where wer = 356 and f1_Saison=1962; -- 0.187 msupdate f1_InSaison set tmp_wmpos = 6 where wer = 381 and f1_Saison=1962; -- 0.166 msupdate f1_InSaison set tmp_wmpos = 7 where wer = 482 and f1_Saison=1962; -- 0.100 msupdate f1_InSaison set tmp_wmpos = 8 where wer = 338 and f1_Saison=1962; -- 0.168 msupdate f1_InSaison set tmp_wmpos = 9 where wer = 168 and f1_Saison=1962; -- 0.170 msupdate f1_InSaison set tmp_wmpos = 10 where wer = 715 and f1_Saison=1962; -- 0.194 msupdate f1_InSaison set tmp_wmpos = 11 where wer = 116 and f1_Saison=1962; -- 0.193 msupdate f1_InSaison set tmp_wmpos = 12 where wer = 121 and f1_Saison=1962; -- 0.186 msupdate f1_InSaison set tmp_wmpos = 13 where wer = 627 and f1_Saison=1962; -- 0.077 msupdate f1_InSaison set tmp_wmpos = 14 where wer = 486 and f1_Saison=1962; -- 0.121 msupdate f1_InSaison set tmp_wmpos = 15 where wer = 160 and f1_Saison=1962; -- 0.184 msupdate f1_InSaison set tmp_wmpos = 16 where wer = 397 and f1_Saison=1962; -- 0.188 msupdate f1_InSaison set tmp_wmpos = 17 where wer = 132 and f1_Saison=1962; -- 0.190 msupdate f1_InSaison set tmp_wmpos = 18 where wer = 346 and f1_Saison=1962; -- 0.161 msupdate f1_InSaison set tmp_wmpos = 19 where wer = 452 and f1_Saison=1962; -- 0.075 msupdate f1_InSaison set tmp_wmpos = 20 where wer = 44 and f1_Saison=1962; -- 0.183 msupdate f1_InSaison set tmp_wmpos = 21 where wer = 461 and f1_Saison=1962; -- 0.086 msupdate f1_InSaison set tmp_wmpos = 22 where wer = 471 and f1_Saison=1962; -- 0.157 msupdate f1_InSaison set tmp_wmpos = 23 where wer = 744 and f1_Saison=1962; -- 0.084 msupdate f1_InSaison set tmp_wmpos = 24 where wer = 149 and f1_Saison=1962; -- 0.190 msupdate f1_InSaison set tmp_wmpos = 25 where wer = 567 and f1_Saison=1962; -- 0.076 msupdate f1_InSaison set tmp_wmpos = 26 where wer = 408 and f1_Saison=1962; -- 0.079 msupdate f1_InSaison set tmp_wmpos = 27 where wer = 680 and f1_Saison=1962; -- 0.147 msupdate f1_InSaison set tmp_wmpos = 28 where wer = 663 and f1_Saison=1962; -- 0.426 msupdate f1_InSaison set tmp_wmpos = 29 where wer = 577 and f1_Saison=1962; -- 0.084 msupdate f1_InSaison set tmp_wmpos = 30 where wer = 192 and f1_Saison=1962; -- 0.089 msupdate f1_InSaison set tmp_wmpos = 31 where wer = 676 and f1_Saison=1962; -- 0.096 msupdate f1_InSaison set tmp_wmpos = 32 where wer = 675 and f1_Saison=1962; -- 0.120 msupdate f1_InSaison set tmp_wmpos = 33 where wer = 197 and f1_Saison=1962; -- 0.102 msupdate f1_InSaison set tmp_wmpos = 34 where wer = 755 and f1_Saison=1962; -- 0.095 msupdate f1_InSaison set tmp_wmpos = 35 where wer = 203 and f1_Saison=1962; -- 0.092 msupdate f1_InSaison set tmp_wmpos = 36 where wer = 668 and f1_Saison=1962; -- 0.184 msupdate f1_InSaison set tmp_wmpos = 37 where wer = 276 and f1_Saison=1962; -- 0.093 msupdate f1_InSaison set tmp_wmpos = 38 where wer = 364 and f1_Saison=1962; -- 0.078 msupdate f1_InSaison set tmp_wmpos = 39 where wer = 673 and f1_Saison=1962; -- 0.104 msupdate f1_InSaison set tmp_wmpos = 40 where wer = 111 and f1_Saison=1962; -- 0.100 msupdate f1_InSaison set tmp_wmpos = 41 where wer = 657 and f1_Saison=1962; -- 0.093 msupdate f1_InSaison set tmp_wmpos = 42 where wer = 368 and f1_Saison=1962; -- 0.078 msupdate f1_InSaison set tmp_wmpos = 43 where wer = 679 and f1_Saison=1962; -- 0.091 msupdate f1_InSaison set tmp_wmpos = 44 where wer = 595 and f1_Saison=1962; -- 0.087 msupdate f1_InSaison set tmp_wmpos = 45 where wer = 226 and f1_Saison=1962; -- 0.092 msupdate f1_InSaison set tmp_wmpos = 46 where wer = 589 and f1_Saison=1962; -- 0.095 msupdate f1_InSaison set tmp_wmpos = 47 where wer = 345 and f1_Saison=1962; -- 0.105 msupdate f1_InSaison set tmp_wmpos = 48 where wer = 465 and f1_Saison=1962; -- 0.090 msupdate f1_InSaison set tmp_wmpos = 49 where wer = 645 and f1_Saison=1962; -- 0.084 msupdate f1_InSaison set tmp_wmpos = 50 where wer = 498 and f1_Saison=1962; -- 0.090 msupdate f1_InSaison set tmp_wmpos = 51 where wer = 669 and f1_Saison=1962; -- 0.079 ms
Kein passender Alias für "64" (Typ:o) gefunden!
Kein passender Alias für "7" (Typ:o) gefunden!
Kein passender Alias für "57" (Typ:o) gefunden!
Kein passender Alias für "10" (Typ:o) gefunden!
Kein passender Alias für "66" (Typ:o) gefunden!
Kein passender Alias für "31" (Typ:o) gefunden!
Kein passender Alias für "73" (Typ:o) gefunden!
Kein passender Alias für "74" (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 =1962 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 = -351 and f1_Saison=1962; -- 0.233 msupdate f1_InSaison set tmp_wmpos = 2 where wer = -206 and f1_Saison=1962; -- 0.230 msupdate f1_InSaison set tmp_wmpos = 3 where wer = -370 and f1_Saison=1962; -- 0.207 msupdate f1_InSaison set tmp_wmpos = 4 where wer = -246 and f1_Saison=1962; -- 0.229 msupdate f1_InSaison set tmp_wmpos = 5 where wer = -171 and f1_Saison=1962; -- 0.106 msupdate f1_InSaison set tmp_wmpos = 6 where wer = -366 and f1_Saison=1962; -- 0.106 msupdate f1_InSaison set tmp_wmpos = 7 where wer = -172 and f1_Saison=1962; -- 0.223 msupdate f1_InSaison set tmp_wmpos = 8 where wer = -391 and f1_Saison=1962; -- 0.119 msupdate f1_InSaison set tmp_wmpos = 9 where wer = -364 and f1_Saison=1962; -- 0.189 msupdate f1_InSaison set tmp_wmpos = 10 where wer = -407 and f1_Saison=1962; -- 0.083 msupdate f1_InSaison set tmp_wmpos = 11 where wer = -341 and f1_Saison=1962; -- 0.206 msupdate f1_InSaison set tmp_wmpos = 12 where wer = -265 and f1_Saison=1962; -- 0.073 msupdate f1_InSaison set tmp_wmpos = 13 where wer = -408 and f1_Saison=1962; -- 0.081 msupdate f1_InSaison set tmp_wmpos = 14 where wer = -403 and f1_Saison=1962; -- 0.086 msupdate f1_InSaison set tmp_wmpos = 15 where wer = -153 and f1_Saison=1962; -- 0.180 msupdate f1_InSaison set tmp_wmpos = 16 where wer = -406 and f1_Saison=1962; -- 0.084 msupdate f1_InSaison set tmp_wmpos = 17 where wer = -247 and f1_Saison=1962; -- 0.090 msupdate f1_InSaison set tmp_wmpos = 18 where wer = -410 and f1_Saison=1962; -- 0.071 msupdate f1_InSaison set tmp_wmpos = 19 where wer = -405 and f1_Saison=1962; -- 0.150 msupdate f1_InSaison set tmp_wmpos = 20 where wer = -235 and f1_Saison=1962; -- 0.079 msupdate f1_InSaison set tmp_wmpos = 21 where wer = -121 and f1_Saison=1962; -- 0.070 msupdate f1_InSaison set tmp_wmpos = 22 where wer = -399 and f1_Saison=1962; -- 0.080 msupdate f1_InSaison set tmp_wmpos = 23 where wer = -243 and f1_Saison=1962; -- 0.078 msupdate f1_InSaison set tmp_wmpos = 24 where wer = -139 and f1_Saison=1962; -- 0.135 msupdate f1_InSaison set tmp_wmpos = 25 where wer = -222 and f1_Saison=1962; -- 0.096 msupdate f1_InSaison set tmp_wmpos = 26 where wer = -214 and f1_Saison=1962; -- 0.100 msupdate f1_InSaison set tmp_wmpos = 27 where wer = -345 and f1_Saison=1962; -- 0.085 msupdate f1_InSaison set tmp_wmpos = 28 where wer = -285 and f1_Saison=1962; -- 0.084 msupdate f1_InSaison set tmp_wmpos = 29 where wer = -396 and f1_Saison=1962; -- 0.087 msupdate f1_InSaison set tmp_wmpos = 30 where wer = -203 and f1_Saison=1962; -- 0.091 msupdate f1_InSaison set tmp_wmpos = 31 where wer = -289 and f1_Saison=1962; -- 0.101 msupdate f1_InSaison set tmp_wmpos = 32 where wer = -402 and f1_Saison=1962; -- 0.095 msupdate f1_InSaison set tmp_wmpos = 33 where wer = -404 and f1_Saison=1962; -- 0.091 msupdate f1_InSaison set tmp_wmpos = 34 where wer = -271 and f1_Saison=1962; -- 0.200 msupdate f1_InSaison set tmp_wmpos = 35 where wer = -409 and f1_Saison=1962; -- 0.115 ms