ACCOUNT ACTIVATION | SIGN UP | LOGIN | CONTACT EPT

>> EASTERNPOKERTOUR.COM

Bar Poker Open Atlantic City Championship 2026

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

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

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

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

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

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

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

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

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

(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 = 6391 AND pts.player_id = 18632

(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 = 6391 AND pts.player_id = 18632

(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 = 6391 AND pts.player_id = 17462

(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 = 6391 AND pts.player_id = 17462

(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 = 6391 AND pts.player_id = 17462

(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 = 6391 AND pts.player_id = 17857

(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 = 6391 AND pts.player_id = 17857

(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 = 6391 AND pts.player_id = 17857

(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 = 6391 AND pts.player_id = 20019

(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 = 6391 AND pts.player_id = 20019

(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 = 6391 AND pts.player_id = 20019

(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 = 6391 AND pts.player_id = 19017

(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 = 6391 AND pts.player_id = 19017

(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 = 6391 AND pts.player_id = 19017

(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 = 6391 AND pts.player_id = 19023

(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 = 6391 AND pts.player_id = 19023

(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 = 6391 AND pts.player_id = 19023

(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 = 6391 AND pts.player_id = 17832

(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 = 6391 AND pts.player_id = 17832

(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 = 6391 AND pts.player_id = 17832

(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 = 6391 AND pts.player_id = 20023

(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 = 6391 AND pts.player_id = 20023

(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 = 6391 AND pts.player_id = 20023

(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 = 6391 AND pts.player_id = 17983

(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 = 6391 AND pts.player_id = 17983

(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 = 6391 AND pts.player_id = 17983

(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 = 6391 AND pts.player_id = 3247

(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 = 6391 AND pts.player_id = 3247

(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 = 6391 AND pts.player_id = 3247

(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 = 6391 AND pts.player_id = 17311

(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 = 6391 AND pts.player_id = 17311

(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 = 6391 AND pts.player_id = 17311

(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 = 6391 AND pts.player_id = 18162

(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 = 6391 AND pts.player_id = 18162

(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 = 6391 AND pts.player_id = 18162

(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 = 6391 AND pts.player_id = 19653

(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 = 6391 AND pts.player_id = 19653

(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 = 6391 AND pts.player_id = 19653

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

RESULTS

#1 Mastropietro, Taylor
168 Points Awarded

#2 Strong, Paul
144 Points Awarded

#3 Putis, John
139 Points Awarded

#4 pilleri, thomas
129 Points Awarded

#5 Gagnon, William
124 Points Awarded

#6 Pena, Jose
119 Points Awarded

#7 Jones, Kevin
114 Points Awarded

#8 zanni, dana
109 Points Awarded

#9 Gleason, Steven
89 Points Awarded

#10 houle, J.P.
84 Points Awarded

#11 Torrisi, Thomas
79 Points Awarded

#12 Williams, Kevin
74 Points Awarded

#13 Arsenault, Brian
69 Points Awarded

VIEW EVENT

Rockingham Saturdays

01/29/2011 @ 2:00 PM

1 Rockingham Park Blvd
Salem, NH
03069

2:00 PM $150 MULTI TABLE

This event is part of the Rockingham Park Tour

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

(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