Index: trunk/ippTools/share/Makefile.am
===================================================================
--- trunk/ippTools/share/Makefile.am	(revision 32799)
+++ trunk/ippTools/share/Makefile.am	(revision 32832)
@@ -10,4 +10,6 @@
 	addtool_find_sky_id_dvo.sql \
 	addtool_find_sky_id.sql \
+	addtool_find_sky_id_multi_dvo.sql \
+	addtool_find_sky_id_multi.sql \
 	addtool_find_stack_id_dvo.sql \
 	addtool_find_stack_id.sql \
@@ -16,8 +18,10 @@
 	addtool_find_pendingexp_stack.sql \
 	addtool_find_pendingexp_staticsky.sql \
+	addtool_find_pendingexp_staticsky_multi.sql \
 	addtool_find_pendingmergeprocess.sql \
 	addtool_find_processedexp_cam.sql \
 	addtool_find_processedexp_stack.sql \
 	addtool_find_processedexp_staticsky.sql \
+	addtool_find_processedexp_staticsky_multi.sql \
 	addtool_find_minidvodbprocessed.sql \
 	addtool_find_minidvodbrun.sql \
@@ -27,4 +31,5 @@
 	addtool_queue_stack_id.sql \
 	addtool_queue_sky_id.sql \
+	addtool_queue_sky_id_multi.sql \
 	addtool_queue_minidvodbrun.sql \
 	addtool_revertminidvodbprocessed.sql \
@@ -32,4 +37,5 @@
 	addtool_revertprocessedexp_stack.sql \
 	addtool_revertprocessedexp_staticsky.sql \
+	addtool_revertprocessedexp_staticsky_multi.sql \
 	bgtool_advancechip.sql \
 	bgtool_advancewarp.sql \
Index: trunk/ippTools/share/addtool_find_pendingexp_staticsky_multi.sql
===================================================================
--- trunk/ippTools/share/addtool_find_pendingexp_staticsky_multi.sql	(revision 32832)
+++ trunk/ippTools/share/addtool_find_pendingexp_staticsky_multi.sql	(revision 32832)
@@ -0,0 +1,32 @@
+SELECT
+    addRun.*,
+    staticskyResult.path_base as stageroot,
+    rawExp.camera,
+    rawExp.telescope
+FROM addRun
+JOIN staticskyRun 
+    ON sky_id = stage_id
+JOIN staticskyResult
+     USING (sky_id)
+JOIN staticskyInput
+     USING (sky_id)
+JOIN stackRun
+    USING (stack_id)
+JOIN stackInputSkyfile 
+     USING(stack_id)
+JOIN warpRun using(warp_id)
+JOIN fakeRun using(fake_id)
+JOIN camRun using(cam_id)
+JOIN chipRun using(chip_id)
+JOIN rawExp using (exp_id)
+LEFT JOIN addProcessedExp using (add_id)
+LEFT JOIN addMask
+    ON addRun.label = addMask.label
+WHERE
+    staticskyRun.state = 'full'
+    AND stage = 'staticsky_multi'
+    AND ((addRun.state = 'new' AND addProcessedExp.add_id IS NULL) OR addRun.state = 'update')
+    AND addRun.dvodb IS NOT NULL
+    AND addRun.workdir IS NOT NULL
+    AND addMask.label IS NULL
+
Index: trunk/ippTools/share/addtool_find_processedexp_staticsky_multi.sql
===================================================================
--- trunk/ippTools/share/addtool_find_processedexp_staticsky_multi.sql	(revision 32832)
+++ trunk/ippTools/share/addtool_find_processedexp_staticsky_multi.sql	(revision 32832)
@@ -0,0 +1,6 @@
+SELECT
+    addProcessedExp.*,
+    addRun.workdir
+FROM addProcessedExp
+JOIN addRun
+    USING(add_id)
Index: trunk/ippTools/share/addtool_find_sky_id_multi.sql
===================================================================
--- trunk/ippTools/share/addtool_find_sky_id_multi.sql	(revision 32832)
+++ trunk/ippTools/share/addtool_find_sky_id_multi.sql	(revision 32832)
@@ -0,0 +1,24 @@
+SELECT
+     distinct(sky_id) as stage_id,
+     staticskyRun.*,
+    staticskyResult.num_inputs
+FROM 
+     staticskyResult
+join staticskyRun using (sky_id)
+join staticskyInput using(sky_id)
+JOIN stackRun USING(stack_id)
+
+LEFT JOIN (SELECT sky_id       AS added_sky_id,
+                  addRun.dvodb AS previous_dvodb
+           FROM addRun
+JOIN staticskyRun on sky_id = stage_id
+          ) as foo
+     ON sky_id = added_sky_id 
+     AND stage = 'staticsky_multi'
+     -- hook for qualifying the join on the previous_dvodb
+     AND %s
+WHERE
+    staticskyRun.state = 'full'
+    AND staticskyResult.quality = 0
+    AND added_exp_id IS NULL
+    -- addtool adds checks on exposure being added to the dvodb previously
Index: trunk/ippTools/share/addtool_find_sky_id_multi_dvo.sql
===================================================================
--- trunk/ippTools/share/addtool_find_sky_id_multi_dvo.sql	(revision 32832)
+++ trunk/ippTools/share/addtool_find_sky_id_multi_dvo.sql	(revision 32832)
@@ -0,0 +1,12 @@
+SELECT distinct(sky_id) as stage_id, staticskyRun.*, staticskyResult.num_inputs 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
+       FROM addRun
+       JOIN staticskyResult on staticskyResult.sky_id = addRun.stage_id
+       JOIN staticskyRun USING(sky_id)
+       WHERE addRun.stage = 'staticsky_multi' AND %s
+      )
Index: trunk/ippTools/share/addtool_queue_cam_id.sql
===================================================================
--- trunk/ippTools/share/addtool_queue_cam_id.sql	(revision 32799)
+++ trunk/ippTools/share/addtool_queue_cam_id.sql	(revision 32832)
@@ -4,4 +4,5 @@
 	'cam',		-- stage
         cam_id,         -- stage_id
