--- branches/mysql/trunk/Portal.pm	2004/03/07 22:07:47	12
+++ branches/mysql/trunk/Portal.pm	2004/03/28 21:13:20	13
@@ -330,6 +330,7 @@
 	}
 
 	$sql .= qq{
+		group by subject.subject_id
 		order by subject.subject
 	};