(mysqli): SELECT * FROM event WHERE id = 5315
(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 = 232
(mysqli): SELECT COUNT(player_id) as cnt FROM player_pts WHERE event_id = 5315 AND action = 'CHECK_IN'
(mysqli): SELECT COUNT(id) as cnt FROM event_photo WHERE event_id = 5315
(mysqli): SELECT COUNT(id) as cnt FROM comment WHERE type = 'event' AND _id = 5315
(mysqli): SELECT id FROM event_photo WHERE event_id = 5315 AND dflt = 1
(mysqli): SELECT photo_name, thumb_name FROM event_photo WHERE event_id = 5315 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 = 5315 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 = 5315 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 = 5315 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 = 5315 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 = 5315 AND pts.player_id = 30327
(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 = 5315 AND pts.player_id = 30327
(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 = 5315 AND pts.player_id = 30327
(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 = 5315 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 = 5315 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 = 5315 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 = 5315 AND pts.player_id = 7302
(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 = 5315 AND pts.player_id = 7302
(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 = 5315 AND pts.player_id = 7302
(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 = 5315 AND pts.player_id = 6299
(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 = 5315 AND pts.player_id = 6299
(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 = 5315 AND pts.player_id = 6299
(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 = 5315 AND pts.player_id = 7025
(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 = 5315 AND pts.player_id = 7025
(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 = 5315 AND pts.player_id = 7025
(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 = 5315 AND pts.player_id = 8075
(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 = 5315 AND pts.player_id = 8075
(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 = 5315 AND pts.player_id = 8075
(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 = 5315 AND pts.player_id = 6314
(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 = 5315 AND pts.player_id = 6314
(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 = 5315 AND pts.player_id = 6314
(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 = 5315 AND pts.player_id = 7434
(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 = 5315 AND pts.player_id = 7434
(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 = 5315 AND pts.player_id = 7434
(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 = 5315 AND pts.player_id = 8135
(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 = 5315 AND pts.player_id = 8135
(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 = 5315 AND pts.player_id = 8135
(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 = 5315 AND pts.action = 'CHECK_IN' ORDER BY p.last
(mysqli): SELECT id FROM player_pts WHERE event_id = 5315 AND player_id = 7007 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 5315 AND player_id = 15242 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 5315 AND player_id = 11058 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 5315 AND player_id = 7200 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 5315 AND player_id = 7309 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 5315 AND player_id = 1598 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 5315 AND player_id = 13683 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 5315 AND player_id = 7434 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 5315 AND player_id = 11614 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 5315 AND player_id = 15238 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 5315 AND player_id = 6299 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 5315 AND player_id = 10121 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 5315 AND player_id = 6801 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 5315 AND player_id = 6827 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 5315 AND player_id = 12795 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 5315 AND player_id = 5361 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 5315 AND player_id = 15239 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 5315 AND player_id = 5223 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 5315 AND player_id = 8695 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 5315 AND player_id = 7267 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 5315 AND player_id = 15241 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 5315 AND player_id = 14554 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 5315 AND player_id = 15240 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 5315 AND player_id = 11246 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 5315 AND player_id = 9533 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 5315 AND player_id = 10798 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 5315 AND player_id = 6472 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 5315 AND player_id = 5218 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 5315 AND player_id = 11143 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 5315 AND player_id = 15243 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 5315 AND player_id = 8135 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 5315 AND player_id = 7025 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 5315 AND player_id = 13389 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 5315 AND player_id = 7302 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 5315 AND player_id = 6639 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 5315 AND player_id = 6829 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 5315 AND player_id = 9317 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 5315 AND player_id = 14026 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 5315 AND player_id = 6269 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 5315 AND player_id = 9597 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 5315 AND player_id = 15237 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 5315 AND player_id = 8075 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 5315 AND player_id = 1829 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 5315 AND player_id = 11918 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 5315 AND player_id = 30327 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 5315 AND player_id = 7187 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 5315 AND player_id = 7188 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 5315 AND player_id = 6894 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 5315 AND player_id = 10407 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 5315 AND player_id = 8584 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 5315 AND player_id = 11613 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 5315 AND player_id = 6852 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 5315 AND player_id = 13065 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 5315 AND player_id = 6314 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 5315 AND player_id = 6187 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 5315 AND player_id = 6672 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 5315 AND player_id = 3446 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 5315 AND player_id = 7572 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 5315 AND player_id = 13573 AND action != 'CHECK_IN'
VIEW EVENT
Franklin Elks-7-24-10
Franklin Elks
07/24/2010
Benefits The Carlin's Family
1077 Pond Street
Franklin, MA
02038
Registration Time:2:00PM
First Hand Dealt At:6:00PM
Evan and Sheila Raine have been active players in the Central Mass. Division of EPT for the past two years. On May 1st, a fire occurred in Bellingham which destroyed the home of their daughter, Jessica, son-in-law, Michael , their three grandchildren (Alex (15), Mitchel (13) and Marissa (10)) and three animals. Everything was lost (including one pet) and since that time, they have all been living with the Raine Family.
We are reaching out to all the EPT family as well as the communities to come and help support the Carlin and Raine families-- Hope to see you there!
DEEPSTACK FORMAT!
10,000 Chip to start with 25/50 starting blinds
NO REBUYS, NO ADD-ONS DURING PLAY
$30- SINGLE TABLE SATELLITES START AT 2PM. Top 2 of 10 players advance to tournament at 6 pm.
This event is part of the Charity tournaments Tour
- Buy In:
- $120.00
- Pay Out:
| Grand Prize |
36% |
$2,600.00 |
| Second Place |
19% |
1,300.00 |
| Third Place |
10% |
700.00 |
| Fourth Place |
8% |
600.00 |
| Fifth Place |
7% |
500.00 |
| Sixth Place |
6% |
450.00 |
| Seventh |
5% |
400.00 |
| Eighth |
4% |
300.00 |
| Ninth |
3% |
200.00 |
| Tenth |
2% |
150.00 |
**payout based on minimum expected turn-out of 100 people at 60% back to players and will be adjusted when participation goes over 100 players. Percentages for each place will change slightly when participation varies. |
(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