>> 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 = 6071
(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 = 200 AND b.player_id = 6071 GROUP BY c._id ORDER BY b.ts DESC LIMIT 5
(mysqli): SELECT c.*, p.first, opt.nickname, pp.thumb_name FROM comment c LEFT JOIN player p ON c.made_by = p.id LEFT JOIN player_opt opt ON c.made_by = opt.player_id LEFT JOIN player_photo pp ON (c.made_by = pp.player_id AND pp.dflt = 1) WHERE c.type = 'blog' AND c._id = 200 ORDER BY c.ts DESC LIMIT 5
(mysqli): SELECT photo_name, thumb_name FROM player_photo WHERE player_id = 6071 AND dflt = 1 LIMIT 1
(mysqli): SELECT CONCAT(p.first,' ',p.last) as name FROM player p WHERE p.id = 6071
Steve's BLOG
to the prince of EPT
10-24-2008 03:48:41 PM
Thanks Michael for inviting me to be on your friends list, the honor is mine !!!
steve
COMMENTS
(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
The Zim
10-24-2008 04:50:27 PM
Steve It's really an honor to have you on my friend's list! It's because of your attitude and class makes me want to show up to these events. See you at the tables Prince of EPT