From ff386b90bbee1abcf9e6cf38a9571e65f5e6a8b8 Mon Sep 17 00:00:00 2001 From: Steven Wittens Date: Mon, 28 Feb 2005 18:00:59 +0000 Subject: #17747: PGSQL improvements --- modules/node/node.module | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'modules/node/node.module') diff --git a/modules/node/node.module b/modules/node/node.module index 6deb1d2d3..bc0f77105 100644 --- a/modules/node/node.module +++ b/modules/node/node.module @@ -582,7 +582,7 @@ function node_search($op = 'search', $keys = null) { case 'status': $last = variable_get('node_cron_last', 0); $total = db_result(db_query('SELECT COUNT(*) FROM {node} WHERE status = 1 AND moderate = 0')); - $remaining = db_result(db_query('SELECT COUNT(*) FROM {node} n LEFT JOIN {node_comment_statistics} c ON n.nid = c.nid WHERE n.status = 1 AND n.moderate = 0 AND (n.created > %d OR n.changed > %d OR c.last_comment_timestamp > %d) ORDER BY GREATEST(n.created, n.changed, c.last_comment_timestamp) ASC', $last, $last, $last)); + $remaining = db_result(db_query('SELECT COUNT(*) FROM {node} n LEFT JOIN {node_comment_statistics} c ON n.nid = c.nid WHERE n.status = 1 AND n.moderate = 0 AND (n.created > %d OR n.changed > %d OR c.last_comment_timestamp > %d)', $last, $last, $last)); return array('remaining' => $remaining, 'total' => $total); case 'search': list($join, $where) = _db_rewrite_sql(); -- cgit v1.2.3