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 'as u, userfield as f WHERE u.userid = f.userid AND ' at line 2

File: users.class.php
Line Number: 317
Query:
SELECT u.userid FROM as u, userfield as f WHERE u.userid = f.userid AND lower(f.field8) = 'shannon26'