Error Number: 1054

Unknown column 'index.html' in 'order clause'

SELECT *, sum(run) as runs, sum(fours) as fours, sum(sixes) as sixes, sum(wicket) as wickets, sum(fifty) as fifty, sum(hundred) as hundred, sum(runs_enhanced) as runs_enhanced, sum(ball_faced) as ball_faced, (sum(run)/sum(ball_faced))*100 as sr, sum(run) / (sum(batted) - sum(is_out)) as average, max(run) as highscore, sum(batted)-sum(is_out) as notout, count(*) as innings, sum(overs) as overs, sum(runs_enhanced) as run_conceded, sum(runs_enhanced)/sum(overs) as eco, sum(IF(wicket=4, 1, 0)) as frw, sum(IF(wicket=5, 1, 0)) as fvw, sum(round(overs, 1))*6/sum(wicket) as bsr FROM `player_match_stats` GROUP BY `pid` ORDER BY `index`.`html` LIMIT 30

Filename: controllers/Frontend.php

Line Number: 687