diff options
| author | Silvio <silvio@socioambiental.org> | 2013-11-19 15:15:02 -0200 |
|---|---|---|
| committer | Silvio <silvio@socioambiental.org> | 2013-11-19 15:15:02 -0200 |
| commit | 85a52429aebe041a135e4cad9bc02a4b80c0a1b1 (patch) | |
| tree | 75bdef4f94c034de22c129099d8150ff6c524cc7 | |
| parent | 3855999ca9a5d475fbbb076989dc225d7475d8c2 (diff) | |
| download | jquery_drawer-85a52429aebe041a135e4cad9bc02a4b80c0a1b1.tar.gz jquery_drawer-85a52429aebe041a135e4cad9bc02a4b80c0a1b1.tar.bz2 | |
Filter out node revisions by selecting distinct entries
| -rw-r--r-- | jquery_drawer.module | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/jquery_drawer.module b/jquery_drawer.module index 5218ae7..a54679d 100644 --- a/jquery_drawer.module +++ b/jquery_drawer.module @@ -177,7 +177,7 @@ function jquery_drawer_page($tid = NULL) { if (isset($filter) && !empty($filter)) { // Then render all nodes whose terms are children of $term - $query = 'SELECT n.nid, n.title, term_node.tid FROM {node} n LEFT JOIN + $query = 'SELECT DISTINCT n.nid, n.title, term_node.tid FROM {node} n LEFT JOIN {term_node} ON term_node.nid = n.nid WHERE term_node.tid IN (%s) AND n.status = "1" ORDER BY term_node.weight_in_tid ASC'; |