Generating Main content nodes based on SQL data (associated with users)
From what i have understood about the problem you are facing, i believe its advised using the content type for profile as well as the votes. Here is the CCK field to use the vote field. 
https://www.drupal.org/project/rate
It would be very easy for you to create view if all fields are part of content types.