>> 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 = 1192
(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 = 'player' AND c._id = 1192 ORDER BY c.ts DESC LIMIT 5
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
President
08-14-2009 06:47:32 PM
haha.. come on tait! wayyy ahead of ya :)
Anthony
07-19-2009 03:12:41 PM
Not to mention...I should be at your final table....spite? hmmmm, very possible!!
Anthony
07-19-2009 03:11:33 PM
Tait...it appears your point average keeps getting further away from me...not really sure what's going on with that but for some reason you have gone in the opposite direction. It must be the whole retroactive theory that's effecting so much! Keep working at it kiddo....you'll get there some day..goals are great to have..if you have any questions or need any tips you just say the word buddy i'm there for ya!!!
The Zim
07-02-2009 06:21:47 AM
Oh yea. That is most def. one of the many secrets of tait
President
05-08-2009 06:58:56 PM
the moose.... i'll write the directions