Index: trunk/ippTools/share/Makefile.am
===================================================================
--- trunk/ippTools/share/Makefile.am	(revision 35955)
+++ trunk/ippTools/share/Makefile.am	(revision 35960)
@@ -410,4 +410,6 @@
 	staticskytool_export_input.sql \
 	staticskytool_export_result.sql \
+	staticskytool_export_skycalrun.sql \
+	staticskytool_export_skycalresult.sql \
 	staticskytool_inputs.sql \
 	staticskytool_todo.sql \
Index: trunk/ippTools/share/disttool_pending_skycal.sql
===================================================================
--- trunk/ippTools/share/disttool_pending_skycal.sql	(revision 35955)
+++ trunk/ippTools/share/disttool_pending_skycal.sql	(revision 35960)
@@ -38,5 +38,4 @@
 JOIN chipRun
     USING(chip_id)
-    -- ON camRun.chip_id = chipRun.chip_id
 JOIN rawExp 
      USING (exp_id)
Index: trunk/ippTools/share/disttool_toadvance.sql
===================================================================
--- trunk/ippTools/share/disttool_toadvance.sql	(revision 35955)
+++ trunk/ippTools/share/disttool_toadvance.sql	(revision 35960)
@@ -262,4 +262,25 @@
         AND distComponent.fault = 0
 UNION
+-- skycal stage
+-- NOTE this assumes that there is only one component per skycalRun
+-- (one skycell)
+SELECT
+    distRun.dist_id,
+    stage,
+    stage_id,
+    outroot,
+    label,
+    clean
+    FROM distRun
+    JOIN skycalResult on stage_id = skycal_id
+    LEFT JOIN distComponent
+        ON distRun.dist_id = distComponent.dist_id
+    WHERE
+        distRun.state = 'new'
+        AND distRun.fault = 0
+        AND distRun.stage = 'skycal'
+        AND distComponent.component IS NOT NULL
+        AND distComponent.fault = 0
+UNION
 -- SSdiff stage
 SELECT
Index: trunk/ippTools/share/staticskytool_export_skycalresult.sql
===================================================================
--- trunk/ippTools/share/staticskytool_export_skycalresult.sql	(revision 35960)
+++ trunk/ippTools/share/staticskytool_export_skycalresult.sql	(revision 35960)
@@ -0,0 +1,1 @@
+SELECT * from skycalResult
Index: trunk/ippTools/share/staticskytool_export_skycalrun.sql
===================================================================
--- trunk/ippTools/share/staticskytool_export_skycalrun.sql	(revision 35960)
+++ trunk/ippTools/share/staticskytool_export_skycalrun.sql	(revision 35960)
@@ -0,0 +1,1 @@
+SELECT * from skycalRun
Index: trunk/ippTools/share/staticskytool_skycalresult.sql
===================================================================
--- trunk/ippTools/share/staticskytool_skycalresult.sql	(revision 35955)
+++ trunk/ippTools/share/staticskytool_skycalresult.sql	(revision 35960)
@@ -2,4 +2,5 @@
     skycalResult.*,
     skycalRun.stack_id,
+    skycalRun.workdir,
     stackRun.filter,
     skycalRun.state,