FALK-DEBUG:db_default:FALK
db_default:FALK
login:, bid:
Kein Cookie
db_default:FALK
Jetzt: 1369547880
Cache:
Anfangszeit: 1369547880.0074
MP LOGGED_IN:
PHP_SELF::/Statistik/Teams SCRIPT_URL:/Statistik/Teams
URL:Statistik:7:
URL:Teams:2:
URL: http://f1.statistiker.org/Statistik/Teams index: 2 selbst: Statistik/Fahrer_Teams Header:
Statistik
select kurzname, tmp_team, tmp_team as wer, tmp_kwms as wms, max(f1_Rennen) as letztes, aktiv is not null as akt, sum(wmpunkte) as wmpunkte, sum(punkte) as punkte, sum(k = 1) as siege, sum(q = 1) as poles, sum(k >= 1 and k <= 3) as podeste, sum(tmp_spos = 1) as srunden, count(f1_Rennergebnis) as gemeldet, sum(q > 0 or runden > 0) as qualifiziert, sum(k > 0) as klassifiziert, (sum(q > 0 or runden > 0) / count(f1_Rennergebnis)) as qual_p, (sum(k>0)/count(f1_Rennergebnis)) as klass_p from f1_Rennergebnis left join f1_Firma on f1_Firma.f1_Firma = tmp_team group by tmp_team having wmpunkte >= 3000 order by wmpunkte desc, letztes
