From 0575c3c0660c8256b4def1b8ff4b4d1b0773ecef Mon Sep 17 00:00:00 2001
From: zsloan
Date: Thu, 21 Sep 2023 18:59:51 +0000
Subject: Fix query in update_cross_reference

---
 gn3/db/phenotypes.py | 3 +--
 1 file changed, 1 insertion(+), 2 deletions(-)

(limited to 'gn3/db')

diff --git a/gn3/db/phenotypes.py b/gn3/db/phenotypes.py
index 6c6e61b..0339aba 100644
--- a/gn3/db/phenotypes.py
+++ b/gn3/db/phenotypes.py
@@ -188,8 +188,7 @@ def update_cross_reference(conn, dataset_id, trait_name, data:dict) -> int:
         cursor.execute(
             f"UPDATE PublishXRef SET {cols} WHERE "
             "Id=%(trait_name)s AND "
-            "InbredSetId="
-            "(SELECT InbredSetId FROM PublishFreeze WHERE Id=%(dataset_id)s)",
+            "InbredSetId=%(dataset_id)s",
             {
                 "dataset_id": dataset_id,
                 "trait_name": trait_name,
-- 
cgit v1.2.3