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 f.field8 != '' ' at line 2

File: users.class.php
Line Number: 211
Query:
SELECT f.userid, f.field8, f.field14 FROM as u, userfield as f WHERE u.userid = f.userid AND f.field8 != '' AND f.field14 > 0 ORDER BY f.field14 DESC