(mysqli): SELECT r.player_id, p.last, p.first, opt.nickname, p.phone, p.email, r.rank_w_addl_pts AS `rank`, r.rank_out_of, (r.pri_event_points + r.pri_bonus_points + r.neu_event_points + r.neu_bonus_points + r.sec_event_points + r.sec_bonus_points) AS total, (r.pri_event_count + r.neu_event_count + r.sec_event_count) as event_count, ROUND(((r.pri_event_points + r.pri_bonus_points + r.neu_event_points + r.neu_bonus_points + r.sec_event_points + r.sec_bonus_points) / (r.pri_event_count + r.neu_event_count + r.sec_event_count)), 2) AS average, (r.pri_wins + r.neu_wins + r.sec_wins) AS wins, (r.pri_top_16s + r.neu_top_16s + r.sec_top_16s) AS top16 FROM rankings AS r LEFT JOIN player AS p ON p.id = r.player_id LEFT JOIN player_opt AS opt ON opt.player_id = p.id WHERE r.rank_type = 'Seasonal' AND r.rank_period = '36' AND r.tournament_id = '22' AND r.rank_basic != '0' AND r.rank_w_addl_pts != '0' ORDER BY r.rank_w_addl_pts ASC, p.last ASC, p.first ASC
TOP 400 BY TOURNAMENT - ERROR
There were no events held during season 36.