Index: trunk/ippTools/share/detselect_select.sql
===================================================================
--- trunk/ippTools/share/detselect_select.sql	(revision 12259)
+++ trunk/ippTools/share/detselect_select.sql	(revision 14271)
@@ -1,12 +1,25 @@
 SELECT DISTINCT
-    detNormalizedImfile.*
-FROM detNormalizedImfile
-JOIN detRun
-    USING(det_id)
-JOIN detRunSummary
-    ON detNormalizedImfile.det_id = detRunSummary.det_id
-    AND detNormalizedImfile.iteration = detRunSummary.iteration
-WHERE
-    detRun.state = 'stop'
-    AND detRun.mode  = 'master'
-    AND detRunSummary.accept = 1
+    *
+FROM
+    (SELECT DISTINCT
+        detNormalizedImfile.*
+    FROM detNormalizedImfile
+    JOIN detRun
+        USING(det_id)
+    JOIN detRunSummary
+        ON detNormalizedImfile.det_id = detRunSummary.det_id
+        AND detNormalizedImfile.iteration = detRunSummary.iteration
+    WHERE
+        detRun.state = 'stop'
+        AND detRun.mode  = 'master'
+        AND detRunSummary.accept = 1
+    UNION
+    SELECT DISTINCT
+        detRegisteredImfile.*
+    FROM detRegisteredImfile
+    JOIN detRun
+        USING(det_id)
+    WHERE
+        detRun.state = 'stop'
+        AND detRun.mode  = 'register'
+    ) as Foo