Index: trunk/ippTools/share/Makefile.am
===================================================================
--- trunk/ippTools/share/Makefile.am	(revision 26266)
+++ trunk/ippTools/share/Makefile.am	(revision 26378)
@@ -140,4 +140,8 @@
      disttool_updateinterest.sql \
      disttool_updatercrun.sql \
+     dqstatstool_createbundle.sql \
+     dqstatstool_definebyquery.sql \
+     dqstatstool_get_contents.sql \
+     dqstatstool_get_run.sql \
      faketool_change_exp_state.sql \
      faketool_change_imfile_data_state.sql \
Index: trunk/ippTools/share/dqstatstool_createbundle.sql
===================================================================
--- trunk/ippTools/share/dqstatstool_createbundle.sql	(revision 26378)
+++ trunk/ippTools/share/dqstatstool_createbundle.sql	(revision 26378)
@@ -0,0 +1,7 @@
+-- Select the information we want from the various tables
+SELECT @COLLIST@ FROM rawExp 
+        JOIN chipRun USING(exp_id) 
+        JOIN camRun USING(chip_id) 
+	JOIN camProcessedExp USING(cam_id)
+        LEFT OUTER JOIN fakeRun USING(cam_id) 
+        LEFT OUTER JOIN warpRun USING(fake_id)
Index: trunk/ippTools/share/dqstatstool_definebyquery.sql
===================================================================
--- trunk/ippTools/share/dqstatstool_definebyquery.sql	(revision 26378)
+++ trunk/ippTools/share/dqstatstool_definebyquery.sql	(revision 26378)
@@ -0,0 +1,9 @@
+-- query to identify unique data to bundle
+
+SELECT exp_id,chip_id,cam_id,warp_id,invalid from rawExp 
+	JOIN chipRun USING(exp_id) 
+	JOIN camRun USING(chip_id) 
+	LEFT OUTER JOIN fakeRun USING(cam_id) 
+	LEFT OUTER JOIN warpRun USING(fake_id)
+	LEFT OUTER JOIN dqstatsContent USING (exp_id,chip_id,cam_id,warp_id)
+WHERE (invalid IS NULL OR invalid = 1)
Index: trunk/ippTools/share/dqstatstool_get_contents.sql
===================================================================
--- trunk/ippTools/share/dqstatstool_get_contents.sql	(revision 26378)
+++ trunk/ippTools/share/dqstatstool_get_contents.sql	(revision 26378)
@@ -0,0 +1,2 @@
+SELECT dqstats_id,exp_id,chip_id,cam_id,warp_id from dqstatsContent
+	WHERE invalid = 0
Index: trunk/ippTools/share/dqstatstool_get_run.sql
===================================================================
--- trunk/ippTools/share/dqstatstool_get_run.sql	(revision 26378)
+++ trunk/ippTools/share/dqstatstool_get_run.sql	(revision 26378)
@@ -0,0 +1,2 @@
+SELECT * from dqstatsRun
+	WHERE state = 'new' AND (fault = 0)