FALK-DEBUG:db_default:FALK
db_default:FALK
login:, bid:
Kein Cookie
db_default:FALK
Jetzt: 1369383570
Cache:
Anfangszeit: 1369383570.6025
MP LOGGED_IN:
PHP_SELF::/statistics/seasons/different-Winners SCRIPT_URL:/statistics/seasons/different-Winners
URL:statistics:7:
URL:seasons:3:
URL:different-Winners::
URL: http://f1-facts.com/statistics/seasons index: 2 selbst: Statistik/Saisonen Header:
statistics
letzte Saison: 2012
create temporary table f1_tmp ( id smallint not null primary key auto_increment, f1_Person int not null, f1_Saison smallint not null, c tinyint not null )
insert into f1_tmp select NULL, f1_Person, f1_Saison, count(*) from f1_Rennergebnis left join f1_Rennen using(f1_Rennen) where k = 1 and f1_Saison <= 2012 group by f1_Saison, f1_Person order by f1_Saison
select f1_Saison, count(*) as x1, "/" as x2, sum(c) as x3, count(*)/sum(c) as p1 from f1_tmp group by f1_Saison order by p1 desc, x1 desc, f1_Saison