SELECT questions.id AS question_id, questions.title AS question_title, options.description AS option_desc, options.id AS option_id, count( answers.id ) AS answers_count
FROM questions, options, answers
WHERE options.question = questions.id
AND (
options.type = 'radio'
)
AND answers.option_id = options.id
AND questions.inquiry =39
AND answers.response
NOT IN (
SELECT answers.response
FROM answers
WHERE answers.inquiry =39
AND answers.option_id
IN ( 485 )
)
GROUP BY options.id
ORDER BY question_id, answers_count DESC