 | | | Jolyon PalmerJolyon Palmer в сравнение със съотборницитеОтбелязаните колонки съдържат стойностите на съответния съотборник. сравнит. точки (точки за сравнение): По-добра/по-лоша квалификация от съот други пилоти... | |
Multiple Translation Services |
FALK-DEBUG: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: 1550264221
Cache:
Anfangszeit: 1550264221.5078
MP LOGGED_IN:
PHP_SELF::/statistika/kolega-ot-otbori/Jolyon SCRIPT_URL:/statistika/kolega-ot-otbori/Jolyon
URL:statistika:7:
URL:kolega-ot-otbori:4:
URL:Jolyon::
### URL: //statistika/kolega-ot-otbori index: 2 Skript: "Statistik/Teamkollegen.php" Header: "Statistik/Teamkollegen_h.php"
select vorname, nachname, tmp_wms, f1_Person.aktiv is not null as akt, f1_Person.land, geb_ort.name as geb_ort_name, s_ort.name as s_ort_name, gebjahr, gebmonat, gebtag, sjahr, smonat, stag, Land_bg.name as landname from f1_Person left join f1_Ort as geb_ort on geb_ort.f1_Ort = f1_Person.gebort left join f1_Ort as s_ort on s_ort.f1_Ort = f1_Person.sort left join Land_bg on id=f1_Person.land where f1_Person = 935; -- 0.794 ms
select f1_Rennen.f1_Rennen, f1_Saison, tmp_team, q, ((q>0)*q + (q<=0)*999) as qv, k, ((k>0)*k + (k<=0)*999) as kv, tmp_spos, ((tmp_spos>0)*tmp_spos + (tmp_spos<=0)*999) as tmp_sposv, punkte, wmpunkte from f1_Rennergebnis left join f1_Rennen using (f1_Rennen) where f1_Person = 935 and ausgang != 2 order by f1_Rennen; -- 1.034 ms
Saison:2016
Person:K.Magnussen, Anzahl:1
Qualpos:14, Teamkollege:15/15
VP:1
Rennpos:11, Teamkollege:12/12
VP:3
Srundpos:999, Teamkollege:999/999
Nach Rennen:937 VP:3
Qualpos:20, Teamkollege:19/19
VP:2
Rennpos:999, Teamkollege:11/11
VP:0
Srundpos:999, Teamkollege:999/999
Nach Rennen:938 VP:0
Qualpos:19, Teamkollege:17/17
VP:-1
Rennpos:22, Teamkollege:17/17
VP:-3
Srundpos:999, Teamkollege:999/999
Nach Rennen:939 VP:-3
Qualpos:18, Teamkollege:17/17
VP:-4
Rennpos:13, Teamkollege:7/7
VP:-6
Srundpos:999, Teamkollege:999/999
Nach Rennen:940 VP:-6
Qualpos:17, Teamkollege:15/15
VP:-7
Rennpos:13, Teamkollege:15/15
VP:-5
Srundpos:999, Teamkollege:999/999
Nach Rennen:941 VP:-5
Qualpos:18, Teamkollege:16/16
VP:-6
Rennpos:999, Teamkollege:999/999
VP:-6
Srundpos:999, Teamkollege:999/999
Nach Rennen:942 VP:-6
Kein passender Alias für "" (Typ:p) gefunden!
Person:, Anzahl:
Person:K.Magnussen, Anzahl:1
Qualpos:22, Teamkollege:21/21
VP:-1
Rennpos:15, Teamkollege:14/14
VP:-3
Srundpos:8, Teamkollege:19/19
Nach Rennen:944 VP:-2
Qualpos:18, Teamkollege:17/17
VP:-3
Rennpos:12, Teamkollege:14/14
VP:-1
Srundpos:13, Teamkollege:17/17
Nach Rennen:945 VP:0
Qualpos:18, Teamkollege:16/16
VP:-1
Rennpos:999, Teamkollege:17/17
VP:-3
Srundpos:18, Teamkollege:12/12
Nach Rennen:946 VP:-4
Person:K.Magnussen, Anzahl:5
Qualpos:999, Teamkollege:999/999
VP:0
Rennpos:12, Teamkollege:15/21
VP:2
Srundpos:16, Teamkollege:12/22
Nach Rennen:947 VP:2
Person:K.Magnussen, Anzahl:1
Qualpos:16, Teamkollege:17/17
VP:1
Rennpos:19, Teamkollege:16/16
VP:-1
Srundpos:17, Teamkollege:21/21
Nach Rennen:948 VP:0
Qualpos:14, Teamkollege:12/12
VP:-1
Rennpos:15, Teamkollege:999/999
VP:1
Srundpos:6, Teamkollege:18/18
Nach Rennen:949 VP:2
Qualpos:20, Teamkollege:21/21
VP:3
Rennpos:999, Teamkollege:17/17
VP:1
Srundpos:999, Teamkollege:999/999
Nach Rennen:950 VP:1
Qualpos:19, Teamkollege:17/17
VP:0
Rennpos:15, Teamkollege:10/10
VP:-2
Srundpos:19, Teamkollege:8/8
Nach Rennen:951 VP:-3
Qualpos:19, Teamkollege:14/14
VP:-4
Rennpos:10, Teamkollege:999/999
VP:-2
Srundpos:12, Teamkollege:21/21
Nach Rennen:952 VP:-1
Qualpos:16, Teamkollege:18/18
VP:0
Rennpos:12, Teamkollege:14/14
VP:2
Srundpos:16, Teamkollege:18/18
Nach Rennen:953 VP:3
Qualpos:15, Teamkollege:18/18
VP:4
Rennpos:13, Teamkollege:11/11
VP:2
Srundpos:999, Teamkollege:999/999
Nach Rennen:954 VP:2
Person:P.Wehrlein, Anzahl:1
Qualpos:999, Teamkollege:16/16
VP:-1
Rennpos:14, Teamkollege:999/999
VP:1
Srundpos:20, Teamkollege:999/999
Nach Rennen:955 VP:2
Person:K.Magnussen, Anzahl:1
Qualpos:16, Teamkollege:18/18
VP:1
Rennpos:999, Teamkollege:14/14
VP:-1
Srundpos:21, Teamkollege:7/7
Nach Rennen:956 VP:-2
Qualpos:15, Teamkollege:18/18
VP:-1
Rennpos:17, Teamkollege:999/999
VP:1
Srundpos:11, Teamkollege:20/20
Nach Rennen:957 VP:2
Saison:2017
Person:NicoHulkenberg, Anzahl:1
Qualpos:20, Teamkollege:12/12
VP:-1
Rennpos:999, Teamkollege:11/11
VP:-3
Srundpos:20, Teamkollege:12/12
Nach Rennen:958 VP:-4
Qualpos:18, Teamkollege:7/7
VP:-5
Rennpos:13, Teamkollege:12/12
VP:-7
Srundpos:999, Teamkollege:999/999
Nach Rennen:959 VP:-7
Qualpos:10, Teamkollege:7/7
VP:-8
Rennpos:13, Teamkollege:9/9
VP:-10
Srundpos:13, Teamkollege:12/12
Nach Rennen:960 VP:-11
Qualpos:16, Teamkollege:8/8
VP:-12
Rennpos:999, Teamkollege:8/8
VP:-14
Srundpos:999, Teamkollege:7/7
Nach Rennen:961 VP:-15
Qualpos:17, Teamkollege:13/13
VP:-16
Rennpos:15, Teamkollege:6/6
VP:-18
Srundpos:6, Teamkollege:15/15
Nach Rennen:962 VP:-17
Qualpos:17, Teamkollege:12/12
VP:-18
Rennpos:11, Teamkollege:999/999
VP:-16
Srundpos:13, Teamkollege:19/19
Nach Rennen:963 VP:-15
Qualpos:15, Teamkollege:10/10
VP:-16
Rennpos:11, Teamkollege:8/8
VP:-18
Srundpos:12, Teamkollege:7/7
Nach Rennen:964 VP:-19
Kein passender Alias für "" (Typ:p) gefunden!
Person:, Anzahl:
Person:NicoHulkenberg, Anzahl:1
Qualpos:16, Teamkollege:11/11
VP:-1
Rennpos:11, Teamkollege:13/13
VP:1
Srundpos:11, Teamkollege:14/14
Nach Rennen:966 VP:2
Qualpos:11, Teamkollege:6/6
VP:1
Rennpos:999, Teamkollege:6/6
VP:-1
Srundpos:999, Teamkollege:8/8
Nach Rennen:967 VP:-2
Qualpos:11, Teamkollege:7/7
VP:-3
Rennpos:12, Teamkollege:17/17
VP:-1
Srundpos:7, Teamkollege:8/8
Nach Rennen:968 VP:0
Qualpos:10, Teamkollege:7/7
VP:-1
Rennpos:13, Teamkollege:6/6
VP:-3
Srundpos:10, Teamkollege:7/7
Nach Rennen:969 VP:-4
Qualpos:17, Teamkollege:12/12
VP:-5
Rennpos:999, Teamkollege:13/13
VP:-7
Srundpos:12, Teamkollege:16/16
Nach Rennen:970 VP:-6
Qualpos:11, Teamkollege:7/7
VP:-7
Rennpos:6, Teamkollege:999/999
VP:-5
Srundpos:5, Teamkollege:13/13
Nach Rennen:971 VP:-4
Qualpos:12, Teamkollege:8/8
VP:-5
Rennpos:15, Teamkollege:16/16
VP:-3
Srundpos:17, Teamkollege:2/2
Nach Rennen:972 VP:-4
Qualpos:14, Teamkollege:12/12
VP:-5
Rennpos:12, Teamkollege:999/999
VP:-3
Srundpos:7, Teamkollege:15/15
Nach Rennen:973 VP:-2
update f1_Person set tmp_vp=-23 where f1_Person = 935; -- 0.225 ms
статистика