SELECT node.nid AS nid,
   node_data_field_lead_image.field_lead_image_fid AS node_data_field_lead_image_field_lead_image_fid,
   node_data_field_lead_image.field_lead_image_list AS node_data_field_lead_image_field_lead_image_list,
   node_data_field_lead_image.field_lead_image_data AS node_data_field_lead_image_field_lead_image_data,
   node.type AS node_type,
   node.vid AS node_vid,
   node_data_field_short_headline.field_short_headline_value AS node_data_field_short_headline_field_short_headline_value,
   node_revisions.body AS node_revisions_body,
   node_revisions.format AS node_revisions_format,
   domain.sitename AS domain_sitename,
   domain.domain_id AS domain_domain_id,
   votingapi_cache_node_percent_vote_average.value AS votingapi_cache_node_percent_vote_average_value
 FROM node node 
 LEFT JOIN votingapi_cache votingapi_cache_node_percent_vote_average ON node.nid = votingapi_cache_node_percent_vote_average.content_id AND (votingapi_cache_node_percent_vote_average.content_type = 'node' AND votingapi_cache_node_percent_vote_average.value_type = 'percent' AND votingapi_cache_node_percent_vote_average.tag = 'vote' AND votingapi_cache_node_percent_vote_average.function = 'average')
 LEFT JOIN content_type_article node_data_field_lead_image ON node.vid = node_data_field_lead_image.vid
 LEFT JOIN content_field_short_headline node_data_field_short_headline ON node.vid = node_data_field_short_headline.vid
 LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid
 LEFT JOIN domain_access domain_access ON node.nid = domain_access.nid
 LEFT JOIN domain domain ON domain_access.gid = domain.domain_id
 WHERE (node.status <> 0) AND (node.type in ('article', 'gallery'))
   ORDER BY votingapi_cache_node_percent_vote_average_value DESC