diff options
| author | Dries Buytaert <dries@buytaert.net> | 2005-05-14 17:01:31 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2005-05-14 17:01:31 +0000 |
| commit | dbd806c41a8239d700d29cdd7d85d593bd9fe20a (patch) | |
| tree | 4ae99ff8c5890f7c90d67c1a0e20548bc2832a1f /modules | |
| parent | 139ef4027ceae2691eb9c5cc2e1f21df44caa145 (diff) | |
| download | brdo-dbd806c41a8239d700d29cdd7d85d593bd9fe20a.tar.gz brdo-dbd806c41a8239d700d29cdd7d85d593bd9fe20a.tar.bz2 | |
- Patch #22857 by mathias: removed redundant DISTINCT().
Diffstat (limited to 'modules')
| -rw-r--r-- | modules/tracker.module | 2 | ||||
| -rw-r--r-- | modules/tracker/tracker.module | 2 |
2 files changed, 2 insertions, 2 deletions
diff --git a/modules/tracker.module b/modules/tracker.module index f84dfa913..15c32e500 100644 --- a/modules/tracker.module +++ b/modules/tracker.module @@ -82,7 +82,7 @@ function tracker_page($uid = 0) { else { $sql = 'SELECT DISTINCT(n.nid), n.title, n.type, n.changed, n.uid, u.name, l.last_comment_timestamp AS last_post, l.comment_count FROM {node} n INNER JOIN {users} u ON n.uid = u.uid INNER JOIN {node_comment_statistics} l ON n.nid = l.nid WHERE n.status = 1 ORDER BY last_post DESC'; $sql = db_rewrite_sql($sql); - $sql_count = 'SELECT COUNT(DISTINCT(n.nid)) FROM {node} n WHERE n.status = 1'; + $sql_count = 'SELECT COUNT(n.nid) FROM {node} n WHERE n.status = 1'; $sql_count = db_rewrite_sql($sql_count); $result = pager_query($sql, 25, 0, $sql_count); } diff --git a/modules/tracker/tracker.module b/modules/tracker/tracker.module index f84dfa913..15c32e500 100644 --- a/modules/tracker/tracker.module +++ b/modules/tracker/tracker.module @@ -82,7 +82,7 @@ function tracker_page($uid = 0) { else { $sql = 'SELECT DISTINCT(n.nid), n.title, n.type, n.changed, n.uid, u.name, l.last_comment_timestamp AS last_post, l.comment_count FROM {node} n INNER JOIN {users} u ON n.uid = u.uid INNER JOIN {node_comment_statistics} l ON n.nid = l.nid WHERE n.status = 1 ORDER BY last_post DESC'; $sql = db_rewrite_sql($sql); - $sql_count = 'SELECT COUNT(DISTINCT(n.nid)) FROM {node} n WHERE n.status = 1'; + $sql_count = 'SELECT COUNT(n.nid) FROM {node} n WHERE n.status = 1'; $sql_count = db_rewrite_sql($sql_count); $result = pager_query($sql, 25, 0, $sql_count); } |