MySQL QUERY ERROR(1064): 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 'ORDER BY userID, appID' at line 25 Query: SELECT sessionID, users.userID AS userID, users.name AS name, username, password, eduID, session_user.active AS userActive, session_user.in_use AS userInUse, apps.appID AS appID, apps.name AS appName, apps.access_level AS appAccessLevel, IFNULL(state, type) AS access, IFNULL(sign, '') AS sign, IFNULL(classes.classID, 0) AS classID FROM (apps, users) LEFT JOIN access ON users.userID = access.userID AND apps.appID = access.appID INNER JOIN session_user ON users.userID = session_user.userID LEFT JOIN student_class ON student_class.userID = users.userID LEFT JOIN classes ON student_class.classID = classes.classID AND classes.year = apps.year WHERE sessionID = ORDER BY userID, appID

Vissza a belépéshez