>> EASTERNPOKERTOUR.COM

---

(mysqli): SELECT pts.player_id AS player_key, p.last, p.first, opt.nickname, p.phone, p.email, p.primary_tournament_id, pts.player_id, COUNT(pts.player_id) as wins, GROUP_CONCAT(CONCAT(e.id, '-', FROM_UNIXTIME(e.date, '%m/%d')) ORDER BY FROM_UNIXTIME(e.date, '%Y%m%d') ASC, e.id ASC SEPARATOR ', ') as date_tournament, (SELECT (r.pri_event_points + r.pri_bonus_points + r.neu_event_points + r.neu_bonus_points + r.sec_event_points + r.sec_bonus_points) FROM rankings AS r WHERE r.player_id = pts.player_id AND r.rank_type = 'Monthly' AND r.rank_period = '202610' AND r.tournament_id = p.primary_tournament_id ORDER BY r.id ASC LIMIT 1) AS total FROM player_pts pts LEFT JOIN player p ON p.id = pts.player_id LEFT JOIN player_opt AS opt ON opt.player_id = p.id LEFT JOIN event e ON e.id = pts.event_id LEFT JOIN tournament t ON e.tournament_id = t.id WHERE pts.action = 1 AND e.date >= 1790812800 AND e.date <= 1793404800 AND pts.player_id != 0 GROUP BY pts.player_id ORDER BY wins DESC, total DESC, p.last ASC, p.first ASC  

---

---

(mysqli): SELECT t.id, t.name, t.state FROM tournament t WHERE t.active = 1 ORDER BY t.name ASC  

---

---

(mysqli): SELECT id, name, city FROM location WHERE active = 1 ORDER BY name ASC  

---

---

(mysqli): SELECT id, name, state FROM tournament WHERE 1 ORDER BY name ASC  

---

---

(mysqli): SELECT l.id, l.name, l.city FROM location l LEFT JOIN event e ON e.location_id = l.id LEFT JOIN tournament t ON t.id = e.tournament_id WHERE l.active = 1 AND t.active = 1 ORDER BY l.name ASC  

---

FEATURED
PLAYERS

Tour Home | Privacy Policy | Charity Events | Corporate Events | Official Rules | Employment | Advertising | Partner Links | Contact