Index: branches/czw_branch/20120906/ippTools/share/Makefile.am
===================================================================
--- branches/czw_branch/20120906/ippTools/share/Makefile.am	(revision 34410)
+++ branches/czw_branch/20120906/ippTools/share/Makefile.am	(revision 34772)
@@ -391,4 +391,5 @@
 	stacktool_sassskyfile.sql \
 	stacktool_tosum.sql \
+	stacktool_tobkg.sql \
 	stacktool_tosummary.sql \
 	stacktool_addsummary.sql \
Index: branches/czw_branch/20120906/ippTools/share/bgtool_towarp.sql
===================================================================
--- branches/czw_branch/20120906/ippTools/share/bgtool_towarp.sql	(revision 34410)
+++ branches/czw_branch/20120906/ippTools/share/bgtool_towarp.sql	(revision 34772)
@@ -1,3 +1,3 @@
-SELECT
+SELECT DISTINCT
     warpBackgroundRun.*,
     warpRun.tess_id,
Index: branches/czw_branch/20120906/ippTools/share/difftool_definestackstack_part0.sql
===================================================================
--- branches/czw_branch/20120906/ippTools/share/difftool_definestackstack_part0.sql	(revision 34410)
+++ branches/czw_branch/20120906/ippTools/share/difftool_definestackstack_part0.sql	(revision 34772)
@@ -39,5 +39,5 @@
 	  WHERE 1
 	  @STACK1_QUERY@ -- input condition
-) AS diffExp ON diffExp.stack1 = stackRun.stack_id AND diffExp.stack2 = template.max_stack_id
+) AS diffExp ON diffExp.stack1 = stackRun.stack_id 
 WHERE
 	stackSumSkyfile.fault = 0 AND stackSumSkyfile.quality = 0
Index: branches/czw_branch/20120906/ippTools/share/difftool_definestackstack_part1.sql
===================================================================
--- branches/czw_branch/20120906/ippTools/share/difftool_definestackstack_part1.sql	(revision 34410)
+++ branches/czw_branch/20120906/ippTools/share/difftool_definestackstack_part1.sql	(revision 34772)
@@ -40,5 +40,5 @@
 	  WHERE 1
 	  @STACK1_QUERY@ -- input constraint
-) AS diffExp ON diffExp.stack1 = stackRun.stack_id AND diffExp.stack2 = template.max_stack_id
+) AS diffExp ON diffExp.stack1 = stackRun.stack_id 
 WHERE
 	stackSumSkyfile.fault = 0 AND stackSumSkyfile.quality = 0
Index: branches/czw_branch/20120906/ippTools/share/magicdstool_torevert_camera.sql
===================================================================
--- branches/czw_branch/20120906/ippTools/share/magicdstool_torevert_camera.sql	(revision 34410)
+++ branches/czw_branch/20120906/ippTools/share/magicdstool_torevert_camera.sql	(revision 34772)
@@ -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/czw_branch/20120906/ippTools/share/pxadmin_create_tables.sql
===================================================================
--- branches/czw_branch/20120906/ippTools/share/pxadmin_create_tables.sql	(revision 34410)
+++ branches/czw_branch/20120906/ippTools/share/pxadmin_create_tables.sql	(revision 34772)
@@ -996,4 +996,5 @@
     maskfrac_magic FLOAT,
     maskfrac_advisory FLOAT,
+    background_model SMALLINT,
     PRIMARY KEY(warp_id, skycell_id, tess_id),
     KEY(good_frac),
@@ -1078,7 +1079,8 @@
         good_frac FLOAT,
         mjd_obs DOUBLE,
-        quality SMALLINT NOT NULL DEFAULT 0,
         fault SMALLINT,
         software_ver VARCHAR(16),
+	background_model SMALLINT,
+        quality SMALLINT NOT NULL DEFAULT 0,
         PRIMARY KEY(stack_id),
         KEY(dtime_stack),
@@ -2115,4 +2117,6 @@
       sigma_dec FLOAT,
       n_astrom INT,
+      n_detections INT,
+      n_extended INT,
       zpt_obs FLOAT,
       zpt_stdev FLOAT,
Index: branches/czw_branch/20120906/ippTools/share/staticskytool_pendingskycalrun.sql
===================================================================
--- branches/czw_branch/20120906/ippTools/share/staticskytool_pendingskycalrun.sql	(revision 34410)
+++ branches/czw_branch/20120906/ippTools/share/staticskytool_pendingskycalrun.sql	(revision 34772)
@@ -1,3 +1,3 @@
-SELECT
+SELECT DISTINCT
     skycalRun.*,
     stackRun.tess_id,
@@ -6,5 +6,5 @@
     staticskyResult.path_base,
     rawExp.camera,
-    staticskyResult.num_inputs = 1 AS singlefilter
+    0 AS  singlefilter
 FROM skycalRun
 JOIN staticskyRun USING (sky_id)
Index: branches/czw_branch/20120906/ippTools/share/staticskytool_result.sql
===================================================================
--- branches/czw_branch/20120906/ippTools/share/staticskytool_result.sql	(revision 34410)
+++ branches/czw_branch/20120906/ippTools/share/staticskytool_result.sql	(revision 34772)
@@ -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/czw_branch/20120906/ippTools/share/staticskytool_todo.sql
===================================================================
--- branches/czw_branch/20120906/ippTools/share/staticskytool_todo.sql	(revision 34410)
+++ branches/czw_branch/20120906/ippTools/share/staticskytool_todo.sql	(revision 34772)
@@ -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