bd0dd070091799dd2d4b78c2279a1342d1b7c7ba
chinhli
  Wed Apr 9 12:15:19 2014 -0700
UCSC GB Track #11226Change the geneReviews tables of hg19 and hg18 to match NCBI.

diff --git src/hg/hgc/hgc.c src/hg/hgc/hgc.c
index 09af365..3020917 100644
--- src/hg/hgc/hgc.c
+++ src/hg/hgc/hgc.c
@@ -9914,31 +9914,31 @@
 	while ((row = sqlNextRow(sr)) != NULL)
 	    {
 	    if (printedCnt < 1)
 		printf("<B>Related UCSC Gene(s): </B>");
 	    else
 		printf(", ");
             printf("<A HREF=\"%s%s&hgg_chrom=none\">", "../cgi-bin/hgGene?hgg_gene=", row[0]);
             printf("%s</A></B>", row[0]);
 	    printedCnt++;
 	    }
         if (printedCnt >= 1) printf("<BR>\n");
 	}
     sqlFreeResult(&sr);
 
     // show GeneReviews  link(s)
-    if (sqlTableExists(conn, "geneReviewsRefGene"))
+    if (sqlTableExists(conn, "geneReviewsGeneGRshortNBKidGRtitle"))
         {
         sqlSafef(query, sizeof(query),
           "select distinct r.name2 from refLink l, omim2gene g, refGene r where l.omimId=%s and g.geneId=l.locusLinkId and g.entryType='gene' and chrom='%s' and txStart = %s and txEnd= %s",
         itemName, chrom, chromStart, chromEnd);
         sr = sqlMustGetResult(conn, query);
         if (sr != NULL)
             {
             while ((row = sqlNextRow(sr)) != NULL)
                 {
                 prGRShortRefGene(row[0]);
                 }
             }
         sqlFreeResult(&sr);
         }