(mysqli): SELECT * FROM event WHERE id = 11141
(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 = 404
(mysqli): SELECT COUNT(player_id) as cnt FROM player_pts WHERE event_id = 11141 AND action = 'CHECK_IN'
(mysqli): SELECT COUNT(id) as cnt FROM event_photo WHERE event_id = 11141
(mysqli): SELECT COUNT(id) as cnt FROM comment WHERE type = 'event' AND _id = 11141
(mysqli): SELECT id FROM event_photo WHERE event_id = 11141 AND dflt = 1
(mysqli): SELECT photo_name, thumb_name FROM event_photo WHERE event_id = 11141 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 = 11141 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 = 11141 AND pts.player_id = 13801
(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 = 11141 AND pts.player_id = 13801
(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 = 11141 AND pts.player_id = 13801
(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 = 11141 AND pts.player_id = 23056
(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 = 11141 AND pts.player_id = 23056
(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 = 11141 AND pts.player_id = 23056
(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 = 11141 AND pts.player_id = 11918
(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 = 11141 AND pts.player_id = 11918
(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 = 11141 AND pts.player_id = 11918
(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 = 11141 AND pts.player_id = 27483
(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 = 11141 AND pts.player_id = 27483
(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 = 11141 AND pts.player_id = 27483
(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 = 11141 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 = 11141 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 = 11141 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 = 11141 AND pts.player_id = 16731
(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 = 11141 AND pts.player_id = 16731
(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 = 11141 AND pts.player_id = 16731
(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 = 11141 AND pts.player_id = 13304
(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 = 11141 AND pts.player_id = 13304
(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 = 11141 AND pts.player_id = 13304
(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 = 11141 AND pts.player_id = 20643
(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 = 11141 AND pts.player_id = 20643
(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 = 11141 AND pts.player_id = 20643
(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 = 11141 AND pts.player_id = 8187
(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 = 11141 AND pts.player_id = 8187
(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 = 11141 AND pts.player_id = 8187
(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 = 11141 AND pts.player_id = 1649
(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 = 11141 AND pts.player_id = 1649
(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 = 11141 AND pts.player_id = 1649
(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 = 11141 AND pts.player_id = 11492
(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 = 11141 AND pts.player_id = 11492
(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 = 11141 AND pts.player_id = 11492
(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 = 11141 AND pts.player_id = 27740
(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 = 11141 AND pts.player_id = 27740
(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 = 11141 AND pts.player_id = 27740
(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 = 11141 AND pts.player_id = 21187
(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 = 11141 AND pts.player_id = 21187
(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 = 11141 AND pts.player_id = 21187
(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 = 11141 AND pts.player_id = 10609
(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 = 11141 AND pts.player_id = 10609
(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 = 11141 AND pts.player_id = 10609
(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 = 11141 AND pts.player_id = 23258
(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 = 11141 AND pts.player_id = 23258
(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 = 11141 AND pts.player_id = 23258
(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 = 11141 AND pts.action = 'CHECK_IN' ORDER BY p.last
(mysqli): SELECT id FROM player_pts WHERE event_id = 11141 AND player_id = 5191 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11141 AND player_id = 13304 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11141 AND player_id = 8187 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11141 AND player_id = 21435 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11141 AND player_id = 12726 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11141 AND player_id = 11446 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11141 AND player_id = 11492 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11141 AND player_id = 23056 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11141 AND player_id = 27740 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11141 AND player_id = 15215 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11141 AND player_id = 15213 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11141 AND player_id = 9122 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11141 AND player_id = 1649 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11141 AND player_id = 20643 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11141 AND player_id = 10609 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11141 AND player_id = 21187 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11141 AND player_id = 23258 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11141 AND player_id = 15498 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11141 AND player_id = 27483 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11141 AND player_id = 5363 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11141 AND player_id = 16731 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11141 AND player_id = 20983 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11141 AND player_id = 13787 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11141 AND player_id = 11918 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11141 AND player_id = 13801 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11141 AND player_id = 15078 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11141 AND player_id = 23494 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11141 AND player_id = 11780 AND action != 'CHECK_IN'
VIEW EVENT
$150 SUPERSTACK
$150 SUPERSTACK
12/08/2012 @ 2:00 PM
14 Church Street
Knights of Columbus
Foxboro, MA
Registration Time:11 - 2PM
First Hand Dealt At:2:00 PM
2:00 PM - $150 SUPERSTACK
$150 for 20,000 starting stack
Extra $10 for a 25,000 starting stack
25/50 starting blinds
Super Deep Structure
20 min blinds first 10 levels
30 min blinds after level 10
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