change
PHP Code:
FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid =
user.userid) INNER JOIN language AS language ON (language.languageid
to :
PHP Code:
FROM ".TABLE_PREFIX."user AS user
LEFT JOIN ".TABLE_PREFIX."userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN ".TABLE_PREFIX."usertextfield AS usertextfield ON (usertextfield.userid =
user.userid) INNER JOIN ".TABLE_PREFIX."language AS language ON (language.languageid