Unknown column 'n.nid' in 'on clause' query

On my personal web site managed by drupal, I have the following error message on the home page:

user warning: Unknown column 'n.nid' in 'on clause' query: SELECT DISTINCT(n.nid), n.title, n.uid, n.changed, l.last_comment_timestamp, GREATEST(n.changed, l.last_comment_timestamp) AS last_change, l.comment_count FROM node n, node_comment_statistics l INNER JOIN node_access na ON na.nid = n.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all'))) AND ( n.nid = l.nid AND n.status = 1 AND n.type IN ('page', 'story') AND 1=1 ) ORDER BY last_change DESC LIMIT 0, 5 in /home/mirguetn/public_html/includes/database.mysql.inc on line 172.

I am running Drupal 5.2
This message occurs when I'm not logged to the site. Once I'm logged, the message disappears.

By looking at various forums, I have read that this error may be linked to MySQL5.
And indeed I'm using MySQL 5.0.27