>> 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 = 137
(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 = 131 AND b.player_id = 137 GROUP BY c._id ORDER BY b.ts DESC LIMIT 5
(mysqli): SELECT photo_name, thumb_name FROM player_photo WHERE player_id = 137 AND dflt = 1 LIMIT 1
(mysqli): SELECT CONCAT(p.first,' ',p.last) as name FROM player p WHERE p.id = 137
Lionel's BLOG
Hey there Poker Fans
06-02-2008 08:10:19 PM
Its been quite a while since my last blog so decided to write a new one! The championship is fast approaching and want to see all those who dont yet have a seat come out and give it a couple of tries for before the main event. Also as always if you have questions or suggestions please feel free to email or call. So come on guys with our new locations doing well Shanghi Gardens and Moose Cabin and the wonderful spread they put out its nothing but a good time. We want to make it most of all fun for all of us. Bad beats or not its a fun game and should always be treated as such. now if you in the WPT its a whole different ball game LOL. Hope to see you guys playing soon.
(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
