diff options
| author | Dries Buytaert <dries@buytaert.net> | 2005-04-04 21:32:21 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2005-04-04 21:32:21 +0000 |
| commit | 398ed04670ca0419e8f04dc7da702ab88d012b89 (patch) | |
| tree | fff8d22c4f7df9ca919a33037fdb07850a58af6e | |
| parent | c7c33cc1747561c1f36569dbfe411b385cbb281b (diff) | |
| download | brdo-398ed04670ca0419e8f04dc7da702ab88d012b89.tar.gz brdo-398ed04670ca0419e8f04dc7da702ab88d012b89.tar.bz2 | |
- Patch #19960 by Gerhard: removed left-over DISTINCT. Spotted by BuddaBoy.
| -rw-r--r-- | modules/book.module | 2 | ||||
| -rw-r--r-- | modules/book/book.module | 2 |
2 files changed, 2 insertions, 2 deletions
diff --git a/modules/book.module b/modules/book.module index 576f8fd1a..16d2eec80 100644 --- a/modules/book.module +++ b/modules/book.module @@ -619,7 +619,7 @@ function book_render() { */ function book_print($nid = 0, $depth = 1) { global $base_url; - $result = db_query(db_rewrite_sql('SELECT DISTINCT(n.nid), n.title, b.weight FROM {node} n INNER JOIN {book} b ON n.nid = b.nid WHERE n.status = 1 AND n.nid = %d AND n.moderate = 0 ORDER BY b.weight, n.title'), $nid); + $result = db_query(db_rewrite_sql('SELECT n.nid, n.title, b.weight FROM {node} n INNER JOIN {book} b ON n.nid = b.nid WHERE n.status = 1 AND n.nid = %d AND n.moderate = 0 ORDER BY b.weight, n.title'), $nid); while ($page = db_fetch_object($result)) { // load the node: diff --git a/modules/book/book.module b/modules/book/book.module index 576f8fd1a..16d2eec80 100644 --- a/modules/book/book.module +++ b/modules/book/book.module @@ -619,7 +619,7 @@ function book_render() { */ function book_print($nid = 0, $depth = 1) { global $base_url; - $result = db_query(db_rewrite_sql('SELECT DISTINCT(n.nid), n.title, b.weight FROM {node} n INNER JOIN {book} b ON n.nid = b.nid WHERE n.status = 1 AND n.nid = %d AND n.moderate = 0 ORDER BY b.weight, n.title'), $nid); + $result = db_query(db_rewrite_sql('SELECT n.nid, n.title, b.weight FROM {node} n INNER JOIN {book} b ON n.nid = b.nid WHERE n.status = 1 AND n.nid = %d AND n.moderate = 0 ORDER BY b.weight, n.title'), $nid); while ($page = db_fetch_object($result)) { // load the node: |