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 = 8 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 = 8 AND pts.player_id = 30 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 = 8 AND pts.player_id = 30 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 = 8 AND pts.player_id = 30 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 = 8 AND pts.player_id = 89 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 = 8 AND pts.player_id = 38 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 = 8 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 = 8 AND pts.player_id = 153 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 = 8 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 = 8 AND pts.player_id = 175 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 = 8 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 = 8 AND pts.player_id = 52 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 = 8 AND pts.player_id = 57 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 = 8 AND pts.player_id = 25 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 = 8 AND pts.player_id = 12 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 = 8 AND pts.player_id = 61 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 = 8 AND pts.player_id = 59 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 = 8 AND pts.player_id = 180 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 = 8 AND pts.player_id = 62 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 = 8 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 = 8 AND pts.player_id = 42 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 = 8 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 = 8 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 = 8 AND pts.player_id = 43 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 = 8 AND pts.player_id = 56 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 = 8 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 = 8 AND pts.player_id = 29 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 = 8 AND pts.player_id = 40 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 = 8 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 = 8 AND pts.player_id = 60 GROUP BY pts.player_id

PLAYER NAME	TOTAL POINTS	EVENT POINTS	BONUS POINTS
Abbenante, Lulu	90	90.0	0
Aldridge, Scott	10	10.0	0
Aston, Sarah	75	75.0	0
Baker, Chris	10	10.0	0
Bowden, Jeffrey SIR	10	10.0	0
Bowen Jr., J B J R	35	35.0	0
Caraballo, Frank	30	30.0	0
Carter, The Slyone	10	10.0	0
Cattani, Tony	10	10.0	0
Clift, Stephen	10	10.0	0
DelMastro, Alan	10	10.0	0
Dowding, Bill	10	10.0	0
Finch, Paul	10	10.0	0
Fitzgerald, Scott	10	10.0	0
Fox, Kyle	10	10.0	0
Furtado, Jaime	10	10.0	0
Gil, Adam W.	10	10.0	0
Goulet, Jamie	120	120.0	0
Gray, Chartley	85	85.0	0
Haskins, Michael	10	10.0	0
Heaney, Stephen	10	10.0	0
Hicks, Jonathan	10	10.0	0
Jacques, Take my Chips	60	60.0	0
Kopitsky Jr., Eric	10	10.0	0
Lampinski, Giggles	10	10.0	0
Love, Courtney	10	10.0	0
Martin, BOB 'THE AMBASSADOR'	95	95.0	0
Meegan, Joe	10	10.0	0
Miller, Mike	10	10.0	0
Morrison Jr., David A.	105	105.0	0
Morrison Sr., David	40	40.0	0
Mr. Brandenburg, Pay Attention	10	10.0	0
Paiz, Omar	65	65.0	0
Palmer, George	80	80.0	0
Pond, B-Rad	10	10.0	0
Pond, Jim	110	110.0	0
Rebollo, John	45	45.0	0
Roque, Timothy	50	50.0	0
Schlicting, Julie	10	10.0	0
Sperlongano, Sal	10	10.0	0
Thibeault, Michelle	55	55.0	0
Tracy, Sandra	10	10.0	0