SELECT *,DATE_FORMAT(start_time,'%Y%m%d%H%i%s') full_date_time,DATE_FORMAT(start_time,'%m/%d') short_date,DATE_FORMAT(start_time,'%H:%i') hhii,home_team,away_team
,WEEKDAY(start_time) week
,(SELECT logo FROM tvl.team WHERE id=away_team_id) away_logo
,(SELECT name FROM tvl.team WHERE id=away_team_id) away_name
,(SELECT logo FROM tvl.team WHERE id=home_team_id) home_logo
,(SELECT name FROM tvl.team WHERE id=home_team_id) home_name
FROM tvl.game WHERE (disabled_reason='' OR disabled_reason IS NULL) AND DATE_FORMAT(start_time,'%u')='06' AND YEAR(start_time)=YEAR(NOW()) ORDER BY start_time ASC,id ASC LIMIT 8
Game 43 ― 02/11 (六)
16:00
Game 44 ― 02/11 (六)
18:00
Game 45 ― 02/12 (日)
15:00
Game 46 ― 02/12 (日)
17:00