SQL errors

In requests:
http://example.org/crss/verb/9 AND http://example.org/crss/nodetype/blog

I get this SQL error:

user error: Column 'nid' in where clause is ambiguous
query: SELECT cid, n.nid, subject, c.comment, timestamp FROM comments c INNER JOIN node n ON c.nid = n.nid WHERE n.status = 1 AND c.status = 0 AND nid IN (230, 787, 965, 980, 1007, --cut--) ORDER BY timestamp DESC LIMIT 0, 15

The problem seems to be that both of comments and node tables has nid column. So it confuses mysql when having nid without being prefixed with table.

Attached a patch against latest CVS release to add missing prefixes.