[MrD]

Hi,
i become an error if the Cronjob works.

Invalid SQL:

SELECT user.*,
userban.usergroupid AS banusergroupid, userban.displaygroupid AS bandisplaygroupid, userban.customtitle AS bancustomtitle, userban.usertitle AS banusertitle
FROM userban AS userban
LEFT JOIN userban_manage AS userban_manage ON(userban_manage.userid = userban.userid)
INNER JOIN user AS user USING(userid)
WHERE userban.bandate < 1193958065;

MySQL Error : Column 'userid' in from clause is ambiguous Error Number : 1052
Date : Friday, November 9th 2007 @ 12:01:05 AM

Any Ideas what the error is?