Index: branches/eam_branches/ipp-20120405/ippTools/share/Makefile.am
===================================================================
--- branches/eam_branches/ipp-20120405/ippTools/share/Makefile.am	(revision 33724)
+++ branches/eam_branches/ipp-20120405/ippTools/share/Makefile.am	(revision 33949)
@@ -450,4 +450,5 @@
 	vptool_pendingrun.sql \
 	vptool_processedcell.sql \
-	vptool_revertrun.sql
+	vptool_revertrun.sql \
+	sctool_list.sql
 
Index: branches/eam_branches/ipp-20120405/ippTools/share/chiptool_pendingimfile.sql
===================================================================
--- branches/eam_branches/ipp-20120405/ippTools/share/chiptool_pendingimfile.sql	(revision 33724)
+++ branches/eam_branches/ipp-20120405/ippTools/share/chiptool_pendingimfile.sql	(revision 33949)
@@ -6,4 +6,6 @@
     rawImfile.magicked as raw_magicked,
     (rawImfile.user_1 is not NULL and rawImfile.user_1 > 0.5) as deburned,
+    rawImfile.burntool_state as burntool_state,
+    rawImfile.video_cells as video_cells,
     rawExp.exp_tag,
     rawExp.exp_name,
Index: branches/eam_branches/ipp-20120405/ippTools/share/pstamptool_revertreq_deletejobs.sql
===================================================================
--- branches/eam_branches/ipp-20120405/ippTools/share/pstamptool_revertreq_deletejobs.sql	(revision 33724)
+++ branches/eam_branches/ipp-20120405/ippTools/share/pstamptool_revertreq_deletejobs.sql	(revision 33949)
@@ -3,3 +3,4 @@
 FROM pstampJob
     JOIN pstampRequest USING(req_id)
-WHERE pstampRequest.state = 'new'
+WHERE pstampRequest.state = 'new' 
+    AND pstampRequest.fault > 0
Index: branches/eam_branches/ipp-20120405/ippTools/share/sctool_list.sql
===================================================================
--- branches/eam_branches/ipp-20120405/ippTools/share/sctool_list.sql	(revision 33949)
+++ branches/eam_branches/ipp-20120405/ippTools/share/sctool_list.sql	(revision 33949)
@@ -0,0 +1,11 @@
+SELECT 
+    skycell.tess_id,
+    skycell.skycell_id,
+    TRUNCATE(skycell.radeg/15., 4) AS rahours,
+    skycell.radeg,
+    skycell.decdeg,
+    skycell.glong,
+    skycell.glat,
+    skycell.width,
+    skycell.height
+FROM skycell
Index: branches/eam_branches/ipp-20120405/ippTools/share/staticskytool_definebyquery_inputs.sql
===================================================================
--- branches/eam_branches/ipp-20120405/ippTools/share/staticskytool_definebyquery_inputs.sql	(revision 33724)
+++ branches/eam_branches/ipp-20120405/ippTools/share/staticskytool_definebyquery_inputs.sql	(revision 33949)
@@ -6,4 +6,5 @@
   FROM stackRun
   JOIN stackSumSkyfile USING(stack_id)
+  JOIN skycell USING(tess_id, skycell_id)
   WHERE stackRun.state = 'full'
       AND stackSumSkyfile.fault = 0
Index: branches/eam_branches/ipp-20120405/ippTools/share/staticskytool_definebyquery_select.sql
===================================================================
--- branches/eam_branches/ipp-20120405/ippTools/share/staticskytool_definebyquery_select.sql	(revision 33724)
+++ branches/eam_branches/ipp-20120405/ippTools/share/staticskytool_definebyquery_select.sql	(revision 33949)
@@ -10,4 +10,5 @@
   FROM stackRun
   JOIN stackSumSkyfile USING(stack_id)
+  JOIN skycell using(tess_id, skycell_id)
   WHERE stackRun.state = 'full'
       AND stackSumSkyfile.fault = 0
@@ -29,4 +30,5 @@
     JOIN stackRun USING(stack_id)
     JOIN stackSumSkyfile USING(stack_id)
+    JOIN skycell USING(tess_id, skycell_id)
     WHERE 1
     -- restrict by selected filters, stackSumSkyfile.good_frac, stackRun.skycell_id, stackRun.label
Index: branches/eam_branches/ipp-20120405/ippTools/share/staticskytool_result.sql
===================================================================
--- branches/eam_branches/ipp-20120405/ippTools/share/staticskytool_result.sql	(revision 33724)
+++ branches/eam_branches/ipp-20120405/ippTools/share/staticskytool_result.sql	(revision 33949)
@@ -6,7 +6,10 @@
     stackRun.tess_id,
     stackRun.skycell_id,
-    count(stackRun.filter) AS num_filters
+    count(stackRun.filter) AS num_filters,
+    skycell.glong,
+    skycell.glat
 FROM staticskyRun
 JOIN staticskyResult USING(sky_id)
 JOIN staticskyInput USING(sky_id)
-JOIN stackRun using(stack_id)
+JOIN stackRun USING(stack_id)
+LEFT JOIN skycell USING(tess_id, skycell_id)