(mysqli): SELECT * FROM event WHERE id = 11142
(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 = 11142 AND action = 'CHECK_IN'
(mysqli): SELECT COUNT(id) as cnt FROM event_photo WHERE event_id = 11142
(mysqli): SELECT COUNT(id) as cnt FROM comment WHERE type = 'event' AND _id = 11142
(mysqli): SELECT id FROM event_photo WHERE event_id = 11142 AND dflt = 1
(mysqli): SELECT photo_name, thumb_name FROM event_photo WHERE event_id = 11142 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 = 11142 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 = 11142 AND pts.player_id = 6187
(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 = 11142 AND pts.player_id = 6187
(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 = 11142 AND pts.player_id = 6187
(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 = 11142 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 = 11142 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 = 11142 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 = 11142 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 = 11142 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 = 11142 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 = 11142 AND pts.player_id = 6731
(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 = 11142 AND pts.player_id = 6731
(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 = 11142 AND pts.player_id = 6731
(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 = 11142 AND pts.player_id = 22318
(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 = 11142 AND pts.player_id = 22318
(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 = 11142 AND pts.player_id = 22318
(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 = 11142 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 = 11142 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 = 11142 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 = 11142 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 = 11142 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 = 11142 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 = 11142 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 = 11142 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 = 11142 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 = 11142 AND pts.player_id = 12849
(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 = 11142 AND pts.player_id = 12849
(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 = 11142 AND pts.player_id = 12849
(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 = 11142 AND pts.player_id = 15213
(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 = 11142 AND pts.player_id = 15213
(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 = 11142 AND pts.player_id = 15213
(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 = 11142 AND pts.player_id = 13304
(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 = 11142 AND pts.player_id = 13304
(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 = 11142 AND pts.player_id = 13304
(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 = 11142 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 = 11142 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 = 11142 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 = 11142 AND pts.player_id = 21284
(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 = 11142 AND pts.player_id = 21284
(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 = 11142 AND pts.player_id = 21284
(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 = 11142 AND pts.action = 'CHECK_IN' ORDER BY p.last
(mysqli): SELECT id FROM player_pts WHERE event_id = 11142 AND player_id = 14168 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11142 AND player_id = 13304 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11142 AND player_id = 10270 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11142 AND player_id = 54 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11142 AND player_id = 14342 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11142 AND player_id = 8187 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11142 AND player_id = 12849 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11142 AND player_id = 5166 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11142 AND player_id = 10087 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11142 AND player_id = 4755 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11142 AND player_id = 23104 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11142 AND player_id = 27737 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11142 AND player_id = 11197 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11142 AND player_id = 12843 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11142 AND player_id = 7246 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11142 AND player_id = 15213 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11142 AND player_id = 15215 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11142 AND player_id = 27521 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11142 AND player_id = 25977 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11142 AND player_id = 26621 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11142 AND player_id = 6731 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11142 AND player_id = 13313 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11142 AND player_id = 21284 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11142 AND player_id = 10609 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11142 AND player_id = 21187 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11142 AND player_id = 23258 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11142 AND player_id = 27483 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11142 AND player_id = 5363 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11142 AND player_id = 9143 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11142 AND player_id = 6115 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11142 AND player_id = 150 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11142 AND player_id = 22600 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11142 AND player_id = 22228 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11142 AND player_id = 22318 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11142 AND player_id = 11918 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11142 AND player_id = 7187 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11142 AND player_id = 7188 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11142 AND player_id = 15078 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11142 AND player_id = 6187 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 11142 AND player_id = 21478 AND action != 'CHECK_IN'
VIEW EVENT
$45 CHEAPSTACK
$45 CHEAPSTACK
12/08/2012 @ 7:00 PM
155 Eastern Ave
Dedham American Legion
Dedham, MA
Registration Time:3-6 PM
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