Big Slick Poker Club

Games on Tuesdays

Total

	Games	Total Pot	Average Pot	Player-Games	Players/ Game
Total	18	$385.00	$21.39	73	4.06

Locations

Location	Games	Total Pot	Average Pot	Player-Games	Players/ Game
Dan's Den	2	$39.00	$19.50	7	3.50
CVC 1.0	1	$15.00	$15.00	3	3.00
Tom's Crib	15	$331.00	$22.07	63	4.20
Total	18	$385.00	$21.39	73	4.06

Types

Type	Games	Total Pot	Average Pot	Player-Games	Players/Game
Cash	2	$31.00	$15.50	7	3.50
Tourny	16	$354.00	$22.13	66	4.13
Total	18	$385.00	$21.39	73	4.06

MDB2 Error: syntax error
_doQuery: [Error message: Could not execute statement] [Last executed query: SELECT i.fname, i.lname, i.active, i.nickname, s.playerid, s.valid, count( s.playerid ) AS gamesplayed, sum( s.amtbuyin ) AS amtbuyin, sum( s.amtcashout ) AS amtcashout, sum( s.amtcashout ) - sum( s.amtbuyin ) AS difference, ((sum(s.amtcashout) - sum(s.amtbuyin)) / sum(s.amtbuyin)) as roi, round((sum(s.amtcashout) - sum( s.amtbuyin ))/count(s.playerid), 2) as average FROM player_stats s, player_info i, game_info g WHERE i.id = s.playerid AND s.valid = 1 AND g.id = s.gameid AND dayofweek(g.date)=3 GROUP BY s.playerid ORDER BY ] [Native code: 1064] [Native message: 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 '' at line 12]