(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 = 2907 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 = 2907 AND pts.player_id = 5638 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 = 2907 AND pts.player_id = 5638 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 = 2907 AND pts.player_id = 5638 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 = 2907 AND pts.player_id = 7715 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 = 2907 AND pts.player_id = 7715 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 = 2907 AND pts.player_id = 7715 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 = 2907 AND pts.player_id = 5947 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 = 2907 AND pts.player_id = 5947 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 = 2907 AND pts.player_id = 5947 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 = 2907 AND pts.player_id = 14168 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 = 2907 AND pts.player_id = 14168 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 = 2907 AND pts.player_id = 14168 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 = 2907 AND pts.player_id = 6011 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 = 2907 AND pts.player_id = 6011 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 = 2907 AND pts.player_id = 6011 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 = 2907 AND pts.player_id = 5981 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 = 2907 AND pts.player_id = 5981 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 = 2907 AND pts.player_id = 5981 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 = 2907 AND pts.player_id = 2849 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 = 2907 AND pts.player_id = 2849 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 = 2907 AND pts.player_id = 2849 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 = 2907 AND pts.player_id = 5867 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 = 2907 AND pts.player_id = 5867 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 = 2907 AND pts.player_id = 5867 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 = 2907 AND pts.player_id = 5178 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 = 2907 AND pts.player_id = 5178 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 = 2907 AND pts.player_id = 5178 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 = 2907 AND pts.player_id = 8269 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 = 2907 AND pts.player_id = 8269 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 = 2907 AND pts.player_id = 8269 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 = 2907 AND pts.player_id = 5535 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 = 2907 AND pts.player_id = 5535 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 = 2907 AND pts.player_id = 5535 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 = 2907 AND pts.player_id = 5534 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 = 2907 AND pts.player_id = 5534 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 = 2907 AND pts.player_id = 5534 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 = 2907 AND pts.player_id = 5678 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 = 2907 AND pts.player_id = 5678 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 = 2907 AND pts.player_id = 5678 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 = 2907 AND pts.player_id = 5443 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 = 2907 AND pts.player_id = 5443 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 = 2907 AND pts.player_id = 5443 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 = 2907 AND pts.player_id = 6278 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 = 2907 AND pts.player_id = 6278 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 = 2907 AND pts.player_id = 6278 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 = 2907 AND pts.player_id = 6470 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 = 2907 AND pts.player_id = 6470 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 = 2907 AND pts.player_id = 6470 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 = 2907 AND pts.player_id = 5363 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 = 2907 AND pts.player_id = 5363 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 = 2907 AND pts.player_id = 5363 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 = 2907 AND pts.player_id = 6115 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 = 2907 AND pts.player_id = 6115 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 = 2907 AND pts.player_id = 6115 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 = 2907 AND pts.player_id = 7384 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 = 2907 AND pts.player_id = 7384 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 = 2907 AND pts.player_id = 7384 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 = 2907 AND pts.player_id = 5639 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 = 2907 AND pts.player_id = 5639 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 = 2907 AND pts.player_id = 5639 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 = 2907 AND pts.player_id = 6187 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 = 2907 AND pts.player_id = 6187 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 = 2907 AND pts.player_id = 6187 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 = 2907 AND pts.player_id = 6026 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 = 2907 AND pts.player_id = 6026 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 = 2907 AND pts.player_id = 6026 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 = 2907 AND pts.player_id = 3446 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 = 2907 AND pts.player_id = 3446 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 = 2907 AND pts.player_id = 3446 GROUP BY pts.player_id  
PLAYER NAME TOTAL POINTS EVENT POINTS BONUS POINTS
Adams, Jamie 10 10.0 0
Adams, George 71 65.0 6
Aldana, Danny 10 10.0 0
Algarin, Lovcelyn 50 10.0 40
Bolton, Jason 10 10.0 0
Brown, Lynn 10 10.0 0
Carl, Andrew 50 10.0 40
Dingley, Irving 10 10.0 0
Harbour, Donna 10 10.0 0
Higgins, Jim 10 10.0 0
Jacobson, Cathy 10 10.0 0
Jacobson, Thomas 132 120.0 12
Landry, William 66 60.0 6
Landry, George 10 10.0 0
Mason, Jesse 51 45.0 6
Mason, Brian 10 10.0 0
Pacheco, Cindy 103 95.0 8
Perez, Alfredo 10 10.0 0
Singh, Mahendra 10 10.0 0
Stroup, Casey 10 10.0 0
Tulipano, Emilio 10 10.0 0
Turner, Rob 41 35.0 6
Vanelli, Reed 10 10.0 0