(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 = 569
(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 = 569 AND pts.action = 'CHECK_IN' AND date <= 1792775711 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 = 569 AND active = 1
(mysqli): SELECT COUNT(id) as cnt FROM event e WHERE location_id = 569 AND date >= 1792713600 AND active = 1
(mysqli): SELECT COUNT(id) as cnt FROM location_photo WHERE location_id = 569
(mysqli): SELECT COUNT(id) as cnt FROM comment WHERE type = 'location' AND _id = 569
(mysqli): SELECT id FROM location_photo WHERE location_id = 569 AND dflt = 1
(mysqli): SELECT photo_name, thumb_name FROM location_photo WHERE location_id = 569 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 = 569 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 = 569 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 = 569 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 = 569 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 = 569 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 = 569 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 = 569 AND action != 'CHECK_IN' GROUP BY pts.player_id
LOCATION DETAILS
WSOP BPO TRAVEL PACKAGE GRAND FINALE- $120
VFW
108 Robbins Road
Walpole, MA
Top 10% Every Night
Our last Travel Satellite will be insane with over 5 BPO VEGAS VACATIONS GUARANTEED AND A WSOP MILLIONAIRE MAKER SEAT ADDED TO 1st PLACE!
SATURDAY, MAY 18th, 11:00 AM at The Walpole VFW108 Robbins Road, Walpole, MA
$120 BPO TRAVEL SATELLITE FINALE
- 15,000 Starting Stack (100/100 starting blinds)
- 20 Min Levels- Re-entry Allowed First 6 Levels/ 15 min levels after level 6
- $60 Add-On Available for 30,000 Chips after level 6
Cost
- $120 for 15,000 starting chips or
- Use up to (4)UNEXPIRED Top 10% tickets offset price or to FREE-ROLL by using all 4!
Prize Format:
1 in 15 Win 2019 BPO Vegas Packages that Include
- $400 Airfare Reimbursement
- 6 Days / 5 Nights at Golden Nugget Hotel & Casino
- Dates include Check in: Sunday, June 9, Check out: Friday, June 14, 2019
- Seat into Day 1A of the $200,000 National Championship
1ST PLACE ALSO RECEIVES WSOP MILLIONAIRE MAKER SEAT to be played June 7-June 10th, 2019.
Top 10% Ticket Rules:
- Tickets won at all EPT Events (Top 10% Rounded Down)
- Tickets can only be reimbursed for initial buy-in
- Tickets are not transferable to any other player
- Tickets must be signed and dated by EPT Manager for redemption
- Tickets cannot be used for add-on or re-entry
Prize Package Rules:
- BPO Prize Package must be used for BPO Vegas 2018
- Prizes package is non-transferable and has no cash value
- Prior Package winners cannot participate in this event
- Prior Seat winners do not receive any additional benefits other than travel and hotel
(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
