Invalid SQL: SELECT departments.departmentid, departments.title, departments.departmentmodule, departments.departmenttype FROM `swdepartments` AS departments LEFT JOIN `swtgroupassigns` AS tgroupassigns ON (tgroupassigns.toassignid = departments.departmentid AND tgroupassigns.type = '1') LEFT JOIN `swgroupassigns` AS groupassigns ON (groupassigns.departmentid = departments.departmentid) LEFT JOIN `swstaffassigns` AS staffassigns ON (staffassigns.departmentid = departments.departmentid) WHERE tgroupassigns.tgroupid =  AND (staffassigns.staffid IN ('0') OR groupassigns.staffgroupid IN('0')) ORDER BY departments.displayorder ASC; (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 (staffassigns.staffid IN ('0') OR groupassigns.staffgroupid IN('0')) ORDER B' at line 1)Invalid SQL: SELECT departments.departmentid, departments.title, departments.departmentmodule, departments.departmenttype FROM `swdepartments` AS departments LEFT JOIN `swtgroupassigns` AS tgroupassigns ON (tgroupassigns.toassignid = departments.departmentid AND tgroupassigns.type = '1') WHERE tgroupassigns.tgroupid =  AND departments.departmentid NOT IN('0') AND departments.departmentmodule = 'livesupport' ORDER BY departments.displayorder ASC; (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 departments.departmentid NOT IN('0') AND departments.departmentmodule = 'liv' at line 1)