From 78c8b6690565ccc569116cdfa41433d920ade089 Mon Sep 17 00:00:00 2001
From: tipaul <tipaul>
Date: Fri, 8 Aug 2003 15:25:27 +0000
Subject: [PATCH] fix for 570 : If a subject search is done from the OPAC or
 Intranet Catalogue, duplicate results are returned.  For instance, if a
 search for 'dogs' returns 25 results that have the subject 'dogs,' there will
 be 25 duplicate listings in the results.

---
 C4/Search.pm | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/C4/Search.pm b/C4/Search.pm
index 4b59910b58..bfa1583cb3 100755
--- a/C4/Search.pm
+++ b/C4/Search.pm
@@ -1077,7 +1077,7 @@ like '%($key[0])%')";		while ($i<$count){			$query.=" and (subject like
 		}
 	} else {
 		if ($type eq 'subject'){
-			$query .= " order by subject";
+			$query .= "group by subject order by subject ";
 		}
 	}
 	my $sth=$dbh->prepare($query);
-- 
2.39.5