(mysqli): SELECT * FROM event WHERE id = 14005
(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 = 134
(mysqli): SELECT COUNT(player_id) as cnt FROM player_pts WHERE event_id = 14005 AND action = 'CHECK_IN'
(mysqli): SELECT COUNT(id) as cnt FROM event_photo WHERE event_id = 14005
(mysqli): SELECT COUNT(id) as cnt FROM comment WHERE type = 'event' AND _id = 14005
(mysqli): SELECT id FROM event_photo WHERE event_id = 14005 AND dflt = 1
(mysqli): SELECT photo_name, thumb_name FROM event_photo WHERE event_id = 14005 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 = 14005 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 = 14005 AND pts.player_id = 22772
(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 = 14005 AND pts.player_id = 22772
(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 = 14005 AND pts.player_id = 22772
(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 = 14005 AND pts.player_id = 27530
(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 = 14005 AND pts.player_id = 27530
(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 = 14005 AND pts.player_id = 27530
(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 = 14005 AND pts.player_id = 29140
(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 = 14005 AND pts.player_id = 29140
(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 = 14005 AND pts.player_id = 29140
(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 = 14005 AND pts.player_id = 24819
(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 = 14005 AND pts.player_id = 24819
(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 = 14005 AND pts.player_id = 24819
(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 = 14005 AND pts.player_id = 13034
(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 = 14005 AND pts.player_id = 13034
(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 = 14005 AND pts.player_id = 13034
(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 = 14005 AND pts.player_id = 2175
(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 = 14005 AND pts.player_id = 2175
(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 = 14005 AND pts.player_id = 2175
(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 = 14005 AND pts.player_id = 8415
(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 = 14005 AND pts.player_id = 8415
(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 = 14005 AND pts.player_id = 8415
(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 = 14005 AND pts.player_id = 27899
(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 = 14005 AND pts.player_id = 27899
(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 = 14005 AND pts.player_id = 27899
(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 = 14005 AND pts.player_id = 1423
(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 = 14005 AND pts.player_id = 1423
(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 = 14005 AND pts.player_id = 1423
(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 = 14005 AND pts.player_id = 21187
(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 = 14005 AND pts.player_id = 21187
(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 = 14005 AND pts.player_id = 21187
(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 = 14005 AND pts.player_id = 22732
(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 = 14005 AND pts.player_id = 22732
(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 = 14005 AND pts.player_id = 22732
(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 = 14005 AND pts.player_id = 6741
(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 = 14005 AND pts.player_id = 6741
(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 = 14005 AND pts.player_id = 6741
(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 = 14005 AND pts.player_id = 12471
(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 = 14005 AND pts.player_id = 12471
(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 = 14005 AND pts.player_id = 12471
(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 = 14005 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 = 14005 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 = 14005 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 = 14005 AND pts.player_id = 12359
(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 = 14005 AND pts.player_id = 12359
(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 = 14005 AND pts.player_id = 12359
(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 = 14005 AND pts.player_id = 13604
(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 = 14005 AND pts.player_id = 13604
(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 = 14005 AND pts.player_id = 13604
(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 = 14005 AND pts.action = 'CHECK_IN' ORDER BY p.last
(mysqli): SELECT id FROM player_pts WHERE event_id = 14005 AND player_id = 6741 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14005 AND player_id = 12359 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14005 AND player_id = 30278 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14005 AND player_id = 24819 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14005 AND player_id = 6743 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14005 AND player_id = 30356 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14005 AND player_id = 2325 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14005 AND player_id = 13034 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14005 AND player_id = 22306 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14005 AND player_id = 21521 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14005 AND player_id = 23056 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14005 AND player_id = 26432 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14005 AND player_id = 15064 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14005 AND player_id = 27899 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14005 AND player_id = 27759 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14005 AND player_id = 13922 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14005 AND player_id = 30657 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14005 AND player_id = 30281 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14005 AND player_id = 4546 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14005 AND player_id = 1294 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14005 AND player_id = 22772 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14005 AND player_id = 2175 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14005 AND player_id = 10093 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14005 AND player_id = 1423 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14005 AND player_id = 21520 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14005 AND player_id = 22732 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14005 AND player_id = 21187 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14005 AND player_id = 29139 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14005 AND player_id = 27530 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14005 AND player_id = 6639 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14005 AND player_id = 29140 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14005 AND player_id = 12471 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14005 AND player_id = 29314 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14005 AND player_id = 15793 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14005 AND player_id = 9730 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14005 AND player_id = 8415 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14005 AND player_id = 13604 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14005 AND player_id = 23341 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14005 AND player_id = 27645 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 14005 AND player_id = 9756 AND action != 'CHECK_IN'
VIEW EVENT
THE RALLY | $300 GTD | BPO TOKENS
11/25/2013
1800 Post Road
The Rally Sports Bar & Grille | AIRPORT PLAZA
Warwick, RI
02888
A well above average field of 40 entered RI Billiards tonight for some NL HE action. This tournament featured many players who made their first visit to the venue, 3 players even trekking from CT!!!! When the food was gone and the dust settled it was Pavel Malyuta who outlasted all others to claim his first win of the season! He sat big stacked at the FT the whole time and played a tight aggressive pre flop game that worked to perfection. Dewey Ordovas seemed prime to give Pavel a run for his money after grinding a short stack into the chip lead but as the blinds increased and every hand became more important he just couldnt find the magic needed to take it down and exited 3rd. Tre Monteiro was the final player left to face Malyuta but it only took a single hand with both players all in and Pavel having a 50k chip lead and JT v Monteiros A/rag. A river J ended the evening and Malyuta was all smiles. 4th place finisher, and recipient of a RI Billiards gift package, was Steve Charron. Charron played perhaps the best of the final 9 but Malyuta trapped him after turning trip jacks and checking to Charron who floated the flop and over aggressively bet the turn to double up Malyuta on his way to victory.
Directors note: Several tabs were left unpaid tonight. Even though it is the waitstaff's responsibility to collect the tab we ask our players to be responsible and please be mindful and respectful of the venue and its staff.
Have a good night!
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
