Index: trunk/ippTools/share/dqstatstool_definebyquery.sql
===================================================================
--- trunk/ippTools/share/dqstatstool_definebyquery.sql	(revision 26378)
+++ 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'