Index: trunk/ippTools/src/dettool.c
===================================================================
--- trunk/ippTools/src/dettool.c	(revision 9087)
+++ trunk/ippTools/src/dettool.c	(revision 9089)
@@ -1064,8 +1064,7 @@
     // det_id is not in detProcessedExp;
     // iteration is not in detProcessedExp;
-    // class_id is not in detProcessedExp;
 
     psString query = psStringCopy(
-        " SELECT"
+        " SELECT DISTINCT"
         "    detProcessedImfile.det_id,"
         "    detRun.iteration,"
@@ -1188,14 +1187,14 @@
         " JOIN rawDetrendExp"
         "    ON detInputExp.exp_tag = rawDetrendExp.exp_tag"
-        " JOIN detProcessedImfile"
+        " JOIN rawImfile"
+        "    ON detInputExp.exp_tag = rawImfile.exp_tag"
+        " LEFT JOIN detProcessedImfile"
         "    ON detInputExp.det_id = detProcessedImfile.det_id"
         "    AND detInputExp.exp_tag = detProcessedImfile.exp_tag"
+        "    AND detProcessedImfile.class_id = rawImfile.class_id"
         " LEFT JOIN detStackedImfile"
         "    ON detInputExp.det_id = detStackedImfile.det_id"
         "    AND detInputExp.iteration = detStackedImfile.iteration"
         "    AND detProcessedImfile.class_id = detStackedImfile.class_id"
-        " LEFT JOIN rawImfile"
-        "    ON detInputExp.exp_tag = rawImfile.exp_tag"
-        "    AND detProcessedImfile.class_id = rawImfile.class_id"
         " WHERE"
         "    detStackedImfile.det_id IS NULL"
@@ -1204,5 +1203,4 @@
         "    AND detInputExp.include = 1"
         " GROUP BY"
-        "    detProcessedImfile.class_id,"
         "    rawImfile.class_id"
         " HAVING"