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: 1550650623
Cache:
Anfangszeit: 1550650623.7481
MP LOGGED_IN:
PHP_SELF::/Statistik/Teams SCRIPT_URL:/Statistik/Teams
URL:Statistik:7:
URL:Teams:2:
### URL: //Statistik/Teams index: 2 Skript: "Statistik/Fahrer_Teams.php" Header: ".php"
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; -- 100.205 ms