Index: /trunk/ippTools/share/camtool_find_chip_id.sql
===================================================================
--- /trunk/ippTools/share/camtool_find_chip_id.sql	(revision 14030)
+++ /trunk/ippTools/share/camtool_find_chip_id.sql	(revision 14031)
@@ -8,6 +8,4 @@
         chipRun.*
     FROM chipRun
-    JOIN chipProcessedExp
-        USING(chip_id)
     WHERE
         chipRun.state = 'stop') as Foo
Index: /trunk/ippTools/share/camtool_find_processedexp.sql
===================================================================
--- /trunk/ippTools/share/camtool_find_processedexp.sql	(revision 14030)
+++ /trunk/ippTools/share/camtool_find_processedexp.sql	(revision 14031)
@@ -1,3 +1,3 @@
-SELECT
+SELECT DISTINCT
     camProcessedExp.*,
     rawExp.exp_tag,
@@ -7,8 +7,10 @@
     rawExp.filelevel
 FROM camProcessedExp
-JOIN chipProcessedExp
+JOIN chipRun
+    USING(chip_id)
+JOIN chipProcessedImfile
     USING(chip_id)
 JOIN rawExp
-    ON chipProcessedExp.exp_id = rawExp.exp_id
+    ON chipProcessedImfile.exp_id = rawExp.exp_id
 WHERE -- bogus condition so there is a pre-existing where to append to
     camProcessedExp.cam_id IS NOT NULL
Index: /trunk/ippTools/share/chiptool_processedimfile.sql
===================================================================
--- /trunk/ippTools/share/chiptool_processedimfile.sql	(revision 14030)
+++ /trunk/ippTools/share/chiptool_processedimfile.sql	(revision 14031)
@@ -1,4 +1,3 @@
-SELECT
-    chipProcessedExp.*,
+SELECT DISTINCT
     chipProcessedImfile.class_id,
     chipProcessedImfile.uri,
@@ -12,9 +11,9 @@
     rawExp.telescope,
     rawExp.filelevel
-FROM chipProcessedImfile
-JOIN chipProcessedExp
+FROM chipRun
+JOIN chipProcessedImfile
     USING(chip_id)
 JOIN rawExp
-    ON chipProcessedExp.exp_id = rawExp.exp_id
+    ON chipProcesseImfile.exp_id = rawExp.exp_id
 WHERE
 -- bogus test; just here so there there is a 'WHERE' stmt to append conditionals too
Index: /trunk/ippTools/share/difftool_inputskyfile.sql
===================================================================
--- /trunk/ippTools/share/difftool_inputskyfile.sql	(revision 14030)
+++ /trunk/ippTools/share/difftool_inputskyfile.sql	(revision 14031)
@@ -1,3 +1,3 @@
-SELECT
+SELECT DISTINCT
     warpSkyfile.*,
     diffInputSkyfile.template,
@@ -14,8 +14,10 @@
 JOIN camProcessedExp
     ON warpInputExp.cam_id = camProcessedExp.cam_id
-JOIN chipProcessedExp
-    ON camProcessedExp.chip_id = chipProcessedExp.chip_id
+JOIN chipRun
+    ON camProcessedExp.chip_id = chipRun.chip_id
+JOIN chipProcessedImfile
+    ON chipRun.chip_id = chipProcessedImfile.chip_id
 JOIN rawExp
-    ON chipProcessedExp.exp_id = rawExp.exp_id
+    ON chipProcessedImfile.exp_id = rawExp.exp_id
 WHERE
     diffRun.state = 'run'
Index: /trunk/ippTools/share/stacktool_inputskyfile.sql
===================================================================
--- /trunk/ippTools/share/stacktool_inputskyfile.sql	(revision 14030)
+++ /trunk/ippTools/share/stacktool_inputskyfile.sql	(revision 14031)
@@ -1,3 +1,3 @@
- SELECT
+SELECT DISTINCT
     warpSkyfile.*,
     rawExp.camera
@@ -13,8 +13,10 @@
 JOIN camProcessedExp
     ON warpInputExp.cam_id = camProcessedExp.cam_id
-JOIN chipProcessedExp
-    ON camProcessedExp.chip_id = chipProcessedExp.chip_id
+JOIN chipRun
+    ON camProcessedExp.chip_id = chipRun.chip_id
+JOIN chipProcessedImfile
+    ON chipRun.chip_id = chipProcessedImfile.chip_id
 JOIN rawExp
-    ON chipProcessedExp.exp_id = rawExp.exp_id
+    ON chipProcessedImfile.exp_id = rawExp.exp_id
 WHERE
     stackRun.state = 'run'