(mysqli): SELECT * FROM event WHERE id = 117
(mysqli): SELECT name FROM tournament WHERE id = 25 AND name LIKE 'charity%'
(mysqli): SELECT name FROM tournament WHERE id = 25
(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 = 14
(mysqli): SELECT COUNT(player_id) as cnt FROM player_pts WHERE event_id = 117 AND action = 'CHECK_IN'
(mysqli): SELECT COUNT(id) as cnt FROM event_photo WHERE event_id = 117
(mysqli): SELECT COUNT(id) as cnt FROM comment WHERE type = 'event' AND _id = 117
(mysqli): SELECT id FROM event_photo WHERE event_id = 117 AND dflt = 1
(mysqli): SELECT photo_name, thumb_name FROM event_photo WHERE event_id = 117 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 = 117 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 = 117 AND pts.player_id = 864
(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 = 117 AND pts.player_id = 864
(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 = 117 AND pts.player_id = 864
(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 = 117 AND pts.player_id = 676
(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 = 117 AND pts.player_id = 676
(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 = 117 AND pts.player_id = 676
(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 = 117 AND pts.player_id = 860
(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 = 117 AND pts.player_id = 860
(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 = 117 AND pts.player_id = 860
(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 = 117 AND pts.player_id = 324
(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 = 117 AND pts.player_id = 324
(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 = 117 AND pts.player_id = 324
(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 = 117 AND pts.player_id = 789
(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 = 117 AND pts.player_id = 789
(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 = 117 AND pts.player_id = 789
(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 = 117 AND pts.player_id = 689
(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 = 117 AND pts.player_id = 689
(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 = 117 AND pts.player_id = 689
(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 = 117 AND pts.player_id = 679
(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 = 117 AND pts.player_id = 679
(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 = 117 AND pts.player_id = 679
(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 = 117 AND pts.player_id = 793
(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 = 117 AND pts.player_id = 793
(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 = 117 AND pts.player_id = 793
(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 = 117 AND pts.player_id = 17950
(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 = 117 AND pts.player_id = 17950
(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 = 117 AND pts.player_id = 17950
(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 = 117 AND pts.player_id = 673
(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 = 117 AND pts.player_id = 673
(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 = 117 AND pts.player_id = 673
(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 = 117 AND pts.player_id = 863
(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 = 117 AND pts.player_id = 863
(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 = 117 AND pts.player_id = 863
(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 = 117 AND pts.player_id = 736
(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 = 117 AND pts.player_id = 736
(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 = 117 AND pts.player_id = 736
(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 = 117 AND pts.player_id = 680
(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 = 117 AND pts.player_id = 680
(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 = 117 AND pts.player_id = 680
(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 = 117 AND pts.player_id = 690
(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 = 117 AND pts.player_id = 690
(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 = 117 AND pts.player_id = 690
(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 = 117 AND pts.player_id = 737
(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 = 117 AND pts.player_id = 737
(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 = 117 AND pts.player_id = 737
(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 = 117 AND pts.player_id = 691
(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 = 117 AND pts.player_id = 691
(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 = 117 AND pts.player_id = 691
(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 = 117 AND pts.action = 'CHECK_IN' ORDER BY p.last
(mysqli): SELECT id FROM player_pts WHERE event_id = 117 AND player_id = 864 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 117 AND player_id = 679 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 117 AND player_id = 863 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 117 AND player_id = 793 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 117 AND player_id = 794 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 117 AND player_id = 324 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 117 AND player_id = 690 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 117 AND player_id = 860 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 117 AND player_id = 17950 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 117 AND player_id = 785 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 117 AND player_id = 737 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 117 AND player_id = 784 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 117 AND player_id = 673 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 117 AND player_id = 680 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 117 AND player_id = 691 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 117 AND player_id = 861 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 117 AND player_id = 736 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 117 AND player_id = 685 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 117 AND player_id = 689 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 117 AND player_id = 337 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 117 AND player_id = 862 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 117 AND player_id = 789 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 117 AND player_id = 738 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 117 AND player_id = 676 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 117 AND player_id = 681 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 117 AND player_id = 790 AND action != 'CHECK_IN'
(mysqli): SELECT id FROM player_pts WHERE event_id = 117 AND player_id = 17408 AND action != 'CHECK_IN'
VIEW EVENT
Wally's Pub
06/13/2006
144 Ashworth Ave.
Hampton Beach, NH
03842
603-926-6954
Another Great Night at Wally's! Congratulations everyone who made the top 16 tonight. Vladamir, see you in December at our World Series of Poker Tournament!!!
This event is part of the Wally's Pub 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