ACCOUNT ACTIVATION | SIGN UP | LOGIN | CONTACT EPT

>> EASTERNPOKERTOUR.COM

Bar Poker Open Atlantic City Championship 2026

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

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

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

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

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

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

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

(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 = 6019 AND pts.player_id = 8657

(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 = 6019 AND pts.player_id = 8657

(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 = 6019 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 = 6019 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 = 6019 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 = 6019 AND pts.player_id = 5943

(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 = 6019 AND pts.player_id = 5943

(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 = 6019 AND pts.player_id = 5943

(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 = 6019 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 = 6019 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 = 6019 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 = 6019 AND pts.player_id = 15430

(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 = 6019 AND pts.player_id = 15430

(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 = 6019 AND pts.player_id = 15430

(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 = 6019 AND pts.player_id = 5981

(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 = 6019 AND pts.player_id = 5981

(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 = 6019 AND pts.player_id = 5981

(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 = 6019 AND pts.player_id = 6187

(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 = 6019 AND pts.player_id = 6187

(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 = 6019 AND pts.player_id = 6187

(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 = 6019 AND pts.player_id = 7573

(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 = 6019 AND pts.player_id = 7573

(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 = 6019 AND pts.player_id = 7573

(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 = 6019 AND pts.player_id = 11719

(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 = 6019 AND pts.player_id = 11719

(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 = 6019 AND pts.player_id = 11719

(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 = 6019 AND pts.player_id = 8980

(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 = 6019 AND pts.player_id = 8980

(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 = 6019 AND pts.player_id = 8980

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

RESULTS

#1 Phillips, Scott
174 Points Awarded

#2 Chobanian, Mark
148 Points Awarded

#3 Germano, Peter
143 Points Awarded

#4 Murray, John
133 Points Awarded

#5 Clark, Walter
128 Points Awarded

#6 Brown, Lynn
123 Points Awarded

#7 Tulipano, Emilio
118 Points Awarded

#8 Calnan, Ron
113 Points Awarded

#9 Tavares, Alex
92 Points Awarded

#10 Weinstein, Alan
87 Points Awarded

VIEW EVENT

TEAM POKER CHALLENGE

TEAM POKER CHALLENGE 8 - $20,000 GUARANTEED!

12/04/2010

Demetri's Function Facility
2 Washington St Route 1 Northbound
Foxboro, MA

Registration Time:11:00 AM
First Hand Dealt At:12:00 PM

REGISTRATION FOR TEAMS OF 4 (includes paypal processing fee (4%):

REGISTRATION FOR TEAMS OF 3 (includes paypal processing fee (4%):

Tournament benefits Attleboro Animal Shelter

This event is part of the Charity tournaments Tour

Buy In:

$45.00

Pay Out:

Individuals will play for 60% of total prize payout that will be paid to the top 10% of the field.

Teams will play for the remaining 40% of total prize payout that will be paid to top 3 teams in this manner:

1st place 50%
2nd place 30%
3rd place 20%

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

(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