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 = 6 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 = 6 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 = 6 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 = 6 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 = 6 AND pts.player_id = 98 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 = 6 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 = 6 AND pts.player_id = 99 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 = 6 AND pts.player_id = 69 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 = 6 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 = 6 AND pts.player_id = 95 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 = 6 AND pts.player_id = 96 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 = 6 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 = 6 AND pts.player_id = 91 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 = 6 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 = 6 AND pts.player_id = 84 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 = 6 AND pts.player_id = 101 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 = 6 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 = 6 AND pts.player_id = 86 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 = 6 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 = 6 AND pts.player_id = 78 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 = 6 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 = 6 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 = 6 AND pts.player_id = 81 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 = 6 AND pts.player_id = 73 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 = 6 AND pts.player_id = 66 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 = 6 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 = 6 AND pts.player_id = 87 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 = 6 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 = 6 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 = 6 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 = 6 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 = 6 AND pts.player_id = 110 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 = 6 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 = 6 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 = 6 AND pts.player_id = 72 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 = 6 AND pts.player_id = 97 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 = 6 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 = 6 AND pts.player_id = 50 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 = 6 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 = 6 AND pts.player_id = 173 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 = 6 AND pts.player_id = 75 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 = 6 AND pts.player_id = 92 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 = 6 AND pts.player_id = 88 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 = 6 AND pts.player_id = 76 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 = 6 AND pts.player_id = 82 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 = 6 AND pts.player_id = 120 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 = 6 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 = 6 AND pts.player_id = 83 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 = 6 AND pts.player_id = 45 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 = 6 AND pts.player_id = 1512 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 = 6 AND pts.player_id = 94 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 = 6 AND pts.player_id = 130 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 = 6 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 = 6 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 = 6 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 = 6 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 = 6 AND pts.player_id = 80 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 = 6 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 = 6 AND pts.player_id = 190 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 = 6 AND pts.player_id = 77 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 = 6 AND pts.player_id = 21 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 = 6 AND pts.player_id = 93 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 = 6 AND pts.player_id = 68 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 = 6 AND pts.player_id = 74 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 = 6 AND pts.player_id = 67 GROUP BY pts.player_id

PLAYER NAME	TOTAL POINTS	EVENT POINTS	BONUS POINTS
Abbenante, Lulu	65	65.0	0
Albert, Tyler	10	10.0	0
Aldridge, Scott	10	10.0	0
Allard, Ray	10	10.0	0
allen, Beatrice	10	10.0	0
Alleva, John	10	10.0	0
Alleva, Greg	10	10.0	0
Asia, Lee	10	10.0	0
Aston, Sarah	10	10.0	0
bassi, smoke the good stuff	10	10.0	0
Beauchamp, David	10	10.0	0
Bowen, Chris	10	10.0	0
Brule Jr., Charles	10	10.0	0
Cabana, Tobias	10	10.0	0
Caraccia, Michael	10	10.0	0
Champagne, Stevie 'Six String'	75	75.0	0
Charron, George call me Lucky	80	80.0	0
Colacone, Joe	10	10.0	0
Cordero, Joe	10	10.0	0
Coupe, Melissa	40	40.0	0
D'Elena, Mike 'the viper'	35	35.0	0
Decristofano, Al	10	10.0	0
DeSalvador, Jessica	10	10.0	0
Diekerhoff, Justin	10	10.0	0
Dowling, Paul	10	10.0	0
Duquette, Tom	10	10.0	0
Ebert, Roger	10	10.0	0
EGAN, MIKE	10	10.0	0
Fargnoli, Jr., Antonio	10	10.0	0
Ferguson, James	10	10.0	0
Finch, Paul	120	120.0	0
Fiore, Matthew	45	45.0	0
Fox, Kyle	10	10.0	0
Frechette, Chris	10	10.0	0
Fresh, Manny	10	10.0	0
Godin, Brad	10	10.0	0
Guglietta, Lareto	10	10.0	0
Hicks, Jonathan	110	110.0	0
Holden, Brian	10	10.0	0
Hunter, Sam	10	10.0	0
Jewell, Michelle	95	95.0	0
Jewell, The Golden Baby	10	10.0	0
Kane, Jamie	10	10.0	0
King, Deryk 'Dr. I Raise'	10	10.0	0
Kopitsky Jr., Eric	50	50.0	0
Lampinski, Giggles	30	30.0	0
Laplume, Phillip	10	10.0	0
Laplume, Sue	10	10.0	0
Leighton, Keith	10	10.0	0
Leighton, Keith	105	105.0	0
Lussier, Brian	90	90.0	0
Maher, Aaron	10	10.0	0
Maher, Mike	10	10.0	0
Martin, Tommy	10	10.0	0
Martin, Keith	10	10.0	0
McManus, Mark	10	10.0	0
Meegan, Ryan	10	10.0	0
Messier, Jay	10	10.0	0
Miller, Mike	10	10.0	0
Morse, Brian	10	10.0	0
Murray, Thomas M.	10	10.0	0
Nacci Jr., Michael	10	10.0	0
Nelson, Bryon	10	10.0	0
Ng, Benedict	10	10.0	0
Nordin, Jarrod	10	10.0	0
Pais, Tony	10	10.0	0
Palombo, Brian	10	10.0	0
Parsons, Teresa	10	10.0	0
Pond, B-Rad	60	60.0	0
Pond, Jim	10	10.0	0
Rebollo, John	55	55.0	0
Santos, Alex	85	85.0	0
Siryaporn, Edward	10	10.0	0
Sterling, Dave	10	10.0	0
Torti, Tony	10	10.0	0
Tremblay, Ron	10	10.0	0
Vizzacco, The Poker Mayor	10	10.0	0
Waite, Todd	10	10.0	0
Walsh, Shawn	10	10.0	0
Yagoubian, Sarkis	10	10.0	0
Yagoubian, Gary	10	10.0	0
Yem, Daniel	10	10.0	0
Yin, Phillip	10	10.0	0