SELECT DATE_FORMAT(CONCAT(date, ' ', starttime), '%Y%m%d%H%i%s') + 0 AS datetime_int, DATEDIFF(date,NOW()) as dateDiff, DATE_FORMAT(date, '%d.%m.%y') as show_datum, team_caption1, team_caption2, team1, team2, id, DATE_FORMAT(starttime, '%H:%i') as starttime2, DATE_FORMAT(updtime, '%H:%i:%s') as updtime,  date, round, season, points1, points2, day, stadium_capacity,lastper, pltime, rmtime, actper, curper, statstatus, scorestat_maxlead1, scorestat_maxlead2, viewers, scorestat_bestrun1, scorestat_bestrun2, scouter1, scouter2 FROM liga1.viw_game_status_active WHERE  league IN ('BBL','BBL-Pokal')  ORDER BY  date, starttime ASC LIMIT 0,9<pre>TeamID: SpielID: Root: /<br />teams: /teams<br />TeamID: /teams<br />Upload: /teams<br />---- INITIAL START -------- <br />Init => _INIT.JSN<br />FNF<br />Scout => .JSN<br />FNF<br />---- INITIAL END -------- <br /><br />CurPer: ''<br />ActPer: ''<br />LastPer: ''<br />GameTime: ''<br />StatStatus: ''<br />Q1 => Q1.JSN<br />Q2 => Q2.JSN<br />Q3 => Q3.JSN<br />Q4 => Q4.JSN<br />X1 => X1.JSN<br />X2 => X2.JSN<br />X3 => X3.JSN<br />X4 => X4.JSN<br />X5 => X5.JSN<br />X6 => X6.JSN<br />X7 => X7.JSN<br />X8 => X8.JSN<br />X9 => X9.JSN<br />-x-x-x-x-x-x-x-x-x-x-x-x-x-x-x-x-x-x-x-x-x-x-x-x-x <br /><br />EXEC-TIME: 1.02 SEKUNDEN<br />EOF!Datei erfolgreich erstellt: /var/www/html/stats/output.html