(mysqli): SELECT * FROM cms LIMIT 1  

(mysqli): SELECT code FROM menus WHERE type ='tree'  
Eastern Poker Tour - Pub Poker in Rhode Island, Massachusetts and New Hampshire

(mysqli): SELECT pts.player_id as id, CONCAT(p.last, ', ', p.first) as name, p.email, p.phone, pts.action FROM player_pts pts INNER JOIN player p ON p.id = pts.player_id WHERE pts.event_id = 31134 AND pts.action = 'CHECK_IN' ORDER BY p.last  

(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM player_pts AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 31134 AND pts.player_id = 38204 GROUP BY pts.player_id  

(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM bounty_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 31134 AND pts.player_id = 38204 GROUP BY pts.player_id  

(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM participation_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 31134 AND pts.player_id = 38204 GROUP BY pts.player_id  

(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM player_pts AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 31134 AND pts.player_id = 41362 GROUP BY pts.player_id  

(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM bounty_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 31134 AND pts.player_id = 41362 GROUP BY pts.player_id  

(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM participation_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 31134 AND pts.player_id = 41362 GROUP BY pts.player_id  

(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM player_pts AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 31134 AND pts.player_id = 14051 GROUP BY pts.player_id  

(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM bounty_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 31134 AND pts.player_id = 14051 GROUP BY pts.player_id  

(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM participation_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 31134 AND pts.player_id = 14051 GROUP BY pts.player_id  

(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM player_pts AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 31134 AND pts.player_id = 36361 GROUP BY pts.player_id  

(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM bounty_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 31134 AND pts.player_id = 36361 GROUP BY pts.player_id  

(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM participation_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 31134 AND pts.player_id = 36361 GROUP BY pts.player_id  

(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM player_pts AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 31134 AND pts.player_id = 41195 GROUP BY pts.player_id  

(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM bounty_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 31134 AND pts.player_id = 41195 GROUP BY pts.player_id  

(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM participation_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 31134 AND pts.player_id = 41195 GROUP BY pts.player_id  

(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM player_pts AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 31134 AND pts.player_id = 8601 GROUP BY pts.player_id  

(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM bounty_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 31134 AND pts.player_id = 8601 GROUP BY pts.player_id  

(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM participation_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 31134 AND pts.player_id = 8601 GROUP BY pts.player_id  

(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM player_pts AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 31134 AND pts.player_id = 39256 GROUP BY pts.player_id  

(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM bounty_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 31134 AND pts.player_id = 39256 GROUP BY pts.player_id  

(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM participation_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 31134 AND pts.player_id = 39256 GROUP BY pts.player_id  

(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM player_pts AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 31134 AND pts.player_id = 41361 GROUP BY pts.player_id  

(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM bounty_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 31134 AND pts.player_id = 41361 GROUP BY pts.player_id  

(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM participation_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 31134 AND pts.player_id = 41361 GROUP BY pts.player_id  

(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM player_pts AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 31134 AND pts.player_id = 41391 GROUP BY pts.player_id  

(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM bounty_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 31134 AND pts.player_id = 41391 GROUP BY pts.player_id  

(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM participation_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 31134 AND pts.player_id = 41391 GROUP BY pts.player_id  

(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM player_pts AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 31134 AND pts.player_id = 15497 GROUP BY pts.player_id  

(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM bounty_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 31134 AND pts.player_id = 15497 GROUP BY pts.player_id  

(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM participation_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 31134 AND pts.player_id = 15497 GROUP BY pts.player_id  

(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM player_pts AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 31134 AND pts.player_id = 15498 GROUP BY pts.player_id  

(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM bounty_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 31134 AND pts.player_id = 15498 GROUP BY pts.player_id  

(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM participation_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 31134 AND pts.player_id = 15498 GROUP BY pts.player_id  

(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM player_pts AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 31134 AND pts.player_id = 27777 GROUP BY pts.player_id  

(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM bounty_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 31134 AND pts.player_id = 27777 GROUP BY pts.player_id  

(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM participation_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 31134 AND pts.player_id = 27777 GROUP BY pts.player_id  

(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM player_pts AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 31134 AND pts.player_id = 24339 GROUP BY pts.player_id  

(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM bounty_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 31134 AND pts.player_id = 24339 GROUP BY pts.player_id  

(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM participation_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 31134 AND pts.player_id = 24339 GROUP BY pts.player_id  

(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM player_pts AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 31134 AND pts.player_id = 28605 GROUP BY pts.player_id  

(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM bounty_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 31134 AND pts.player_id = 28605 GROUP BY pts.player_id  

(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM participation_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 31134 AND pts.player_id = 28605 GROUP BY pts.player_id  

(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM player_pts AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 31134 AND pts.player_id = 16467 GROUP BY pts.player_id  

(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM bounty_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 31134 AND pts.player_id = 16467 GROUP BY pts.player_id  

(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM participation_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 31134 AND pts.player_id = 16467 GROUP BY pts.player_id  

(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM player_pts AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 31134 AND pts.player_id = 15809 GROUP BY pts.player_id  

(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM bounty_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 31134 AND pts.player_id = 15809 GROUP BY pts.player_id  

(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM participation_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 31134 AND pts.player_id = 15809 GROUP BY pts.player_id  

(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM player_pts AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 31134 AND pts.player_id = 40185 GROUP BY pts.player_id  

(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM bounty_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 31134 AND pts.player_id = 40185 GROUP BY pts.player_id  

(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM participation_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 31134 AND pts.player_id = 40185 GROUP BY pts.player_id  

(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM player_pts AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 31134 AND pts.player_id = 28779 GROUP BY pts.player_id  

(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM bounty_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 31134 AND pts.player_id = 28779 GROUP BY pts.player_id  

(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM participation_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 31134 AND pts.player_id = 28779 GROUP BY pts.player_id  

(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM player_pts AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 31134 AND pts.player_id = 37547 GROUP BY pts.player_id  

(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM bounty_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 31134 AND pts.player_id = 37547 GROUP BY pts.player_id  

(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM participation_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 31134 AND pts.player_id = 37547 GROUP BY pts.player_id  

(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM player_pts AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 31134 AND pts.player_id = 38586 GROUP BY pts.player_id  

(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM bounty_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 31134 AND pts.player_id = 38586 GROUP BY pts.player_id  

(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM participation_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 31134 AND pts.player_id = 38586 GROUP BY pts.player_id  

(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM player_pts AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 31134 AND pts.player_id = 15624 GROUP BY pts.player_id  

(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM bounty_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 31134 AND pts.player_id = 15624 GROUP BY pts.player_id  

(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM participation_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 31134 AND pts.player_id = 15624 GROUP BY pts.player_id  

(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM player_pts AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 31134 AND pts.player_id = 34851 GROUP BY pts.player_id  

(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM bounty_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 31134 AND pts.player_id = 34851 GROUP BY pts.player_id  

(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM participation_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 31134 AND pts.player_id = 34851 GROUP BY pts.player_id  
PLAYER NAME TOTAL POINTS EVENT POINTS BONUS POINTS
Bower, Earl 10 10.0 0
Caporale, Matt 10 10.0 0
Colangelo, Bob 56 50.0 6
Conway, Bill 98 90.0 8
Diblasi, Phil 46 40.0 6
Holbrook, Allyson 36 30.0 6
Kaizer, Sonny 10 10.0 0
Miller, Emily 10 10.0 0
Miller, Abbey 83 75.0 8
O'Hare, Dennis 113 105.0 8
O'Hare , Kelly 131 120.0 11
Ostrofsky, Libby 51 45.0 6
Pell, Susan 66 60.0 6
Peters, Charlie 93 85.0 8
Resch, Brenda 71 65.0 6
Resch, Glenn 10 10.0 0
Robbins, Jason 10 10.0 0
Rogers, Chris 118 110.0 8
Tutor, Jerry 88 80.0 8
Valentino, Doris 41 35.0 6
Vanderbie, Kim 103 95.0 8
Zavu, Bogdan 61 55.0 6