DrupalBin

SELECT n.nid, (vaa.value*vac.value)+((SELECT count(wsd.DATA) FROM {webform_submitted_data} wsd WHERE wsd.DATA = n.nid AND wsd.cid = 6)*200) AS total

    FROM node n

    LEFT JOIN {votingapi_cache} vaa ON n.nid = vaa.content_id

    LEFT JOIN {votingapi_cache} vac ON vaa.content_id = vac.content_id

    LEFT JOIN {page_title} pt ON n.nid = pt.id

    WHERE n.type = 'exhibit' AND n.LANGUAGE = 'en' AND vaa.FUNCTION = 'average' AND vac.FUNCTION = 'count' AND pt.type = 'node'

    ORDER BY total DESC, pt.page_title ASC

SELECT DISTINCT(node.nid), votingapi_vote_vote_points.timestamp AS votingapi_vote_vote_points_timestamp FROM node node LEFT JOIN votingapi_cache votingapi_cache_vote_points_count ON node.nid = votinga

SELECT DISTINCT(node.nid), votingapi_vote_vote_points.timestamp AS votingapi_vote_vote_points_timestamp FROM node node LEFT JOIN votingapi_cache votingapi_cache_vote_points_count ON node.nid = votinga