select branch_id,after from survey_branches where section_id=:section_id select question_id, question_text, abstract_data_type from survey_questions q, survey_sections s where s.survey_id=:survey_id and sort_key<=(select sort_key from survey_sections where section_id=:after) and q.section_id=s.section_id and abstract_data_type in ('boolean','choice') and presentation_type in ('select', 'radio', 'checkbox') select choice_id,label from survey_question_choices where question_id=:question_id order by sort_order