 | | |
| |
FALK-DEBUG:db_default:FALK
db_default:FALK
login:, bid:
Kein Cookie
db_default:FALK
Jetzt: 1369518291
Cache:
Anfangszeit: 1369518291.1541
MP LOGGED_IN:
PHP_SELF::/Ergebnisse/Saison/1985 SCRIPT_URL:/Ergebnisse/Saison/1985
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 = 1985 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 =1985 and f1_Rennen.f1_Rennen <= 419 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
419: Zweiter: 62 -> 53 vs. Erster: 76
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 =1985 and f1_Rennen.f1_Rennen <= 418 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
418: Zweiter: 71 -> 53 vs. Erster: 72
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 =1985 and f1_Rennen.f1_Rennen <= 417 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
417: Zweiter: 80 -> 53 vs. Erster: 69
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 =1985 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=1985 and wer=597
update f1_Person set tmp_wms=-1 where f1_Person=597
WM-Entscheidung:418
select min(f1_Rennen) from f1_Rennen where f1_Saison=1985
update f1_Saison set tmp_wm_entscheidung = 14 where f1_Saison=1985
update f1_Rennergebnis set tmp_wm_entscheidung = "" where f1_Rennen = 418 and f1_Person=597
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 = 1985 order by f1_Rennen.f1_Rennen
Kein passender Alias für "94" (Typ:o) gefunden!
Kein passender Alias für "99" (Typ:o) gefunden!
Kein passender Alias für "96" (Typ:o) gefunden!
Kein passender Alias für "7" (Typ:o) gefunden!
Kein passender Alias für "95" (Typ:o) gefunden!
Kein passender Alias für "98" (Typ:o) gefunden!
Kein passender Alias für "86" (Typ:o) gefunden!
Kein passender Alias für "55" (Typ:o) gefunden!
Kein passender Alias für "76" (Typ:o) gefunden!
Kein passender Alias für "64" (Typ:o) gefunden!
Kein passender Alias für "31" (Typ:o) gefunden!
Kein passender Alias für "57" (Typ:o) gefunden!
Kein passender Alias für "77" (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 =1985 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
Kein passender Alias für "79" (Typ:o) gefunden!
Kein passender Alias für "101" (Typ:o) gefunden!
wmtab: wmupdate:1
select count(*) from f1_InSaison where tmp_wmpos = 0 and f1_Saison=1985
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 = 1985 order by f1_Rennen.f1_Rennen, k desc
Kein passender Alias für "94" (Typ:o) gefunden!
Kein passender Alias für "99" (Typ:o) gefunden!
Kein passender Alias für "96" (Typ:o) gefunden!
Kein passender Alias für "7" (Typ:o) gefunden!
Kein passender Alias für "95" (Typ:o) gefunden!
Kein passender Alias für "98" (Typ:o) gefunden!
Kein passender Alias für "86" (Typ:o) gefunden!
Kein passender Alias für "55" (Typ:o) gefunden!
Kein passender Alias für "76" (Typ:o) gefunden!
Kein passender Alias für "64" (Typ:o) gefunden!
Kein passender Alias für "31" (Typ:o) gefunden!
Kein passender Alias für "57" (Typ:o) gefunden!
Kein passender Alias für "77" (Typ:o) gefunden!
Kein passender Alias für "79" (Typ:o) gefunden!
Kein passender Alias für "101" (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 =1985 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
Kein passender Alias für "583" (Typ:p) gefunden!
Kein passender Alias für "94" (Typ:o) gefunden!
Kein passender Alias für "99" (Typ:o) gefunden!
Kein passender Alias für "96" (Typ:o) gefunden!
Kein passender Alias für "7" (Typ:o) gefunden!
Kein passender Alias für "95" (Typ:o) gefunden!
Kein passender Alias für "98" (Typ:o) gefunden!
Kein passender Alias für "86" (Typ:o) gefunden!
Kein passender Alias für "55" (Typ:o) gefunden!
Kein passender Alias für "76" (Typ:o) gefunden!
Kein passender Alias für "64" (Typ:o) gefunden!
Kein passender Alias für "31" (Typ:o) gefunden!
Kein passender Alias für "57" (Typ:o) gefunden!
Kein passender Alias für "77" (Typ:o) gefunden!
Kein passender Alias für "79" (Typ:o) gefunden!
Kein passender Alias für "101" (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 =1985 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