(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 = 10137 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 = 10137 AND pts.player_id = 1487 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 = 10137 AND pts.player_id = 1487 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 = 10137 AND pts.player_id = 1487 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 = 10137 AND pts.player_id = 21288 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 = 10137 AND pts.player_id = 21288 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 = 10137 AND pts.player_id = 21288 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 = 10137 AND pts.player_id = 22032 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 = 10137 AND pts.player_id = 22032 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 = 10137 AND pts.player_id = 22032 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 = 10137 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 = 10137 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 = 10137 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 = 10137 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 = 10137 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 = 10137 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 = 10137 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 = 10137 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 = 10137 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 = 10137 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 = 10137 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 = 10137 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 = 10137 AND pts.player_id = 6731 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 = 10137 AND pts.player_id = 6731 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 = 10137 AND pts.player_id = 6731 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 = 10137 AND pts.player_id = 22228 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 = 10137 AND pts.player_id = 22228 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 = 10137 AND pts.player_id = 22228 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 = 10137 AND pts.player_id = 11033 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 = 10137 AND pts.player_id = 11033 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 = 10137 AND pts.player_id = 11033 GROUP BY pts.player_id  
PLAYER NAME TOTAL POINTS EVENT POINTS BONUS POINTS
Borel, Sue 58 55.0 3
Dugas, Stephen 10 10.0 0
Dugas, Connie 10 10.0 0
Jacobson, Thomas 10 10.0 0
Jacobson, Cathy 10 10.0 0
Landry, William 10 10.0 0
Landry, George 50 10.0 40
LeCorn, Charles 10 10.0 0
Rampino, Mike 33 30.0 3
Young, Adam 10 10.0 0