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,9SELECT 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-11-11','2025-11-12','2025-11-13','2025-11-14','2025-11-15') AND  stat_all.id NOT IN ('0')  ORDER BY   stat_all.date, stat_all.time ASC LIMIT 0,9<br />EXEC-TIME: 0.45 SEKUNDEN<br />EOF!Datei erfolgreich erstellt: /var/www/html/stats/output.html