SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokensSELECT u.id AS id, u.name AS name, u.username AS user_username, u.school AS user_school, u.class AS class, u.age, u.sex, u.student_number FROM users u WHERE u.school = :school AND u.school_year = (SELECT value FROM settings WHERE code = 'current_school_year') AND u.id NOT IN ( SELECT user_id FROM users u2, role_user ru2, roles r2 WHERE u2.id = ru2.user_id AND r2.code IN (:teacherCode0, :teacherCode1) AND ru2.role_id = r2.id AND u2.school = u.school AND u2.class = u.class ) ORDER BY RIGHT(CONCAT('0', u.student_number), 2)
CMS
