#2 SQL Error on "employee" page

[Anonymous]

Going to the "employee" page as a manager, I get always
this error:

Can't execute statement: Unknown column 'm.maxweek' in
'on clause'

Select w.userid, w.timebank, t.week
From maxweek_view m, weeks w LEFT OUTER
JOIN timebank t ON ( (t.year100+t.week) = m.maxweek
AND t.userid = w.userid)
Where (m.userid = w.userid) And m.maxweek
= (w.year100+w.week)

Using Rodeo 1.0 with MySQL 5.0.24 and perl 5.8.8 on
Debian etch.

Regards, Adrian.