+	%d,		-- stage_extra1
         '%s',           -- state
         '%s',           -- workdir
Index: trunk/ippTools/share/addtool_queue_sky_id.sql
===================================================================
--- trunk/ippTools/share/addtool_queue_sky_id.sql	(revision 32799)
+++ trunk/ippTools/share/addtool_queue_sky_id.sql	(revision 32832)
@@ -4,4 +4,5 @@
         'staticsky',		-- stage
         sky_id,         -- stage_id
+	%d,		-- stage_extra1
         '%s',           -- state
         '%s',           -- workdir
Index: trunk/ippTools/share/addtool_queue_sky_id_multi.sql
===================================================================
--- trunk/ippTools/share/addtool_queue_sky_id_multi.sql	(revision 32832)
+++ trunk/ippTools/share/addtool_queue_sky_id_multi.sql	(revision 32832)
@@ -0,0 +1,22 @@
+INSERT INTO addRun
+    SELECT
+        0,              -- add_id
+        'staticsky_multi',		-- stage
+        sky_id,         -- stage_id
+	%d,		-- stage_extra1
+        '%s',           -- state
+        '%s',           -- workdir
+	'%s',           -- workdir_state
+        '%s',           -- reduction
+        '%s',           -- label
+        '%s',           -- data_group
+        '%s',           -- dvodb 
+        '%s',           -- note
+	%d,		-- image_only
+	%d,		-- minidvodb
+	'%s',           -- minidvodb_group 
+ 	'%s'	        -- minidvodb_name
+    FROM staticskyRun
+    WHERE
+        staticskyRun.state = 'full'
+        AND staticskyRun.sky_id = %lld
Index: trunk/ippTools/share/addtool_queue_stack_id.sql
===================================================================
--- trunk/ippTools/share/addtool_queue_stack_id.sql	(revision 32799)
+++ trunk/ippTools/share/addtool_queue_stack_id.sql	(revision 32832)
@@ -4,4 +4,5 @@
         'stack',		-- stage
         stack_id,         -- stage_id
+	%d,		  --stage_extra1
         '%s',           -- state
         '%s',           -- workdir
Index: trunk/ippTools/share/addtool_revertprocessedexp_staticsky_multi.sql
===================================================================
--- trunk/ippTools/share/addtool_revertprocessedexp_staticsky_multi.sql	(revision 32832)
+++ trunk/ippTools/share/addtool_revertprocessedexp_staticsky_multi.sql	(revision 32832)
@@ -0,0 +1,7 @@
+DELETE FROM addProcessedExp
+USING addProcessedExp, addRun
+WHERE
+    addRun.add_id = addProcessedExp.add_id
+    AND addProcessedExp.fault != 0
+    AND addRun.state = 'new'
+    AND addRun.stage = 'staticsky_multi'