1c4a6e31cf19dab85ee7da573e5d20dd3af00a09
hiram
  Fri Feb 3 14:35:53 2012 -0800
checking in Fan's branch for the rgdGene2 update
diff --git src/hg/hgGene/pathways.c src/hg/hgGene/pathways.c
index 28e3f2a..11a3669 100644
--- src/hg/hgGene/pathways.c
+++ src/hg/hgGene/pathways.c
@@ -25,31 +25,31 @@
     void (*printLinks)(struct pathwayLink *pl, 
     	struct sqlConnection *conn, char *geneId);
     /* Print out links. */
     };
 
 static void keggLink(struct pathwayLink *pl, struct sqlConnection *conn, 
 	char *geneId)
 /* Print out kegg database link. */
 {
 char query[512], **row;
 struct sqlResult *sr;
 
 if (isRgdGene(conn))
 {
 safef(query, sizeof(query), 
-	"select k.locusID, k.mapID, keggMapDesc.description"
+	"select distinct k.locusID, k.mapID, keggMapDesc.description"
 	" from rgdGene2KeggPathway k, keggMapDesc, rgdGene2 x"
 	" where k.rgdId=x.name "
 	" and x.name='%s'"
 	" and k.mapID = keggMapDesc.mapID"
 	, geneId);
 }
 else
 {
 safef(query, sizeof(query), 
 	"select k.locusID, k.mapID, keggMapDesc.description"
 	" from keggPathway k, keggMapDesc, kgXref x"
 	" where k.kgID=x.kgId "
 	" and x.kgID='%s'"
 	" and k.mapID = keggMapDesc.mapID"
 	, geneId);