(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 = 36940 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 = 36940 AND pts.player_id = 46356 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 = 36940 AND pts.player_id = 46356 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 = 36940 AND pts.player_id = 46356 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 = 36940 AND pts.player_id = 45104 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 = 36940 AND pts.player_id = 45104 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 = 36940 AND pts.player_id = 45104 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 = 36940 AND pts.player_id = 30800 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 = 36940 AND pts.player_id = 30800 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 = 36940 AND pts.player_id = 30800 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 = 36940 AND pts.player_id = 45252 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 = 36940 AND pts.player_id = 45252 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 = 36940 AND pts.player_id = 45252 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 = 36940 AND pts.player_id = 29292 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 = 36940 AND pts.player_id = 29292 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 = 36940 AND pts.player_id = 29292 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 = 36940 AND pts.player_id = 10166 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 = 36940 AND pts.player_id = 10166 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 = 36940 AND pts.player_id = 10166 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 = 36940 AND pts.player_id = 28834 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 = 36940 AND pts.player_id = 28834 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 = 36940 AND pts.player_id = 28834 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 = 36940 AND pts.player_id = 10352 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 = 36940 AND pts.player_id = 10352 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 = 36940 AND pts.player_id = 10352 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 = 36940 AND pts.player_id = 40262 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 = 36940 AND pts.player_id = 40262 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 = 36940 AND pts.player_id = 40262 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 = 36940 AND pts.player_id = 40503 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 = 36940 AND pts.player_id = 40503 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 = 36940 AND pts.player_id = 40503 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 = 36940 AND pts.player_id = 36585 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 = 36940 AND pts.player_id = 36585 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 = 36940 AND pts.player_id = 36585 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 = 36940 AND pts.player_id = 33436 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 = 36940 AND pts.player_id = 33436 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 = 36940 AND pts.player_id = 33436 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 = 36940 AND pts.player_id = 35259 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 = 36940 AND pts.player_id = 35259 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 = 36940 AND pts.player_id = 35259 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 = 36940 AND pts.player_id = 37229 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 = 36940 AND pts.player_id = 37229 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 = 36940 AND pts.player_id = 37229 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 = 36940 AND pts.player_id = 38808 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 = 36940 AND pts.player_id = 38808 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 = 36940 AND pts.player_id = 38808 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 = 36940 AND pts.player_id = 29453 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 = 36940 AND pts.player_id = 29453 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 = 36940 AND pts.player_id = 29453 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 = 36940 AND pts.player_id = 43346 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 = 36940 AND pts.player_id = 43346 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 = 36940 AND pts.player_id = 43346 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 = 36940 AND pts.player_id = 27825 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 = 36940 AND pts.player_id = 27825 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 = 36940 AND pts.player_id = 27825 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 = 36940 AND pts.player_id = 39451 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 = 36940 AND pts.player_id = 39451 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 = 36940 AND pts.player_id = 39451 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 = 36940 AND pts.player_id = 21896 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 = 36940 AND pts.player_id = 21896 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 = 36940 AND pts.player_id = 21896 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 = 36940 AND pts.player_id = 6037 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 = 36940 AND pts.player_id = 6037 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 = 36940 AND pts.player_id = 6037 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 = 36940 AND pts.player_id = 15720 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 = 36940 AND pts.player_id = 15720 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 = 36940 AND pts.player_id = 15720 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 = 36940 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 = 36940 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 = 36940 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 = 36940 AND pts.player_id = 38054 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 = 36940 AND pts.player_id = 38054 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 = 36940 AND pts.player_id = 38054 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 = 36940 AND pts.player_id = 43662 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 = 36940 AND pts.player_id = 43662 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 = 36940 AND pts.player_id = 43662 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 = 36940 AND pts.player_id = 43661 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 = 36940 AND pts.player_id = 43661 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 = 36940 AND pts.player_id = 43661 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 = 36940 AND pts.player_id = 15703 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 = 36940 AND pts.player_id = 15703 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 = 36940 AND pts.player_id = 15703 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 = 36940 AND pts.player_id = 44939 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 = 36940 AND pts.player_id = 44939 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 = 36940 AND pts.player_id = 44939 GROUP BY pts.player_id  
PLAYER NAME TOTAL POINTS EVENT POINTS BONUS POINTS
Austin, Bill 52 45.0 7
Booras, Debbie 10 10.0 0
Carrington, Chris 100 90.0 10
Carroll, Don 95 85.0 10
Chapin, Gary 120 110.0 10
Cignarella, Mark 72 65.0 7
Cooper, Tony 90 80.0 10
Dallaire, Jeff 10 10.0 0
Davis, Karin 10 10.0 0
Davis, Nikki 57 50.0 7
Doucette, Justin 10 10.0 0
Foster, Melanie 10 10.0 0
Foster, Amaryllis 37 30.0 7
Giulliano, Jaimar 10 10.0 0
Gordon, Rich 10 10.0 0
Hartnett, Cassie 10 10.0 0
Lopez, Angel 10 10.0 0
Lyons, Bill 85 75.0 10
Macneil, Greg 10 10.0 0
Mintz, Jayson 67 60.0 7
Nichol, Chris 42 35.0 7
Osche, Joe 105 95.0 10
Pell, Susan 115 105.0 10
Souza, Wanderson 62 55.0 7
Steeves, Scott 134 120.0 14
Steeves, Vaughn 10 10.0 0
Tokaya, Greg 10 10.0 0
Wall, Phil 47 40.0 7