Index: branches/eam_branches/ipp-20120905/ippTools/share/bgtool_towarp.sql
===================================================================
--- branches/eam_branches/ipp-20120905/ippTools/share/bgtool_towarp.sql	(revision 34575)
+++ branches/eam_branches/ipp-20120905/ippTools/share/bgtool_towarp.sql	(revision 34735)
@@ -1,3 +1,3 @@
-SELECT
+SELECT DISTINCT
     warpBackgroundRun.*,
     warpRun.tess_id,
Index: branches/eam_branches/ipp-20120905/ippTools/share/magicdstool_torevert_camera.sql
===================================================================
--- branches/eam_branches/ipp-20120905/ippTools/share/magicdstool_torevert_camera.sql	(revision 34575)
+++ branches/eam_branches/ipp-20120905/ippTools/share/magicdstool_torevert_camera.sql	(revision 34735)
@@ -23,4 +23,6 @@
     JOIN rawExp using(exp_id)
 WHERE magicDSRun.stage = 'camera'
+    AND camProcessedExp.fault = 0
+    AND camRun.state = 'full'
     AND ((magicDSRun.state = 'new' AND magicDSFile.fault > 0)
          OR ((magicDSRun.state = 'goto_censored' OR magicDSRun.state = 'goto_restored')
Index: branches/eam_branches/ipp-20120905/ippTools/share/staticskytool_result.sql
===================================================================
--- branches/eam_branches/ipp-20120905/ippTools/share/staticskytool_result.sql	(revision 34575)
+++ branches/eam_branches/ipp-20120905/ippTools/share/staticskytool_result.sql	(revision 34735)
@@ -7,4 +7,7 @@
     stackRun.skycell_id,
     count(stackRun.filter) AS num_filters,
+    TRUNCATE(skycell.radeg/15., 4) AS rahours,
+    skycell.radeg,
+    skycell.decdeg,
     skycell.glong,
     skycell.glat
Index: branches/eam_branches/ipp-20120905/ippTools/share/staticskytool_todo.sql
===================================================================
--- branches/eam_branches/ipp-20120905/ippTools/share/staticskytool_todo.sql	(revision 34575)
+++ branches/eam_branches/ipp-20120905/ippTools/share/staticskytool_todo.sql	(revision 34735)
@@ -7,8 +7,14 @@
     stackRun.tess_id,
     stackRun.skycell_id,
+    TRUNCATE(skycell.radeg/15., 4) as rahours,
+    skycell.radeg,
+    skycell.decdeg,
+    skycell.glong,
+    skycell.glat,
     IFNULL(Label.priority, 10000) AS priority
 FROM staticskyRun
 JOIN staticskyInput USING (sky_id)
 JOIN stackRun USING (stack_id)
+JOIN skycell USING(tess_id, skycell_id)
 LEFT JOIN staticskyResult USING(sky_id)
 LEFT JOIN Label ON staticskyRun.label = Label.label
Index: branches/eam_branches/ipp-20120905/ippTools/src/camtool.c
===================================================================
--- branches/eam_branches/ipp-20120905/ippTools/src/camtool.c	(revision 34575)
+++ branches/eam_branches/ipp-20120905/ippTools/src/camtool.c	(revision 34735)
@@ -970,10 +970,10 @@
     psFree(where);
 
+    int numDeleted = psDBAffectedRows(config->dbh);
     if (!psDBCommit(config->dbh)) {
         psError(PS_ERR_UNKNOWN, false, "database error");
         return false;
     }
-    int numUpdated = psDBAffectedRows(config->dbh);
-    psLogMsg("camtool", PS_LOG_INFO, "Updated %d camProcessedExps", numUpdated);
+    psLogMsg("camtool", PS_LOG_INFO, "Deleted %d camProcessedExps", numDeleted);
 
     return true;
Index: branches/eam_branches/ipp-20120905/ippTools/src/stacktool.c
===================================================================
--- branches/eam_branches/ipp-20120905/ippTools/src/stacktool.c	(revision 34575)
+++ branches/eam_branches/ipp-20120905/ippTools/src/stacktool.c	(revision 34735)
@@ -1115,4 +1115,5 @@
     PXOPT_COPY_STR(config->args, where, "-skycell_id", "stackRun.skycell_id", "==");
     PXOPT_COPY_STR(config->args, where, "-filter", "stackRun.filter", "LIKE");
+    PXOPT_COPY_STR(config->args, where, "-state", "stackRun.state", "==");
     pxAddLabelSearchArgs(config, where, "-label", "stackRun.label", "LIKE");
     pxAddLabelSearchArgs(config, where, "-data_group", "stackRun.data_group", "LIKE");
Index: branches/eam_branches/ipp-20120905/ippTools/src/stacktoolConfig.c
===================================================================
--- branches/eam_branches/ipp-20120905/ippTools/src/stacktoolConfig.c	(revision 34575)
+++ branches/eam_branches/ipp-20120905/ippTools/src/stacktoolConfig.c	(revision 34735)
@@ -206,4 +206,5 @@
     psMetadataAddF64(sumskyfileArgs, PS_LIST_TAIL, "-mjd_obs_begin",  0,      "search by mjd_obs (average mjd_obs of inputs <=)", NAN);
     psMetadataAddF64(sumskyfileArgs, PS_LIST_TAIL, "-mjd_obs_end",  0,      "search by mjd_obs (average mjd_obs of inputs>=)", NAN);
+    psMetadataAddStr(sumskyfileArgs, PS_LIST_TAIL, "-state", 0,             "search by state", NULL);
     psMetadataAddS16(sumskyfileArgs, PS_LIST_TAIL, "-fault",  0,            "search by fault code", 0);
     psMetadataAddU64(sumskyfileArgs, PS_LIST_TAIL, "-limit",  0,            "limit result set to N items", 0);