select pretty_name, description, supertype from dotlrn_classes_full where class_key = :class_key select dotlrn_class_instances_full.*, (select count(*) from dotlrn_member_rels_approved where dotlrn_member_rels_approved.community_id = dotlrn_class_instances_full.class_instance_id) as n_members from dotlrn_class_instances_full where dotlrn_class_instances_full.class_key = :class_key select dotlrn_class_instances_full.*, (select count(*) from dotlrn_member_rels_approved where dotlrn_member_rels_approved.community_id = dotlrn_class_instances_full.class_instance_id) as n_members from dotlrn_class_instances_full where dotlrn_class_instances_full.class_key = :class_key and dotlrn_class_instances_full.term_id = :term_id