(mysqli): SELECT * FROM event WHERE id = 11368
(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 = 405
(mysqli): SELECT COUNT(player_id) as cnt FROM player_pts WHERE event_id = 11368 AND action = 'CHECK_IN'
(mysqli): SELECT COUNT(id) as cnt FROM event_photo WHERE event_id = 11368
(mysqli): SELECT COUNT(id) as cnt FROM comment WHERE type = 'event' AND _id = 11368
(mysqli): SELECT id FROM event_photo WHERE event_id = 11368 AND dflt = 1
(mysqli): SELECT photo_name, thumb_name FROM event_photo WHERE event_id = 11368 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 = 11368 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 = 11368 AND pts.player_id = 15221
(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 = 11368 AND pts.player_id = 15221
(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 = 11368 AND pts.player_id = 15221
(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 = 11368 AND pts.player_id = 23414
(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 = 11368 AND pts.player_id = 23414
(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 = 11368 AND pts.player_id = 23414
(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 = 11368 AND pts.player_id = 13706
(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 = 11368 AND pts.player_id = 13706
(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 = 11368 AND pts.player_id = 13706
(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 = 11368 AND pts.player_id = 15185
(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 = 11368 AND pts.player_id = 15185
(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 = 11368 AND pts.player_id = 15185
(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 = 11368 AND pts.player_id = 27521
(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 = 11368 AND pts.player_id = 27521
(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 = 11368 AND pts.player_id = 27521
(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 = 11368 AND pts.player_id = 20395
(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 = 11368 AND pts.player_id = 20395
(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 = 11368 AND pts.player_id = 20395
(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 = 11368 AND pts.player_id = 7188
(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 = 11368 AND pts.player_id = 7188
(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 = 11368 AND pts.player_id = 7188
(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 = 11368 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 = 11368 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 = 11368 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 = 11368 AND pts.player_id = 24534
(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 = 11368 AND pts.player_id = 24534
(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 = 11368 AND pts.player_id = 24534
(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 = 11368 AND pts.player_id = 22707
(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 = 11368 AND pts.player_id = 22707
(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 = 11368 AND pts.player_id = 22707
(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 = 11368 AND pts.player_id = 13949
(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 = 11368 AND pts.player_id = 13949
(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 = 11368 AND pts.player_id = 13949
(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 = 11368 AND pts.player_id = 22990
(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 = 11368 AND pts.player_id = 22990
(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 = 11368 AND pts.player_id = 22990
(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 = 11368 AND pts.player_id = 21184
(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 = 11368 AND pts.player_id = 21184
(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 = 11368 AND pts.player_id = 21184
(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 = 11368 AND pts.player_id = 12893
(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 = 11368 AND pts.player_id = 12893
(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 = 11368 AND pts.player_id = 12893
(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 = 11368 AND pts.player_id = 21241
(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 = 11368 AND pts.player_id = 21241
(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 = 11368 AND pts.player_id = 21241
(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 = 11368 AND pts.action = 'CHECK_IN' ORDER BY p.last
(mysqli): SELECT id FROM player_pts WHERE event_id = 11368 AND player_id = 27946 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11368 AND player_id = 8187 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11368 AND player_id = 20395 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11368 AND player_id = 12893 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11368 AND player_id = 6063 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11368 AND player_id = 6071 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11368 AND player_id = 22607 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11368 AND player_id = 23104 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11368 AND player_id = 13706 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11368 AND player_id = 27737 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11368 AND player_id = 13949 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11368 AND player_id = 21184 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11368 AND player_id = 21117 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11368 AND player_id = 24534 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11368 AND player_id = 27521 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11368 AND player_id = 22990 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11368 AND player_id = 12286 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11368 AND player_id = 6278 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11368 AND player_id = 21241 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11368 AND player_id = 16317 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11368 AND player_id = 15221 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11368 AND player_id = 15185 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11368 AND player_id = 22707 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11368 AND player_id = 23414 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11368 AND player_id = 27131 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11368 AND player_id = 23874 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11368 AND player_id = 23538 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11368 AND player_id = 11918 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11368 AND player_id = 7188 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11368 AND player_id = 7187 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11368 AND player_id = 26710 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11368 AND player_id = 5359 AND action != 'CHECK_IN'
VIEW EVENT
$45 CHEAPSTACK
$45 CHEAPSTACK
12/29/2012 @ 7:00 PM
155 Eastern Ave
Dedham American Legion
Dedham, MA
Registration Time:5 - 7PM
First Hand Dealt At:7:00 PM
3:00 PM – 6:00 PM
- $15 SINGLE TABLE SATELLITES (2 IN 10 ADVANCE TO MAIN EVENT)
- 2,000 STARTING STACKS, 10 MIN LEVELS, 25/50 STARTING BLINDS
7:00 PM - DEEPSTACK CHEAPSTACK!
- $45 FOR 10,000 CHIPS
- SINGLE RE-ENTRY ALLOWED THROUGH REGISTRATION DESK
- 25/50 STARTING BLINDS, 15 MIN LEVELS
1/2 NO LIMIT ALL NIGHT
This event is part of the Charity tournaments Tour
- Buy In:
- $45.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