DrupalBin

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 = votingapi_cache_vote_points_count.content_id AND votingapi_cache_vote_points_count.content_type = 'node' AND votingapi_cache_vote_points_count.value_type = 'points' AND votingapi_cache_vote_points_count.tag = 'vote' AND votingapi_cache_vote_points_count.FUNCTION = 'count' LEFT JOIN votingapi_vote votingapi_vote_vote_points ON node.nid = votingapi_vote_vote_points.content_id AND votingapi_vote_vote_points.content_type = 'node' AND votingapi_vote_vote_points.value_type = 'points' AND votingapi_vote_vote_points.tag = 'vote' WHERE (node.STATUS = '1') AND (node.type IN ('blog')) AND (votingapi_cache_vote_points_count.value >= 5) GROUP BY node.nid, votingapi_vote_vote_points_timestamp ORDER BY votingapi_vote_vote_points_timestamp DESC LIMIT 0, 5