>> EASTERNPOKERTOUR.COM
(mysqli): SELECT p.first, opt.nickname FROM player p LEFT JOIN player_opt opt ON p.id = opt.player_id WHERE p.id = 13352
(mysqli): SELECT b.*, COUNT(c.id) as comment_cnt FROM blog b LEFT JOIN comment c ON (b.id = c._id AND c.type = 'blog') WHERE b.id = 545 AND b.player_id = 13352 GROUP BY c._id ORDER BY b.ts DESC LIMIT 5
(mysqli): SELECT photo_name, thumb_name FROM player_photo WHERE player_id = 13352 AND dflt = 1 LIMIT 1
(mysqli): SELECT CONCAT(p.first,' ',p.last) as name FROM player p WHERE p.id = 13352
Sean's BLOG
November Nine Experience at Foxwoods
02-13-2011 08:52:41 PM
Finished 31st out of 210 at the November Nine Experience at Foxwoods (6 places out of the money). Local pro Bill Spadea was at my table (he finished 13th at the 2007 WSOP). Overall I think I played a decent tournament. Ran into a little trouble at the end. It was great to meet Duhamel and the other November Niners.
(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
