Summer 2021: B 5v5 Arlington League Champs: TAP All-Stars

    Scores, Box Scores & Write-Ups

Error Performing Query: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'and s.week_id <= AND p.player_id = s.player_id AND r.player_id = p.player_id AN' at line 1
SELECT avg(points) as stat , count(stat_id) as games, player_name, team_name, p.player_id, t.team_id FROM roster r, teams t, player p, stats s WHERE s.league_id = and s.week_id <= AND p.player_id = s.player_id AND r.player_id = p.player_id AND r.team_id = t.team_id AND r.league_id = s.league_id and season='S' GROUP BY p.player_id having games >= 0 ORDER BY stat DESC LIMIT 0 , 30;
Points Per Game

Error Performing Query: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'and s.week_id <= AND p.player_id = s.player_id AND r.player_id = p.player_id AN' at line 1
SELECT (((sum( s.points ) - (SUM( s.turn)) + ( 1.5 * sum( s.ob ) ) + ( 2 * (sum( s.assists )*1.5) ) ) + ((1.5*sum(s.rebounds))+(2*(sum(s.steals)+sum(blocks))))) /count(stat_id)) as playervalue, count(stat_id) as games, player_name, team_name, p.player_id, t.team_id FROM roster r, teams t, player p, stats s WHERE s.league_id = and s.week_id <= AND p.player_id = s.player_id AND r.player_id = p.player_id AND r.team_id = t.team_id AND r.league_id = s.league_id and season='S' GROUP BY p.player_id having games >= 0 ORDER BY playervalue DESC LIMIT 0 , 30;
Player Rater

Error Performing Query: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'and s.week_id <= AND p.player_id = s.player_id AND r.player_id = p.player_id AN' at line 1
SELECT ((sum( rebounds )+sum(ob))/ count( stat_id )) as stat , count(stat_id) as games, player_name, team_name, p.player_id, t.team_id FROM roster r, teams t, player p, stats s WHERE s.league_id = and s.week_id <= AND p.player_id = s.player_id AND r.player_id = p.player_id AND r.team_id = t.team_id AND r.league_id = s.league_id and season='S' GROUP BY p.player_id having games >= 0 ORDER BY stat DESC LIMIT 0 , 30;
Rebounds Per Game

Error Performing Query: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'and s.week_id <= AND p.player_id = s.player_id AND r.player_id = p.player_id AN' at line 1
SELECT avg(tp_md ) as stat , count(stat_id) as games, player_name, team_name, p.player_id, t.team_id, sum( tp_md ) AS md, sum( tp_att ) AS att FROM roster r, teams t, player p, stats s WHERE s.league_id = and s.week_id <= AND p.player_id = s.player_id AND r.player_id = p.player_id AND r.team_id = t.team_id AND r.league_id = s.league_id and season='S' GROUP BY p.player_id having games >= 0 ORDER BY stat DESC LIMIT 0 , 15;
3s Per Game

Error Performing Query: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'and s.week_id <= AND p.player_id = s.player_id AND r.player_id = p.player_id AN' at line 1
SELECT ((sum( assists ))/ count( stat_id )) as stat , count(stat_id) as games, player_name, team_name, p.player_id, t.team_id FROM roster r, teams t, player p, stats s WHERE s.league_id = and s.week_id <= AND p.player_id = s.player_id AND r.player_id = p.player_id AND r.team_id = t.team_id AND r.league_id = s.league_id and season='S' GROUP BY p.player_id having games >= 0 ORDER BY stat DESC LIMIT 0 , 30;
Assists Per Game