From: olivier larcheveque <olivier.larcheveque@u-ol.(none)>
Date: Mon, 4 Oct 2010 14:46:39 +0000 (-0400)
Subject: retourne dans les recherches les résultats qui nont pas de listset
X-Git-Url: http://git.auf.org/?p=auf_savoirs_en_partage_django.git;a=commitdiff_plain;h=44f15deea9ed590294972f71228eb0813949c058

retourne dans les recherches les résultats qui nont pas de listset
---

diff --git a/auf_savoirs_en_partage/savoirs/lib/sep.py b/auf_savoirs_en_partage/savoirs/lib/sep.py
index 56b5cc3..7a6aae3 100644
--- a/auf_savoirs_en_partage/savoirs/lib/sep.py
+++ b/auf_savoirs_en_partage/savoirs/lib/sep.py
@@ -152,11 +152,11 @@ class SEP:
 
         q = "SELECT r.id, (%s) AS score FROM savoirs_record AS r \
              LEFT JOIN savoirs_record_listsets AS rl ON r.id = rl.record_id \
-             JOIN savoirs_listset AS l ON rl.listset_id = l.spec \
+             LEFT JOIN savoirs_listset AS l ON rl.listset_id = l.spec \
              WHERE (%s) AND r.validated = 1 AND l.validated = 1 \
              GROUP BY r.id \
              HAVING score > 0 ORDER BY score DESC" % (m, m)
-
+        print q
         from django.db import connection, transaction
         cursor = connection.cursor()
         cursor.execute(q)