SELECT TeamID, Name, P,W,D,L,F,A,CONVERT((F-A), SIGNED)as 'GD',PTS, 
(SELECT count(goals.TeamID) FROM goals INNER JOIN fixtures 
        ON (goals.FixtureID = fixtures.FixtureID) WHERE goals.TeamID = teams.TeamID AND fixtures.Date = CURDATE() AND goals.event = 'goal' GROUP BY goals.TeamID) AS 'efor'
 ,(SELECT count(goals.TeamID) FROM goals INNER JOIN fixtures 
        ON (goals.FixtureID = fixtures.FixtureID) WHERE goals.TeamID = fixtures.AwayTeam AND teams.TeamID = fixtures.HomeTeam AND fixtures.Date = CURDATE() AND goals.event = 'goal' GROUP BY goals.TeamID) AS 'eagainst'
 FROM teams WHERE leagueID = 1 ORDER BY PTS DESC,GD DESC;