Profile
Stats
Games
Form
|
|
Sorry but there are no league results for this season |
|
|
League Stats |
Description |
Total |
Percentage |
Total number of matches |
0 |
|
Number of home wins |
|
0.0% |
Number of away wins |
|
0.0% |
Number of draws |
|
0.0% |
Total number of goals |
0 |
|
Total number of home goals |
|
0.0% |
Total number of away goals |
|
0.0% |
|
|
Sorry there are currently no fixtures for this League |
Sorry there are no current results for this League | |
|
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=''
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 |
| |
|
|
|