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