>> 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 = 850
(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 = 34 AND b.player_id = 850 GROUP BY c._id ORDER BY b.ts DESC LIMIT 5
(mysqli): SELECT photo_name, thumb_name FROM player_photo WHERE player_id = 850 AND dflt = 1 LIMIT 1
(mysqli): SELECT CONCAT(p.first,' ',p.last) as name FROM player p WHERE p.id = 850
Matt's BLOG
HAPPY HOLIDAYS EPT!!!
12-17-2007 07:55:41 PM
<object id="A6906544187227425792" quality="high" data="http://llnw.jibjab.com/content/player.swf?content_url=http://www.jibjab.com/sendables/api/remote/LNwLrHpyTqxzk2en4EmpU4jD.xml" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" wmode="transparent" height="369" width="435"><param name="wmode" value="transparent"></param><param name="movie" value="http://llnw.jibjab.com/content/player.swf"></param><param name="scaleMode" value="showAll"></param><param name="quality" value="high"></param><param name="allowNetworking" value="internal"></param><param name="FlashVars" value="content_url=http://www.jibjab.com/sendables/api/remote/LNwLrHpyTqxzk2en4EmpU4jD.xml"></param><param name="allowScriptAccess" value="never"></param></object><div style="text-align:center; width:435px; margin-top:6px;">Don't send a lame <a href="http://www.jibjab.com/sendables/category/48/holiday">Holiday eCard</a>. Try <a href="http://www.jibjab.com/sendables">JibJab Sendables</a>!</div>
(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
