[heugabel]

this works without sql error.

the query has 2 same joins.

SELECT forum.forumid, forum.lastpost, CONCAT(usergroup.opentag, forum.lastposter, usergroup.closetag) AS lastposter, forum.lastposterid, forum.lastthread, forum.lastthreadid, forum.lasticonid, forum.threadcount, forum.replycount, forum.lastpostid, forum.lastprefixid, user.usergroupid, user.homepage, user.options AS useroptions, IF(userlist.friend = 'yes', 1, 0) AS isfriend

FROM forum AS forum

LEFT JOIN user AS user ON (user.userid = forum.lastposterid)
LEFT JOIN userlist AS userlist ON (userlist.relationid = user.userid AND userlist.type = 'buddy' AND userlist.userid = 1)
LEFT JOIN user AS user ON (forum.lastposterid = user.userid) LEFT JOIN usergroup AS usergroup ON (user.usergroupid = usergroup.usergroupid);