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 = 1 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 = 1 AND pts.player_id = 138 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 = 1 AND pts.player_id = 138 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 = 1 AND pts.player_id = 138 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 = 1 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 = 1 AND pts.player_id = 14 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 = 1 AND pts.player_id = 9 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 = 1 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 = 1 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 = 1 AND pts.player_id = 54 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 = 1 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 = 1 AND pts.player_id = 23 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 = 1 AND pts.player_id = 63 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 = 1 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 = 1 AND pts.player_id = 36 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 = 1 AND pts.player_id = 33 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 = 1 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 = 1 AND pts.player_id = 22 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 = 1 AND pts.player_id = 34 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 = 1 AND pts.player_id = 39 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 = 1 AND pts.player_id = 35 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 = 1 AND pts.player_id = 51 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 = 1 AND pts.player_id = 58 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 = 1 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 = 1 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 = 1 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 = 1 AND pts.player_id = 44 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 = 1 AND pts.player_id = 37 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 = 1 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 = 1 AND pts.player_id = 53 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 = 1 AND pts.player_id = 27 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 = 1 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 = 1 AND pts.player_id = 26 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 = 1 AND pts.player_id = 49 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 = 1 AND pts.player_id = 24 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 = 1 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 = 1 AND pts.player_id = 32448 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 = 1 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 = 1 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 = 1 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 = 1 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 = 1 AND pts.player_id = 60 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 = 1 AND pts.player_id = 46 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 = 1 AND pts.player_id = 41 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 = 1 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 = 1 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 = 1 AND pts.player_id = 16 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 = 1 AND pts.player_id = 64 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 = 1 AND pts.player_id = 21 GROUP BY pts.player_id

PLAYER NAME	TOTAL POINTS	EVENT POINTS	BONUS POINTS
, Julie	45	45.0	0
Abbenante, Lulu	10	10.0	0
Absi, Mike	10	10.0	0
Alleva, John	105	105.0	0
Amaral, Nicholas	10	10.0	0
Amend, Aces	110	110.0	0
Aston, Sarah	10	10.0	0
Beauchamp, David	10	10.0	0
Benn, Lionel	90	90.0	0
Bowden, Stephanie	10	10.0	0
Bryant, Sabrina	75	75.0	0
Caraccia, Michael	105	105.0	0
Cattani, Tony	10	10.0	0
Charette, Paul	10	10.0	0
Chiu, Michael	80	80.0	0
Clift, Stephen	10	10.0	0
Collins, Jared	10	10.0	0
Cordero, Joe	50	50.0	0
Coupe, Melissa	10	10.0	0
Duquette, Tom	10	10.0	0
EGAN, MIKE	10	10.0	0
Fargnoli, Jr., Antonio	110	110.0	0
Finch, Paul	10	10.0	0
Fox, Kyle	10	10.0	0
Goddard III, Charles	120	120.0	0
Godin, Brad	10	10.0	0
Hartley Jr., Richard W.	10	10.0	0
Hicks, Jonathan	35	35.0	0
Hogan, Jason	95	95.0	0
Iarocci, Nicholas	40	40.0	0
Kopitsky Jr., Eric	10	10.0	0
Lamanzky, Kevin	10	10.0	0
Laplume, Sue	10	10.0	0
Levasseur, Dorothy	10	10.0	0
Martin, BOB 'THE AMBASSADOR'	10	10.0	0
McCrory SR., Glenn	120	120.0	0
Meegan, Joe	60	60.0	0
Morrison Jr., David A.	85	85.0	0
Pond, Jim	10	10.0	0
Pond, B-Rad	10	10.0	0
Roque, Timothy	65	65.0	0
Sanford, James	10	10.0	0
Santos, Alex	30	30.0	0
Schaney, Adam	10	10.0	0
Schaney, Tonya	55	55.0	0
Sterling, Dave	10	10.0	0
Thomas, Matt	10	10.0	0
Vangel, Mathew	10	10.0	0
Vizzacco, The Poker Mayor	10	10.0	0