Home

Fix for Fix for VotingAPI + Views buggy query

March 31, 2008 - 11:46am — Anonymous
  1. 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

Submit Fix

Any tags you'd like to associate with your code, delimitered by commas (example: Views, CCK, Module, etc).
Select the syntax highlighting mode to use.