>> EASTERNPOKERTOUR.COM
(mysqli): SELECT r.player_id, CONCAT(p.first, ' ', p.last) AS name, (SELECT pp.thumb_name FROM player_photo AS pp WHERE pp.player_id = r.player_id AND pp.dflt = 1 ORDER BY pp.id ASC LIMIT 1) AS thumb_name, SUM((r.pri_event_points + r.pri_bonus_points)) AS total, SUM(r.pri_event_count) as event_count FROM rankings AS r LEFT JOIN player AS p ON p.id = r.player_id WHERE r.rank_type = 'Alltime' AND r.rank_basic != '0' AND r.rank_w_addl_pts != '0' GROUP BY r.player_id ORDER BY total DESC, p.last ASC, p.first ASC LIMIT 8
(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
