Index: trunk/ippTools/share/addtool_find_sky_id.sql
===================================================================
--- trunk/ippTools/share/addtool_find_sky_id.sql	(revision 31511)
+++ trunk/ippTools/share/addtool_find_sky_id.sql	(revision 31596)
@@ -3,6 +3,6 @@
 FROM 
      staticskyResult
-join staticSkyRun using (sky_id)
-join staticSkyInput using (stack_id)
+join staticskyRun using (sky_id)
+join staticskyInput using(sky_id)
 JOIN stackRun USING(stack_id)
 
@@ -13,5 +13,5 @@
           ) as foo
      ON sky_id = added_sky_id 
-     AND stage = 'sky'
+     AND stage = 'staticsky'
      -- hook for qualifying the join on the previous_dvodb
      AND %s
Index: trunk/ippTools/share/addtool_find_sky_id_dvo.sql
===================================================================
--- trunk/ippTools/share/addtool_find_sky_id_dvo.sql	(revision 31511)
+++ trunk/ippTools/share/addtool_find_sky_id_dvo.sql	(revision 31596)
@@ -1,4 +1,7 @@
 SELECT staticskyRun.* FROM staticskyResult
 JOIN staticskyRun USING(sky_id)
+join staticskyInput using(sky_id)
+JOIN stackRun USING(stack_id)
+
 WHERE staticskyRun.state = 'full' and staticskyResult.quality = 0
     AND sky_id NOT IN (SELECT sky_id