(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 = 30689 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 = 30689 AND pts.player_id = 40611 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 = 30689 AND pts.player_id = 40611 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 = 30689 AND pts.player_id = 40611 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 = 30689 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 = 30689 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 = 30689 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 = 30689 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 = 30689 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 = 30689 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 = 30689 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 = 30689 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 = 30689 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 = 30689 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 = 30689 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 = 30689 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 = 30689 AND pts.player_id = 23838 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 = 30689 AND pts.player_id = 23838 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 = 30689 AND pts.player_id = 23838 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 = 30689 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 = 30689 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 = 30689 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 = 30689 AND pts.player_id = 15540 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 = 30689 AND pts.player_id = 15540 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 = 30689 AND pts.player_id = 15540 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 = 30689 AND pts.player_id = 29352 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 = 30689 AND pts.player_id = 29352 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 = 30689 AND pts.player_id = 29352 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 = 30689 AND pts.player_id = 39261 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 = 30689 AND pts.player_id = 39261 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 = 30689 AND pts.player_id = 39261 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 = 30689 AND pts.player_id = 13711 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 = 30689 AND pts.player_id = 13711 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 = 30689 AND pts.player_id = 13711 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 = 30689 AND pts.player_id = 23336 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 = 30689 AND pts.player_id = 23336 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 = 30689 AND pts.player_id = 23336 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 = 30689 AND pts.player_id = 40166 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 = 30689 AND pts.player_id = 40166 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 = 30689 AND pts.player_id = 40166 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 = 30689 AND pts.player_id = 15068 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 = 30689 AND pts.player_id = 15068 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 = 30689 AND pts.player_id = 15068 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 = 30689 AND pts.player_id = 15589 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 = 30689 AND pts.player_id = 15589 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 = 30689 AND pts.player_id = 15589 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 = 30689 AND pts.player_id = 37411 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 = 30689 AND pts.player_id = 37411 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 = 30689 AND pts.player_id = 37411 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 = 30689 AND pts.player_id = 21906 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 = 30689 AND pts.player_id = 21906 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 = 30689 AND pts.player_id = 21906 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 = 30689 AND pts.player_id = 30511 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 = 30689 AND pts.player_id = 30511 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 = 30689 AND pts.player_id = 30511 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 = 30689 AND pts.player_id = 32060 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 = 30689 AND pts.player_id = 32060 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 = 30689 AND pts.player_id = 32060 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 = 30689 AND pts.player_id = 14686 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 = 30689 AND pts.player_id = 14686 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 = 30689 AND pts.player_id = 14686 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 = 30689 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 = 30689 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 = 30689 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 = 30689 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 = 30689 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 = 30689 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 = 30689 AND pts.player_id = 40972 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 = 30689 AND pts.player_id = 40972 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 = 30689 AND pts.player_id = 40972 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 = 30689 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 = 30689 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 = 30689 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 = 30689 AND pts.player_id = 6059 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 = 30689 AND pts.player_id = 6059 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 = 30689 AND pts.player_id = 6059 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 = 30689 AND pts.player_id = 29985 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 = 30689 AND pts.player_id = 29985 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 = 30689 AND pts.player_id = 29985 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 = 30689 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 = 30689 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 = 30689 AND pts.player_id = 38586 GROUP BY pts.player_id  
PLAYER NAME TOTAL POINTS EVENT POINTS BONUS POINTS
Boulette, Shawn 10 10.0 0
Bower, Earl 10 10.0 0
Chapin, Gary 84 75.0 9
Colangelo, Bob 119 110.0 9
Cooper, Tony 47 40.0 7
Corin, Bryan 134 120.0 14
Dallaire, Jeff 67 60.0 7
Devane, Ricky 10 10.0 0
Discher, Bert 42 35.0 7
Gedmin, John 10 10.0 0
Giroux, Paul 104 95.0 9
Gray, Ryan 10 10.0 0
Kane, David 10 10.0 0
Kelley, Sean 57 50.0 7
Lemire, Jim 10 10.0 0
Louissaint, Madsen 94 85.0 9
Mann, Richard 72 65.0 7
Marden, Kevin 10 10.0 0
Mercer, Jerry 10 10.0 0
Morrison, Shirley 62 55.0 7
Nichol, Chris 37 30.0 7
Pell, Susan 10 10.0 0
Rice, Erin 89 80.0 9
Robbins, Jason 10 10.0 0
Shankman, David 52 45.0 7
Shepard, Chris 114 105.0 9
Valentino, Doris 99 90.0 9