| 1 |
- SELECT sr.*, ht.name, atm.name FROM `SoccerResults` sr inner join Team ht on homeTeamId = ht.id inner JOIN Team atm on awayTeamId = atm.id WHERE sr.leagueId = (SELECT id FROM League WHere name = 'mls') AND (awayScore = -1 OR homeScore = -1) AND DATE(gameDate) < DATE(NOW());
|
