(mysqli): SELECT * FROM event WHERE id = 11119
(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 = 11119 AND action = 'CHECK_IN'
(mysqli): SELECT COUNT(id) as cnt FROM event_photo WHERE event_id = 11119
(mysqli): SELECT COUNT(id) as cnt FROM comment WHERE type = 'event' AND _id = 11119
(mysqli): SELECT id FROM event_photo WHERE event_id = 11119 AND dflt = 1
(mysqli): SELECT photo_name, thumb_name FROM event_photo WHERE event_id = 11119 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 = 11119 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 = 11119 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 = 11119 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 = 11119 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 = 11119 AND pts.player_id = 5166
(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 = 11119 AND pts.player_id = 5166
(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 = 11119 AND pts.player_id = 5166
(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 = 11119 AND pts.player_id = 6348
(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 = 11119 AND pts.player_id = 6348
(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 = 11119 AND pts.player_id = 6348
(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 = 11119 AND pts.player_id = 23104
(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 = 11119 AND pts.player_id = 23104
(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 = 11119 AND pts.player_id = 23104
(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 = 11119 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 = 11119 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 = 11119 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 = 11119 AND pts.player_id = 420
(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 = 11119 AND pts.player_id = 420
(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 = 11119 AND pts.player_id = 420
(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 = 11119 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 = 11119 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 = 11119 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 = 11119 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 = 11119 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 = 11119 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 = 11119 AND pts.player_id = 12776
(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 = 11119 AND pts.player_id = 12776
(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 = 11119 AND pts.player_id = 12776
(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 = 11119 AND pts.player_id = 26483
(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 = 11119 AND pts.player_id = 26483
(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 = 11119 AND pts.player_id = 26483
(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 = 11119 AND pts.player_id = 22645
(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 = 11119 AND pts.player_id = 22645
(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 = 11119 AND pts.player_id = 22645
(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 = 11119 AND pts.player_id = 7559
(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 = 11119 AND pts.player_id = 7559
(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 = 11119 AND pts.player_id = 7559
(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 = 11119 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 = 11119 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 = 11119 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 = 11119 AND pts.player_id = 7187
(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 = 11119 AND pts.player_id = 7187
(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 = 11119 AND pts.player_id = 7187
(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 = 11119 AND pts.player_id = 27697
(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 = 11119 AND pts.player_id = 27697
(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 = 11119 AND pts.player_id = 27697
(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 = 11119 AND pts.action = 'CHECK_IN' ORDER BY p.last
(mysqli): SELECT id FROM player_pts WHERE event_id = 11119 AND player_id = 12997 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11119 AND player_id = 22645 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11119 AND player_id = 5166 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11119 AND player_id = 6169 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11119 AND player_id = 15605 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11119 AND player_id = 23104 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11119 AND player_id = 15752 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11119 AND player_id = 12276 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11119 AND player_id = 27743 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11119 AND player_id = 10737 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11119 AND player_id = 27742 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11119 AND player_id = 6348 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11119 AND player_id = 8066 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11119 AND player_id = 22990 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11119 AND player_id = 12776 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11119 AND player_id = 420 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11119 AND player_id = 12326 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11119 AND player_id = 12022 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11119 AND player_id = 27697 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11119 AND player_id = 26483 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11119 AND player_id = 22651 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11119 AND player_id = 4577 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11119 AND player_id = 12555 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11119 AND player_id = 11549 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11119 AND player_id = 8657 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11119 AND player_id = 23874 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11119 AND player_id = 13787 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11119 AND player_id = 7187 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11119 AND player_id = 7188 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11119 AND player_id = 7559 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11119 AND player_id = 14086 AND action != 'CHECK_IN'
VIEW EVENT
$45 CHEAPSTACK
$45 CHEAPSTACK
12/01/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