Вьюха выдает такой запрос

SELECT node.nid AS nid,
node.title AS node_title,
node.language AS node_language,
votingapi_cache_node_percent_vote_text_average.value AS votingapi_cache_node_percent_vote_text_average_value,
votingapi_cache_node_percent_vote_music_average.value AS votingapi_cache_node_percent_vote_music_average_value
FROM node node
LEFT JOIN votingapi_cache votingapi_cache_node_percent_vote_text_average ON node.nid = votingapi_cache_node_percent_vote_text_average.content_id AND (votingapi_cache_node_percent_vote_text_average.content_type = 'node' AND votingapi_cache_node_percent_vote_text_average.value_type = 'percent' AND votingapi_cache_node_percent_vote_text_average.tag = 'vote_text' AND votingapi_cache_node_percent_vote_text_average.function = 'average')
LEFT JOIN votingapi_cache votingapi_cache_node_percent_vote_music_average ON node.nid = votingapi_cache_node_percent_vote_music_average.content_id AND (votingapi_cache_node_percent_vote_music_average.content_type = 'node' AND votingapi_cache_node_percent_vote_music_average.value_type = 'percent' AND votingapi_cache_node_percent_vote_music_average.tag = 'vote_music' AND votingapi_cache_node_percent_vote_music_average.function = 'average')
INNER JOIN content_field_noderef_artist node_data_field_noderef_artist ON node.vid = node_data_field_noderef_artist.vid
WHERE (node.type in ('song')) AND (node_data_field_noderef_artist.field_noderef_artist_nid = '1545')

пробую составить запрос и сложить значения рейтинга, что -то не получается...

на вьюхе выводятся заголовки песен рейтинг по виджету слова и виджету музыка (модуль Rate) нужно

1. сложить значения

2. сложить и разделить на 2