Anonymous

SELECT TeamID
	, `Name`
	, (SELECT COUNT(TeamID) 
		FROM goals INNER JOIN fixtures ON (goals.FixtureID = fixtures.FixtureID) 
		WHERE goals.TeamID = teams.TeamID AND goals.event = 'goal') AS 'gf'
	, (SELECT COUNT(TeamID) 
		FROM goals INNER JOIN fixtures ON (goals.FixtureID = fixtures.FixtureID) 
		WHERE goals.TeamID != teams.TeamID AND (teams.TeamID = fixtures.AwayTeam || teams.TeamID = fixtures.HomeTeam) AND goals.event = 'goal') AS 'ga'
	, F+gf AS 'GFTODAY'
	, A+ga AS 'GATODAY'
	,GFTODAY-GATODAY AS 'GDTODAY'
FROM teams
WHERE LeagueID = 1;