(mysqli): SELECT * FROM event WHERE id = 14252
(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 = 527
(mysqli): SELECT COUNT(player_id) as cnt FROM player_pts WHERE event_id = 14252 AND action = 'CHECK_IN'
(mysqli): SELECT COUNT(id) as cnt FROM event_photo WHERE event_id = 14252
(mysqli): SELECT COUNT(id) as cnt FROM comment WHERE type = 'event' AND _id = 14252
(mysqli): SELECT id FROM event_photo WHERE event_id = 14252 AND dflt = 1
(mysqli): SELECT photo_name, thumb_name FROM event_photo WHERE event_id = 14252 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 = 14252 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 = 14252 AND pts.player_id = 21117
(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 = 14252 AND pts.player_id = 21117
(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 = 14252 AND pts.player_id = 21117
(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 = 14252 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 = 14252 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 = 14252 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 = 14252 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 = 14252 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 = 14252 AND pts.player_id = 15215
(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 = 14252 AND pts.player_id = 28805
(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 = 14252 AND pts.player_id = 28805
(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 = 14252 AND pts.player_id = 28805
(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 = 14252 AND pts.player_id = 8584
(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 = 14252 AND pts.player_id = 8584
(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 = 14252 AND pts.player_id = 8584
(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 = 14252 AND pts.player_id = 10876
(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 = 14252 AND pts.player_id = 10876
(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 = 14252 AND pts.player_id = 10876
(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 = 14252 AND pts.player_id = 22228
(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 = 14252 AND pts.player_id = 22228
(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 = 14252 AND pts.player_id = 22228
(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 = 14252 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 = 14252 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 = 14252 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 = 14252 AND pts.player_id = 11492
(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 = 14252 AND pts.player_id = 11492
(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 = 14252 AND pts.player_id = 11492
(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 = 14252 AND pts.player_id = 30885
(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 = 14252 AND pts.player_id = 30885
(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 = 14252 AND pts.player_id = 30885
(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 = 14252 AND pts.player_id = 10296
(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 = 14252 AND pts.player_id = 10296
(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 = 14252 AND pts.player_id = 10296
(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 = 14252 AND pts.player_id = 27795
(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 = 14252 AND pts.player_id = 27795
(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 = 14252 AND pts.player_id = 27795
(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 = 14252 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 = 14252 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 = 14252 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 = 14252 AND pts.player_id = 26487
(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 = 14252 AND pts.player_id = 26487
(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 = 14252 AND pts.player_id = 26487
(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 = 14252 AND pts.player_id = 30941
(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 = 14252 AND pts.player_id = 30941
(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 = 14252 AND pts.player_id = 30941
(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 = 14252 AND pts.player_id = 14739
(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 = 14252 AND pts.player_id = 14739
(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 = 14252 AND pts.player_id = 14739
(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 = 14252 AND pts.action = 'CHECK_IN' ORDER BY p.last
(mysqli): SELECT id FROM player_pts WHERE event_id = 14252 AND player_id = 10876 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14252 AND player_id = 27667 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14252 AND player_id = 2786 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14252 AND player_id = 28805 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14252 AND player_id = 153 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14252 AND player_id = 28142 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14252 AND player_id = 30627 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14252 AND player_id = 6063 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14252 AND player_id = 6071 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14252 AND player_id = 11492 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14252 AND player_id = 6965 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14252 AND player_id = 15213 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14252 AND player_id = 28596 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14252 AND player_id = 15215 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14252 AND player_id = 9122 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14252 AND player_id = 21117 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14252 AND player_id = 30812 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14252 AND player_id = 30885 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14252 AND player_id = 24635 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14252 AND player_id = 24688 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14252 AND player_id = 30941 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14252 AND player_id = 10296 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14252 AND player_id = 6075 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14252 AND player_id = 26487 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14252 AND player_id = 11437 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14252 AND player_id = 22651 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14252 AND player_id = 22228 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14252 AND player_id = 30943 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14252 AND player_id = 30942 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14252 AND player_id = 27795 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14252 AND player_id = 8584 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14252 AND player_id = 14739 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14252 AND player_id = 5907 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14252 AND player_id = 6385 AND action != 'CHECK_IN'
VIEW EVENT
40K SUPERSTACKED & $500 GTD | PNC CLUB + BPO TOKENS
01/12/2014
21 Railroad Ave
Portuguese National Club
Stoughton, MA
(508) 584-9200
Todays 34 player second event at Morrells Country Tavern featured the return and Season 21 debut of Bill Spadea, who finished 13th at the 2007 WSOP Main Event in Las Vegas! He was a challenge for todays field and a clear choice to be this evenings bounty!
With Robert Heckman, 10th, and Mike Delfino, 9th, simultaneously bubbling the FT only 8 players remained as action kicked off. Defending Sun Night winner Donna Centamore couldnt make it two free weeks of buffets as she was the first to exit in 8th. Short stack Mike Rampino shipped it in from the bb v a raise from Don "Blue" Harris for his final 1.5 BB and saw his Q2o hit the flop only to get rivered by Blue to finish 7th. Antonio Acevedo had a big stack at FT commencement but fierce blind v blind action v Blue and a double up of Dave Grenon meant the end of Acevedos evening in 6th place.
So Blue and Rich Bennet sat five handed with both Grenon fellas, Dave and Joe, and tonights bounty Spadea. Spadea was in good shape as 5 handed play got under way but several limps failed to bare fruit and David Grenon played tough from the SB v Spadeas BB leaving Spadea looking to ship it or fold it deep. When Spadea finally did ship preflop he found himself in a 3 way showdown with Joe Grenon, who was all in for less, and Blue. Bill need a diamond on the turn or river to make the only flush available at showdown while Joe held JTo for second pair and an open ended straight, while Blue felted top pair. Joe straightened out for a big triple up while Bill bricked out on the nut flush draw meaning Blue would scoop the side pot and claim tonights bounty points! Spadea impressed on his 5th place run.
Rich Bennet played a tight FT and made it to four handed action but an aggressive four handed game showed him the door in 4th. So Blue was left as chip leader to play the father/son tandem of Joe and David Grenon.
David started the FT with 11k played well to chip up while Joe Grenon was grinding away his shirt stack 3 handed. With blinds at 10/20K David pushed all in from the button w/roughly 120k, Joe got it in for less from the sb, while Blue surprised everyone with a call from the BB. With a 3 way showdown Blue was the only one to connect with the board as his K8s turned an 8 to take out both Grenons at once and take home tonights W and a free week of buffets without playing a single hand of heads up poker! Congratualtions to Don on his 3rd win as we approach the midway point of the season!
Directors note: Spadea, as expected, proved a tricky bounty to eliminate but Blue found a way! Yet again an events winner also knocked out the events bounty for major points towards the Jan POTM!
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
