(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 = 8073 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 = 8073 AND pts.player_id = 10270 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 = 8073 AND pts.player_id = 10270 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 = 8073 AND pts.player_id = 10270 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 = 8073 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 = 8073 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 = 8073 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 = 8073 AND pts.player_id = 21193 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 = 8073 AND pts.player_id = 21193 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 = 8073 AND pts.player_id = 21193 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 = 8073 AND pts.player_id = 21435 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 = 8073 AND pts.player_id = 21435 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 = 8073 AND pts.player_id = 21435 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 = 8073 AND pts.player_id = 9789 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 = 8073 AND pts.player_id = 9789 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 = 8073 AND pts.player_id = 9789 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 = 8073 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 = 8073 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 = 8073 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 = 8073 AND pts.player_id = 6259 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 = 8073 AND pts.player_id = 6259 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 = 8073 AND pts.player_id = 6259 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 = 8073 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 = 8073 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 = 8073 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 = 8073 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 = 8073 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 = 8073 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 = 8073 AND pts.player_id = 21630 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 = 8073 AND pts.player_id = 21630 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 = 8073 AND pts.player_id = 21630 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 = 8073 AND pts.player_id = 10840 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 = 8073 AND pts.player_id = 10840 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 = 8073 AND pts.player_id = 10840 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 = 8073 AND pts.player_id = 16227 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 = 8073 AND pts.player_id = 16227 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 = 8073 AND pts.player_id = 16227 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 = 8073 AND pts.player_id = 5357 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 = 8073 AND pts.player_id = 5357 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 = 8073 AND pts.player_id = 5357 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 = 8073 AND pts.player_id = 21657 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 = 8073 AND pts.player_id = 21657 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 = 8073 AND pts.player_id = 21657 GROUP BY pts.player_id  
PLAYER NAME TOTAL POINTS EVENT POINTS BONUS POINTS
Amato, Tom 10 10.0 0
Brown, Lynn 10 10.0 0
Costa, Mike 10 10.0 0
Costa, Sandy 10 10.0 0
Darosa, Vinnie 34 30.0 4
Dugas, Connie 10 10.0 0
Fox, Linda 10 10.0 0
Landry, William 100 95.0 5
Landry, George 54 50.0 4
Lewis, Scott 10 10.0 0
McCree, Tracy 69 65.0 4
Milord, Francois 44 40.0 4
Poulin, Mike 10 10.0 0
Simmons , Donald 10 10.0 0