>> EASTERNPOKERTOUR.COM
(mysqli): SELECT * FROM tournament WHERE id = 14
(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 = 14 AND pts.action = 'CHECK_IN'
(mysqli): SELECT COUNT(id) as cnt FROM tournament_photo WHERE tournament_id = 14
(mysqli): SELECT COUNT(id) as cnt FROM comment WHERE type = 'tournament' AND _id = 14
(mysqli): SELECT id FROM tournament_photo WHERE tournament_id = 14 AND dflt = 1
(mysqli): SELECT photo_name, thumb_name FROM tournament_photo WHERE tournament_id = 14 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 = 14 OR l.id IN (533) ) 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 = 14 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 = 14
(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
The nutz
08-22-2010 01:25:08 AM
Let´s go framingham in two weeks its time to show the EPT that the players from framingham are here to stay. All the players from Rhode Island are saying that Mass. players aren´t good enough. it´s time to prove them wrong. Good luck to all.
President
05-19-2010 05:35:47 PM
John.. nice job hitting 40 at shoppers!!! Framingham is moving up to the big leagues now!! Finally start seeing some Framingham players with some jackets on!!