>> 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 = 24688
(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 = 758 AND b.player_id = 24688 GROUP BY c._id ORDER BY b.ts DESC LIMIT 5
(mysqli): SELECT photo_name, thumb_name FROM player_photo WHERE player_id = 24688 AND dflt = 1 LIMIT 1
(mysqli): SELECT CONCAT(p.first,' ',p.last) as name FROM player p WHERE p.id = 24688
D dawg's BLOG
newbe
05-29-2012 05:32:32 AM
hello all. my name is douglas kelly. love playing poker. new to the EPT. looking to make some new poker buddies. all are welcome. Hmu here or on facebook (Douglas Kelly or [email protected] or [email protected] )
(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
