(mysqli): SELECT * FROM event WHERE id = 8823
(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 = 330
(mysqli): SELECT COUNT(player_id) as cnt FROM player_pts WHERE event_id = 8823 AND action = 'CHECK_IN'
(mysqli): SELECT COUNT(id) as cnt FROM event_photo WHERE event_id = 8823
(mysqli): SELECT COUNT(id) as cnt FROM comment WHERE type = 'event' AND _id = 8823
(mysqli): SELECT id FROM event_photo WHERE event_id = 8823 AND dflt = 1
(mysqli): SELECT photo_name, thumb_name FROM event_photo WHERE event_id = 8823 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 = 8823 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 = 8823 AND pts.player_id = 7190
(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 = 8823 AND pts.player_id = 7190
(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 = 8823 AND pts.player_id = 7190
(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 = 8823 AND pts.player_id = 3670
(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 = 8823 AND pts.player_id = 3670
(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 = 8823 AND pts.player_id = 3670
(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 = 8823 AND pts.player_id = 7251
(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 = 8823 AND pts.player_id = 7251
(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 = 8823 AND pts.player_id = 7251
(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 = 8823 AND pts.player_id = 12471
(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 = 8823 AND pts.player_id = 12471
(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 = 8823 AND pts.player_id = 12471
(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 = 8823 AND pts.player_id = 22882
(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 = 8823 AND pts.player_id = 22882
(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 = 8823 AND pts.player_id = 22882
(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 = 8823 AND pts.player_id = 18965
(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 = 8823 AND pts.player_id = 18965
(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 = 8823 AND pts.player_id = 18965
(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 = 8823 AND pts.player_id = 8322
(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 = 8823 AND pts.player_id = 8322
(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 = 8823 AND pts.player_id = 8322
(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 = 8823 AND pts.player_id = 22880
(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 = 8823 AND pts.player_id = 22880
(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 = 8823 AND pts.player_id = 22880
(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 = 8823 AND pts.player_id = 22094
(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 = 8823 AND pts.player_id = 22094
(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 = 8823 AND pts.player_id = 22094
(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 = 8823 AND pts.player_id = 21435
(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 = 8823 AND pts.player_id = 21435
(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 = 8823 AND pts.player_id = 21435
(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 = 8823 AND pts.player_id = 12843
(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 = 8823 AND pts.player_id = 12843
(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 = 8823 AND pts.player_id = 12843
(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 = 8823 AND pts.player_id = 15498
(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 = 8823 AND pts.player_id = 15498
(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 = 8823 AND pts.player_id = 15498
(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 = 8823 AND pts.player_id = 21288
(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 = 8823 AND pts.player_id = 21288
(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 = 8823 AND pts.player_id = 21288
(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 = 8823 AND pts.player_id = 22502
(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 = 8823 AND pts.player_id = 22502
(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 = 8823 AND pts.player_id = 22502
(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 = 8823 AND pts.action = 'CHECK_IN' ORDER BY p.last
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 10909 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 10331 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 13304 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 15420 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 14777 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 8698 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 22882 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 22093 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 14046 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 22094 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 22229 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 12527 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 21193 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 21435 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 12718 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 3670 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 22502 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 15605 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 11492 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 13706 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 11833 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 21288 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 22032 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 21521 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 22879 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 331 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 12843 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 21848 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 8322 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 22786 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 12705 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 22565 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 22990 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 3911 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 17866 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 8135 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 14489 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 5443 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 22846 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 13313 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 7190 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 18965 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 9119 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 10453 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 10609 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 22633 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 1 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 21187 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 11193 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 22881 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 22878 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 22685 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 14771 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 22729 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 22856 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 15498 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 15497 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 6639 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 9143 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 11805 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 8657 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 12471 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 11147 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 7156 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 22228 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 22872 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 9820 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 7251 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 11918 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 8661 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 4660 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 22118 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 14086 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 8823 AND player_id = 22880 AND action != 'CHECK_IN'
VIEW EVENT
10K211
New Year's Day $10,000 GTD SUPERSTACK
02/11/2012
Elks Club
152 Winslow Ave
Norwood, MA
Registration Time:12 - 4 PM
First Hand Dealt At:4:00 PM
11:30 PM - $20 SUPER-SATELLITE
- MULTI TABLE FORMAT (1 in 10 advance to main tournament)
- 5 SEATS GUARANTEED ($750 IN SEATS) MORE IF WE BREAK 50
- 5,000 Starting stack, 10 min levels, no antes
$40 SATELLITES 12:00 PM – 3:00 PM
- SINGLE TABLE FORMAT (Top 2 per table advance to main event)
- 3,000 starting stack, 10 min levels, no antes
4:00 PM MAIN EVENT - $10,000 GUARANTEED PAYOUT
- $150 Donation for 15,000 starting stack
- $10 Extra donation for 5,000 chips
- 20 minute levels, 25/50 starting blinds
$10,000 FINAL TABLE PAYOUT IS GUARANTEED!
$3,500 FIRST PLACE IS GUARANTEED
70% Payout after guarantee is met
~ ½ NO LIMIT, SIT N GO’S WILL BE AVAILABLE THROUGHOUT THE EVENING ON DEMAND ~
This event is part of the Charity tournaments Tour
- Buy In:
- $150.00
- Pay Out:
| Rank |
> 40 |
41 - 80 |
81 - 120 |
121 - 160 |
161 - 200 |
> 201 |
1 |
50.00% |
42.00% |
35.00% |
32.00% |
30.00% |
28.50% |
2 |
30.00% |
22.00% |
18.00% |
17.00% |
16.25% |
15.00% |
3 |
20.00% |
12.00% |
10.25% |
9.75% |
9.50% |
9.25% |
4 |
|
9.00% |
8.50% |
8.00% |
7.75% |
7.50% |
5 |
|
8.00% |
7.50% |
7.00% |
6.75% |
6.50% |
6 |
|
7.00% |
6.50% |
6.00% |
5.75% |
5.50% |
7 |
|
|
5.50% |
5.00% |
4.75% |
4.50% |
8 |
|
|
4.75% |
4.25% |
4.00% |
3.75% |
9 |
|
|
4.00% |
3.50% |
3.25% |
3.00% |
10-12 |
|
|
|
2.50% |
2.25% |
2.25% |
13-15 |
|
|
|
|
1.75% |
1.75% |
16-18 |
|
|
|
|
|
1.50% |
*This is meant to be only a guideline and reference for charities. Typically payouts are rounded to the nearest $50 and paid in accordance to MA State Laws.
Management reserves the right to limit seating, cancel or modify tournaments in the best interest of the hosting charity at its sole discretion and without prior notice.
(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