AND AlumniAcademicInfo.department_id = UnitDepartment.department_id
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%'

AND AlumniAcademicInfo.grad_date IS NOT NULL AND AlumniAcademicInfo.grad_date BETWEEN '2018-01-01' AND '2018-01-10'

AND AlumniJobInfo.work_status LIKE '%$work_status%'
AND AlumniAcademicInfo.education_type LIKE '%$education_type%'


Bu şekilde çalışması lazım tarih alanını düzenleyebilirsiniz. Eğer anydesk bağlantı verirseniz kontrol edebiliriz. Diğer alanlar yüzünden bir çakışma olabilir sql ne hata döndürüyor görmemiz lazım