>> 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 = 24651
(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 = 1002 AND b.player_id = 24651 GROUP BY c._id ORDER BY b.ts DESC LIMIT 5
(mysqli): SELECT photo_name, thumb_name FROM player_photo WHERE player_id = 24651 AND dflt = 1 LIMIT 1
(mysqli): SELECT CONCAT(p.first,' ',p.last) as name FROM player p WHERE p.id = 24651
Frank's BLOG
Saturdays
10-26-2013 11:07:51 PM
Saturday has both a positive and a negative! Positive is its my first day off work for the week and the negative..... I can't get away from my wife by going to play EPT poker at a local pub!!! Looking forward to double stacks tomorrow! Oh and....just noticed I have 101 profile views, I must really be making an impression knocking so many people out each game! The next bounty should be on me, but then no one would get it!! But you can try!! Best of luck tomorrow my fellow EPT addicts!
(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
