Index: trunk/ippTools/src/dettool.c
===================================================================
--- trunk/ippTools/src/dettool.c	(revision 8311)
+++ trunk/ippTools/src/dettool.c	(revision 8330)
@@ -748,8 +748,23 @@
     PS_ASSERT_PTR_NON_NULL(config, false);
 
+    // select det_id, det_type & rawImfile *
+    // get det_id from detInputExp.det_id
+    // get det_type from detRun.position
+    // det_id is not in detProccessedImfile
+    // exp_id is not in detProccessedImfile
+    // class_is is not in detProccessedImfile
     psString query = psStringCopy(
             "SELECT detInputExp.det_id, detRun.det_type, rawImfile.*"
-            " FROM rawImfile JOIN detInputExp USING(exp_id) "
-            " JOIN detRun ON detInputExp.det_id = detRun.position"); 
+            " FROM rawImfile"
+            " LEFT JOIN detInputExp USING(exp_id) "
+            " LEFT JOIN detRun ON detInputExp.det_id = detRun.position"
+            " LEFT JOIN detProcessedImfile"
+                " ON detInputExp.det_id = detProcessedImfile.det_id"
+                " AND rawImfile.exp_id = detProcessedImfile.exp_id"
+                " AND rawImfile.class_id = detProcessedImfile.class_id"
+            " WHERE detProcessedImfile.det_id IS NULL AND"
+            " detProcessedImfile.exp_id IS NULL AND"
+            " detProcessedImfile.class_id IS NULL"
+        ); 
 
     // XXX search criterian are disabled