(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 = 583
(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 = 583 AND pts.action = 'CHECK_IN' AND date <= 1792777134 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 = 583 AND active = 1
(mysqli): SELECT COUNT(id) as cnt FROM event e WHERE location_id = 583 AND date >= 1792713600 AND active = 1
(mysqli): SELECT COUNT(id) as cnt FROM location_photo WHERE location_id = 583
(mysqli): SELECT COUNT(id) as cnt FROM comment WHERE type = 'location' AND _id = 583
(mysqli): SELECT id FROM location_photo WHERE location_id = 583 AND dflt = 1
(mysqli): SELECT photo_name, thumb_name FROM location_photo WHERE location_id = 583 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 = 583 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 = 583 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 = 583 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 = 583 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 = 583 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 = 583 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 = 583 AND action != 'CHECK_IN' GROUP BY pts.player_id
LOCATION DETAILS
VFW NEW YEARS SPECIAL #2 - $200 GTD CRAZY PINEAPPLE
486 Bedford Street
Fall River, MA
02721
$ 200 GUARANTEED CRAZY PINEAPPLE
5:30 PM Registration
6:00 PM First Hand
20,000 Starting Stack
15 Min Levels
Nightly Prizes:
<> - 39 = $200 GUARANTEED
40 - 59 = $400
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.
(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
