selectcount(*) as aggregate from `running_student_info` leftjoin `student_personal_info` on `student_personal_info`.`id` = `running_student_info`.`student_id` leftjoin `student_guardian_information` on `student_guardian_information`.`id` = `running_student_info`.`student_id` leftjoin `add_group` on `add_group`.`id` = `running_student_info`.`group_id` where `running_student_info`.`class_id` ='311611180001'