(mysqli): SELECT * FROM event WHERE id = 11934
(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 = 435
(mysqli): SELECT COUNT(player_id) as cnt FROM player_pts WHERE event_id = 11934 AND action = 'CHECK_IN'
(mysqli): SELECT COUNT(id) as cnt FROM event_photo WHERE event_id = 11934
(mysqli): SELECT COUNT(id) as cnt FROM comment WHERE type = 'event' AND _id = 11934
(mysqli): SELECT id FROM event_photo WHERE event_id = 11934 AND dflt = 1
(mysqli): SELECT photo_name, thumb_name FROM event_photo WHERE event_id = 11934 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 = 11934 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 = 11934 AND pts.player_id = 15605
(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 = 11934 AND pts.player_id = 15605
(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 = 11934 AND pts.player_id = 15605
(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 = 11934 AND pts.player_id = 10305
(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 = 11934 AND pts.player_id = 10305
(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 = 11934 AND pts.player_id = 10305
(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 = 11934 AND pts.player_id = 10536
(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 = 11934 AND pts.player_id = 10536
(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 = 11934 AND pts.player_id = 10536
(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 = 11934 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 = 11934 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 = 11934 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 = 11934 AND pts.player_id = 12454
(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 = 11934 AND pts.player_id = 12454
(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 = 11934 AND pts.player_id = 12454
(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 = 11934 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 = 11934 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 = 11934 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 = 11934 AND pts.player_id = 11780
(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 = 11934 AND pts.player_id = 11780
(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 = 11934 AND pts.player_id = 11780
(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 = 11934 AND pts.player_id = 14086
(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 = 11934 AND pts.player_id = 14086
(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 = 11934 AND pts.player_id = 14086
(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 = 11934 AND pts.player_id = 8415
(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 = 11934 AND pts.player_id = 8415
(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 = 11934 AND pts.player_id = 8415
(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 = 11934 AND pts.player_id = 991
(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 = 11934 AND pts.player_id = 991
(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 = 11934 AND pts.player_id = 991
(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 = 11934 AND pts.player_id = 6169
(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 = 11934 AND pts.player_id = 6169
(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 = 11934 AND pts.player_id = 6169
(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 = 11934 AND pts.player_id = 21059
(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 = 11934 AND pts.player_id = 21059
(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 = 11934 AND pts.player_id = 21059
(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 = 11934 AND pts.action = 'CHECK_IN' ORDER BY p.last
(mysqli): SELECT id FROM player_pts WHERE event_id = 11934 AND player_id = 7007 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11934 AND player_id = 15420 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11934 AND player_id = 26946 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11934 AND player_id = 991 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11934 AND player_id = 23723 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11934 AND player_id = 28197 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11934 AND player_id = 24882 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11934 AND player_id = 20395 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11934 AND player_id = 21059 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11934 AND player_id = 6063 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11934 AND player_id = 6071 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11934 AND player_id = 12454 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11934 AND player_id = 6169 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11934 AND player_id = 25015 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11934 AND player_id = 13942 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11934 AND player_id = 6834 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11934 AND player_id = 15605 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11934 AND player_id = 23104 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11934 AND player_id = 21521 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11934 AND player_id = 23056 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11934 AND player_id = 5223 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11934 AND player_id = 9122 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11934 AND player_id = 28429 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11934 AND player_id = 17866 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11934 AND player_id = 10296 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11934 AND player_id = 20643 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11934 AND player_id = 10609 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11934 AND player_id = 24977 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11934 AND player_id = 22613 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11934 AND player_id = 22993 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11934 AND player_id = 15497 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11934 AND player_id = 11147 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11934 AND player_id = 10305 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11934 AND player_id = 11038 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11934 AND player_id = 23459 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11934 AND player_id = 6894 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11934 AND player_id = 10536 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11934 AND player_id = 8415 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11934 AND player_id = 11780 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11934 AND player_id = 3446 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11934 AND player_id = 14086 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11934 AND player_id = 6375 AND action != 'CHECK_IN'
VIEW EVENT
$150 SUPERSTACK
$150 SUPERSTACK
03/16/2013 @ 2:00 PM
4 Hayward Field
Italian American Veterans Club
Milford, MA
01757
Registration Time:11:00 AM
First Hand Dealt At:2:00 PM
11:00 AM - $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
1/2 No Limit Available All Day!
This event is part of the Charity tournaments Tour
- Buy In:
- $150.00
- Pay Out:
| LEVEL |
SM |
BIG |
ANTE |
TIME |
| |
|
|
|
|
| 1 |
25 |
50 |
|
20 |
| 2 |
50 |
100 |
|
20 |
| 3 |
100 |
200 |
|
20 |
| 4 |
150 |
300 |
|
20 |
| 5 |
200 |
400 |
|
20 |
| 6 |
300 |
600 |
|
20 |
| 7 |
400 |
800 |
100 |
20 |
| 8 |
600 |
1,200 |
100 |
30 |
| 9 |
800 |
1,600 |
200 |
30 |
| 10 |
1,000 |
2,000 |
300 |
30 |
| 11 |
1,500 |
3,000 |
400 |
30 |
| 12 |
2,000 |
4,000 |
500 |
30 |
| 13 |
3,000 |
6,000 |
500 |
30 |
| 14 |
4,000 |
8,000 |
1,000 |
30 |
| 15 |
6,000 |
12,000 |
1,000 |
30 |
| 16 |
8,000 |
16,000 |
2,000 |
30 |
| 17 |
10,000 |
20,000 |
3,000 |
30 |
| 18 |
15,000 |
30,000 |
4,000 |
30 |
| 19 |
20,000 |
40,000 |
5,000 |
30 |
| 20 |
30,000 |
60,000 |
5,000 |
30 |
| 21 |
40,000 |
80,000 |
10,000 |
30 |
Future levels at the discretion of floor manager.
Breaks are posted on site and are held for 10 minutes every 4 levels but are ultimately at the discretion of the floor. |
|
|
|
|
|
|
|
| |
PAYOUT TABLE |
|
< 30 |
31 - 60 |
61 - 80 |
81 - 100 |
101 - 150 |
151 - 200 |
1 |
43.00% |
39.00% |
30.30% |
29.00% |
28.50% |
26.75% |
2 |
25.00% |
23.00% |
19.25% |
17.00% |
16.00% |
14.50% |
3 |
18.00% |
16.00% |
13.10% |
11.50% |
10.10% |
9.80% |
4 |
14.00% |
12.00% |
10.40% |
9.40% |
8.10% |
7.90% |
5 |
|
10.00% |
8.55% |
8.00% |
6.50% |
5.75% |
6 |
|
|
7.20% |
6.90% |
5.20% |
4.70% |
7 |
|
|
6.10% |
5.85% |
4.30% |
4.05% |
8 |
|
|
5.10% |
4.85% |
3.60% |
3.55% |
9 |
|
|
|
4.10% |
3.15% |
2.95% |
10 |
|
|
|
3.40% |
2.60% |
2.00% |
11 - 12 |
|
|
|
|
2.60% |
2.00% |
13 - 15 |
|
|
|
|
2.25% |
1.85% |
16 - 20 |
|
|
|
|
|
1.70% |
|
|
|
|
|
|
|
(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