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')='27' AND YEAR(start_time)=YEAR(NOW()) ORDER BY start_time ASC,id ASC LIMIT 8