Team Stats - Regular Season - 0

$res_team=sendSql($db,"SELECT CONCAT('',s.team_id,'') AS 'TM', Count(*) AS 'Gs', round($aggFunc(s.fgm),$roundDigits) AS 'FGM', round($aggFunc(s.fga),$roundDigits) AS 'FGA', right(round($aggFunc(s.fgm)/$aggFunc(s.fga),2),3) AS 'FG%', round($aggFunc(s.3pm),$roundDigits) AS '3PM', round($aggFunc(s.3pa),$roundDigits) AS '3PA', right(round($aggFunc(s.3pm)/$aggFunc(s.3pa),2),3) AS '3P%', round($aggFunc(s.ftm),$roundDigits) AS 'FTM', round($aggFunc(s.fta),$roundDigits) AS 'FTA', right(round($aggFunc(s.ftm)/$aggFunc(s.fta),2),3) AS 'FT%', round($aggFunc(s.oreb),$roundDigits) AS 'OFF', round($aggFunc(s.dreb),$roundDigits) AS 'DEF', round($aggFunc(s.rebs),$roundDigits) AS 'REB', round($aggFunc(s.ast),$roundDigits) AS 'AST', round($aggFunc(s.stl),$roundDigits) AS 'STL', round($aggFunc(s.blk),$roundDigits) AS 'BLK', round($aggFunc(s.tos),$roundDigits) AS 'TO', round($aggFunc(s.pf),$roundDigits) AS 'PF', round($aggFunc(s.pip),$roundDigits) AS 'PIP', round($aggFunc(s.scp),$roundDigits) AS 'SCP', round($aggFunc(s.fbp),$roundDigits) AS 'FBP', round($aggFunc(s.bep),$roundDigits) AS 'BEP', round($aggFunc(s.pts),$roundDigits) AS 'PTS', round($aggFunc(s.pts)-$aggFunc(o.pts),$roundDigits) AS 'MRG' FROM 3_stats s LEFT JOIN (select game_id, opponent_id as team_id, Round(avg(pts),1) as pts from 3_stats WHERE week_type like '$selectedWeekType%' group by 1,2) o on s.team_id = o.team_id and s.game_id = o.game_id WHERE s.week_type like '$selectedWeekType%' AND s.week BETWEEN $selectedWeekMin AND $selectedWeekMax GROUP BY 1 ORDER BY $sortBy DESC;"); // OPPONENT $res_opp= sendSql($db,"SELECT CONCAT('',s.opponent_id,'') AS 'TM', Count(*) AS 'Gs', round($aggFunc(s.fgm),$roundDigits) AS 'FGM', round($aggFunc(s.fga),$roundDigits) AS 'FGA', right(round($aggFunc(s.fgm)/$aggFunc(s.fga),2),3) AS 'FG%', round($aggFunc(s.3pm),$roundDigits) AS '3PM', round($aggFunc(s.3pa),$roundDigits) AS '3PA', right(round($aggFunc(s.3pm)/$aggFunc(s.3pa),2),3) AS '3P%', round($aggFunc(s.ftm),$roundDigits) AS 'FTM', round($aggFunc(s.fta),$roundDigits) AS 'FTA', right(round($aggFunc(s.ftm)/$aggFunc(s.fta),2),3) AS 'FT%', round($aggFunc(s.oreb),$roundDigits) AS 'OFF', round($aggFunc(s.dreb),$roundDigits) AS 'DEF', round($aggFunc(s.rebs),$roundDigits) AS 'REB', round($aggFunc(s.ast),$roundDigits) AS 'AST', round($aggFunc(s.stl),$roundDigits) AS 'STL', round($aggFunc(s.blk),$roundDigits) AS 'BLK', round($aggFunc(s.tos),$roundDigits) AS 'TO', round($aggFunc(s.pf),$roundDigits) AS 'PF', round($aggFunc(s.pip),$roundDigits) AS 'PIP', round($aggFunc(s.scp),$roundDigits) AS 'SCP', round($aggFunc(s.fbp),$roundDigits) AS 'FBP', round($aggFunc(s.bep),$roundDigits) AS 'BEP', round($aggFunc(s.pts),$roundDigits) AS 'PTS', round($aggFunc(o.pts)-$aggFunc(s.pts),$roundDigits) AS 'MRG' FROM 3_stats s LEFT JOIN (select game_id, team_id, Round(avg(pts),1) as pts from 3_stats WHERE week_type like '$selectedWeekType%' group by 1,2) o on s.opponent_id = o.team_id and s.game_id = o.game_id WHERE s.week_type like '$selectedWeekType%' AND s.week BETWEEN $selectedWeekMin AND $selectedWeekMax GROUP BY s.opponent_id ORDER BY $sortBy;"); // LEAGUE $res_league = sendSql($db,"SELECT 'League' AS 'TM', Count(*) AS 'Gs', round($aggFunc(s.fgm),$roundDigits) AS 'FGM', round($aggFunc(s.fga),$roundDigits) AS 'FGA', right(round($aggFunc(s.fgm)/$aggFunc(s.fga),2),3) AS 'FG%', round($aggFunc(s.3pm),$roundDigits) AS '3PM', round($aggFunc(s.3pa),$roundDigits) AS '3PA', right(round($aggFunc(s.3pm)/$aggFunc(s.3pa),2),3) AS '3P%', round($aggFunc(s.ftm),$roundDigits) AS 'FTM', round($aggFunc(s.fta),$roundDigits) AS 'FTA', right(round($aggFunc(s.ftm)/$aggFunc(s.fta),2),3) AS 'FT%', round($aggFunc(s.oreb),$roundDigits) AS 'OFF', round($aggFunc(s.dreb),$roundDigits) AS 'DEF', round($aggFunc(s.rebs),$roundDigits) AS 'REB', round($aggFunc(s.ast),$roundDigits) AS 'AST', round($aggFunc(s.stl),$roundDigits) AS 'STL', round($aggFunc(s.blk),$roundDigits) AS 'BLK', round($aggFunc(s.tos),$roundDigits) AS 'TO', round($aggFunc(s.pf),$roundDigits) AS 'PF', round($aggFunc(s.pip),$roundDigits) AS 'PIP', round($aggFunc(s.scp),$roundDigits) AS 'SCP', round($aggFunc(s.fbp),$roundDigits) AS 'FBP', round($aggFunc(s.bep),$roundDigits) AS 'BEP', round($aggFunc(s.pts),$roundDigits) AS 'PTS', round($aggFunc(0),$roundDigits) AS 'MRG' FROM 3_stats s WHERE s.week_type like '$selectedWeekType%' AND s.week BETWEEN $selectedWeekMin AND $selectedWeekMax;"); ?>

Statistics

Team Stats - Regular Season - 0

League

Team

Opponents