DrupalBin

Summary:

Tags:

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

Source code: * 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

Syntax highlighting mode: ActionScriptColdFusionDiffDrupalDrupal 5Drupal 6HTMLJavascriptMySQLPHPPythonrobots.txtSQLText

Select the syntax highlighting mode to use.