Index: trunk/ippTools/share/dqstatstool_definebyquery.sql
===================================================================
--- trunk/ippTools/share/dqstatstool_definebyquery.sql	(revision 27301)
+++ trunk/ippTools/share/dqstatstool_definebyquery.sql	(revision 27304)
@@ -1,5 +1,5 @@
 -- query to identify unique data to bundle
 
-SELECT exp_id,chip_id,cam_id,warp_id,invalid from rawExp 
+SELECT DISTINCT exp_id,chip_id,cam_id,warp_id,invalid from rawExp 
 	JOIN chipRun USING(exp_id) 
 	JOIN camRun USING(chip_id) 
@@ -7,3 +7,3 @@
 	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)
+WHERE camRun.state = 'full'
Index: trunk/ippTools/share/dqstatstool_get_run.sql
===================================================================
--- trunk/ippTools/share/dqstatstool_get_run.sql	(revision 27301)
+++ trunk/ippTools/share/dqstatstool_get_run.sql	(revision 27304)
@@ -1,2 +1,4 @@
-SELECT * from dqstatsRun
-	WHERE state = 'new' AND (fault = 0)
+SELECT DISTINCT dqstatsRun.*,rawExp.camera from dqstatsRun
+       JOIN dqstatsContent USING(dqstats_id)
+       JOIN rawExp USING(exp_id)
+       	WHERE dqstatsRun.state = 'new' AND (dqstatsRun.fault = 0)