ACCOUNT ACTIVATION | SIGN UP | LOGIN | CONTACT EPT

>> EASTERNPOKERTOUR.COM

Bar Poker Open Atlantic City Championship 2026

(mysqli): SELECT * FROM event WHERE id = 10812

(mysqli): SELECT name FROM tournament WHERE id = 7 AND name LIKE 'charity%'

(mysqli): SELECT name FROM tournament WHERE id = 7

(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 = 295

(mysqli): SELECT COUNT(player_id) as cnt FROM player_pts WHERE event_id = 10812 AND action = 'CHECK_IN'

(mysqli): SELECT COUNT(id) as cnt FROM event_photo WHERE event_id = 10812

(mysqli): SELECT COUNT(id) as cnt FROM comment WHERE type = 'event' AND _id = 10812

(mysqli): SELECT id FROM event_photo WHERE event_id = 10812 AND dflt = 1

(mysqli): SELECT photo_name, thumb_name FROM event_photo WHERE event_id = 10812 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 = 10812 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 = 10812 AND pts.player_id = 457

(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 = 10812 AND pts.player_id = 457

(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 = 10812 AND pts.player_id = 457

(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 = 10812 AND pts.player_id = 26946

(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 = 10812 AND pts.player_id = 26946

(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 = 10812 AND pts.player_id = 26946

(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 = 10812 AND pts.player_id = 11160

(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 = 10812 AND pts.player_id = 11160

(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 = 10812 AND pts.player_id = 11160

(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 = 10812 AND pts.player_id = 6824

(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 = 10812 AND pts.player_id = 6824

(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 = 10812 AND pts.player_id = 6824

(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 = 10812 AND pts.player_id = 13724

(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 = 10812 AND pts.player_id = 13724

(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 = 10812 AND pts.player_id = 13724

(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 = 10812 AND pts.player_id = 6169

(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 = 10812 AND pts.player_id = 6169

(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 = 10812 AND pts.player_id = 6169

(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 = 10812 AND pts.player_id = 8650

(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 = 10812 AND pts.player_id = 8650

(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 = 10812 AND pts.player_id = 8650

(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 = 10812 AND pts.player_id = 9671

(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 = 10812 AND pts.player_id = 9671

(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 = 10812 AND pts.player_id = 9671

(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 = 10812 AND pts.player_id = 23363

(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 = 10812 AND pts.player_id = 23363

(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 = 10812 AND pts.player_id = 23363

(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 = 10812 AND pts.player_id = 27335

(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 = 10812 AND pts.player_id = 27335

(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 = 10812 AND pts.player_id = 27335

(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 = 10812 AND pts.player_id = 9122

(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 = 10812 AND pts.player_id = 9122

(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 = 10812 AND pts.player_id = 9122

(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 = 10812 AND pts.player_id = 15497

(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 = 10812 AND pts.player_id = 15497

(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 = 10812 AND pts.player_id = 15497

(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 = 10812 AND pts.player_id = 9220

(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 = 10812 AND pts.player_id = 9220

(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 = 10812 AND pts.player_id = 9220

(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 = 10812 AND pts.player_id = 21472

(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 = 10812 AND pts.player_id = 21472

(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 = 10812 AND pts.player_id = 21472

(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 = 10812 AND pts.action = 'CHECK_IN' ORDER BY p.last

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 10279 AND action != 'CHECK_IN'

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 10909 AND action != 'CHECK_IN'

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 27335 AND action != 'CHECK_IN'

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 26946 AND action != 'CHECK_IN'

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 24137 AND action != 'CHECK_IN'

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 23723 AND action != 'CHECK_IN'

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 9220 AND action != 'CHECK_IN'

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 21048 AND action != 'CHECK_IN'

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 21051 AND action != 'CHECK_IN'

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 22961 AND action != 'CHECK_IN'

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 6169 AND action != 'CHECK_IN'

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 13489 AND action != 'CHECK_IN'

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 11160 AND action != 'CHECK_IN'

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 15135 AND action != 'CHECK_IN'

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 10087 AND action != 'CHECK_IN'

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 13487 AND action != 'CHECK_IN'

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 24532 AND action != 'CHECK_IN'

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 15436 AND action != 'CHECK_IN'

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 23104 AND action != 'CHECK_IN'

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 13706 AND action != 'CHECK_IN'

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 27338 AND action != 'CHECK_IN'

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 11833 AND action != 'CHECK_IN'

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 10247 AND action != 'CHECK_IN'

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 22867 AND action != 'CHECK_IN'

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 15752 AND action != 'CHECK_IN'

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 13949 AND action != 'CHECK_IN'

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 27339 AND action != 'CHECK_IN'

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 13713 AND action != 'CHECK_IN'

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 23363 AND action != 'CHECK_IN'

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 6824 AND action != 'CHECK_IN'

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 9122 AND action != 'CHECK_IN'

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 27284 AND action != 'CHECK_IN'

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 6348 AND action != 'CHECK_IN'

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 14801 AND action != 'CHECK_IN'

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 5535 AND action != 'CHECK_IN'

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 21472 AND action != 'CHECK_IN'

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 8135 AND action != 'CHECK_IN'

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 10664 AND action != 'CHECK_IN'

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 23499 AND action != 'CHECK_IN'

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 6731 AND action != 'CHECK_IN'

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 9739 AND action != 'CHECK_IN'

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 6075 AND action != 'CHECK_IN'

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 8650 AND action != 'CHECK_IN'

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 12278 AND action != 'CHECK_IN'

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 13531 AND action != 'CHECK_IN'

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 1423 AND action != 'CHECK_IN'

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 12326 AND action != 'CHECK_IN'

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 9671 AND action != 'CHECK_IN'

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 457 AND action != 'CHECK_IN'

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 25700 AND action != 'CHECK_IN'

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 11437 AND action != 'CHECK_IN'

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 15497 AND action != 'CHECK_IN'

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 15498 AND action != 'CHECK_IN'

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 6639 AND action != 'CHECK_IN'

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 5363 AND action != 'CHECK_IN'

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 8657 AND action != 'CHECK_IN'

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 10305 AND action != 'CHECK_IN'

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 5373 AND action != 'CHECK_IN'

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 22228 AND action != 'CHECK_IN'

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 13724 AND action != 'CHECK_IN'

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 27131 AND action != 'CHECK_IN'

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 23012 AND action != 'CHECK_IN'

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 23874 AND action != 'CHECK_IN'

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 495 AND action != 'CHECK_IN'

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 11918 AND action != 'CHECK_IN'

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 27334 AND action != 'CHECK_IN'

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 6952 AND action != 'CHECK_IN'

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 24140 AND action != 'CHECK_IN'

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 14970 AND action != 'CHECK_IN'

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 15078 AND action != 'CHECK_IN'

(mysqli): SELECT id FROM player_pts WHERE event_id = 10812 AND player_id = 14086 AND action != 'CHECK_IN'

RESULTS

#1 Murray, John
156 Points Awarded

#2 Baughman, Luke
135 Points Awarded

#3 Coakley, Robert
130 Points Awarded

#4 Guess, Jess
120 Points Awarded

#5 Reynolds, Bob
115 Points Awarded

#6 Chobanian, Mark
110 Points Awarded

#7 MacDonald, Robin
105 Points Awarded

#8 Murphy, Ed
100 Points Awarded

#9 Goudailler, Frank
83 Points Awarded

#11 Balzarin, John
73 Points Awarded

#13 Gundlach, Todd
63 Points Awarded

#14 O'Hare, Dennis
58 Points Awarded

#15 Burgess, Sean
53 Points Awarded

#16 Jones, Mark
48 Points Awarded

VIEW EVENT

$80 MINI-MEGA

COLUMBUS DAY MINI-MEGA

10/08/2012 @ 2:00 PM

155 Eastern Ave
Dedham American Legion
Dedham, MA

508 252-9761

Registration Time:1-2 PM
First Hand Dealt At:2:00 PM

2:00 PM - MINI-MEGASTACK
- $70 DONATION FOR 15,000 CHIPS
- $10 EXTRA DONATION FOR 20,000 STARTING STACK
- 20 min levels, 25/50 starting blinds, DEEPSTACK FORMAT

3:00 PM - 6:00 PM - $30 SATELLITES
2,000 starting stacks, 25/50 starting blinds
10 min levels no antes
TOP 2 PER TABLE ADVANCE TO 7:00 EVENT

7:00 PM - MONDAY NIGHT BOUNTY (normal weekly event)
- $110 ($90 DONATION + $20 BOUNTY) FOR 15,000 CHIPS
- $10 DONATION FOR A 20,000 STARTING STACK
- 15 min levels

1/2 NO LIMIT AVAILABLE ALL DAY

This event is part of the Charity tournaments Tour

Buy In:

$70.00

Pay Out:

Rank < 40 41 - 80 81 - 120 121 - 160 161 - 200 > 201

1

50.00%

42.00%

35.00%

32.00%

30.00%

28.50%

2

30.00%

22.00%

18.00%

17.00%

16.25%

15.00%

3

20.00%

12.00%

10.25%

9.75%

9.50%

9.25%

4

9.00%

8.50%

8.00%

7.75%

7.50%

5

8.00%

7.50%

7.00%

6.75%

6.50%

6

7.00%

6.50%

6.00%

5.75%

5.50%

7

5.50%

5.00%

4.75%

4.50%

8

4.75%

4.25%

4.00%

3.75%

9

4.00%

3.50%

3.25%

3.00%

10-12

2.50%

2.25%

2.25%

13-15

1.75%

1.75%

16-18

1.50%

Rank	< 40	41 - 80	81 - 120	121 - 160	161 - 200	> 201
1	50.00%	42.00%	35.00%	32.00%	30.00%	28.50%
2	30.00%	22.00%	18.00%	17.00%	16.25%	15.00%
3	20.00%	12.00%	10.25%	9.75%	9.50%	9.25%
4		9.00%	8.50%	8.00%	7.75%	7.50%
5		8.00%	7.50%	7.00%	6.75%	6.50%
6		7.00%	6.50%	6.00%	5.75%	5.50%
7			5.50%	5.00%	4.75%	4.50%
8			4.75%	4.25%	4.00%	3.75%
9			4.00%	3.50%	3.25%	3.00%
10-12				2.50%	2.25%	2.25%
13-15					1.75%	1.75%
16-18						1.50%

*These are not exact amounts. This table will be used as a guideline and reference for charities. Typically payouts are rounded to the nearest $50

(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

Roster

(mysqli): SELECT p.first, opt.nickname FROM player p LEFT JOIN player_opt opt ON p.id = opt.player_id WHERE p.id = 10812

(mysqli): SELECT opt.player_id, pp.thumb_name as thumb, CONCAT(p.first,' ',p.last) as name FROM player_opt opt LEFT JOIN player_photo pp ON opt.player_id = pp.player_id INNER JOIN player p ON p.id = opt.player_id WHERE opt.featured = 1 AND pp.dflt = 1