(mysqli): SELECT * FROM event WHERE id = 14248
(mysqli): SELECT name FROM tournament WHERE id = 2 AND name LIKE 'charity%'
(mysqli): SELECT name FROM tournament WHERE id = 2
(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 = 15
(mysqli): SELECT COUNT(player_id) as cnt FROM player_pts WHERE event_id = 14248 AND action = 'CHECK_IN'
(mysqli): SELECT COUNT(id) as cnt FROM event_photo WHERE event_id = 14248
(mysqli): SELECT COUNT(id) as cnt FROM comment WHERE type = 'event' AND _id = 14248
(mysqli): SELECT id FROM event_photo WHERE event_id = 14248 AND dflt = 1
(mysqli): SELECT photo_name, thumb_name FROM event_photo WHERE event_id = 14248 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 = 14248 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 = 14248 AND pts.player_id = 28596
(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 = 14248 AND pts.player_id = 28596
(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 = 14248 AND pts.player_id = 28596
(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 = 14248 AND pts.player_id = 22229
(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 = 14248 AND pts.player_id = 22229
(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 = 14248 AND pts.player_id = 22229
(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 = 14248 AND pts.player_id = 11192
(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 = 14248 AND pts.player_id = 11192
(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 = 14248 AND pts.player_id = 11192
(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 = 14248 AND pts.player_id = 22815
(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 = 14248 AND pts.player_id = 22815
(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 = 14248 AND pts.player_id = 22815
(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 = 14248 AND pts.player_id = 775
(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 = 14248 AND pts.player_id = 775
(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 = 14248 AND pts.player_id = 775
(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 = 14248 AND pts.player_id = 10176
(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 = 14248 AND pts.player_id = 10176
(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 = 14248 AND pts.player_id = 10176
(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 = 14248 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 = 14248 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 = 14248 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 = 14248 AND pts.player_id = 30911
(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 = 14248 AND pts.player_id = 30911
(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 = 14248 AND pts.player_id = 30911
(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 = 14248 AND pts.player_id = 708
(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 = 14248 AND pts.player_id = 708
(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 = 14248 AND pts.player_id = 708
(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 = 14248 AND pts.player_id = 30913
(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 = 14248 AND pts.player_id = 30913
(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 = 14248 AND pts.player_id = 30913
(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 = 14248 AND pts.player_id = 1487
(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 = 14248 AND pts.player_id = 1487
(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 = 14248 AND pts.player_id = 1487
(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 = 14248 AND pts.player_id = 29952
(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 = 14248 AND pts.player_id = 29952
(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 = 14248 AND pts.player_id = 29952
(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 = 14248 AND pts.player_id = 28277
(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 = 14248 AND pts.player_id = 28277
(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 = 14248 AND pts.player_id = 28277
(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 = 14248 AND pts.player_id = 11779
(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 = 14248 AND pts.player_id = 11779
(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 = 14248 AND pts.player_id = 11779
(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 = 14248 AND pts.player_id = 8778
(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 = 14248 AND pts.player_id = 8778
(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 = 14248 AND pts.player_id = 8778
(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 = 14248 AND pts.player_id = 15215
(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 = 14248 AND pts.player_id = 15215
(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 = 14248 AND pts.player_id = 15215
(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 = 14248 AND pts.action = 'CHECK_IN' ORDER BY p.last
(mysqli): SELECT id FROM player_pts WHERE event_id = 14248 AND player_id = 5638 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14248 AND player_id = 1482 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14248 AND player_id = 2786 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14248 AND player_id = 21512 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14248 AND player_id = 1487 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14248 AND player_id = 28142 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14248 AND player_id = 30627 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14248 AND player_id = 30914 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14248 AND player_id = 30912 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14248 AND player_id = 22229 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14248 AND player_id = 22815 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14248 AND player_id = 11492 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14248 AND player_id = 27909 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14248 AND player_id = 28277 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14248 AND player_id = 30917 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14248 AND player_id = 30915 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14248 AND player_id = 12964 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14248 AND player_id = 12417 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14248 AND player_id = 30770 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14248 AND player_id = 708 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14248 AND player_id = 8778 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14248 AND player_id = 15215 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14248 AND player_id = 15213 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14248 AND player_id = 28596 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14248 AND player_id = 21117 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14248 AND player_id = 10176 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14248 AND player_id = 11192 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14248 AND player_id = 15407 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14248 AND player_id = 30916 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14248 AND player_id = 10296 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14248 AND player_id = 23046 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14248 AND player_id = 29952 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14248 AND player_id = 19378 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14248 AND player_id = 775 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14248 AND player_id = 8585 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14248 AND player_id = 12778 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14248 AND player_id = 21475 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14248 AND player_id = 29743 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14248 AND player_id = 22651 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14248 AND player_id = 30913 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14248 AND player_id = 19724 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14248 AND player_id = 12861 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14248 AND player_id = 22228 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14248 AND player_id = 27558 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14248 AND player_id = 15675 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14248 AND player_id = 30911 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14248 AND player_id = 11780 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14248 AND player_id = 16549 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14248 AND player_id = 11779 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14248 AND player_id = 6385 AND action != 'CHECK_IN'
VIEW EVENT
Wednesdays SMA- $300 GTD + BPO TOKENS!
01/08/2014
115 New State Hwy
Raynham, MA
02767
Jockey Club was busting at the seams as tonights field swelled to 50 players! This marked the 7th of past 10 events at this venue to break 40 players to award even greater prizes to EPT SOMA players!
The final table began 8 handed as Andy "Glue" Gomaa busted 9th seconds after Phil Pacheco, 10th, as each top 16 table lost a player to send on the final 8. Pacheco and Brendan Souza, who was super stacking early on after a dream triple up, were the final 2 horses of the 7 person, all new, Berkley Crew, introduced by Michael Garrant. With Pacheco bubbling the FT, Souza was Berkleys last man standing but entered the FT a bottom 3 stack and was finished off in 8th.
Play noticeably tightened up 7 handed and, though generally healthy all night, Robert Santangelo was the next man ousted. John Hickey played a tight FT but with blinds at 10/20k his all in for 35k more was called by the BB, Keith Marshall. Though Marshall called light, Hickey revealed 46s, flopped an open ended straight but couldnt draw out and signed out 6th. Marshall seemed to enjoy his FT experience more than most as he stacked two players, played several hands blind in sb v bb situations, and survived many all ins! However when he shipped the button, Dave Grenon snap called from the BB w/KK. Marshall needed a duck for a set but it wasnt meant to be as he exited 5th.
Dave DaRosa had a nice stack but the blinds crept up on him and he just couldnt find a hand or spot to add some chips and finally bubbled the prizepool in 4th. Paul Hudson played a fine tournament but couldnt build any momentum towards a championship run as he went card dead at the FT. Dave Grenon busted him in 3rd leaving Dave HU for the 2nd straight Wednesday night.
Mark Esters won the HU match last week v. Grenon but tonight Esters was the bounty. David was calling out Esters, hungry for bounty points, before the 2 even shared the same felt. However they did late night and David made good on his declaration, bouncing defending champ Esters before Top 16! Impressive!
Tom Collins was left to face David tonight. Collins was the only player at the FT who had been getting the better of Grenon. The two battled through 20/40k and most of 30/60k, with Collins scoring a huge double up as he 3 bet all in with his QJs which Grenon was forced to pay off with QTs. From this point on though Grenon applied consistent pressure to build his stack while Collins was kept alive through walks. Grenon was just too hot and it wasnt long before Collins was left flipping for his life, and tonight Dave wasnt losing flips. David was playing his 5th FT in his past 8 events, and tonight claimed his 2nd win of Season 21 while Collins respectably added his 7th 2nd place finish to this seasons resume! Congratulations David and Tom and thank you to all the faces, new and old, who made tonights event a success!
Directors Note: At just 18 years old, David Grenon is improving his game and proving he is a player to watch out for! David earned bounty points for the second consecutive event! This also marked the 4th event, of 5 SOMA events this year, that the victor also knocked out the bounty! Odd but true!
This event is part of the Southern Massachusetts Tour
(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
