SQL query results if else

SELECT
s.time AS TIME
‘tts AS sugesstWall
r.region_name ‘complaints, AS courseName,
c.center_name AS centerName
cr.class_name AS className
tscc.course_name, AS courseName,
stu.true_name AS studentName
stu.phone, AS studentPhone,
CASE s.flag
WHEN 0 THEN WHEN 1 THEN’
‘complaint’ recommended ‘
ELSE’ praise ‘
END AS flag
st.type_name AS type_name
s.obj_name, AS obj_name,
dep.dept_name AS deptName
tel.name, AS titleName,
s.content AS content
FROM
suggest s
LEFT JOIN center C ON c.center _id = s.center_id
LEFT JOIN city ON city.city_id=c.city_id
LEFT JOIN region R ON city.region_id=r.region_id
LEFT JOIN suggest_type St ON st.type_id
LEFT JOIN student = s.suggest_type stu ON s.student_id= stu.student_id
LEFT JOIN classroom Cr ON stu.class_id=cr.class_id
LEFT JOIN series_class SC ON sc.series_class_id cr.series_class_id
LEFT JOIN tsc_course TSCC = ON sc.course_id = tscc.course_id
LEFT JOIN employee e ON e.employee_id=s.obj_id
LEFT JOIN dept dep ON e.dept_id=dep.dept_id
LEFT JOIN Title Tel ON tel.title_id=e.title_id
WHERE 1=1
AND s.time > 00:00:00’wpap60 =’2016-09-01 3001br, AND, s.time, <‘2016-10-01 00:00:00’