BergensBowl

League Win Ratios

Overdogs


Feil i "SELECT AVG(SIGN(CAST(tmr1.Score AS Unsigned)-CAST(tmr2.Score AS Unsigned)))/2.0+ 0.5 AS wr, COUNT(tmr1.Team_Id) AS nom, SIGN(ROUND((IFNULL((SELECT sqTmr1.Team_Rating FROM TEAM_MATCH_REPORT sqTmr1, MATCH_REPORT sqMr WHERE sqMr.DateValue differenceNumber of MatchesWin Ratio
Feil i "SELECT AVG(SIGN(CAST(tmr1.Score AS Unsigned)-CAST(tmr2.Score AS Unsigned)))/2.0+ 0.5 AS wr, COUNT(tmr1.Team_Id) AS nom, CAST((IFNULL((SELECT sqTmr1.Team_Rating FROM TEAM_MATCH_REPORT sqTmr1, MATCH_REPORT sqMr WHERE sqMr.DateValue differenceNumber of MatchesWin Ratio

Races


Feil i "SELECT r.id AS RId, r.Race_Name, COUNT(DISTINCT t1.Id) AS antlag, r.Def_Small_Logo, AVG(SIGN(CAST(tmr1.Score AS Unsigned)-CAST(tmr2.Score AS Unsigned)))/2.0+0.5 AS wr, COUNT(tmr1.Team_Id) AS nom FROM TEAM_MATCH_REPORT tmr1, TEAM_MATCH_REPORT tmr2, MATCH_REPORT mr, RACE r, TEAM t1 WHERE tmr1.Match_Report_Id=mr.Id AND tmr2.Match_Report_Id=mr.Id AND tmr1.Team_Id=t1.Id AND t1.Race_Id=r.Id AND NOT(tmr1.Team_Id=tmr2.Team_Id) AND mr.Status='Played' GROUP BY r.Id ORDER BY wr DESC, nom DESC": BIGINT UNSIGNED value is out of range in '(cast(`krokodille`.`tmr1`.`Score` as unsigned) - cast(`krokodille`.`tmr2`.`Score` as unsigned))'
RaceNumber of TeamsNumber of MatchesWin Ratio

Teams


Feil i "SELECT t1.Id, t1.Name, t1.Small_Logo, r.Def_Small_Logo, AVG(SIGN(CAST(tmr1.Score AS Unsigned)-CAST(tmr2.Score AS Unsigned)))/2.0 + 0.5 AS wr, COUNT(tmr1.Team_Id) AS nom FROM TEAM_MATCH_REPORT tmr1, TEAM_MATCH_REPORT tmr2, MATCH_REPORT mr, TEAM t1, RACE r WHERE tmr1.Match_Report_Id=mr.Id AND tmr2.Match_Report_Id=mr.Id AND tmr1.Team_Id=t1.Id AND NOT(t1.Id=tmr2.Team_Id) AND t1.Race_Id = r.id AND mr.Status='Played' GROUP BY t1.Id ORDER BY wr DESC, nom DESC": BIGINT UNSIGNED value is out of range in '(cast(`krokodille`.`tmr1`.`Score` as unsigned) - cast(`krokodille`.`tmr2`.`Score` as unsigned))'
TeamNumber of MatchesWin Ratio