select count(*) from dotlrn_member_rels_full where rel_type='dotlrn_member_rel' and community_id=:community_id select description,template_id from survey_templates select template from surveys where survey_id=:survey_id select question_text as bquestion, abstract_data_type, boolean_answer from survey_branches b, survey_conditions c, survey_questions q where q.question_id=c.question_id and c.condition_id=b.condition and b.section_id=:section_id select label as bchoice from survey_branches b, survey_conditions c, survey_question_choices qc where qc.choice_id=c.choice_id and c.condition_id=b.condition and b.section_id=:section_id