Drupal 5.1 + VotingAPI (+ Userreview) + Views => Top 10 List?

I doubt this will be of much use, but I did want to respond. Back in February, I made a (released, but not publicized) module for the 4.7.x version that created a ballot in which the something could be nominated for multiple categories. This was voting on blogs, but my results page does something similar to what you want. It's a convoluted example, but maybe my clarifications below the code will help.

function blogawards_results($limit = 0) {
    $voting_categories = taxonomy_get_children(0, 1);
    $output = "";
    foreach ($voting_categories as $tid => $category_object) {
        $results = blogawards_get_voting_results(BLOGAWARDS_CONTENT_TYPE, $tid);
        //echo "<pre>";print_r($results);echo "</pre>";
        $output .= "<div id=\"category_results_" . $tid . "\"><h3>$category_object->name</h3>\n";
        $category_vote_sum = 0;
        $category_limit_counter = 0;
        foreach ($results as $blog_result) {
            if ($limit == 0 || $category_limit_counter < $limit) {
                
            
                if ($blog_result->function != 0) {
                $blog_node = node_load($blog_result->function);
                $output .= "<div id=\"result_" . $tid . "_" . $blog_node->title . "\" ><span class=\"title\" style=\"font-style:italic\">" . l($blog_node->title, $blog_node->field_url[0]['value'], array ("target" => "_blank", "rel" => "nofollow")) . "</span>: <span class=\"value\" style=\"color: blue\">$blog_result->value</span></div>\n";
                $category_vote_sum += $blog_result->value;
                $category_limit_counter++;
            }
            }
            else if ($blog_result->function != 0) $category_vote_sum += $blog_result->value;
            
        }
        $output .= "<div id=\"category_total_" . $tid . "\" style=\"color: red\"><h4 style=\"color: black\">Total votes this category:</h4> $category_vote_sum</div></div>\n";
    }
    $output .= "<div>Results Last Updated: " . format_date(variable_get("votingapi_last_cron",''), "large") . "</div>";
    return $output;
}

Every blog that could be nominated for something was in a CCK node, and every blog competing for an "award" was a taxonomy term. If you ignore all the themeing cruft, it's just going through each taxonomy term and displaying the votes that have already been calculated. BLOGAWARDS_CONTENT_TYPE was taxonomy, so the results were stored for each taxonomy term ($tid).

Although the page I linked to won't do it (it's now just a page node), the function was written so that you could minimize that to a lower number, instead of displaying all the results. So if the results page is at example.com/results, example.com/results/10 would give you the top 10 for each category.

Hope that helps.

_{If you really want to see the full module, I can post the URL, but I'm really not proud of it since it's my first (and only) Drupal module. It doesn't use any themeing or caching, which took down the database server multiple times an hour. It's also hardcoded for our setup.}

I forgot to mention how I got the results out.

function blogawards_get_voting_results($content_type, $content_id) {
    $voting_results = array ();
    $result = db_query("SELECT * FROM {votingapi_cache} v WHERE content_type='%s' AND content_id=%d ORDER BY v.value DESC", $content_type, $content_id);
    while ($cached = db_fetch_object($result)) {
        $voting_results[] = $cached;
    }
    return $voting_results;
}

I didn't like the way votingapi_get_voting_results() worked, so I used my own version. Looking back on it, I probably should have used hook_alter_sql hook to edit the SQL, and return an array from the DB object.

See http://drupal.org/node/148357 for how I do it

Views integration in VotingAPI 5.x is fundamentally broken -- it works for a small number of cases but more complex cases like this are not supported, and this isn't being developed further. Views support was rewriten in the 2.x branch to fix these issues. If anyone wants to take a stab at rewriting the Views integration for D5, they're welcome to, but it's not on my radar at present.