(more) db prefix abstraction issues

queries of the form:
db_query('Select node.title from {node}');
will fail on prefixed dbs because 'node.title' is not a valid table.column. They should always be in the form
db_query('Select n.title from {node} AS n');