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 INNER JOIN options ON options.question = questions.id INNER JOIN answers ON answers.option_id = options.id WHERE (options.type = 'radio') 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