(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 = 324
(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 = 324 AND pts.action = 'CHECK_IN' AND date <= 1792774192 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 = 324 AND active = 1
(mysqli): SELECT COUNT(id) as cnt FROM event e WHERE location_id = 324 AND date >= 1792713600 AND active = 1
(mysqli): SELECT COUNT(id) as cnt FROM location_photo WHERE location_id = 324
(mysqli): SELECT COUNT(id) as cnt FROM comment WHERE type = 'location' AND _id = 324
(mysqli): SELECT id FROM location_photo WHERE location_id = 324 AND dflt = 1
(mysqli): SELECT photo_name, thumb_name FROM location_photo WHERE location_id = 324 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 = 324 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 = 324 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 = 324 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 = 324 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 = 324 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 = 324 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 = 324 AND action != 'CHECK_IN' GROUP BY pts.player_id
LOCATION DETAILS
$30K FINALS CHAMPIONSHIP (POINTS)
Foxwoods Resort & Casino
Mashantucket, CT
SATURDAY APRIL 6 - SUNDAY APRIL 7th, 2019
$30,000 CHAMPIONSHIP IS BACK AT FOXWOODS
The top players from each region are all invited to compete at Foxwoods Resort and Casino Live on Television for $30,000! To qualify for this event, you must be in the top 10% from your region for the year or have qualified for a $30K Finals "Bye".
Saturday, April 6, 2019
Day 1: Annual Points Championship
At: 10:00 AM
Format:
20,000 Base Starting stack
Up to 32,000 Chips For Higher Ranking
100/200 Starting Blinds
30 Minute Levels
Cost:
$35 player cost
(to pay for 2 days of dealers, floor, space, and drinks)
How Do You Qualify?
All players receive participation points each night for playing.
Top 16 players receive additional point based on their finish. Players are ranked within the region that they play the most, their primary region. The top 10% from each region for the year, during the dates April 29, 2017 - April 20, 2018 is invited!
Players that have already won a finals seat can play in this event for the double stack. There is no benefit in playing if you already won a double stack.
Tournament will play down to the Top 16 Players who will advance to Day 2: The $30,000 Finals on Sunday.
(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
