(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 = 27
(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 = 27 AND pts.action = 'CHECK_IN' AND date <= 1792775711 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 = 27 AND active = 1
(mysqli): SELECT COUNT(id) as cnt FROM event e WHERE location_id = 27 AND date >= 1792713600 AND active = 1
(mysqli): SELECT COUNT(id) as cnt FROM location_photo WHERE location_id = 27
(mysqli): SELECT COUNT(id) as cnt FROM comment WHERE type = 'location' AND _id = 27
(mysqli): SELECT id FROM location_photo WHERE location_id = 27 AND dflt = 1
(mysqli): SELECT photo_name, thumb_name FROM location_photo WHERE location_id = 27 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 = 27 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 = 27 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 = 27 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 = 27 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 = 27 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 = 27 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 = 27 AND action != 'CHECK_IN' GROUP BY pts.player_id
LOCATION DETAILS
30K CHAMPIONSHIP DAY 2
213 Taunton Ave
Johnson and Wales Inn
Seekonk, MA
02771
888 EPT NATION
| PRIZE |
$30,000 CHAMPIONSHIP |
|
| Total Payout |
$30,000 |
|
Place |
Payout |
1st |
$9,000- or the $12,000 WSOP PACKAGE |
2nd |
$5,000- |
3rd |
$3,500- |
4th |
$2,500- |
5th |
$1,750- |
6th |
$1,500- |
7th |
$1,250- |
8th |
$1,000- |
9th |
$650- |
10th |
$500- |
11th |
$500- |
12th |
$500- |
13th |
$500- |
14th |
$500- |
15th |
$250- |
16th |
$200- |
17th |
$200- |
18th |
$200- |
19th |
$200- |
20th |
$200- |
Total |
$30,000/$33,000 with the WSOP PACKAGE |
DID YOU QUALIFY?
DAY 1 POINTS CHAMPIONSHIPS (JAN 23):
You must have finished in the top 15% for your local region that you play in to compete in DAY 1 of the 30K Championship. For your convenience, you can see your personal ranking as well as a link to the ranking right on your player profile. You can also see your ranking on the rankings page and see where you stand during your season.
Eligible players are the top players in Rhode Island, Southern Massachusetts, Central Massachusetts, Worcester, Lowell, and The Charity Events. Players who have qualified in more then one region must chose their highest ranking for chip advantage, we do not combine points from different regions.
CHIP ADVANTAGE
RANKING |
CHIPSTACK |
RANKING |
CHIPSTACK |
1-10 |
25,000 |
91-110 |
18,000 |
11-30 |
22,000 |
111-130 |
17,000 |
31-50 |
21,000 |
131-150 |
16,000 |
51-70 |
20,000 |
150+ |
15,000 |
71-90 |
19,000 |
|
|
DAY 2 TOURNAMENT OF CHAMPIONS (JAN 24):
You must have won an Eastern Poker Tour sponsored tournament between the dates June 20, 2009 – January 22nd 2010. For your convenience, you can see if you qualified on the seasonal wall of champions page below.
CHIP ADVANTAGE Your first win will get you into the tournament with 20,000 chips to start then every additional win will get you an extra 1,000 chips to start (up to 30,000 MAX)
click here for seasonal wall of champions
(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
