select survey_id from survsimp_questions where question_id = :question_id select count(*) from survsimp_question_responses where question_id = :question_id delete from survsimp_choice_scores where choice_id in (select choice_id from survsimp_question_choices where question_id = :question_id) delete from survsimp_question_choices where question_id = :question_id