(mysqli): SELECT * FROM event WHERE id = 40411
(mysqli): SELECT name FROM tournament WHERE id = 7 AND name LIKE 'charity%'
(mysqli): SELECT name FROM tournament WHERE id = 7
(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 l.*, t.start_date, t.end_date FROM location l INNER JOIN event e ON e.location_id = l.id INNER JOIN tournament t ON t.id = e.tournament_id WHERE l.id = 336
(mysqli): SELECT COUNT(player_id) as cnt FROM player_pts WHERE event_id = 40411 AND action = 'CHECK_IN'
(mysqli): SELECT COUNT(id) as cnt FROM event_photo WHERE event_id = 40411
(mysqli): SELECT COUNT(id) as cnt FROM comment WHERE type = 'event' AND _id = 40411
(mysqli): SELECT id FROM event_photo WHERE event_id = 40411 AND dflt = 1
(mysqli): SELECT photo_name, thumb_name FROM event_photo WHERE event_id = 40411 AND dflt = 1 LIMIT 1
(mysqli): SELECT pts.player_id as player_id, pts.action, CONCAT(p.last, ', ', p.first) as name, pts.earnings FROM player_pts pts INNER JOIN player p ON p.id = pts.player_id WHERE pts.event_id = 40411 AND pts.action != 'CHECK_IN' ORDER BY pts.points DESC
(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 = 40411 AND pts.player_id = 38787
(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 = 40411 AND pts.player_id = 38787
(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 = 40411 AND pts.player_id = 38787
(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 = 40411 AND pts.player_id = 53937
(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 = 40411 AND pts.player_id = 53937
(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 = 40411 AND pts.player_id = 53937
(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 = 40411 AND pts.player_id = 22444
(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 = 40411 AND pts.player_id = 22444
(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 = 40411 AND pts.player_id = 22444
(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 = 40411 AND pts.player_id = 37320
(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 = 40411 AND pts.player_id = 37320
(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 = 40411 AND pts.player_id = 37320
(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 = 40411 AND pts.player_id = 28680
(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 = 40411 AND pts.player_id = 28680
(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 = 40411 AND pts.player_id = 28680
(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 = 40411 AND pts.player_id = 22966
(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 = 40411 AND pts.player_id = 22966
(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 = 40411 AND pts.player_id = 22966
(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 = 40411 AND pts.player_id = 27131
(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 = 40411 AND pts.player_id = 27131
(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 = 40411 AND pts.player_id = 27131
(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 = 40411 AND pts.player_id = 21906
(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 = 40411 AND pts.player_id = 21906
(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 = 40411 AND pts.player_id = 21906
(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 = 40411 AND pts.player_id = 17565
(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 = 40411 AND pts.player_id = 17565
(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 = 40411 AND pts.player_id = 17565
(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 = 40411 AND pts.player_id = 50271
(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 = 40411 AND pts.player_id = 50271
(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 = 40411 AND pts.player_id = 50271
(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 = 40411 AND pts.player_id = 39283
(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 = 40411 AND pts.player_id = 39283
(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 = 40411 AND pts.player_id = 39283
(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 = 40411 AND pts.action = 'CHECK_IN' ORDER BY p.last
(mysqli): SELECT id FROM player_pts WHERE event_id = 40411 AND player_id = 27667 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 40411 AND player_id = 53937 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 40411 AND player_id = 38787 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 40411 AND player_id = 37320 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 40411 AND player_id = 39283 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 40411 AND player_id = 20960 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 40411 AND player_id = 17565 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 40411 AND player_id = 28680 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 40411 AND player_id = 22966 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 40411 AND player_id = 21906 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 40411 AND player_id = 22444 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 40411 AND player_id = 42817 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 40411 AND player_id = 23043 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 40411 AND player_id = 27131 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 40411 AND player_id = 12167 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 40411 AND player_id = 40681 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 40411 AND player_id = 51296 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 40411 AND player_id = 50271 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 40411 AND player_id = 50445 AND action != 'CHECK_IN'
VIEW EVENT
World Series of Poker Main Event Satellite Charity Event
Walpole VFW
06/01/2024 @ 11:00 AM
108 Robbins Road
Walpole, MA
Registration Time:10:30AM
First Hand Dealt At:11:00AM
Saturday, June 1, 2024
World Series of Poker Main Event Satellite Charity Event
11:00 AM
- $700 for 30,000 Chips
- 30 Min Levels
- 1 in 20 Win $11,000 WSOP Main Event Packages
WSOP Main Event Package Includes:
- $10,000 Main Event Entry
- $1,000 Hotel and Travel Stipend
- Before you ask... Package is not transferrable, you cannot take the money, but you can defer it to 2025 if you can't make it fit your schedule this year! There are plenty of tournaments to take the money, this isn't one of them :)
This event is part of the Charity tournaments Tour
- Buy In:
- $700.00
(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