diff options
| author | Steven Wittens <steven@10.no-reply.drupal.org> | 2005-02-28 18:00:59 +0000 |
|---|---|---|
| committer | Steven Wittens <steven@10.no-reply.drupal.org> | 2005-02-28 18:00:59 +0000 |
| commit | ff386b90bbee1abcf9e6cf38a9571e65f5e6a8b8 (patch) | |
| tree | 592832e68e3c2d24c8e7634f847c033896cfc03d /modules/node/node.module | |
| parent | a203f728bd012a101448633f29e35d16e820575d (diff) | |
| download | brdo-ff386b90bbee1abcf9e6cf38a9571e65f5e6a8b8.tar.gz brdo-ff386b90bbee1abcf9e6cf38a9571e65f5e6a8b8.tar.bz2 | |
#17747: PGSQL improvements
Diffstat (limited to 'modules/node/node.module')
| -rw-r--r-- | modules/node/node.module | 2 |
1 files changed, 1 insertions, 1 deletions
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(); |