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, round, season, points1, points2, day, stadium_capacity FROM liga1.viw_game_status_active WHERE  league IN ('BBL','BBL-Pokal')  ORDER BY  date, starttime ASC LIMIT 0,9<pre>Root: /<br />teams: /teams<br />TeamID: /teams/team486<br />Upload: /teams/team486/upload<br />---- INITIAL START -------- <br />Init => 2004064_INIT.JSN<br />Filesize: 6524 bytes <br />File: 2004064_INIT.JSN Read ok<br />- - - - - - - - - - -<br />Scout => 2004064.JSN<br />Filesize: 6150 bytes <br />File: 2004064.JSN Read ok<br />- - - - - - - - - - -<br />---- INITIAL END -------- <br /><br />CurPer: ''<br />ActPer: 'Q1'<br />LastPer: ''<br />GameTime: ''<br />StatStatus: 'N'<br />Q1 => 2004064Q1.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 />SELECT gamestatall.*, DATE_FORMAT(CONCAT(stat_all.date, ' ', stat_all.time), '%Y%m%d%H%i%s') + 0 AS datetime_int, DATEDIFF(stat_all.date,NOW()) as dateDiff, DATE_FORMAT(stat_all.date, '%d.%m.%y') as show_datum, stat_all.team1, stat_all.team2, stat_all.id, DATE_FORMAT(stat_all.time, '%H:%i') as starttime2,  stat_all.date, stat_all.round, stat_all.season, stat_all.points1, stat_all.points2,  stat_all.day, stat_all.league FROM liga1.viw_game_status_all as stat_all  JOIN liga1.viw_gameplans as gamestatall ON gamestatall.id = stat_all.id WHERE  stat_all.league IN ('BBL','BBL-Pokal') AND stat_all.date IN ('2025-12-05','2025-12-06','2025-12-07','2025-12-08','2025-12-09') AND  stat_all.id NOT IN ('0','2004064')  ORDER BY   stat_all.date, stat_all.time ASC LIMIT 0,9<br />EXEC-TIME: 1.13 SEKUNDEN<br />EOF!Datei erfolgreich erstellt: /var/www/html/stats/output.html