(mysqli): SELECT * FROM event WHERE id = 14699
(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 = 521
(mysqli): SELECT COUNT(player_id) as cnt FROM player_pts WHERE event_id = 14699 AND action = 'CHECK_IN'
(mysqli): SELECT COUNT(id) as cnt FROM event_photo WHERE event_id = 14699
(mysqli): SELECT COUNT(id) as cnt FROM comment WHERE type = 'event' AND _id = 14699
(mysqli): SELECT id FROM event_photo WHERE event_id = 14699 AND dflt = 1
(mysqli): SELECT photo_name, thumb_name FROM event_photo WHERE event_id = 14699 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 = 14699 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 = 14699 AND pts.player_id = 27737
(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 = 14699 AND pts.player_id = 27737
(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 = 14699 AND pts.player_id = 27737
(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 = 14699 AND pts.player_id = 29346
(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 = 14699 AND pts.player_id = 29346
(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 = 14699 AND pts.player_id = 29346
(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 = 14699 AND pts.player_id = 15605
(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 = 14699 AND pts.player_id = 15605
(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 = 14699 AND pts.player_id = 15605
(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 = 14699 AND pts.player_id = 15675
(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 = 14699 AND pts.player_id = 15675
(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 = 14699 AND pts.player_id = 15675
(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 = 14699 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 = 14699 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 = 14699 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 = 14699 AND pts.player_id = 15498
(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 = 14699 AND pts.player_id = 15498
(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 = 14699 AND pts.player_id = 15498
(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 = 14699 AND pts.player_id = 10247
(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 = 14699 AND pts.player_id = 10247
(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 = 14699 AND pts.player_id = 10247
(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 = 14699 AND pts.player_id = 30988
(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 = 14699 AND pts.player_id = 30988
(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 = 14699 AND pts.player_id = 30988
(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 = 14699 AND pts.player_id = 21435
(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 = 14699 AND pts.player_id = 21435
(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 = 14699 AND pts.player_id = 21435
(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 = 14699 AND pts.player_id = 22444
(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 = 14699 AND pts.player_id = 22444
(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 = 14699 AND pts.player_id = 22444
(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 = 14699 AND pts.player_id = 19134
(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 = 14699 AND pts.player_id = 19134
(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 = 14699 AND pts.player_id = 19134
(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 = 14699 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 = 14699 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 = 14699 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 = 14699 AND pts.player_id = 23104
(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 = 14699 AND pts.player_id = 23104
(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 = 14699 AND pts.player_id = 23104
(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 = 14699 AND pts.player_id = 153
(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 = 14699 AND pts.player_id = 153
(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 = 14699 AND pts.player_id = 153
(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 = 14699 AND pts.player_id = 6063
(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 = 14699 AND pts.player_id = 6063
(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 = 14699 AND pts.player_id = 6063
(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 = 14699 AND pts.player_id = 22233
(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 = 14699 AND pts.player_id = 22233
(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 = 14699 AND pts.player_id = 22233
(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 = 14699 AND pts.action = 'CHECK_IN' ORDER BY p.last
(mysqli): SELECT id FROM player_pts WHERE event_id = 14699 AND player_id = 153 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14699 AND player_id = 6071 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14699 AND player_id = 6063 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14699 AND player_id = 21435 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14699 AND player_id = 22233 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14699 AND player_id = 15605 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14699 AND player_id = 23104 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14699 AND player_id = 27737 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14699 AND player_id = 10247 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14699 AND player_id = 28137 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14699 AND player_id = 30988 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14699 AND player_id = 8142 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14699 AND player_id = 13385 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14699 AND player_id = 22990 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14699 AND player_id = 29901 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14699 AND player_id = 1 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14699 AND player_id = 29346 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14699 AND player_id = 22444 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14699 AND player_id = 15498 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14699 AND player_id = 15675 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14699 AND player_id = 11918 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14699 AND player_id = 19134 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14699 AND player_id = 15078 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14699 AND player_id = 8618 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14699 AND player_id = 13573 AND action != 'CHECK_IN'
VIEW EVENT
$60 CRAZY PINEAPPLE
CRAZY PINEAPPLE
03/01/2014 @ 7:00 PM
BSV German Club
8 County Street
Walpole, MA
02081
Registration Time:6:00 PM
First Hand Dealt At:7:00 PM
$60 FOR 12,000 CHIPS
15 MIN BLINDS, NO ANTES
RE-ENTRY WILL BE ALLOWED
WHAT IS CRAZY HOLIDAY 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.
This event is part of the Charity tournaments Tour
- Buy In:
- $60.00
- Proceeds to benefit:
- Shooting Touch
(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