>> EASTERNPOKERTOUR.COM
(mysqli): SELECT * FROM tournament WHERE id = 18
(mysqli): SELECT COUNT(DISTINCT(pts.player_id)) as cnt FROM player_pts pts INNER JOIN event e ON e.id = pts.event_id WHERE e.tournament_id = 18 AND pts.action = 'CHECK_IN'
(mysqli): SELECT COUNT(id) as cnt FROM tournament_photo WHERE tournament_id = 18
(mysqli): SELECT COUNT(id) as cnt FROM comment WHERE type = 'tournament' AND _id = 18
(mysqli): SELECT id FROM tournament_photo WHERE tournament_id = 18 AND dflt = 1
(mysqli): SELECT photo_name, thumb_name FROM tournament_photo WHERE tournament_id = 18 AND dflt = 1 LIMIT 1
(mysqli): SELECT DISTINCT l.id, l.name, l.city, l.day, l.default_time FROM location l LEFT JOIN event e ON l.id = e.location_id WHERE l.active = 1 AND ( e.tournament_id = 18 ) AND e.date >= 1743724800 AND e.date <= 1806451200 ORDER BY l.day, l.default_time, l.name DESC
October 2026 - Rankings
Current Season Rankings
(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 = 'tournament' AND c._id = 18 ORDER BY c.ts DESC LIMIT 5
COMMENTS
(mysqli): SELECT p.first, opt.nickname FROM player p LEFT JOIN player_opt opt ON p.id = opt.player_id WHERE p.id = 18
(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
12-31-2010 09:03:40 PM
UNLOCK ALL THE FEATURES OF YOUR PLAYER PROFILE AND ACTIVATE YOUR ACCOUNT! 1) Click This Link 2) USE OPTION 2, your membership card should be provided by the river poker room staff
Joe
11-21-2010 06:34:34 AM
huad