Problem with adding the "VotingAPI: Voting results" field

Ok, I digged a little deep into the code. I was looking at the MySQL query generated from the devel module:

SELECT 	count(node.nid) 
FROM 	node node 
.....
LEFT JOIN 
	votingapi_cache votingapi_cache 
ON 	node.nid = votingapi_cache.content_id 
AND 	votingapi_cache.content_type = 'node' 
WHERE 	(node.type 
	IN ('content-links')) 
AND 	((term_node.tid = '2')) 
// @@ The following three equal statements limited the result set to the ones that only have been voted
AND 	(votingapi_cache.value_type = 'percent')  
AND 	(votingapi_cache.tag = 'vote') 
AND 	(votingapi_cache.function = 'average')

As I commented in the code, although it is a left join, if you use the columns from the right table in the where clause, the result set will be restricted to that table. Move those up to right after "left join ... on ... " should solve the problem. Something like:

SELECT 	count(node.nid) 
FROM 	node node 
.....
LEFT JOIN 
	votingapi_cache votingapi_cache 
ON 	node.nid = votingapi_cache.content_id 
AND 	votingapi_cache.content_type = 'node' 
// @@ This is the right place
AND 	(votingapi_cache.value_type = 'percent')  
AND 	(votingapi_cache.tag = 'vote') 
AND 	(votingapi_cache.function = 'average')
WHERE 	(node.type 
	IN ('content-links')) 
AND 	((term_node.tid = '2')) 

I will try to put a patch for this (never done one before). Meanwhile, any suggestions or comments are welcome.

After some research, it seems to be an issue with the VotingAPI and its integration with Views.

After spending half a day, I gave up on the patch idea. I did a quick fix though to fit my needs. Below is my hack if anyone is insterested:

1. In the votingapi_views_tables() function (located in the votingapi_views.inc file), change:

......
"extra" => array(
        'content_type' => 'node',
      ),
......

to

"extra" => array(
        'content_type' => 'node',
	// Following three columns are added to the "left join ... on ..." part of the query
        'value_type' => 'percent',
		'tag' => 'vote',
		'function' => 'average'
      ),

2. Also comment out most part of the votingapi_views_value_query_handler function:

function votingapi_views_value_query_handler($field, $fieldinfo, &$query) {
  $table = $field['tablename'];
  /* Comment out this portion
  if (is_string($field['options'])) {
    $options = unserialize($field['options']);
    if (is_array($options)) {
      foreach ($options as $column => $value) {
        $query->add_where("$table.$column = '$value'");
      }
    }
  }*/
}

Question: I couldn't figure out how to programmably change the "extra" field of the table array using the "option" values. Any ideas?