>> 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 = 1159
(mysqli): SELECT b.* FROM blog b WHERE b.player_id = 1159 ORDER BY b.ts DESC LIMIT 0, 20
(mysqli): SELECT COUNT(id) as comment_count FROM comment WHERE _id = 80 AND type = 'blog'
(mysqli): SELECT COUNT(id) as comment_count FROM comment WHERE _id = 41 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 = 41 ORDER BY c.ts DESC LIMIT 5
(mysqli): SELECT photo_name, thumb_name FROM player_photo WHERE player_id = 1159 AND dflt = 1 LIMIT 1
(mysqli): SELECT CONCAT(p.first,' ',p.last) as name FROM player p WHERE p.id = 1159
Tactics's BLOG
ahhh...
03-27-2008 10:10:30 PM
Good point! I think I made my first post here when I took a huge beat lol - all good now.
Whatever comes to mind...
01-06-2008 10:43:17 PM
Figured I would start one and see where it goes. Feel free to post.
Getting sick of the luck factor at some places and people winning when they have no clue even how to play the game - simply mind blowing.
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
Jess
03-27-2008 09:44:42 PM
You're forgetting $10 buffet free poker.. People aren't supposed to know how to play poker. And you owe me a heads up match