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 |
| |
|
|
|