C.A.C. Basketball
League Sign Up
Wall of Champions
Contact Us
Map & Directions
Hall of Fame
Blog Archives
Pick-Up Times
Rules 4v4
Rules 5v5
Message Boards
Waiver
3 on 3 Tourneys
5 v 5 Leagues
5v5 Draft East F15
5v5 Draft W16
A 5v5 W16
B1 5v5 W16
B1 5v5 West F15
B2 5v5 Atlantic W16
B2 5v5 Central W16
B2 5v5 East W16
B2 5v5 Mid W16
B2 5v5 North W16
B2 5v5 Pacific W15
B2 5v5 South W16
B2 5v5 West W16
Co-Ed 5v5 S14
Co-Ed 5v5 East W14
Co-Ed W16
Corporate 5v5 East W16
Corporate 5v5 North W16
Corporate 5v5 South W15
Corporate 5v5 West W16
4 v 4 Leagues
A DRAFT W15
B Draft East W16
B Draft West W16
B2 4v4 East W16
B2 4v4 West W16
Franchise Draft W16
Lunch League S10
OVER30 W16
Sat Draft W16
Sunday AM W16
W5v5 W16
Videos
News

All Time Stats (minimum 30 games)

League Records

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.league_id = l.league_id and s.week_id <= 22 AND p.player_id = s.player_i' 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, p.player_id FROM player p, stats s, league l WHERE league_type in () and s.league_id = l.league_id and s.week_id <= 22 AND p.player_id = s.player_id AND l.league_id = s.league_id and season='S' GROUP BY p.player_id having games >= 30 ORDER BY playervalue DESC LIMIT 0 , 20;
Player Rater
#PlayerRatingGP

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 <= 22 AND p.player_id = s.player_id AND l.league_id = s.league_' at line 1
SELECT avg(points) as stat , count(stat_id) as games, player_name, p.player_id, sum(points) as sumstat FROM player p, stats s, league l WHERE l.league_type in () and s.week_id <= 22 AND p.player_id = s.player_id AND l.league_id = s.league_id and season='S' GROUP BY p.player_id having games >= 30 ORDER BY stat DESC LIMIT 0 , 30;
Points Per Game
#PlayerTotalAvgGP

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 <= 22 AND p.player_id = s.player_id AND l.league_id = s.league_i' at line 1
SELECT avg(tp_md ) as stat , count(stat_id) as games, player_name, p.player_id, sum( tp_md ) AS md, sum( tp_att ) AS att FROM league l, player p, stats s WHERE l.league_type in () and s.week_id <= 22 AND p.player_id = s.player_id AND l.league_id = s.league_id and l.league_id > 133 and season='S' GROUP BY p.player_id having games >= 15 ORDER BY stat DESC LIMIT 0 , 20;
3s Per Game
#PlayerTotalAvgGP

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 <= 22 AND p.player_id = s.player_id AND l.league_id = s.league_' at line 1
SELECT avg(steals) as stat , count(stat_id) as games, player_name, p.player_id, sum(steals) as sumstat FROM player p, stats s, league l WHERE l.league_type in () and s.week_id <= 22 AND p.player_id = s.player_id AND l.league_id = s.league_id and season='S' GROUP BY p.player_id having games >= 30 ORDER BY stat DESC LIMIT 0 , 30;
Steals Per Game
#PlayerTotalAvgGP

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.league_id <400 AND s.week_id <=22 AND season = 'S' AND p.player_id ' at line 7
SELECT ( ( sum( assists ) ) / count( stat_id ) ) AS stat, count( p.player_id ) AS games, player_name, p.player_id, sum( assists ) AS sumstat FROM player p, stats s, league l WHERE l.league_type in () AND s.league_id <400 AND s.week_id <=22 AND season = 'S' AND p.player_id = s.player_id AND l.league_id = s.league_id GROUP BY p.player_id HAVING games >=30 ORDER BY stat DESC LIMIT 0 , 20
Assists Per Game
#PlayerTotalAvgGP

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 <= 22 AND p.player_id = s.player_id AND l.league_id = s.league_i' at line 1
SELECT ((sum( rebounds )+sum(ob))/ count( stat_id )) as stat , count(stat_id) as games, player_name, p.player_id, (sum( rebounds )+sum(ob)) as sumstat FROM player p, stats s, league l WHERE l.league_type in () and s.week_id <= 22 AND p.player_id = s.player_id AND l.league_id = s.league_id and season='S' GROUP BY p.player_id having games >= 30 ORDER BY stat DESC LIMIT 0 , 20;
Rebounds Per Game
#PlayerTotalAvgGP

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 <= 22 AND p.player_id = s.player_id AND l.league_id = s.league_' at line 1
SELECT avg(blocks) as stat , count(stat_id) as games, player_name, p.player_id, sum(blocks) as sumstat FROM player p, stats s, league l WHERE l.league_type in () and s.week_id <= 22 AND p.player_id = s.player_id AND l.league_id = s.league_id and season='S' GROUP BY p.player_id having games >= 30 ORDER BY stat DESC LIMIT 0 , 30;
Blocks Per Game
#PlayerTotalAvgGP

This Is New Functionality

Please contact me with further suggestions or tweaks: send comments (thinkel@orcapack.com)