WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND course.is_deleted!=1' at line 39]
SELECT DISTINCT(course.id) AS course_id, UPPER(course.name) AS course_name, course.course_slug AS course_slug, course.code AS code, course.intake AS intake, course.language AS language, course.campus AS campus, course.cost AS study_cost, CONCAT('RM ',course.cost) AS cost, course.description AS description, UPPER(city.name) AS city_name, city.id AS city_id, study_duration.name AS duration, study_mode.name AS mode, study_attendance.name AS attendance, university.id AS university_id, university.name AS university_name, university.university_slug AS university_slug, media2.name AS university_media_name, faculty.name AS faculty_name, faculty.id AS faculty_id, UPPER(city.name) AS city_name, media.name AS faculty_media_name, UPPER(country.name) AS country_name, LOWER(country.iso) AS iso, cat.category FROM ukes_course AS course LEFT JOIN ukes_faculty AS faculty on faculty.id=course.faculty_id LEFT JOIN ukes_university AS university on university.id=course.university_id LEFT JOIN ukes_city AS city on city.id=university.city_id LEFT JOIN ukes_country AS country on country.id=city.country_id LEFT JOIN ukes_study_duration AS study_duration ON study_duration.id=course.study_duration_id LEFT JOIN ukes_study_mode AS study_mode ON study_mode.id= course.study_mode_id LEFT JOIN ukes_study_attendance AS study_attendance ON study_attendance.id=course.study_attendance_id LEFT JOIN ukes_media AS media ON media.id=faculty.media_id LEFT JOIN ukes_media AS media2 ON media2.id=university.media_id LEFT JOIN ukes_course_category AS cat ON cat.id=course.course_category_id WHERE faculty.id= AND course.is_deleted!=1