(mysqli): SELECT * FROM event WHERE id = 11096
(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 = 11096 AND action = 'CHECK_IN'
(mysqli): SELECT COUNT(id) as cnt FROM event_photo WHERE event_id = 11096
(mysqli): SELECT COUNT(id) as cnt FROM comment WHERE type = 'event' AND _id = 11096
(mysqli): SELECT id FROM event_photo WHERE event_id = 11096 AND dflt = 1
(mysqli): SELECT photo_name, thumb_name FROM event_photo WHERE event_id = 11096 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 = 11096 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 = 11096 AND pts.player_id = 6071
(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 = 11096 AND pts.player_id = 6071
(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 = 11096 AND pts.player_id = 6071
(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 = 11096 AND pts.player_id = 21946
(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 = 11096 AND pts.player_id = 21946
(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 = 11096 AND pts.player_id = 21946
(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 = 11096 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 = 11096 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 = 11096 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 = 11096 AND pts.player_id = 9220
(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 = 11096 AND pts.player_id = 9220
(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 = 11096 AND pts.player_id = 9220
(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 = 11096 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 = 11096 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 = 11096 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 = 11096 AND pts.player_id = 16317
(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 = 11096 AND pts.player_id = 16317
(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 = 11096 AND pts.player_id = 16317
(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 = 11096 AND pts.player_id = 6063
(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 = 11096 AND pts.player_id = 6063
(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 = 11096 AND pts.player_id = 6063
(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 = 11096 AND pts.player_id = 10737
(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 = 11096 AND pts.player_id = 10737
(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 = 11096 AND pts.player_id = 10737
(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 = 11096 AND pts.player_id = 14168
(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 = 11096 AND pts.player_id = 14168
(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 = 11096 AND pts.player_id = 14168
(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 = 11096 AND pts.player_id = 1598
(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 = 11096 AND pts.player_id = 1598
(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 = 11096 AND pts.player_id = 1598
(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 = 11096 AND pts.player_id = 21478
(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 = 11096 AND pts.player_id = 21478
(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 = 11096 AND pts.player_id = 21478
(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 = 11096 AND pts.player_id = 1040
(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 = 11096 AND pts.player_id = 1040
(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 = 11096 AND pts.player_id = 1040
(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 = 11096 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 = 11096 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 = 11096 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 = 11096 AND pts.player_id = 27695
(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 = 11096 AND pts.player_id = 27695
(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 = 11096 AND pts.player_id = 27695
(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 = 11096 AND pts.player_id = 15559
(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 = 11096 AND pts.player_id = 15559
(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 = 11096 AND pts.player_id = 15559
(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 = 11096 AND pts.player_id = 27564
(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 = 11096 AND pts.player_id = 27564
(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 = 11096 AND pts.player_id = 27564
(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 = 11096 AND pts.action = 'CHECK_IN' ORDER BY p.last
(mysqli): SELECT id FROM player_pts WHERE event_id = 11096 AND player_id = 14168 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11096 AND player_id = 13304 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11096 AND player_id = 27694 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11096 AND player_id = 54 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11096 AND player_id = 27564 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11096 AND player_id = 27695 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11096 AND player_id = 5981 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11096 AND player_id = 9220 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11096 AND player_id = 27696 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11096 AND player_id = 6071 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11096 AND player_id = 6063 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11096 AND player_id = 1598 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11096 AND player_id = 6169 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11096 AND player_id = 21946 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11096 AND player_id = 771 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11096 AND player_id = 10737 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11096 AND player_id = 4136 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11096 AND player_id = 15559 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11096 AND player_id = 5178 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11096 AND player_id = 6348 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11096 AND player_id = 9370 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11096 AND player_id = 27656 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11096 AND player_id = 12326 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11096 AND player_id = 23258 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11096 AND player_id = 27697 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11096 AND player_id = 16317 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11096 AND player_id = 6639 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11096 AND player_id = 15332 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11096 AND player_id = 1040 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11096 AND player_id = 21983 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11096 AND player_id = 13773 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11096 AND player_id = 11569 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11096 AND player_id = 500 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11096 AND player_id = 1556 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11096 AND player_id = 7187 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11096 AND player_id = 7188 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11096 AND player_id = 11780 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11096 AND player_id = 21478 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11096 AND player_id = 14086 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11096 AND player_id = 22331 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11096 AND player_id = 3085 AND action != 'CHECK_IN'
VIEW EVENT
$45 CHEAPSTACK
$45 CHEAPSTACK
11/24/2012 @ 7:00 PM
155 Eastern Ave
Dedham American Legion
Dedham, MA
Registration Time:4 - 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