(mysqli): SELECT * FROM cms LIMIT 1  

(mysqli): SELECT code FROM menus WHERE type ='tree'  
Eastern Poker Tour - Pub Poker in Rhode Island, Massachusetts and New Hampshire
Bar Poker Open Atlantic City Championship 2026
Bar Poker Open

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

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

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

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

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

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

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

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

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

(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 = 21603 AND pts.player_id = 25294  

(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 = 21603 AND pts.player_id = 25294  

(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 = 21603 AND pts.player_id = 17676  

(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 = 21603 AND pts.player_id = 17676  

(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 = 21603 AND pts.player_id = 17676  

(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 = 21603 AND pts.player_id = 29413  

(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 = 21603 AND pts.player_id = 29413  

(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 = 21603 AND pts.player_id = 29413  

(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 = 21603 AND pts.player_id = 27862  

(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 = 21603 AND pts.player_id = 27862  

(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 = 21603 AND pts.player_id = 27862  

(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 = 21603 AND pts.player_id = 15956  

(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 = 21603 AND pts.player_id = 15956  

(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 = 21603 AND pts.player_id = 15956  

(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 = 21603 AND pts.player_id = 31228  

(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 = 21603 AND pts.player_id = 31228  

(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 = 21603 AND pts.player_id = 31228  

(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 = 21603 AND pts.player_id = 32625  

(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 = 21603 AND pts.player_id = 32625  

(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 = 21603 AND pts.player_id = 32625  

(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 = 21603 AND pts.player_id = 14025  

(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 = 21603 AND pts.player_id = 14025  

(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 = 21603 AND pts.player_id = 14025  

(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 = 21603 AND pts.player_id = 32106  

(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 = 21603 AND pts.player_id = 32106  

(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 = 21603 AND pts.player_id = 32106  

(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 = 21603 AND pts.player_id = 34551  

(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 = 21603 AND pts.player_id = 34551  

(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 = 21603 AND pts.player_id = 34551  

(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 = 21603 AND pts.player_id = 30240  

(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 = 21603 AND pts.player_id = 30240  

(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 = 21603 AND pts.player_id = 30240  

(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 = 21603 AND pts.player_id = 34455  

(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 = 21603 AND pts.player_id = 34455  

(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 = 21603 AND pts.player_id = 34455  

(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 = 21603 AND pts.player_id = 33022  

(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 = 21603 AND pts.player_id = 33022  

(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 = 21603 AND pts.player_id = 33022  

(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 = 21603 AND pts.player_id = 2085  

(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 = 21603 AND pts.player_id = 2085  

(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 = 21603 AND pts.player_id = 2085  

(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 = 21603 AND pts.player_id = 36511  

(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 = 21603 AND pts.player_id = 36511  

(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 = 21603 AND pts.player_id = 36511  

(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 = 21603 AND pts.player_id = 29873  

(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 = 21603 AND pts.player_id = 29873  

(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 = 21603 AND pts.player_id = 29873  

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

RESULTS

#1  Say, Garry
158 Points Awarded
#2  Saltzman, Leonard
137 Points Awarded
#3  Cunha, Josh
132 Points Awarded
#4  Leone, Spencer
122 Points Awarded
#5  Bright, Peter
117 Points Awarded
#6  Copp, Robert
112 Points Awarded
#7  Marsden, John
107 Points Awarded
#8  Sherwood, Mark
102 Points Awarded
#9  DeCologero, Anthony
84 Points Awarded
#10  Bejaniance, Mike
79 Points Awarded
#11  Adams, Paul
74 Points Awarded
#12  Wilson, Michael
69 Points Awarded
#13  Mann, Bill
64 Points Awarded
#14  Lamothe, Don
59 Points Awarded
#15  Molander, Scott
54 Points Awarded
#16  Haubner, Frank
49 Points Awarded
 

VIEW EVENT

American Civic League | WED| $300 GTD +BPO TOKENS

06/29/2016

512 Central Ave
The Reds Club
Lowell, MA
01852

978-459-3041



This event is part of the Greater Lowell 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  

GET DIRECTIONS

  ,     
  ,     

Roster


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

(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  

FEATURED
PLAYERS

Paul Giroux
Mike McGeehan
Paul Seely
Oswald Garlington
Ryan Chua
Mark Thibodeau
David D'Iorio