From 44f15deea9ed590294972f71228eb0813949c058 Mon Sep 17 00:00:00 2001 From: olivier larcheveque Date: Mon, 4 Oct 2010 10:46:39 -0400 Subject: [PATCH] =?utf8?q?retourne=20dans=20les=20recherches=20les=20r=C3=A9?= =?utf8?q?sultats=20qui=20nont=20pas=20de=20listset?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- auf_savoirs_en_partage/savoirs/lib/sep.py | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) 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) -- 1.7.10.4