(mysqli): SELECT * FROM event WHERE id = 11095
(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 = 11095 AND action = 'CHECK_IN'
(mysqli): SELECT COUNT(id) as cnt FROM event_photo WHERE event_id = 11095
(mysqli): SELECT COUNT(id) as cnt FROM comment WHERE type = 'event' AND _id = 11095
(mysqli): SELECT id FROM event_photo WHERE event_id = 11095 AND dflt = 1
(mysqli): SELECT photo_name, thumb_name FROM event_photo WHERE event_id = 11095 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 = 11095 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 = 11095 AND pts.player_id = 9479
(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 = 11095 AND pts.player_id = 9479
(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 = 11095 AND pts.player_id = 9479
(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 = 11095 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 = 11095 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 = 11095 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 = 11095 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 = 11095 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 = 11095 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 = 11095 AND pts.player_id = 22613
(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 = 11095 AND pts.player_id = 22613
(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 = 11095 AND pts.player_id = 22613
(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 = 11095 AND pts.player_id = 15078
(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 = 11095 AND pts.player_id = 15078
(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 = 11095 AND pts.player_id = 15078
(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 = 11095 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 = 11095 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 = 11095 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 = 11095 AND pts.player_id = 13762
(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 = 11095 AND pts.player_id = 13762
(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 = 11095 AND pts.player_id = 13762
(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 = 11095 AND pts.player_id = 21193
(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 = 11095 AND pts.player_id = 21193
(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 = 11095 AND pts.player_id = 21193
(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 = 11095 AND pts.player_id = 27696
(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 = 11095 AND pts.player_id = 27696
(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 = 11095 AND pts.player_id = 27696
(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 = 11095 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 = 11095 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 = 11095 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 = 11095 AND pts.player_id = 15757
(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 = 11095 AND pts.player_id = 15757
(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 = 11095 AND pts.player_id = 15757
(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 = 11095 AND pts.player_id = 8650
(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 = 11095 AND pts.player_id = 8650
(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 = 11095 AND pts.player_id = 8650
(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 = 11095 AND pts.player_id = 9370
(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 = 11095 AND pts.player_id = 9370
(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 = 11095 AND pts.player_id = 9370
(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 = 11095 AND pts.player_id = 5534
(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 = 11095 AND pts.player_id = 5534
(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 = 11095 AND pts.player_id = 5534
(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 = 11095 AND pts.player_id = 11147
(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 = 11095 AND pts.player_id = 11147
(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 = 11095 AND pts.player_id = 11147
(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 = 11095 AND pts.action = 'CHECK_IN' ORDER BY p.last
(mysqli): SELECT id FROM player_pts WHERE event_id = 11095 AND player_id = 13304 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11095 AND player_id = 8187 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11095 AND player_id = 27696 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11095 AND player_id = 6063 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11095 AND player_id = 6071 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11095 AND player_id = 16729 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11095 AND player_id = 6169 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11095 AND player_id = 21193 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11095 AND player_id = 21435 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11095 AND player_id = 21288 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11095 AND player_id = 6348 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11095 AND player_id = 15757 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11095 AND player_id = 5534 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11095 AND player_id = 9370 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11095 AND player_id = 13762 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11095 AND player_id = 13389 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11095 AND player_id = 8650 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11095 AND player_id = 18965 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11095 AND player_id = 21187 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11095 AND player_id = 16317 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11095 AND player_id = 9479 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11095 AND player_id = 22613 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11095 AND player_id = 5363 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11095 AND player_id = 11147 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11095 AND player_id = 13773 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11095 AND player_id = 11918 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11095 AND player_id = 7188 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11095 AND player_id = 7187 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11095 AND player_id = 15078 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11095 AND player_id = 6375 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11095 AND player_id = 3148 AND action != 'CHECK_IN'
VIEW EVENT
$150 SUPERSTACK
$150 SUPERSTACK
11/24/2012 @ 2:00 PM
14 Church Street
Knights of Columbus
Foxboro, MA
Registration Time:11 - 2P
First Hand Dealt At:2:00 PM
11:00 AM - $25 SUPERSATELLITE
*Free with voucher from 72K championship. You must have voucher with you to redeem.
- 15,000 starting stack, 10 min levels, 100-200 starting blinds, no antes
12:00 PM - $40 SATELLITES (Top 2 Per Table Advance)
- 3,000 starting stack
- 10 min levels
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