Workbench ile sorguyu direkt olarak veritabanında deniyorum fakat boş bir sorgu ekranı ile karşılaşıyorum (echo ile aynı)
Senin tavsiyen ile yaptığım düzeltmeyle birlikte sorgunun tamamı bu şekilde.
SELECT
`name`,
`surname`,
`department_name`,
DATE_FORMAT(`grad_date`, '%d %b %Y') AS grad_date,
`grad_type_name`,
`firm_name`,
`email`,
`academic_name`,
`work_status`
FROM
mebis.Alumni,
mebis.UnitDepartment,
mebis.AlumniAcademicInfo,
mebis.AlumniGradType,
mebis.AlumniJobInfo,
mebis.UnitAcademic,
mebis.WorkStatus,
mebis.AlumniEducationType
WHERE
AlumniAcademicInfo.alumni_id = Alumni.alumni_id
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 AlumniJobInfo.work_status = WorkStatus.status_id
AND AlumniAcademicInfo.faculty_id = UnitAcademic.academic_id
AND AlumniAcademicInfo.education_type = AlumniEducationType.id
AND AlumniAcademicInfo.grad_type_id LIKE '%%'
AND AlumniAcademicInfo.faculty_id LIKE '%%'
AND AlumniAcademicInfo.department_id LIKE '%%'
AND Alumni.name LIKE '%%'
AND Alumni.surname LIKE '%%'
AND AlumniJobInfo.work_status LIKE '%%'
AND AlumniAcademicInfo.education_type LIKE '%%'
AND (AlumniAcademicInfo.grad_date >= '2017-12-12%' AND AlumniAcademicInfo.grad_date <= '%')
ORDER BY Alumni.alumni_id
Mesela bu sorguda 2017-12-12 tarihinden sonra mezun olmuş olan 4 kişinin gelmiş olması lazım yetkilibiri