(mysqli): SELECT * FROM event WHERE id = 4554
(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 = 192
(mysqli): SELECT COUNT(player_id) as cnt FROM player_pts WHERE event_id = 4554 AND action = 'CHECK_IN'
(mysqli): SELECT COUNT(id) as cnt FROM event_photo WHERE event_id = 4554
(mysqli): SELECT COUNT(id) as cnt FROM comment WHERE type = 'event' AND _id = 4554
(mysqli): SELECT id FROM event_photo WHERE event_id = 4554 AND dflt = 1
(mysqli): SELECT photo_name, thumb_name FROM event_photo WHERE event_id = 4554 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 = 4554 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 = 4554 AND pts.player_id = 13571
(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 = 4554 AND pts.player_id = 13571
(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 = 4554 AND pts.player_id = 13571
(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 = 4554 AND pts.player_id = 10909
(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 = 4554 AND pts.player_id = 10909
(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 = 4554 AND pts.player_id = 10909
(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 = 4554 AND pts.player_id = 13010
(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 = 4554 AND pts.player_id = 13010
(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 = 4554 AND pts.player_id = 13010
(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 = 4554 AND pts.player_id = 10664
(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 = 4554 AND pts.player_id = 10664
(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 = 4554 AND pts.player_id = 10664
(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 = 4554 AND pts.player_id = 10311
(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 = 4554 AND pts.player_id = 10311
(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 = 4554 AND pts.player_id = 10311
(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 = 4554 AND pts.player_id = 1
(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 = 4554 AND pts.player_id = 1
(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 = 4554 AND pts.player_id = 1
(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 = 4554 AND pts.player_id = 12007
(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 = 4554 AND pts.player_id = 12007
(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 = 4554 AND pts.player_id = 12007
(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 = 4554 AND pts.player_id = 13574
(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 = 4554 AND pts.player_id = 13574
(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 = 4554 AND pts.player_id = 13574
(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 = 4554 AND pts.player_id = 11610
(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 = 4554 AND pts.player_id = 11610
(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 = 4554 AND pts.player_id = 11610
(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 = 4554 AND pts.player_id = 13576
(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 = 4554 AND pts.player_id = 13576
(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 = 4554 AND pts.player_id = 13576
(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 = 4554 AND pts.action = 'CHECK_IN' ORDER BY p.last
(mysqli): SELECT id FROM player_pts WHERE event_id = 4554 AND player_id = 10909 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 4554 AND player_id = 9220 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 4554 AND player_id = 6169 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 4554 AND player_id = 13390 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 4554 AND player_id = 10087 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 4554 AND player_id = 8821 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 4554 AND player_id = 13574 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 4554 AND player_id = 13576 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 4554 AND player_id = 11524 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 4554 AND player_id = 11833 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 4554 AND player_id = 13577 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 4554 AND player_id = 13572 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 4554 AND player_id = 13488 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 4554 AND player_id = 9645 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 4554 AND player_id = 10312 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 4554 AND player_id = 11610 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 4554 AND player_id = 9316 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 4554 AND player_id = 6348 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 4554 AND player_id = 6154 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 4554 AND player_id = 13579 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 4554 AND player_id = 10310 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 4554 AND player_id = 10293 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 4554 AND player_id = 9370 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 4554 AND player_id = 11708 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 4554 AND player_id = 11001 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 4554 AND player_id = 13571 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 4554 AND player_id = 13077 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 4554 AND player_id = 10664 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 4554 AND player_id = 1483 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 4554 AND player_id = 1 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 4554 AND player_id = 6902 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 4554 AND player_id = 11193 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 4554 AND player_id = 9670 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 4554 AND player_id = 13010 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 4554 AND player_id = 12007 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 4554 AND player_id = 11147 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 4554 AND player_id = 10305 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 4554 AND player_id = 13578 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 4554 AND player_id = 9144 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 4554 AND player_id = 13382 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 4554 AND player_id = 10311 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 4554 AND player_id = 13580 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 4554 AND player_id = 6938 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 4554 AND player_id = 6894 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 4554 AND player_id = 6153 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 4554 AND player_id = 13575 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 4554 AND player_id = 3446 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 4554 AND player_id = 12009 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 4554 AND player_id = 13573 AND action != 'CHECK_IN'
VIEW EVENT
3-19 Charity
$5,000 GUARANTEE FOR THE KIDS!
03/19/2010
161 King Hill Road
Braintree Son's Of Italy
Braintree, MA
02184
Registration Time:4:00 PM
First Hand Dealt At:7:00 PM
Adoption & Foster Care Mentoring, also known as AFC, has empowered foster and adopted youth in Boston to flourish through committed mentoring relationships since 2001. AFC continues to be one of only a few mentoring organizations in the United States, and the only mentoring organization in Massachusetts, to exclusively serve youth with experience in the foster care system and to design trainings and programs specifically tailored to their unique needs. By matching youth in foster care with caring, consistent, adult volunteer mentors, and by providing group mentoring and skill-building opportunities to prepare these young people for independent living, Adoption & Foster Care Mentoring is working toward a day when all foster and adopted youth can say, “I will flourish; my community will support me
Get in Cheap
$30 Satellites start at 4:00PM
Sit-n-go format top 2 from each table advance to $120 main tournament at 7
This event is part of the Charity tournaments Tour
- Buy In:
- $120.00
- Charity Web Site:
- http://www.afcmentoring.org
- Pay Out:
| Place |
Minimum Payout |
1st |
$2,000.00 |
| 2nd |
$1,200.00 |
| 3rd |
$600.00 |
| 4th |
$450.00 |
| 5th |
$300.00 |
| 6th |
$250.00 |
| 7th |
$200.00 |
This payout is guaranteed no matter how many people show!
Prizes increase at a rate of 60% of donation after guarantee is met
|
(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