(mysqli): SELECT * FROM event WHERE id = 14279
(mysqli): SELECT name FROM tournament WHERE id = 1 AND name LIKE 'charity%'
(mysqli): SELECT name FROM tournament WHERE id = 1
(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 = 196
(mysqli): SELECT COUNT(player_id) as cnt FROM player_pts WHERE event_id = 14279 AND action = 'CHECK_IN'
(mysqli): SELECT COUNT(id) as cnt FROM event_photo WHERE event_id = 14279
(mysqli): SELECT COUNT(id) as cnt FROM comment WHERE type = 'event' AND _id = 14279
(mysqli): SELECT id FROM event_photo WHERE event_id = 14279 AND dflt = 1
(mysqli): SELECT photo_name, thumb_name FROM event_photo WHERE event_id = 14279 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 = 14279 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 = 14279 AND pts.player_id = 1640
(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 = 14279 AND pts.player_id = 1640
(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 = 14279 AND pts.player_id = 1640
(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 = 14279 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 = 14279 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 = 14279 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 = 14279 AND pts.player_id = 15581
(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 = 14279 AND pts.player_id = 15581
(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 = 14279 AND pts.player_id = 15581
(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 = 14279 AND pts.player_id = 21177
(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 = 14279 AND pts.player_id = 21177
(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 = 14279 AND pts.player_id = 21177
(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 = 14279 AND pts.player_id = 26432
(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 = 14279 AND pts.player_id = 26432
(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 = 14279 AND pts.player_id = 26432
(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 = 14279 AND pts.player_id = 2325
(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 = 14279 AND pts.player_id = 2325
(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 = 14279 AND pts.player_id = 2325
(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 = 14279 AND pts.player_id = 7597
(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 = 14279 AND pts.player_id = 7597
(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 = 14279 AND pts.player_id = 7597
(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 = 14279 AND pts.player_id = 5514
(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 = 14279 AND pts.player_id = 5514
(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 = 14279 AND pts.player_id = 5514
(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 = 14279 AND pts.player_id = 4942
(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 = 14279 AND pts.player_id = 4942
(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 = 14279 AND pts.player_id = 4942
(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 = 14279 AND pts.player_id = 6817
(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 = 14279 AND pts.player_id = 6817
(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 = 14279 AND pts.player_id = 6817
(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 = 14279 AND pts.player_id = 79
(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 = 14279 AND pts.player_id = 79
(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 = 14279 AND pts.player_id = 79
(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 = 14279 AND pts.player_id = 4878
(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 = 14279 AND pts.player_id = 4878
(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 = 14279 AND pts.player_id = 4878
(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 = 14279 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 = 14279 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 = 14279 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 = 14279 AND pts.player_id = 29857
(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 = 14279 AND pts.player_id = 29857
(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 = 14279 AND pts.player_id = 29857
(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 = 14279 AND pts.player_id = 10167
(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 = 14279 AND pts.player_id = 10167
(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 = 14279 AND pts.player_id = 10167
(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 = 14279 AND pts.player_id = 30027
(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 = 14279 AND pts.player_id = 30027
(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 = 14279 AND pts.player_id = 30027
(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 = 14279 AND pts.action = 'CHECK_IN' ORDER BY p.last
(mysqli): SELECT id FROM player_pts WHERE event_id = 14279 AND player_id = 8727 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14279 AND player_id = 29857 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14279 AND player_id = 6011 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14279 AND player_id = 6817 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14279 AND player_id = 29078 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14279 AND player_id = 12999 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14279 AND player_id = 13268 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14279 AND player_id = 8058 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14279 AND player_id = 10167 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14279 AND player_id = 9810 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14279 AND player_id = 9777 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14279 AND player_id = 2325 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14279 AND player_id = 11492 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14279 AND player_id = 12663 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14279 AND player_id = 21177 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14279 AND player_id = 27737 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14279 AND player_id = 10440 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14279 AND player_id = 4942 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14279 AND player_id = 7597 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14279 AND player_id = 26432 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14279 AND player_id = 1503 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14279 AND player_id = 9122 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14279 AND player_id = 21117 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14279 AND player_id = 29074 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14279 AND player_id = 715 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14279 AND player_id = 1640 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14279 AND player_id = 30843 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14279 AND player_id = 5514 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14279 AND player_id = 21187 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14279 AND player_id = 22651 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14279 AND player_id = 4878 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14279 AND player_id = 79 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14279 AND player_id = 15581 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14279 AND player_id = 13399 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14279 AND player_id = 11782 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14279 AND player_id = 30027 AND action != 'CHECK_IN'
VIEW EVENT
Red's Kitchen Saturday - 3PM- $300 GTD
01/04/2014
1314 Fall River Ave
Won Sports Complex
Seekonk, MA
Solid of turnout of 36 today at the DS+DP at Luxury Box in Seekonk! Todays guest of honor was Bill McGuire who was competing in his 100th 1pm Lux Box event! In honor of his 100th Bill was awarded 30 points to begin the event, but any player who knocked him out would claim his points as he was todays bounty!
Lux Box debutant Vincent Flemming III made the final table but his short stack quickly succumbed in 9th. McGuire was still alive, and chipped up well during top 16 play, but finally saw himself on the losing side of a big flip v Kathie Maione to finish his 100th in 8th place! Lux Box 1pm all time points leader Jane Gallucci soon followed in 7th, followed shortly after by Jim Dawber, 6th.
With 5 handed action underway and blinds already at 10/20k short stack Larry Goldberg,5th, unsuccessfully defended his bb HU for 50K total with 24o v Rich Didick, who opened the betting with KK. Didick amassed 76K by buffet break, and played a solid and patient FT, but walked away with yet another 4th place finish after being craftily outplayed by Don "Blue" Harris in several blind v blind hands.
Jim Salvatore benefited from several walks from Harris as the blinds reached 20/40k 3 handed before finally getting his double up through Kathie Maione. However, it wasnt meant to be as Salvatore aggressively shipped it all in w/A5o 3 handed only to have Harris snap call and felt TT which held on propelling Harris to the chip lead v Kathie Maione HU. A great HU match ensued but as the chips moved back and forth and the stacks evened out as blinds peaked at 30/60k. Finally Kathie Maione flopped a set of 4s which she check reraised only to have Blue defend his raise on the flop. She played it strong on the turn with the chip lead and an all in. Blue tanked long and hard before paying her off with his A5o, busting HU with 2nd pair! This marked the 3rd consecutive event where the player who captured the events bounty continued on to victory! Congratualtions Kathie Maione!
Directors Note: It was god to be back in the front of Luxury Box once again! This area will continue to serve future events here, offering better lighting and bar and pool table access! Also, a reminder, all Saturday events are neutral and count immediately towards regional rankings. This venue regualarly draw players from 3 regions! POTM events the next two weeks will surely shrink the field size so come on down to Luxury Box for your chance to earn a W and a berth into our season 21 Tournament of Champions! Happy New Year!
This event is part of the Rhode Island 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
