(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
Bar Poker Open Atlantic City Championship 2026
Bar Poker Open

(mysqli): SELECT id, name, city FROM location WHERE active = 1 ORDER BY name ASC  

(mysqli): SELECT id, name, state FROM tournament WHERE 1 ORDER BY name ASC  

(mysqli): SELECT * FROM location WHERE id = 493  

(mysqli): SELECT COUNT(pts.player_id) as num_players FROM event e INNER JOIN player_pts pts ON pts.event_id = e.id WHERE e.location_id = 493 AND pts.action = 'CHECK_IN' AND date <= 1792777527 AND active = 1 GROUP BY pts.event_id ORDER BY e.date ASC  

(mysqli): SELECT SUM(money_collected) as money_collected_sum FROM event e WHERE location_id = 493 AND active = 1  

(mysqli): SELECT COUNT(id) as cnt FROM event e WHERE location_id = 493 AND date >= 1792713600 AND active = 1  

(mysqli): SELECT COUNT(id) as cnt FROM location_photo WHERE location_id = 493  

(mysqli): SELECT COUNT(id) as cnt FROM comment WHERE type = 'location' AND _id = 493  

(mysqli): SELECT id FROM location_photo WHERE location_id = 493 AND dflt = 1  

(mysqli): SELECT photo_name, thumb_name FROM location_photo WHERE location_id = 493 AND dflt = 1 LIMIT 1  

(mysqli): SELECT p.id as trash, SUM(pts.points) as pts, pts.player_id, CONCAT(p.last,', ',p.first) as name FROM event e INNER JOIN player_pts pts ON pts.event_id = e.id INNER JOIN player p ON p.id = pts.player_id WHERE e.location_id = 493 GROUP BY pts.player_id ORDER BY pts DESC LIMIT 200  

(mysqli): SELECT ppts.player_id AS id, SUM(ppts.points) as pts FROM participation_points ppts INNER JOIN event e ON e.id = ppts.event_id WHERE e.location_id = 493 GROUP BY ppts.player_id  

(mysqli): SELECT bpts.player_id AS id, SUM(bpts.points) as pts FROM bounty_points bpts INNER JOIN event e ON e.id = bpts.event_id WHERE e.location_id = 493 GROUP BY bpts.player_id  

(mysqli): SELECT pts.player_id, COUNT(DISTINCT(pts.event_id)) as cnt FROM player_pts pts INNER JOIN event e ON e.id = pts.event_id WHERE e.location_id = 493 GROUP BY pts.player_id  

(mysqli): SELECT pts.player_id, COUNT(DISTINCT(event_id)) as cnt FROM player_pts pts INNER JOIN event e ON e.id = pts.event_id WHERE e.location_id = 493 AND action = 1 GROUP BY pts.player_id  

(mysqli): SELECT pts.player_id, COUNT(DISTINCT(event_id)) as cnt FROM player_pts pts INNER JOIN event e ON e.id = pts.event_id WHERE e.location_id = 493 AND (action = 1 OR action = 2 OR action = 3) GROUP BY pts.player_id  

(mysqli): SELECT pts.player_id, COUNT(DISTINCT(event_id)) as cnt FROM player_pts pts INNER JOIN event e ON e.id = pts.event_id WHERE e.location_id = 493 AND action != 'CHECK_IN' GROUP BY pts.player_id  

TOP 50 PLAYERS

#1  Harris, Shirley
453 Points / 6 Events
#2  Coleman, Matt
436 Points / 7 Events
#3  Pilato, Paul
410 Points / 6 Events
#4  Smith, Anthony
387 Points / 5 Events
#5  Daniels, Brent
377 Points / 7 Events
#6  VanClief, Brian
373 Points / 4 Events
#7  Mercier, Suzanne
350 Points / 5 Events
#8  Chouinard, Vickie
344 Points / 5 Events
#9  Maia, Leonardo
298 Points / 4 Events
#10  DeProfio, Tony
296 Points / 3 Events
#11  Avellan, Robyn
292 Points / 7 Events
#12  Martin, James
291 Points / 4 Events
#13  Beausoleil, Jerry
248 Points / 5 Events
#14  Gagnon, DJ
226 Points / 3 Events
#15  Lin, Ruby
224 Points / 7 Events
#16  Stevenson, Mary
223 Points / 5 Events
#17  Nawoichik, Richard B.
198 Points / 4 Events
#18  Pimentel, Crystal
195 Points / 6 Events
#19  Ellsworth, Daniel
191 Points / 1 Events
#20  Novel, Dennis
189 Points / 4 Events
#21  DeProfio, Pat
188 Points / 2 Events
#22  Lisi, Joe
186 Points / 1 Events
#23  Leone, Spencer
180 Points / 6 Events
#24  Driscoll, Tim
179 Points / 2 Events
#25  Tuttle, Noha
178 Points / 6 Events
#26  Stott, Robyn
170 Points / 4 Events
#27  Canniff, Lori
170 Points / 4 Events
#28  Lamothe, Don
165 Points / 4 Events
#29  Belluardo, Tom
158 Points / 3 Events
#30  Daigle, Linda
154 Points / 3 Events
#31  Hillman, Herb
148 Points / 2 Events
#32  Maille, Shawn
142 Points / 5 Events
#33  Foden, Janice
139 Points / 2 Events
#34  Fox, Paul
136 Points / 5 Events
#35  Moran, Bob
131 Points / 2 Events
#36  Doucette, Betsy
131 Points / 4 Events
#37  Ferchak, Michael
121 Points / 1 Events
#38  Johnson, Leonard
112 Points / 2 Events
#39  Micozzi, Judy
110 Points / 3 Events
#40  Coutu, Don
107 Points / 1 Events
#41  Cruz, Rob
107 Points / 3 Events
#42  Cruz, Charlene
107 Points / 1 Events
#43  Graham, Larry
96 Points / 2 Events
#44  Chmielecki, Jennifer
95 Points / 1 Events
#45  Hill, Heather
92 Points / 3 Events
#46  Masse, Dave
86 Points / 1 Events
#47  Micozzi, Andrew
86 Points / 3 Events
#48  Girard, Daniel
85 Points / 1 Events
#49  Saigbah, Mercy
84 Points / 2 Events
#50  Barrett, Carole
83 Points / 4 Events

LOCATION DETAILS

Scola's

101 Broadway Rd
Dracut, MA
01826

978-970-3838


COMPLETED EVENTS


(mysqli): SELECT id, name, city FROM location WHERE active = 1 ORDER BY name ASC  

(mysqli): SELECT id, name, state FROM tournament WHERE 1 ORDER BY name ASC  

GET DIRECTIONS

  ,     
  ,     

(mysqli): SELECT p.first, opt.nickname FROM player p LEFT JOIN player_opt opt ON p.id = opt.player_id WHERE p.id = 493  

(mysqli): SELECT opt.player_id, pp.thumb_name as thumb, CONCAT(p.first,' ',p.last) as name FROM player_opt opt LEFT JOIN player_photo pp ON opt.player_id = pp.player_id INNER JOIN player p ON p.id = opt.player_id WHERE opt.featured = 1 AND pp.dflt = 1  

FEATURED
PLAYERS

John Murray
Oswald Garlington
Paul Giroux
Greg Spirito
Steven Walsh
Paul Seely
Shane Matthews