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 = 7 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 = 7 AND pts.player_id = 10 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 = 7 AND pts.player_id = 10 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 = 7 AND pts.player_id = 10 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 = 7 AND pts.player_id = 204 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 = 7 AND pts.player_id = 193 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 = 7 AND pts.player_id = 186 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 = 7 AND pts.player_id = 65 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 = 7 AND pts.player_id = 90 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 = 7 AND pts.player_id = 139 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 = 7 AND pts.player_id = 163 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 = 7 AND pts.player_id = 48 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 = 7 AND pts.player_id = 144 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 = 7 AND pts.player_id = 116 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 = 7 AND pts.player_id = 55 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 = 7 AND pts.player_id = 121 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 = 7 AND pts.player_id = 28 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 = 7 AND pts.player_id = 79 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 = 7 AND pts.player_id = 32 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 = 7 AND pts.player_id = 31 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 = 7 AND pts.player_id = 47 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 = 7 AND pts.player_id = 152 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 = 7 AND pts.player_id = 21 GROUP BY pts.player_id

PLAYER NAME	TOTAL POINTS	EVENT POINTS	BONUS POINTS
Amend, Aces	10	10.0	0
Babcock, Bill	10	10.0	0
Baker, Chris	35	35.0	0
Benedetti, Ron	10	10.0	0
Bowden, Stephanie	120	120.0	0
Bowen Jr., J B J R	10	10.0	0
Cabana, Tobias	75	75.0	0
Carter, The Slyone	95	95.0	0
Charron, George call me Lucky	10	10.0	0
Cherwinski, Josh	10	10.0	0
Citrone, Richard	30	30.0	0
Corley, John	10	10.0	0
DelMastro, Alan	10	10.0	0
Diekerhoff, Justin	10	10.0	0
Dowding, Bill	90	90.0	0
Goddard III, Charles	10	10.0	0
Goulet, Jamie	65	65.0	0
Harris, Randy	10	10.0	0
Heaney, Stephen	10	10.0	0
Jacques, Take my Chips	10	10.0	0
Lampinski, Giggles	10	10.0	0
Mahar, Chris	10	10.0	0
Martin, BOB 'THE AMBASSADOR'	105	105.0	0
Messier, Jay	10	10.0	0
Morrison Jr., David A.	10	10.0	0
Morrison Sr., David	55	55.0	0
Palmer, George	80	80.0	0
Pierce, Tim	85	85.0	0
Rebollo, John	45	45.0	0
Schaney, Tonya	110	110.0	0
Schaney, Adam	10	10.0	0
Sterling, Dave	10	10.0	0
Theilig, Frederick	60	60.0	0
Torti, Tony	10	10.0	0
Vardakis, Jessie	40	40.0	0
Vizzacco, The Poker Mayor	50	50.0	0