pagination for site user list :warnings for sql syntax

i can following warnings after changing "db_query" for the main display query to "db_rewrite_sql", when logged in as authenticated user, works fine when looged as site admin. can neone help??

user warning: 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 'node as n LEFT OUTER JOIN profile_values as t_1 on (u.uid = t_1. query: SELECT COUNT(*) as numrows FROM (SELECT DISTINCT u.uid as `@uid`, t_1.value as `@profile_goanfrom`, t_3.value as `@profile_herefor`, t_2.value as `@profile_currently`, t_13.value as `@profile_gender` FROM users as u node as n LEFT OUTER JOIN profile_values as t_1 on (u.uid = t_1.uid and t_1.fid = 1) LEFT OUTER JOIN profile_values as t_3 on (u.uid = t_3.uid and t_3.fid = 3) LEFT OUTER JOIN profile_values as t_2 on (u.uid = t_2.uid and t_2.fid = 2) LEFT OUTER JOIN profile_values as t_13 on (u.uid = t_13.uid and t_13.fid = 13) WHERE ((n.moderate != 1 OR n.uid = 38)) AND ( (u.uid != 0) AND (u.status = 1)) as cd1 ) in /home/httpd/vhosts/goatalking.com/httpdocs/includes/database.mysql.inc on line 172.
user warning: 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 'node as n LEFT OUTER JOIN profile_values as t_1 on (u.uid = t_1. query: SELECT DISTINCT `@uid`, `@profile_goanfrom`, `@profile_herefor`, `@profile_currently`, `@profile_gender` FROM (SELECT DISTINCT u.uid as `@uid`, t_1.value as `@profile_goanfrom`, t_3.value as `@profile_herefor`, t_2.value as `@profile_currently`, t_13.value as `@profile_gender` FROM users as u node as n LEFT OUTER JOIN profile_values as t_1 on (u.uid = t_1.uid and t_1.fid = 1) LEFT OUTER JOIN profile_values as t_3 on (u.uid = t_3.uid and t_3.fid = 3) LEFT OUTER JOIN profile_values as t_2 on (u.uid = t_2.uid and t_2.fid = 2) LEFT OUTER JOIN profile_values as t_13 on (u.uid = t_13.uid and t_13.fid = 13) WHERE ((n.moderate != 1 OR n.uid = 38)) AND ( (u.uid != 0) AND (u.status = 1)) as cd ) ORDER BY `@profile_goanfrom` ASC LIMIT 0, 10 in /home/httpd/vhosts/goatalking.com/httpdocs/includes/database.mysql.inc on line 172.