AND AlumniAcademicInfo.department_id = UnitDepartment.department_id
AND AlumniAcademicInfo.grad_date IS NOT NULL
AND AlumniAcademicInfo.university_id = 1
AND AlumniAcademicInfo.grad_type_id = AlumniGradType.type_id
AND AlumniJobInfo.alumni_id = AlumniAcademicInfo.alumni_id
AND AlumniAcademicInfo.faculty_id = UnitAcademic.academic_id
AND AlumniAcademicInfo.grad_type_id LIKE '%$graduated_type%'
AND AlumniAcademicInfo.faculty_id LIKE '%$graduated_faculty%'
AND AlumniAcademicInfo.department_id LIKE '%$graduated_department%'
AND Alumni.name LIKE '%$alumni_name%'
AND Alumni.surname LIKE '%$alumni_surname%'
OR AlumniAcademicInfo.grad_date BETWEEN '$start_date%' AND '$end_date%'
AND AlumniJobInfo.work_status LIKE '%$work_status%'
AND AlumniAcademicInfo.education_type LIKE '%$education_type%'

baştaki AND'i OR olarak değiştirdim. Bu sefer de work_status kısımlarını uygun şekilde getirmiyor