(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 = 25420 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 = 25420 AND pts.player_id = 38817 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 = 25420 AND pts.player_id = 38817 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 = 25420 AND pts.player_id = 38817 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 = 25420 AND pts.player_id = 10292 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 = 25420 AND pts.player_id = 10292 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 = 25420 AND pts.player_id = 10292 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 = 25420 AND pts.player_id = 30563 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 = 25420 AND pts.player_id = 30563 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 = 25420 AND pts.player_id = 30563 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 = 25420 AND pts.player_id = 35521 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 = 25420 AND pts.player_id = 35521 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 = 25420 AND pts.player_id = 35521 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 = 25420 AND pts.player_id = 31275 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 = 25420 AND pts.player_id = 31275 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 = 25420 AND pts.player_id = 31275 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 = 25420 AND pts.player_id = 13706 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 = 25420 AND pts.player_id = 13706 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 = 25420 AND pts.player_id = 13706 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 = 25420 AND pts.player_id = 27069 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 = 25420 AND pts.player_id = 27069 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 = 25420 AND pts.player_id = 27069 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 = 25420 AND pts.player_id = 28176 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 = 25420 AND pts.player_id = 28176 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 = 25420 AND pts.player_id = 28176 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 = 25420 AND pts.player_id = 13082 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 = 25420 AND pts.player_id = 13082 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 = 25420 AND pts.player_id = 13082 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 = 25420 AND pts.player_id = 38819 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 = 25420 AND pts.player_id = 38819 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 = 25420 AND pts.player_id = 38819 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 = 25420 AND pts.player_id = 38818 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 = 25420 AND pts.player_id = 38818 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 = 25420 AND pts.player_id = 38818 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 = 25420 AND pts.player_id = 11371 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 = 25420 AND pts.player_id = 11371 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 = 25420 AND pts.player_id = 11371 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 = 25420 AND pts.player_id = 2876 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 = 25420 AND pts.player_id = 2876 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 = 25420 AND pts.player_id = 2876 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 = 25420 AND pts.player_id = 28408 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 = 25420 AND pts.player_id = 28408 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 = 25420 AND pts.player_id = 28408 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 = 25420 AND pts.player_id = 31609 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 = 25420 AND pts.player_id = 31609 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 = 25420 AND pts.player_id = 31609 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 = 25420 AND pts.player_id = 10305 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 = 25420 AND pts.player_id = 10305 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 = 25420 AND pts.player_id = 10305 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 = 25420 AND pts.player_id = 23136 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 = 25420 AND pts.player_id = 23136 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 = 25420 AND pts.player_id = 23136 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 = 25420 AND pts.player_id = 14086 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 = 25420 AND pts.player_id = 14086 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 = 25420 AND pts.player_id = 14086 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 = 25420 AND pts.player_id = 7572 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 = 25420 AND pts.player_id = 7572 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 = 25420 AND pts.player_id = 7572 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 = 25420 AND pts.player_id = 35227 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 = 25420 AND pts.player_id = 35227 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 = 25420 AND pts.player_id = 35227 GROUP BY pts.player_id  
PLAYER NAME TOTAL POINTS EVENT POINTS BONUS POINTS
Brittan, Ron 60 55.0 5
Bronske, Pat 10 10.0 0
Cantor, Eric 10 10.0 0
Cepeda, James 10 10.0 0
Cormier, Brad 112 105.0 7
DiBuduo, Bernard 102 95.0 7
Dougherty, David 10 10.0 0
Dowd, Carolyn 50 45.0 5
Falvey, Michael 97 90.0 7
Fleming, Glenn 70 65.0 5
Fleming, Peter 55 50.0 5
Kelley, Nicholas 65 60.0 5
Phillips, John 117 110.0 7
Piaseczny, Chris 82 75.0 7
Politano, Jean 10 10.0 0
Quinn, Jim 87 80.0 7
Sullivan, Kevin 10 10.0 0
Welch, Meredith 92 85.0 7
Wright, Timmy 130 120.0 10
Yackel, Ed 10 10.0 0