>> EASTERNPOKERTOUR.COM

---

(mysqli): SELECT pts.player_id AS player_key, p.last, p.first, opt.nickname, pts.player_id, COUNT(pts.player_id) as wins FROM player_pts pts LEFT JOIN player AS p ON p.id = pts.player_id LEFT JOIN player_opt AS opt ON opt.player_id = p.id LEFT JOIN event AS e ON e.id = pts.event_id LEFT JOIN tournament AS t ON e.tournament_id = t.id WHERE pts.action = 1 AND pts.player_id != 0 GROUP BY pts.player_id ORDER BY wins 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  

---