>> 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.* FROM blog b WHERE b.player_id = 6071 ORDER BY b.ts DESC LIMIT 0, 20
(mysqli): SELECT COUNT(id) as comment_count FROM comment WHERE _id = 205 AND type = 'blog'
(mysqli): SELECT COUNT(id) as comment_count FROM comment WHERE _id = 200 AND type = 'blog'
(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
thanks Rich
10-30-2008 02:03:05 PM
Rich, thank you for the invite, you and Mike are two of my favorite people
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