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: 1550537122
Cache:
Anfangszeit: 1550537122.6442
MP LOGGED_IN:
PHP_SELF::/outcomes/race/1974/Nuerburgring/classification SCRIPT_URL:/outcomes/race/1974/Nuerburgring/classification
URL:outcomes:6:
URL:race:2:
### URL: //outcomes/race index: 2 Skript: "Ergebnisse/Rennen.php" Header: "Ergebnisse/Rennen_h.php"
select * from f1_Wetter_en; -- 0.185 ms
Jahr :1974
Ort :60
Strecke:
Rennen :246
select max(prio) as p, f1_Bild.f1_Bild, x, y, ((nachbearbeiten is not null) or (spaeter is not null)) as n, copyright, inhaber from f1_AufBild left join f1_Bild using(f1_Bild) where f1_AufBild.typ="r" and f1_AufBild.wert="246" and f1_Bild.copyright <= 0 group by f1_AufBild.f1_Bild order by p desc, qualitaet desc, spektakulaer desc, x desc limit 5; -- 1.793 ms
Kein passender Alias für "246" (Typ:r) gefunden!
select f1_Rennergebnis.f1_Person, f1_Rennergebnis.f1_Produkt, tmp_team, f1_Firma.kurzname, vorname, nachname, startnummer, k, zeit, startposition, q, qzeit, s, srunde, runden from f1_Rennergebnis left join f1_Person using (f1_Person) left join f1_Firma on f1_Firma.f1_Firma=f1_Rennergebnis.tmp_team where f1_Rennen=246 and q >= -2 order by k <= 0, (abs(k) + k), runden desc, (zeit) desc, q <= 0, abs(q), s <= 0, s; -- 0.527 msselect name, f1_Ereignis.f1_Ereignis, kategorie, runde from f1_PersonInEreignis left join f1_Ereignis using(f1_Ereignis) left join f1_Ereigniskat_en on f1_Ereigniskat_en.id = kategorie where f1_Rennen=246 and f1_Person =613 and (aenderung <= -100 and runde >= 0); -- 0.261 msselect name, f1_Ereignis.f1_Ereignis, kategorie, runde from f1_PersonInEreignis left join f1_Ereignis using(f1_Ereignis) left join f1_Ereigniskat_en on f1_Ereigniskat_en.id = kategorie where f1_Rennen=246 and f1_Person =651 and (aenderung <= -100 and runde >= 0); -- 0.180 msselect name, f1_Ereignis.f1_Ereignis, kategorie, runde from f1_PersonInEreignis left join f1_Ereignis using(f1_Ereignis) left join f1_Ereigniskat_en on f1_Ereigniskat_en.id = kategorie where f1_Rennen=246 and f1_Person =614 and (aenderung <= -100 and runde >= 0); -- 0.200 msselect name, f1_Ereignis.f1_Ereignis, kategorie, runde from f1_PersonInEreignis left join f1_Ereignis using(f1_Ereignis) left join f1_Ereigniskat_en on f1_Ereigniskat_en.id = kategorie where f1_Rennen=246 and f1_Person =574 and (aenderung <= -100 and runde >= 0); -- 0.231 msselect name, f1_Ereignis.f1_Ereignis, kategorie, runde from f1_PersonInEreignis left join f1_Ereignis using(f1_Ereignis) left join f1_Ereigniskat_en on f1_Ereigniskat_en.id = kategorie where f1_Rennen=246 and f1_Person =394 and (aenderung <= -100 and runde >= 0); -- 0.217 msselect name, f1_Ereignis.f1_Ereignis, kategorie, runde from f1_PersonInEreignis left join f1_Ereignis using(f1_Ereignis) left join f1_Ereigniskat_en on f1_Ereigniskat_en.id = kategorie where f1_Rennen=246 and f1_Person =598 and (aenderung <= -100 and runde >= 0); -- 0.170 msselect name, f1_Ereignis.f1_Ereignis, kategorie, runde from f1_PersonInEreignis left join f1_Ereignis using(f1_Ereignis) left join f1_Ereigniskat_en on f1_Ereigniskat_en.id = kategorie where f1_Rennen=246 and f1_Person =697 and (aenderung <= -100 and runde >= 0); -- 0.212 msselect name, f1_Ereignis.f1_Ereignis, kategorie, runde from f1_PersonInEreignis left join f1_Ereignis using(f1_Ereignis) left join f1_Ereigniskat_en on f1_Ereigniskat_en.id = kategorie where f1_Rennen=246 and f1_Person =403 and (aenderung <= -100 and runde >= 0); -- 0.249 msselect name, f1_Ereignis.f1_Ereignis, kategorie, runde from f1_PersonInEreignis left join f1_Ereignis using(f1_Ereignis) left join f1_Ereigniskat_en on f1_Ereigniskat_en.id = kategorie where f1_Rennen=246 and f1_Person =379 and (aenderung <= -100 and runde >= 0); -- 0.212 msselect name, f1_Ereignis.f1_Ereignis, kategorie, runde from f1_PersonInEreignis left join f1_Ereignis using(f1_Ereignis) left join f1_Ereigniskat_en on f1_Ereigniskat_en.id = kategorie where f1_Rennen=246 and f1_Person =571 and (aenderung <= -100 and runde >= 0); -- 0.192 msselect name, f1_Ereignis.f1_Ereignis, kategorie, runde from f1_PersonInEreignis left join f1_Ereignis using(f1_Ereignis) left join f1_Ereigniskat_en on f1_Ereigniskat_en.id = kategorie where f1_Rennen=246 and f1_Person =136 and (aenderung <= -100 and runde >= 0); -- 0.202 msselect name, f1_Ereignis.f1_Ereignis, kategorie, runde from f1_PersonInEreignis left join f1_Ereignis using(f1_Ereignis) left join f1_Ereigniskat_en on f1_Ereigniskat_en.id = kategorie where f1_Rennen=246 and f1_Person =556 and (aenderung <= -100 and runde >= 0); -- 0.212 msselect name, f1_Ereignis.f1_Ereignis, kategorie, runde from f1_PersonInEreignis left join f1_Ereignis using(f1_Ereignis) left join f1_Ereigniskat_en on f1_Ereigniskat_en.id = kategorie where f1_Rennen=246 and f1_Person =172 and (aenderung <= -100 and runde >= 0); -- 0.187 msselect name, f1_Ereignis.f1_Ereignis, kategorie, runde from f1_PersonInEreignis left join f1_Ereignis using(f1_Ereignis) left join f1_Ereigniskat_en on f1_Ereigniskat_en.id = kategorie where f1_Rennen=246 and f1_Person =110 and (aenderung <= -100 and runde >= 0); -- 0.154 msselect name, f1_Ereignis.f1_Ereignis, kategorie, runde from f1_PersonInEreignis left join f1_Ereignis using(f1_Ereignis) left join f1_Ereigniskat_en on f1_Ereigniskat_en.id = kategorie where f1_Rennen=246 and f1_Person =362 and (aenderung <= -100 and runde >= 0); -- 0.262 msselect name, f1_Ereignis.f1_Ereignis, kategorie, runde from f1_PersonInEreignis left join f1_Ereignis using(f1_Ereignis) left join f1_Ereigniskat_en on f1_Ereigniskat_en.id = kategorie where f1_Rennen=246 and f1_Person =496 and (aenderung <= -100 and runde >= 0); -- 0.180 msselect name, f1_Ereignis.f1_Ereignis, kategorie, runde from f1_PersonInEreignis left join f1_Ereignis using(f1_Ereignis) left join f1_Ereigniskat_en on f1_Ereigniskat_en.id = kategorie where f1_Rennen=246 and f1_Person =391 and (aenderung <= -100 and runde >= 0); -- 0.195 msselect name, f1_Ereignis.f1_Ereignis, kategorie, runde from f1_PersonInEreignis left join f1_Ereignis using(f1_Ereignis) left join f1_Ereigniskat_en on f1_Ereigniskat_en.id = kategorie where f1_Rennen=246 and f1_Person =253 and (aenderung <= -100 and runde >= 0); -- 0.211 msselect name, f1_Ereignis.f1_Ereignis, kategorie, runde from f1_PersonInEreignis left join f1_Ereignis using(f1_Ereignis) left join f1_Ereigniskat_en on f1_Ereigniskat_en.id = kategorie where f1_Rennen=246 and f1_Person =511 and (aenderung <= -100 and runde >= 0); -- 0.230 msselect name, f1_Ereignis.f1_Ereignis, kategorie, runde from f1_PersonInEreignis left join f1_Ereignis using(f1_Ereignis) left join f1_Ereigniskat_en on f1_Ereigniskat_en.id = kategorie where f1_Rennen=246 and f1_Person =140 and (aenderung <= -100 and runde >= 0); -- 0.199 msselect name, f1_Ereignis.f1_Ereignis, kategorie, runde from f1_PersonInEreignis left join f1_Ereignis using(f1_Ereignis) left join f1_Ereigniskat_en on f1_Ereigniskat_en.id = kategorie where f1_Rennen=246 and f1_Person =664 and (aenderung <= -100 and runde >= 0); -- 0.193 msselect name, f1_Ereignis.f1_Ereignis, kategorie, runde from f1_PersonInEreignis left join f1_Ereignis using(f1_Ereignis) left join f1_Ereigniskat_en on f1_Ereigniskat_en.id = kategorie where f1_Rennen=246 and f1_Person =289 and (aenderung <= -100 and runde >= 0); -- 0.238 msselect name, f1_Ereignis.f1_Ereignis, kategorie, runde from f1_PersonInEreignis left join f1_Ereignis using(f1_Ereignis) left join f1_Ereigniskat_en on f1_Ereigniskat_en.id = kategorie where f1_Rennen=246 and f1_Person =437 and (aenderung <= -100 and runde >= 0); -- 0.218 msselect name, f1_Ereignis.f1_Ereignis, kategorie, runde from f1_PersonInEreignis left join f1_Ereignis using(f1_Ereignis) left join f1_Ereigniskat_en on f1_Ereigniskat_en.id = kategorie where f1_Rennen=246 and f1_Person =447 and (aenderung <= -100 and runde >= 0); -- 0.241 msselect name, f1_Ereignis.f1_Ereignis, kategorie, runde from f1_PersonInEreignis left join f1_Ereignis using(f1_Ereignis) left join f1_Ereigniskat_en on f1_Ereigniskat_en.id = kategorie where f1_Rennen=246 and f1_Person =329 and (aenderung <= -100 and runde >= 0); -- 0.187 msselect name, f1_Ereignis.f1_Ereignis, kategorie, runde from f1_PersonInEreignis left join f1_Ereignis using(f1_Ereignis) left join f1_Ereigniskat_en on f1_Ereigniskat_en.id = kategorie where f1_Rennen=246 and f1_Person =570 and (aenderung <= -100 and runde >= 0); -- 0.190 msselect name, f1_Ereignis.f1_Ereignis, kategorie, runde from f1_PersonInEreignis left join f1_Ereignis using(f1_Ereignis) left join f1_Ereigniskat_en on f1_Ereigniskat_en.id = kategorie where f1_Rennen=246 and f1_Person =758 and (aenderung <= -100 and runde >= 0); -- 0.205 msselect name, f1_Ereignis.f1_Ereignis, kategorie, runde from f1_PersonInEreignis left join f1_Ereignis using(f1_Ereignis) left join f1_Ereigniskat_en on f1_Ereigniskat_en.id = kategorie where f1_Rennen=246 and f1_Person =390 and (aenderung <= -100 and runde >= 0); -- 0.183 msselect name, f1_Ereignis.f1_Ereignis, kategorie, runde from f1_PersonInEreignis left join f1_Ereignis using(f1_Ereignis) left join f1_Ereigniskat_en on f1_Ereigniskat_en.id = kategorie where f1_Rennen=246 and f1_Person =513 and (aenderung <= -100 and runde >= 0); -- 0.288 msselect name, f1_Ereignis.f1_Ereignis, kategorie, runde from f1_PersonInEreignis left join f1_Ereignis using(f1_Ereignis) left join f1_Ereigniskat_en on f1_Ereigniskat_en.id = kategorie where f1_Rennen=246 and f1_Person =654 and (aenderung <= -100 and runde >= 0); -- 0.199 msselect name, f1_Ereignis.f1_Ereignis, kategorie, runde from f1_PersonInEreignis left join f1_Ereignis using(f1_Ereignis) left join f1_Ereigniskat_en on f1_Ereigniskat_en.id = kategorie where f1_Rennen=246 and f1_Person =270 and (aenderung <= -100 and runde >= 0); -- 0.157 msselect name, f1_Ereignis.f1_Ereignis, kategorie, runde from f1_PersonInEreignis left join f1_Ereignis using(f1_Ereignis) left join f1_Ereigniskat_en on f1_Ereigniskat_en.id = kategorie where f1_Rennen=246 and f1_Person =97 and (aenderung <= -100 and runde >= 0); -- 0.242 ms
outcomes
Kein passender Alias für "77" (Typ:o) gefunden!
Kein passender Alias für "76" (Typ:o) gefunden!