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: 1524666695
Cache:
Anfangszeit: 1524666695.0771
MP LOGGED_IN:
PHP_SELF::/Ergebnisse/Saison/1956 SCRIPT_URL:/Ergebnisse/Saison/1956
URL:Ergebnisse:6:
URL:Saison:1:
### URL: //Ergebnisse/Saison index: 2 Skript: "Ergebnisse/Weltmeisterschaften.php" Header: "Ergebnisse/Weltmeisterschaften_h.php"
Ergebnisse
select * from f1_Wetter_de; -- 0.140 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 = 1956 order by f1_Rennen.f1_Rennen; -- 0.262 ms
Kein passender Alias für "65" (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 "57" (Typ:o) gefunden!
Kein passender Alias für "59" (Typ:o) gefunden!
Kein passender Alias für "55" (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 =1956 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.620 ms
wmtab: wmupdate:1
select count(*) from f1_InSaison where tmp_wmpos = 0 and f1_Saison=1956; -- 0.262 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 = 1956 order by f1_Rennen.f1_Rennen, k desc; -- 0.624 ms
Kein passender Alias für "65" (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 "57" (Typ:o) gefunden!
Kein passender Alias für "59" (Typ:o) gefunden!
Kein passender Alias für "55" (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 =1956 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.868 msupdate f1_InSaison set tmp_wmpos = 1 where wer = 13 and f1_Saison=1956; -- 0.101 msupdate f1_InSaison set tmp_wmpos = 2 where wer = 525 and f1_Saison=1956; -- 0.206 msupdate f1_InSaison set tmp_wmpos = 3 where wer = 225 and f1_Saison=1956; -- 0.105 msupdate f1_InSaison set tmp_wmpos = 4 where wer = 135 and f1_Saison=1956; -- 0.226 msupdate f1_InSaison set tmp_wmpos = 5 where wer = 295 and f1_Saison=1956; -- 0.099 msupdate f1_InSaison set tmp_wmpos = 6 where wer = 210 and f1_Saison=1956; -- 0.080 msupdate f1_InSaison set tmp_wmpos = 7 where wer = 313 and f1_Saison=1956; -- 0.072 msupdate f1_InSaison set tmp_wmpos = 8 where wer = 366 and f1_Saison=1956; -- 0.074 msupdate f1_InSaison set tmp_wmpos = 9 where wer = 319 and f1_Saison=1956; -- 0.091 msupdate f1_InSaison set tmp_wmpos = 10 where wer = 282 and f1_Saison=1956; -- 0.083 msupdate f1_InSaison set tmp_wmpos = 11 where wer = 528 and f1_Saison=1956; -- 0.077 msupdate f1_InSaison set tmp_wmpos = 12 where wer = 373 and f1_Saison=1956; -- 0.092 msupdate f1_InSaison set tmp_wmpos = 13 where wer = 298 and f1_Saison=1956; -- 0.118 msupdate f1_InSaison set tmp_wmpos = 14 where wer = 312 and f1_Saison=1956; -- 0.108 msupdate f1_InSaison set tmp_wmpos = 15 where wer = 591 and f1_Saison=1956; -- 0.091 msupdate f1_InSaison set tmp_wmpos = 16 where wer = 568 and f1_Saison=1956; -- 0.084 msupdate f1_InSaison set tmp_wmpos = 17 where wer = 39 and f1_Saison=1956; -- 0.187 msupdate f1_InSaison set tmp_wmpos = 18 where wer = 564 and f1_Saison=1956; -- 0.215 msupdate f1_InSaison set tmp_wmpos = 19 where wer = 37 and f1_Saison=1956; -- 0.072 msupdate f1_InSaison set tmp_wmpos = 20 where wer = 45 and f1_Saison=1956; -- 0.180 msupdate f1_InSaison set tmp_wmpos = 21 where wer = 342 and f1_Saison=1956; -- 0.103 msupdate f1_InSaison set tmp_wmpos = 22 where wer = 604 and f1_Saison=1956; -- 0.071 msupdate f1_InSaison set tmp_wmpos = 23 where wer = 333 and f1_Saison=1956; -- 0.103 msupdate f1_InSaison set tmp_wmpos = 24 where wer = 607 and f1_Saison=1956; -- 0.095 msupdate f1_InSaison set tmp_wmpos = 25 where wer = 317 and f1_Saison=1956; -- 0.069 msupdate f1_InSaison set tmp_wmpos = 26 where wer = 435 and f1_Saison=1956; -- 0.085 ms
Kein passender Alias für "861" (Typ:p) gefunden!
update f1_InSaison set tmp_wmpos = 27 where wer = 861 and f1_Saison=1956; -- 0.397 msupdate f1_InSaison set tmp_wmpos = 28 where wer = 579 and f1_Saison=1956; -- 0.086 msupdate f1_InSaison set tmp_wmpos = 29 where wer = 581 and f1_Saison=1956; -- 0.091 msupdate f1_InSaison set tmp_wmpos = 30 where wer = 708 and f1_Saison=1956; -- 0.087 msupdate f1_InSaison set tmp_wmpos = 31 where wer = 131 and f1_Saison=1956; -- 0.098 msupdate f1_InSaison set tmp_wmpos = 32 where wer = 743 and f1_Saison=1956; -- 0.089 msupdate f1_InSaison set tmp_wmpos = 33 where wer = 321 and f1_Saison=1956; -- 0.082 msupdate f1_InSaison set tmp_wmpos = 34 where wer = 19 and f1_Saison=1956; -- 0.114 msupdate f1_InSaison set tmp_wmpos = 35 where wer = 745 and f1_Saison=1956; -- 0.081 msupdate f1_InSaison set tmp_wmpos = 36 where wer = 756 and f1_Saison=1956; -- 0.167 msupdate f1_InSaison set tmp_wmpos = 37 where wer = 27 and f1_Saison=1956; -- 0.086 msupdate f1_InSaison set tmp_wmpos = 38 where wer = 681 and f1_Saison=1956; -- 0.095 msupdate f1_InSaison set tmp_wmpos = 39 where wer = 611 and f1_Saison=1956; -- 0.093 msupdate f1_InSaison set tmp_wmpos = 40 where wer = 347 and f1_Saison=1956; -- 0.089 msupdate f1_InSaison set tmp_wmpos = 41 where wer = 16 and f1_Saison=1956; -- 0.079 msupdate f1_InSaison set tmp_wmpos = 42 where wer = 645 and f1_Saison=1956; -- 0.098 msupdate f1_InSaison set tmp_wmpos = 43 where wer = 369 and f1_Saison=1956; -- 0.122 msupdate f1_InSaison set tmp_wmpos = 44 where wer = 89 and f1_Saison=1956; -- 0.210 msupdate f1_InSaison set tmp_wmpos = 45 where wer = 222 and f1_Saison=1956; -- 0.074 msupdate f1_InSaison set tmp_wmpos = 46 where wer = 417 and f1_Saison=1956; -- 0.079 msupdate f1_InSaison set tmp_wmpos = 47 where wer = 406 and f1_Saison=1956; -- 0.222 msupdate f1_InSaison set tmp_wmpos = 48 where wer = 805 and f1_Saison=1956; -- 0.069 msupdate f1_InSaison set tmp_wmpos = 49 where wer = 254 and f1_Saison=1956; -- 0.084 msupdate f1_InSaison set tmp_wmpos = 50 where wer = 550 and f1_Saison=1956; -- 0.106 msupdate f1_InSaison set tmp_wmpos = 51 where wer = 187 and f1_Saison=1956; -- 0.216 msupdate f1_InSaison set tmp_wmpos = 52 where wer = 606 and f1_Saison=1956; -- 0.182 msupdate f1_InSaison set tmp_wmpos = 53 where wer = 862 and f1_Saison=1956; -- 0.092 msupdate f1_InSaison set tmp_wmpos = 54 where wer = 272 and f1_Saison=1956; -- 0.100 ms
Kein passender Alias für "843" (Typ:p) gefunden!
update f1_InSaison set tmp_wmpos = 55 where wer = 843 and f1_Saison=1956; -- 0.093 msupdate f1_InSaison set tmp_wmpos = 56 where wer = 484 and f1_Saison=1956; -- 0.089 msupdate f1_InSaison set tmp_wmpos = 57 where wer = 840 and f1_Saison=1956; -- 0.104 msupdate f1_InSaison set tmp_wmpos = 58 where wer = 736 and f1_Saison=1956; -- 0.092 msupdate f1_InSaison set tmp_wmpos = 59 where wer = 836 and f1_Saison=1956; -- 0.082 msupdate f1_InSaison set tmp_wmpos = 60 where wer = 18 and f1_Saison=1956; -- 0.085 msupdate f1_InSaison set tmp_wmpos = 61 where wer = 667 and f1_Saison=1956; -- 0.088 msupdate f1_InSaison set tmp_wmpos = 62 where wer = 7 and f1_Saison=1956; -- 0.079 msupdate f1_InSaison set tmp_wmpos = 63 where wer = 102 and f1_Saison=1956; -- 0.091 msupdate f1_InSaison set tmp_wmpos = 64 where wer = 731 and f1_Saison=1956; -- 0.092 msupdate f1_InSaison set tmp_wmpos = 65 where wer = 814 and f1_Saison=1956; -- 0.081 msupdate f1_InSaison set tmp_wmpos = 66 where wer = 509 and f1_Saison=1956; -- 0.111 msupdate f1_InSaison set tmp_wmpos = 67 where wer = 217 and f1_Saison=1956; -- 0.095 msupdate f1_InSaison set tmp_wmpos = 68 where wer = 638 and f1_Saison=1956; -- 0.083 msupdate f1_InSaison set tmp_wmpos = 69 where wer = 43 and f1_Saison=1956; -- 0.098 msupdate f1_InSaison set tmp_wmpos = 70 where wer = 44 and f1_Saison=1956; -- 0.222 msupdate f1_InSaison set tmp_wmpos = 71 where wer = 235 and f1_Saison=1956; -- 0.082 msupdate f1_InSaison set tmp_wmpos = 72 where wer = 666 and f1_Saison=1956; -- 0.102 msupdate f1_InSaison set tmp_wmpos = 73 where wer = 825 and f1_Saison=1956; -- 0.099 msupdate f1_InSaison set tmp_wmpos = 74 where wer = 14 and f1_Saison=1956; -- 0.079 msupdate f1_InSaison set tmp_wmpos = 75 where wer = 650 and f1_Saison=1956; -- 0.102 msupdate f1_InSaison set tmp_wmpos = 76 where wer = 739 and f1_Saison=1956; -- 0.128 msupdate f1_InSaison set tmp_wmpos = 77 where wer = 727 and f1_Saison=1956; -- 0.078 msupdate f1_InSaison set tmp_wmpos = 78 where wer = 265 and f1_Saison=1956; -- 0.090 msupdate f1_InSaison set tmp_wmpos = 79 where wer = 160 and f1_Saison=1956; -- 0.239 msupdate f1_InSaison set tmp_wmpos = 80 where wer = 774 and f1_Saison=1956; -- 0.087 msupdate f1_InSaison set tmp_wmpos = 81 where wer = 147 and f1_Saison=1956; -- 0.220 msupdate f1_InSaison set tmp_wmpos = 82 where wer = 360 and f1_Saison=1956; -- 0.092 msupdate f1_InSaison set tmp_wmpos = 83 where wer = 273 and f1_Saison=1956; -- 0.120 msupdate f1_InSaison set tmp_wmpos = 84 where wer = 483 and f1_Saison=1956; -- 0.087 msupdate f1_InSaison set tmp_wmpos = 85 where wer = 749 and f1_Saison=1956; -- 0.077 msupdate f1_InSaison set tmp_wmpos = 86 where wer = 508 and f1_Saison=1956; -- 0.130 msupdate f1_InSaison set tmp_wmpos = 87 where wer = 251 and f1_Saison=1956; -- 0.200 msupdate f1_InSaison set tmp_wmpos = 88 where wer = 640 and f1_Saison=1956; -- 0.080 msupdate f1_InSaison set tmp_wmpos = 89 where wer = 363 and f1_Saison=1956; -- 0.124 msupdate f1_InSaison set tmp_wmpos = 90 where wer = 704 and f1_Saison=1956; -- 0.101 msupdate f1_InSaison set tmp_wmpos = 91 where wer = 458 and f1_Saison=1956; -- 0.070 msupdate f1_InSaison set tmp_wmpos = 92 where wer = 828 and f1_Saison=1956; -- 0.125 msupdate f1_InSaison set tmp_wmpos = 93 where wer = 732 and f1_Saison=1956; -- 0.095 msupdate f1_InSaison set tmp_wmpos = 94 where wer = 214 and f1_Saison=1956; -- 0.081 msupdate f1_InSaison set tmp_wmpos = 95 where wer = 181 and f1_Saison=1956; -- 0.083 msupdate f1_InSaison set tmp_wmpos = 96 where wer = 464 and f1_Saison=1956; -- 0.099 msupdate f1_InSaison set tmp_wmpos = 97 where wer = 168 and f1_Saison=1956; -- 0.191 msupdate f1_InSaison set tmp_wmpos = 98 where wer = 789 and f1_Saison=1956; -- 0.124 msupdate f1_InSaison set tmp_wmpos = 99 where wer = 515 and f1_Saison=1956; -- 0.082 ms
Kein passender Alias für "65" (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 "57" (Typ:o) gefunden!
Kein passender Alias für "59" (Typ:o) gefunden!
Kein passender Alias für "55" (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 =1956 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 = -246 and f1_Saison=1956; -- 0.347 msupdate f1_InSaison set tmp_wmpos = 2 where wer = -302 and f1_Saison=1956; -- 0.123 msupdate f1_InSaison set tmp_wmpos = 3 where wer = -205 and f1_Saison=1956; -- 0.361 msupdate f1_InSaison set tmp_wmpos = 4 where wer = -73 and f1_Saison=1956; -- 0.383 msupdate f1_InSaison set tmp_wmpos = 5 where wer = -104 and f1_Saison=1956; -- 0.119 msupdate f1_InSaison set tmp_wmpos = 6 where wer = -57 and f1_Saison=1956; -- 0.404 msupdate f1_InSaison set tmp_wmpos = 7 where wer = -351 and f1_Saison=1956; -- 0.370 msupdate f1_InSaison set tmp_wmpos = 8 where wer = -318 and f1_Saison=1956; -- 0.124 msupdate f1_InSaison set tmp_wmpos = 9 where wer = -77 and f1_Saison=1956; -- 0.106 msupdate f1_InSaison set tmp_wmpos = 10 where wer = -274 and f1_Saison=1956; -- 0.083 msupdate f1_InSaison set tmp_wmpos = 11 where wer = -305 and f1_Saison=1956; -- 0.068 msupdate f1_InSaison set tmp_wmpos = 12 where wer = -212 and f1_Saison=1956; -- 0.241 msupdate f1_InSaison set tmp_wmpos = 13 where wer = -275 and f1_Saison=1956; -- 0.131 msupdate f1_InSaison set tmp_wmpos = 14 where wer = -8 and f1_Saison=1956; -- 0.071 msupdate f1_InSaison set tmp_wmpos = 15 where wer = -22 and f1_Saison=1956; -- 0.065 msupdate f1_InSaison set tmp_wmpos = 16 where wer = -361 and f1_Saison=1956; -- 0.064 msupdate f1_InSaison set tmp_wmpos = 17 where wer = -356 and f1_Saison=1956; -- 0.058 msupdate f1_InSaison set tmp_wmpos = 18 where wer = -58 and f1_Saison=1956; -- 0.104 msupdate f1_InSaison set tmp_wmpos = 19 where wer = -97 and f1_Saison=1956; -- 0.111 msupdate f1_InSaison set tmp_wmpos = 20 where wer = -2 and f1_Saison=1956; -- 0.102 msupdate f1_InSaison set tmp_wmpos = 21 where wer = -35 and f1_Saison=1956; -- 0.110 msupdate f1_InSaison set tmp_wmpos = 22 where wer = -21 and f1_Saison=1956; -- 0.183 msupdate f1_InSaison set tmp_wmpos = 23 where wer = -266 and f1_Saison=1956; -- 0.089 msupdate f1_InSaison set tmp_wmpos = 24 where wer = -33 and f1_Saison=1956; -- 0.101 msupdate f1_InSaison set tmp_wmpos = 25 where wer = -271 and f1_Saison=1956; -- 0.077 msupdate f1_InSaison set tmp_wmpos = 26 where wer = -269 and f1_Saison=1956; -- 0.102 msupdate f1_InSaison set tmp_wmpos = 27 where wer = -111 and f1_Saison=1956; -- 0.077 msupdate f1_InSaison set tmp_wmpos = 28 where wer = -37 and f1_Saison=1956; -- 0.070 msupdate f1_InSaison set tmp_wmpos = 29 where wer = -109 and f1_Saison=1956; -- 0.102 msupdate f1_InSaison set tmp_wmpos = 30 where wer = -19 and f1_Saison=1956; -- 0.082 msupdate f1_InSaison set tmp_wmpos = 31 where wer = -75 and f1_Saison=1956; -- 0.116 msupdate f1_InSaison set tmp_wmpos = 32 where wer = -100 and f1_Saison=1956; -- 0.070 msupdate f1_InSaison set tmp_wmpos = 33 where wer = -48 and f1_Saison=1956; -- 0.087 msupdate f1_InSaison set tmp_wmpos = 34 where wer = -65 and f1_Saison=1956; -- 0.129 msupdate f1_InSaison set tmp_wmpos = 35 where wer = -51 and f1_Saison=1956; -- 0.081 msupdate f1_InSaison set tmp_wmpos = 36 where wer = -284 and f1_Saison=1956; -- 0.088 msupdate f1_InSaison set tmp_wmpos = 37 where wer = -115 and f1_Saison=1956; -- 0.117 msupdate f1_InSaison set tmp_wmpos = 38 where wer = -172 and f1_Saison=1956; -- 0.249 msupdate f1_InSaison set tmp_wmpos = 39 where wer = -85 and f1_Saison=1956; -- 0.124 msupdate f1_InSaison set tmp_wmpos = 40 where wer = -362 and f1_Saison=1956; -- 0.124 msupdate f1_InSaison set tmp_wmpos = 41 where wer = -360 and f1_Saison=1956; -- 0.080 msupdate f1_InSaison set tmp_wmpos = 42 where wer = -359 and f1_Saison=1956; -- 0.093 msupdate f1_InSaison set tmp_wmpos = 43 where wer = -114 and f1_Saison=1956; -- 0.258 msupdate f1_InSaison set tmp_wmpos = 44 where wer = -47 and f1_Saison=1956; -- 0.108 msupdate f1_InSaison set tmp_wmpos = 45 where wer = -12 and f1_Saison=1956; -- 0.089 msupdate f1_InSaison set tmp_wmpos = 46 where wer = -235 and f1_Saison=1956; -- 0.076 msupdate f1_InSaison set tmp_wmpos = 47 where wer = -45 and f1_Saison=1956; -- 0.137 msupdate f1_InSaison set tmp_wmpos = 48 where wer = -184 and f1_Saison=1956; -- 0.085 msupdate f1_InSaison set tmp_wmpos = 49 where wer = -79 and f1_Saison=1956; -- 0.093 msupdate f1_InSaison set tmp_wmpos = 50 where wer = -363 and f1_Saison=1956; -- 0.087 msupdate f1_InSaison set tmp_wmpos = 51 where wer = -61 and f1_Saison=1956; -- 0.091 msupdate f1_InSaison set tmp_wmpos = 52 where wer = -46 and f1_Saison=1956; -- 0.116 ms
Kein passender Alias für "-5" (Typ:f) gefunden!
update f1_InSaison set tmp_wmpos = 53 where wer = -5 and f1_Saison=1956; -- 0.251 ms