Fix query for retrieving mrna dataset group name

1 files 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})