(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 = 632
(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 = 632 AND pts.action = 'CHECK_IN' AND date <= 1792787326 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 = 632 AND active = 1
(mysqli): SELECT COUNT(id) as cnt FROM event e WHERE location_id = 632 AND date >= 1792713600 AND active = 1
(mysqli): SELECT COUNT(id) as cnt FROM location_photo WHERE location_id = 632
(mysqli): SELECT COUNT(id) as cnt FROM comment WHERE type = 'location' AND _id = 632
(mysqli): SELECT id FROM location_photo WHERE location_id = 632 AND dflt = 1
(mysqli): SELECT photo_name, thumb_name FROM location_photo WHERE location_id = 632 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 = 632 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 = 632 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 = 632 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 = 632 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 = 632 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 = 632 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 = 632 AND action != 'CHECK_IN' GROUP BY pts.player_id
LOCATION DETAILS
$40 BPO TRAVEL SATELLITE @ Walpole VFW
108 Robbins Road
Walpole VFW
Walpole, MA
Bar Poker Open !!!
Win A Travel Package to this year’s $400,000+ National Championship Every Week. First Place has a guaranteed prize of $100,000!
You will win a full package to play for an estimated payout of 400,000 against other poker league players across the country AND stay at the premiere poker destination in North America by winning this event!
12:30 PM Registration
1:00 PM FIRST HAND
- $40 DONATION FOR 15,000 CHIPS 100/100 STARTING BLINDSs
- - 20 MIN LEVELS THROUGHOUT ENTIRE EVENT
-- RE-ENTRY ALLOWED FIRST 6 LEVELS
- $40 ADD-ON FOR 20,000 CHIPS DURING BREAK
-ALL PLAYERS WELCOME TO BUY-IN FOR $40
- DISCOUNT TICKET HOLDERS ONLY PAY $10 INITIAL ENTRY ($30 DISCOUNT)
- FINISH TOP 10% AT ANY EPT EVENT TO WIN A $40 DISCOUNT TICKET
PRIZES:
[EVERY 50 ENTRIES] WE GIVE AWAY A BPO VEGAS PACKAGE
1 PACKAGES GUARANTEED EVERY SINGLE EVENT!!!!!
- - 5 NIGHTS 6 DAY STAY AT GOLDEN NUGGET [SUN(6/11/23) - FRI(6/16/23))
- - DAY 1A SEAT INTO THE $400,000 CHAMPIONSHIP W/ $100,000 GUARANTEED 1ST PLACE!
- $400 TRAVEL REIMBURSEMENT TO PICK UP IN VEGAS
[EVERY 5 ENTRIES] IN BETWEEN THE 50 ENTRIES ROUNDED UP
WE GIVE AWAY A $120 WSOP/BPO FINALE SEAT
(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
