From 85a52429aebe041a135e4cad9bc02a4b80c0a1b1 Mon Sep 17 00:00:00 2001 From: Silvio Date: Tue, 19 Nov 2013 15:15:02 -0200 Subject: Filter out node revisions by selecting distinct entries --- jquery_drawer.module | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) 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'; -- cgit v1.2.3