Index: branches/haf_branches/ipp.20100512/ippTools/share/Makefile.am
===================================================================
--- branches/haf_branches/ipp.20100512/ippTools/share/Makefile.am	(revision 27935)
+++ branches/haf_branches/ipp.20100512/ippTools/share/Makefile.am	(revision 27936)
@@ -7,8 +7,12 @@
      addtool_find_cam_id.sql \
      addtool_find_pendingexp.sql \
+     addtool_find_pendingmergeprocess.sql \
      addtool_find_processedexp.sql \
+     addtool_find_minidvodbrun.sql \
+     addtool_find_minidvodbrun2.sql \
      addtool_pendingcleanupexp.sql \
      addtool_pendingcleanuprun.sql \
      addtool_queue_cam_id.sql \
+     addtool_queue_minidvodbrun.sql \
      addtool_reset_faulted_runs.sql \
      addtool_revertprocessedexp.sql \
Index: branches/haf_branches/ipp.20100512/ippTools/share/addtool_find_minidvodbrun.sql
===================================================================
--- branches/haf_branches/ipp.20100512/ippTools/share/addtool_find_minidvodbrun.sql	(revision 27936)
+++ branches/haf_branches/ipp.20100512/ippTools/share/addtool_find_minidvodbrun.sql	(revision 27936)
@@ -0,0 +1,7 @@
+SELECT
+    minidvodbRun.*,
+    addRun.minidvodb_group
+FROM minidvodbRun
+LEFT JOIN addRun
+    USING(minidvodb_name)
+
Index: branches/haf_branches/ipp.20100512/ippTools/share/addtool_find_minidvodbrun2.sql
===================================================================
--- branches/haf_branches/ipp.20100512/ippTools/share/addtool_find_minidvodbrun2.sql	(revision 27936)
+++ branches/haf_branches/ipp.20100512/ippTools/share/addtool_find_minidvodbrun2.sql	(revision 27936)
@@ -0,0 +1,23 @@
+-- this selects the minidvodbs that have complete addRuns
+SELECT minidvodb_name, minidvodb_path, mergedvodb_path, state, minidbg 
+AS minidvodb_group 
+FROM minidvodbRun 
+JOIN 
+   (SELECT minidvodb_name, count(state) as cnt2, cnt, minidbg, minidbn 
+   FROM addRun LEFT JOIN 
+       -- this select grabs (and counts) all the addRuns with any state
+       -- and groups them by the name
+       (SELECT minidvodb_group as minidbg, minidvodb_name as minidbn, count(state) 
+        AS cnt 
+        FROM addRun 
+        GROUP BY minidvodb_name ) 
+   AS foo1 ON minidvodb_name = minidbn
+        -- the second select grabs and counts all the addRuns with state
+        -- of 'full'	     
+   WHERE addRun.state = 'full' 
+   GROUP BY minidvodb_name ) 
+AS foo2 
+USING(minidvodb_name) 
+WHERE cnt2 = cnt
+       -- the 3rd select only grabs the columns where the counts are the same
+       -- (same number of 'full' and any state)
Index: branches/haf_branches/ipp.20100512/ippTools/share/addtool_find_pendingmergeprocess.sql
===================================================================
--- branches/haf_branches/ipp.20100512/ippTools/share/addtool_find_pendingmergeprocess.sql	(revision 27936)
+++ branches/haf_branches/ipp.20100512/ippTools/share/addtool_find_pendingmergeprocess.sql	(revision 27936)
@@ -0,0 +1,5 @@
+SELECT minidvodbRun.* 
+FROM minidvodbRun 
+LEFT JOIN minidvodbProcessed
+USING(minidvodb_name)
+WHERE (minidvodbRun.state = 'to_be_merged' AND minidvodbProcessed.minidvodb_name IS NULL)
Index: branches/haf_branches/ipp.20100512/ippTools/share/addtool_find_processedexp.sql
===================================================================
--- branches/haf_branches/ipp.20100512/ippTools/share/addtool_find_processedexp.sql	(revision 27935)
+++ branches/haf_branches/ipp.20100512/ippTools/share/addtool_find_processedexp.sql	(revision 27936)
@@ -2,6 +2,8 @@
     addProcessedExp.*,
     addRun.workdir
-FROM addRun
-JOIN camProcessedExp
+FROM addProcessedExp
+JOIN addRun
+    USING(add_id)
+JOIN camRun
     USING(cam_id)
 JOIN chipRun
Index: branches/haf_branches/ipp.20100512/ippTools/share/addtool_queue_minidvodbrun.sql
===================================================================
--- branches/haf_branches/ipp.20100512/ippTools/share/addtool_queue_minidvodbrun.sql	(revision 27936)
+++ branches/haf_branches/ipp.20100512/ippTools/share/addtool_queue_minidvodbrun.sql	(revision 27936)
@@ -0,0 +1,12 @@
+-- create rcRun's for all destinations that have filesets that they are interested in available
+INSERT INTO minidvodbRun
+SELECT                  -- rows in this select must match rcRun
+    minidvodb_name,
+    minidvodb_path,
+    mergedvodb_path,
+    'new'
+
+FROM addRun 
+LEFT JOIN minidvodbRun USING(minidvodb_name)
+-- WHERE minidvodbRun.minidvodb_name IS NULL
+