The query on the node revisions table does not use db-prefix

And shouldn't db_query_range be used for limit queries?

In template.php

37 $sql="SELECT node.nid AS nid,
38 node.title AS node_title,
39 node_revisions.body AS node_revisions_body,
40 node_revisions.format AS node_revisions_format,
41 node.created AS node_created
42 FROM {node}
43 LEFT JOIN {node_revisions} node_revisions ON node.vid = node_revisions.vid
44 ORDER BY node_created DESC ";

42 FROM {node}

should be

42 FROM {node} node

Else you get "node.nid unknown" errors.