Eastern Poker Tour - Pub Poker in Rhode Island, Massachusetts and New Hampshire

(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 = 4971 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 = 4971 AND pts.player_id = 13512 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 = 4971 AND pts.player_id = 13512 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 = 4971 AND pts.player_id = 13512 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 = 4971 AND pts.player_id = 13231 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 = 4971 AND pts.player_id = 13231 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 = 4971 AND pts.player_id = 13231 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 = 4971 AND pts.player_id = 9564 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 = 4971 AND pts.player_id = 9564 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 = 4971 AND pts.player_id = 9564 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 = 4971 AND pts.player_id = 6216 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 = 4971 AND pts.player_id = 6216 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 = 4971 AND pts.player_id = 6216 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 = 4971 AND pts.player_id = 7268 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 = 4971 AND pts.player_id = 7268 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 = 4971 AND pts.player_id = 7268 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 = 4971 AND pts.player_id = 6819 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 = 4971 AND pts.player_id = 6819 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 = 4971 AND pts.player_id = 6819 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 = 4971 AND pts.player_id = 6215 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 = 4971 AND pts.player_id = 6215 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 = 4971 AND pts.player_id = 6215 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 = 4971 AND pts.player_id = 6511 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 = 4971 AND pts.player_id = 6511 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 = 4971 AND pts.player_id = 6511 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 = 4971 AND pts.player_id = 9122 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 = 4971 AND pts.player_id = 9122 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 = 4971 AND pts.player_id = 9122 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 = 4971 AND pts.player_id = 1802 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 = 4971 AND pts.player_id = 1802 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 = 4971 AND pts.player_id = 1802 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 = 4971 AND pts.player_id = 5328 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 = 4971 AND pts.player_id = 5328 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 = 4971 AND pts.player_id = 5328 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 = 4971 AND pts.player_id = 14354 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 = 4971 AND pts.player_id = 14354 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 = 4971 AND pts.player_id = 14354 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 = 4971 AND pts.player_id = 9687 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 = 4971 AND pts.player_id = 9687 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 = 4971 AND pts.player_id = 9687 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 = 4971 AND pts.player_id = 11246 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 = 4971 AND pts.player_id = 11246 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 = 4971 AND pts.player_id = 11246 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 = 4971 AND pts.player_id = 6602 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 = 4971 AND pts.player_id = 6602 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 = 4971 AND pts.player_id = 6602 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 = 4971 AND pts.player_id = 13834 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 = 4971 AND pts.player_id = 13834 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 = 4971 AND pts.player_id = 13834 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 = 4971 AND pts.player_id = 6149 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 = 4971 AND pts.player_id = 6149 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 = 4971 AND pts.player_id = 6149 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 = 4971 AND pts.player_id = 6304 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 = 4971 AND pts.player_id = 6304 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 = 4971 AND pts.player_id = 6304 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 = 4971 AND pts.player_id = 14045 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 = 4971 AND pts.player_id = 14045 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 = 4971 AND pts.player_id = 14045 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 = 4971 AND pts.player_id = 6535 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 = 4971 AND pts.player_id = 6535 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 = 4971 AND pts.player_id = 6535 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 = 4971 AND pts.player_id = 8075 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 = 4971 AND pts.player_id = 8075 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 = 4971 AND pts.player_id = 8075 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 = 4971 AND pts.player_id = 7187 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 = 4971 AND pts.player_id = 7187 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 = 4971 AND pts.player_id = 7187 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 = 4971 AND pts.player_id = 6314 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 = 4971 AND pts.player_id = 6314 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 = 4971 AND pts.player_id = 6314 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 = 4971 AND pts.player_id = 9913 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 = 4971 AND pts.player_id = 9913 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 = 4971 AND pts.player_id = 9913 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 = 4971 AND pts.player_id = 6603 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 = 4971 AND pts.player_id = 6603 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 = 4971 AND pts.player_id = 6603 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 = 4971 AND pts.player_id = 5907 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 = 4971 AND pts.player_id = 5907 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 = 4971 AND pts.player_id = 5907 GROUP BY pts.player_id

PLAYER NAME	TOTAL POINTS	EVENT POINTS	BONUS POINTS
Archambault, Norman	72	65.0	7
Barnes, David	30	10.0	20
Bergeron, Linda	10	10.0	0
Cramer, Marc	84	75.0	9
Dena Jr., Robert	10	10.0	0
Duprey, Ivan	104	95.0	9
Frieband, Tod	10	10.0	0
Gardner, Jim	52	45.0	7
Gundlach, Todd	114	105.0	9
Harry, Dave	62	55.0	7
Herzog, Frank	169	110.0	59
Hof, Alison	133	120.0	13
Johns, Ken	10	10.0	0
Johnson, John	67	60.0	7
maillet, Ron	94	85.0	9
Niazi, Haider	10	10.0	0
Pereira, Andre	10	10.0	0
Pitasi, Judy	47	40.0	7
Radovich, Matthew	37	30.0	7
Russell, Hank	10	10.0	0
Shuman, Jeff	10	10.0	0
Smith, Nada	99	90.0	9
Trautwein, Larry	89	80.0	9
Wagner, Steve	42	35.0	7
Wildeman, William	10	10.0	0
Wood, Bolly	57	50.0	7