Index: trunk/ippTools/share/detselect_search.sql
===================================================================
--- trunk/ippTools/share/detselect_search.sql	(revision 14269)
+++ trunk/ippTools/share/detselect_search.sql	(revision 14271)
@@ -1,11 +1,28 @@
 SELECT DISTINCT
-    detRunSummary.det_id,
-    detRunSummary.iteration,
-    detRun.filelevel
-FROM detRun
-JOIN detRunSummary
-    USING(det_id)
-WHERE
-   detRun.state = 'stop'
-   AND detRun.mode  = 'master'
-   AND detRunSummary.accept = 1
+    det_id,
+    iteration,
+    filelevel
+FROM
+    (SELECT DISTINCT
+        detRun.det_id,
+        detRun.iteration,
+        detRun.filelevel,
+        detRun.registered
+    FROM detRun
+    JOIN detRunSummary
+        USING(det_id)
+    WHERE
+       detRun.state = 'stop'
+       AND detRun.mode  = 'master'
+       AND detRunSummary.accept = 1
+    UNION
+    SELECT DISTINCT
+        detRun.det_id,
+        detRun.iteration,
+        detRun.filelevel,
+        detRun.registered
+    FROM detRun
+    WHERE
+       detRun.state = 'stop'
+       AND detRun.mode  = 'register'
+    ) as Foo
Index: trunk/ippTools/share/detselect_select.sql
===================================================================
--- trunk/ippTools/share/detselect_select.sql	(revision 14269)
+++ 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