(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
As Seen on Comcast

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

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

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

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

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

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

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

(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 = 5573 AND pts.player_id = 11147  

(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 = 5573 AND pts.player_id = 11147  

(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 = 5573 AND pts.player_id = 13804  

(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 = 5573 AND pts.player_id = 13804  

(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 = 5573 AND pts.player_id = 13804  

(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 = 5573 AND pts.player_id = 13683  

(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 = 5573 AND pts.player_id = 13683  

(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 = 5573 AND pts.player_id = 13683  

(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 = 5573 AND pts.player_id = 8651  

(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 = 5573 AND pts.player_id = 8651  

(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 = 5573 AND pts.player_id = 8651  

(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 = 5573 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 = 5573 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 = 5573 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 = 5573 AND pts.player_id = 8075  

(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 = 5573 AND pts.player_id = 8075  

(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 = 5573 AND pts.player_id = 8075  

(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 = 5573 AND pts.player_id = 5191  

(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 = 5573 AND pts.player_id = 5191  

(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 = 5573 AND pts.player_id = 5191  

(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 = 5573 AND pts.player_id = 6348  

(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 = 5573 AND pts.player_id = 6348  

(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 = 5573 AND pts.player_id = 6348  

(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 = 5573 AND pts.player_id = 2211  

(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 = 5573 AND pts.player_id = 2211  

(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 = 5573 AND pts.player_id = 2211  

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

RESULTS

#1  Plante, Brian
172 Points Awarded
#2  Struzynski, Mark
146 Points Awarded
#3  Chiappini, Kathy
141 Points Awarded
#4  Roderiques, John
131 Points Awarded
#6  Murray, John
121 Points Awarded
#7  Shuman, Jeff
116 Points Awarded
#8  Acerra, Bill "Milkshake"
111 Points Awarded
#9  Harding, Glenn
91 Points Awarded
#10  Ellis, Diane
86 Points Awarded
 

VIEW EVENT

$10,000 GUARANTEED

$10,000 Guaranteed!Sponsored by Dennis Phillips in honor of 9/11

 

09/11/2010

119 Prospect Heights
Portuguese Club
Milford, MA


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


bernarddennis

DENNIS PHILLIPS WILL BE HOSTING THE CHARITY MEMORIAL POKER TOURNAMENT TO BENEFIT MILFORD FIREFIGHTERS. DURING THIS EVENT WE WILL ALSO TAKE SOME TIME TO HONOR THE NYC FIREFIGHTERS, THE HERO'S, AND THE VICTIMS FROM THIS NATIONAL TRAGEDY ON 9/11

Register Now! Seats are limited!


$40 SINGLE TABLE SATELLITES START AT 2:00 PM

TOP 2 PER TABLE ADVANCE TO MAIN EVENT

$150 MAIN EVENT STARTS AT 6:00 PM $10,000 GUARANTEED PRIZE PAYOUT!!
DEEPSTACK FORMAT!
12,000 CHIPS TO START
3,000 Add-on donation available for $10 during registration only

25/50 starting blinds and 20 minute levels

Payouts increase at a rate of 75% of buy-in after guarantee is met


This event is part of the Charity tournaments Tour


Buy In:
$150.00                    
Pay Out:

$10,000 PAYOUT IS GUARANTEED. AMOUNT WILL INCREASE AT A RATE OF 75% OF THE BUY-IN AFTER GUARANTEE IS MET

PAYOUTS




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

(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

David D'Iorio
Greg Spirito
Carole Smith
Paul Seely
Mike McGeehan
Andre Pereira
Oswald Garlington