From d0d996f4d963de9e033b622a1e51385cb1be0886 Mon Sep 17 00:00:00 2001
From: zsloan
Date: Mon, 7 Aug 2023 20:23:25 +0000
Subject: Fix query for retrieving mrna dataset group name

---
 gn3/db/datasets.py | 10 +++++-----
 1 file changed, 5 insertions(+), 5 deletions(-)

diff --git a/gn3/db/datasets.py b/gn3/db/datasets.py
index 38819db..0c0fab4 100644
--- a/gn3/db/datasets.py
+++ b/gn3/db/datasets.py
@@ -44,11 +44,11 @@ def retrieve_mrna_group_name(connection: Any, probeset_id: int):
     of the group the dataset belongs to.
     """
     query = (
-        "SELECT is.Name "
-        "FROM ProbeSet ps LEFT JOIN ProbeSetXRef psx ON px.ProbeSetId = ps.Id "
-        "INNER JOIN ProbeSetFreeze psf ON psx.ProbeSetFreezeId = psf.Id "
-        "INNER JOIN ProbeFreeze pf ON psf.ProbeFreezeId = ProbeFreeze.Id "
-        "INNER JOIN InbredSet is ON pf.InbredSetId = is.Id "
+        "SELECT iset.Name "
+        "FROM ProbeSet ps LEFT JOIN ProbeSetXRef psx ON psx.ProbeSetId = ps.Id "
+        "LEFT JOIN ProbeSetFreeze psf ON psx.ProbeSetFreezeId = psf.Id "
+        "LEFT JOIN ProbeFreeze pf ON psf.ProbeFreezeId = pf.Id "
+        "LEFT JOIN InbredSet iset ON pf.InbredSetId = iset.Id "
         "WHERE ps.Id = %(probeset_id)s")
     with connection.cursor() as cursor:
         cursor.execute(query, {"probeset_id": probeset_id})
-- 
cgit 1.4.1