SELECT t.team_id, t.team_name,t.league_id,sum(r.played) played, sum(r.w) win, sum(r.d) draw, sum(r.l) loss, sum(r.gf) glsf, sum(r.ga) glsa, sum(r.gd) gd, sum(r.pts) pts,l.league_name
FROM BB_teams t,BB_results r, BB_leagues l, BB_fixtures f
WHERE t.team_id = r.team_id
AND l.league_id=t.league_id
AND r.league_id=t.league_id
AND r.match_id=f.match_id
AND l.league_id='d46b834cd558455803a5c77ab59110b3'
AND f.week>=10
AND f.week<=5
GROUP by l.league_id, t.team_Name,r.team_id
ORDER BY pts DESC,
gd DESC,
glsf DESC,
glsa ASC,
win DESC,
draw DESC,
loss ASC
Sorry but there are no league results for this season |
|