 | | | championship positions | |
FALK-DEBUG:db_default:FALK
db_default:FALK
login:, bid:
Kein Cookie
db_default:FALK
Jetzt: 1369518644
Cache:
Anfangszeit: 1369518644.6932
MP LOGGED_IN:
PHP_SELF::/statistics/championship-positions SCRIPT_URL:/statistics/championship-positions
URL:statistics:7:
URL:championship-positions:8:
URL: http://f1-facts.com/statistics/championship-positions index: 2 selbst: Statistik/wmplaetze Header:
statistics
Tabelle:f1_Person gk:>
select wer, count(*) as summe, aktiv is not null as akt, sum(tmp_wmpos>10) as anz_rest, sum(tmp_wmpos=1) as anz_pos_1, sum(tmp_wmpos=2) as anz_pos_2, sum(tmp_wmpos=3) as anz_pos_3, sum(tmp_wmpos=4) as anz_pos_4, sum(tmp_wmpos=5) as anz_pos_5, sum(tmp_wmpos=6) as anz_pos_6, sum(tmp_wmpos=7) as anz_pos_7, sum(tmp_wmpos=8) as anz_pos_8, sum(tmp_wmpos=9) as anz_pos_9, sum(tmp_wmpos=10) as anz_pos_10 from f1_InSaison left join f1_Person on f1_Person.f1_Person = f1_InSaison.wer where wer>0 and tmp_wmpos > 0 group by wer having anz_pos_1 > 0 or anz_pos_2 > 0 or anz_pos_3 > 0 or anz_pos_4 > 0 or anz_pos_5 > 0 or anz_pos_6 > 0 or anz_pos_7 > 0 or anz_pos_8 > 0 or anz_pos_9 > 0 order by anz_pos_1 desc, anz_pos_2 desc, anz_pos_3 desc, anz_pos_4 desc, anz_pos_5 desc, anz_pos_6 desc, anz_pos_7 desc, anz_pos_8 desc, anz_pos_9 desc, anz_pos_10 desc