(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 * FROM location WHERE id = 549
(mysqli): SELECT COUNT(pts.player_id) as num_players FROM event e INNER JOIN player_pts pts ON pts.event_id = e.id WHERE e.location_id = 549 AND pts.action = 'CHECK_IN' AND date <= 1792776324 AND active = 1 GROUP BY pts.event_id ORDER BY e.date ASC
(mysqli): SELECT SUM(money_collected) as money_collected_sum FROM event e WHERE location_id = 549 AND active = 1
(mysqli): SELECT COUNT(id) as cnt FROM event e WHERE location_id = 549 AND date >= 1792713600 AND active = 1
(mysqli): SELECT COUNT(id) as cnt FROM location_photo WHERE location_id = 549
(mysqli): SELECT COUNT(id) as cnt FROM comment WHERE type = 'location' AND _id = 549
(mysqli): SELECT id FROM location_photo WHERE location_id = 549 AND dflt = 1
(mysqli): SELECT photo_name, thumb_name FROM location_photo WHERE location_id = 549 AND dflt = 1 LIMIT 1
(mysqli): SELECT p.id as trash, SUM(pts.points) as pts, pts.player_id, CONCAT(p.last,', ',p.first) as name FROM event e INNER JOIN player_pts pts ON pts.event_id = e.id INNER JOIN player p ON p.id = pts.player_id WHERE e.location_id = 549 GROUP BY pts.player_id ORDER BY pts DESC LIMIT 200
(mysqli): SELECT ppts.player_id AS id, SUM(ppts.points) as pts FROM participation_points ppts INNER JOIN event e ON e.id = ppts.event_id WHERE e.location_id = 549 GROUP BY ppts.player_id
(mysqli): SELECT bpts.player_id AS id, SUM(bpts.points) as pts FROM bounty_points bpts INNER JOIN event e ON e.id = bpts.event_id WHERE e.location_id = 549 GROUP BY bpts.player_id
(mysqli): SELECT pts.player_id, COUNT(DISTINCT(pts.event_id)) as cnt FROM player_pts pts INNER JOIN event e ON e.id = pts.event_id WHERE e.location_id = 549 GROUP BY pts.player_id
(mysqli): SELECT pts.player_id, COUNT(DISTINCT(event_id)) as cnt FROM player_pts pts INNER JOIN event e ON e.id = pts.event_id WHERE e.location_id = 549 AND action = 1 GROUP BY pts.player_id
(mysqli): SELECT pts.player_id, COUNT(DISTINCT(event_id)) as cnt FROM player_pts pts INNER JOIN event e ON e.id = pts.event_id WHERE e.location_id = 549 AND (action = 1 OR action = 2 OR action = 3) GROUP BY pts.player_id
(mysqli): SELECT pts.player_id, COUNT(DISTINCT(event_id)) as cnt FROM player_pts pts INNER JOIN event e ON e.id = pts.event_id WHERE e.location_id = 549 AND action != 'CHECK_IN' GROUP BY pts.player_id
LOCATION DETAILS
12/30 *CRAZY PINEAPPLE* $200 GTD Liz's Diamond Bar
1 Menfi Way
Hopedale, MA
1:30 PM Registration
2:00 PM First Hand
$20 Buffet Lunch
20,000 Starting Stack
15 Min Levels
Nightly Prizes:
0 - 39 = $200 GTD PAYOUT
40- 59= $400 PAYOUT
60 - 89 = $800
90 - 119 = $1,200
WHAT IS CRAZY PINEAPPLE!?
No-Limit Texas Hold'em with a fun twist! Crazy Pineapple is nearly identical to regular Holdem, save for the alterations listed below. Pineapple still uses a Flop/Turn/River structure. The blinds are the same. The betting is the same. You can raise, call, check or fold each round. If you’re familiar with Holdem, you’ll pick right up on Pineapple
What makes Crazy Pineapple different, is that you’re dealt three hole cards instead of two. In Crazy Pineapple, you must discard one of your cards after the flop, and then play with your other two for the remainder of the game. Of course, this can get rather crazy because having seen the flop, players can create some strong hands by the time they toss their weakest card.
For Full Payout Table Click Here
Seasonal Prizes:
Players can also qualify for over $200,000 in prizes at our Monthly Championship, Seasonal Championships, and Special Events.
Click Here For More Details
(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
