[Mazinger]

I want to change 'Most Viewed' to 'Most Rated'

Can you help me with this query:

PHP Code:

// Most view thread
    if ($_REQUEST['top'] == '+++++++_most_viewed')    {
        $get_stats_mostviewed = $vbulletin->db->query_read("
            SELECT threadid,
                title,
                forumid,
                views,
                dateline,
                visible,
                open,
                lastpost,
                replycount,
                postusername,
                lastposter                
            FROM " . TABLE_PREFIX . "thread AS thread
            WHERE NOT ISNULL(threadid) AND visible = '1' AND views > '0' AND open!='10' $+++++++exclforums $+++++++topstats_timecut_mostviewed
            ORDER BY views DESC
            LIMIT 0, $resultthread
            ");        
        while ($get_most_viewed = $db->fetch_array($get_stats_mostviewed))    {
            $get_most_viewed[fullthreadtitle] = strip_tags($get_most_viewed[title]);
            if ($trimthreadtitle > 0)    {
                $get_most_viewed[titletrimmed] = fetch_trimmed_title($get_most_viewed[fullthreadtitle], $trimthreadtitle);
            }
            else    {
                $get_most_viewed[titletrimmed] = $get_most_viewed[fullthreadtitle];
            }
            $get_most_viewed[newpost] = ($get_most_viewed[lastpost] > $vbulletin->userinfo['lastvisit'])? 'new' : 'old';
            $get_most_viewed_forumtitle = strip_tags($vbulletin->forumcache["$get_most_viewed[forumid]"]['title_clean']);
            $get_most_viewed[fullforumtitle] = strip_tags($get_most_viewed_forumtitle);        
            $get_new_postdate = vbdate($vbulletin->options['+++++++topstats_date_format'], $get_most_viewed[lastpost]);
            $get_new_posttime = vbdate($vbulletin->options['+++++++topstats_time_format'], $get_most_viewed[lastpost]);
            $get_startdate = vbdate($vbulletin->options['+++++++topstats_date_format'], $get_most_viewed[dateline]);
            $get_starttime = vbdate($vbulletin->options['+++++++topstats_time_format'], $get_most_viewed[dateline]);    
            eval('$+++++++topstats_top.= "' . $vbulletin->templatecache['+++++++_topstats_mostviewed'] . '";');
        }
        if (!$+++++++topstats_top)    $+++++++topstats_top = 'No Result';
        print_output($+++++++topstats_top);
        exit;
    }