(mysqli): SELECT * FROM event WHERE id = 2171
(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 = 92
(mysqli): SELECT COUNT(player_id) as cnt FROM player_pts WHERE event_id = 2171 AND action = 'CHECK_IN'
(mysqli): SELECT COUNT(id) as cnt FROM event_photo WHERE event_id = 2171
(mysqli): SELECT COUNT(id) as cnt FROM comment WHERE type = 'event' AND _id = 2171
(mysqli): SELECT id FROM event_photo WHERE event_id = 2171 AND dflt = 1
(mysqli): SELECT photo_name, thumb_name FROM event_photo WHERE event_id = 2171 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 = 2171 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 = 2171 AND pts.player_id = 4511
(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 = 2171 AND pts.player_id = 4511
(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 = 2171 AND pts.player_id = 4511
(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 = 2171 AND pts.action = 'CHECK_IN' ORDER BY p.last
(mysqli): SELECT id FROM player_pts WHERE event_id = 2171 AND player_id = 4511 AND action != 'CHECK_IN'
VIEW EVENT
HJY $1000 FREE-ROLL
94 HJY's $1,000 ROCK N' freeROLL
07/26/2008
104 Mechanic St
Highland Country Club
Attleboro, MA
02703
Registration Time:1:00 PM
First Hand Dealt At:2:00 PM
PAY ABSOLUTELY NOTHING TO PLAY! NO FOOD TO PURCHASE.. JUST COME DOWN AND PLAY!
THIS $1000- FREE POKER TOURNAMENT WILL BE PACKED FULL OF DJ CELEBRITIES, THE CHICKS THAT ROCK ALL BEING BEING HEAVILY PROMOTED BY 94 HJY!
This event is part of the Charity tournaments Tour
- Buy In:
- $0.00
- Charity Web Site:
- www.whjy.com
- Pay Out:
| First |
|
50.00% |
500.00 |
| Second |
|
20.00% |
200.00 |
| Third |
|
10.00% |
100.00 |
| Fourth |
|
10.00% |
100.00 |
| Fifth |
|
10.00% |
100.00 |
(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
