How to make a raw SQL query to get the node/node_votes pairs?
Try this query:

SELECT field_vote_rating from field_data_field_vote
WHERE entity_type = 'node' AND entity_id = $nid;


You can use the database api to create SQL Queries