[The Realist]

Im getting the following. Done all as above, error is:

Invalid SQL:
SELECT
userfield.field5, usergroup.title, user.username, user.userid, user.invisible, user.receivepm,
user.usergroupid, user.lastactivity, user.lastvisit, userfield.field6, userfield.field
FROM usergroup
LEFT JOIN user ON (usergroup.usergroupid = user.usergroupid)
LEFT JOIN userfield ON (userfield.userid = user.userid)
WHERE usergroup.showgroup = 1 AND usergroup.usergroupid = 10

mysql error: Unknown column 'userfield.field5' in 'field list'

mysql error number: 1054

Anyone?

Running 2.2.4