(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 * FROM location WHERE id = 513
(mysqli): SELECT COUNT(pts.player_id) as num_players FROM event e INNER JOIN player_pts pts ON pts.event_id = e.id WHERE e.location_id = 513 AND pts.action = 'CHECK_IN' AND date <= 1792775769 AND active = 1 GROUP BY pts.event_id ORDER BY e.date ASC
(mysqli): SELECT SUM(money_collected) as money_collected_sum FROM event e WHERE location_id = 513 AND active = 1
(mysqli): SELECT COUNT(id) as cnt FROM event e WHERE location_id = 513 AND date >= 1792713600 AND active = 1
(mysqli): SELECT COUNT(id) as cnt FROM location_photo WHERE location_id = 513
(mysqli): SELECT COUNT(id) as cnt FROM comment WHERE type = 'location' AND _id = 513
(mysqli): SELECT id FROM location_photo WHERE location_id = 513 AND dflt = 1
(mysqli): SELECT photo_name, thumb_name FROM location_photo WHERE location_id = 513 AND dflt = 1 LIMIT 1
(mysqli): SELECT p.id as trash, SUM(pts.points) as pts, pts.player_id, CONCAT(p.last,', ',p.first) as name FROM event e INNER JOIN player_pts pts ON pts.event_id = e.id INNER JOIN player p ON p.id = pts.player_id WHERE e.location_id = 513 GROUP BY pts.player_id ORDER BY pts DESC LIMIT 200
(mysqli): SELECT ppts.player_id AS id, SUM(ppts.points) as pts FROM participation_points ppts INNER JOIN event e ON e.id = ppts.event_id WHERE e.location_id = 513 GROUP BY ppts.player_id
(mysqli): SELECT bpts.player_id AS id, SUM(bpts.points) as pts FROM bounty_points bpts INNER JOIN event e ON e.id = bpts.event_id WHERE e.location_id = 513 GROUP BY bpts.player_id
(mysqli): SELECT pts.player_id, COUNT(DISTINCT(pts.event_id)) as cnt FROM player_pts pts INNER JOIN event e ON e.id = pts.event_id WHERE e.location_id = 513 GROUP BY pts.player_id
(mysqli): SELECT pts.player_id, COUNT(DISTINCT(event_id)) as cnt FROM player_pts pts INNER JOIN event e ON e.id = pts.event_id WHERE e.location_id = 513 AND action = 1 GROUP BY pts.player_id
(mysqli): SELECT pts.player_id, COUNT(DISTINCT(event_id)) as cnt FROM player_pts pts INNER JOIN event e ON e.id = pts.event_id WHERE e.location_id = 513 AND (action = 1 OR action = 2 OR action = 3) GROUP BY pts.player_id
(mysqli): SELECT pts.player_id, COUNT(DISTINCT(event_id)) as cnt FROM player_pts pts INNER JOIN event e ON e.id = pts.event_id WHERE e.location_id = 513 AND action != 'CHECK_IN' GROUP BY pts.player_id
LOCATION DETAILS
TEAM POKER CHAMPIONSHIP 11 - $15,000 GTD!
Norwood Elks
152 Winslow Ave
Norwood, MA
TEAM POKER CHALLENGE is back for our 10th year, with a new look, and with a massive $15,000 Guarantee!!
TEAM POKER changes the whole dynamic of a poker tournament. Usually, once you are eliminated, you no longer have any shot to win anything more in the tournament. Now, with your teammates still in the game, you still have a financial interest in the tournament keeping you and your teammates on edge as your lasting players make every move!
Aside from it being a massive tournament with usually 250-300 players, it is also one of the most exciting tournaments of the year as you sweat every move your team makes and hang out with hundreds of fellow EPT players at a great venue! Put together your own team of "elite" players, and don't miss out on this year's event!
Saturday, November 17th, 2018
Walpole German Club8 County St.Walpole, MA
(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
