Home

Fix for VotingAPI + Webform exhibit ranking SQL

January 14, 2010 - 1:23pm — Anonymous
  1. 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
  2.     FROM node n
  3.     LEFT JOIN {votingapi_cache} vaa ON n.nid = vaa.content_id
  4.     LEFT JOIN {votingapi_cache} vac ON vaa.content_id = vac.content_id
  5.     LEFT JOIN {page_title} pt ON n.nid = pt.id
  6.     WHERE n.type = 'exhibit' AND n.LANGUAGE = 'en' AND vaa.FUNCTION = 'average' AND vac.FUNCTION = 'count' AND pt.type = 'node'
  7.     ORDER BY total DESC, pt.page_title ASC

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.