сорри, забыл запрос по строчкам разбить :(.

Dmitri 29.07.2002 14:46

SELECT 
  answer.answer,
  COUNT(voice.id) as voices 
FROM 
  answer LEFT JOIN voice ON answer.id=voice.answerId 
WHERE  
  answer.voteId=$form:voteId 
GROUP BY 
  answer.answer 
ORDER BY 
  answer.order