Changeset 35096 for branches/eam_branches/ipp-20121219/ippTools/share/stacktool_tobkg.sql

Timestamp:

Feb 6, 2013, 2:34:49 PM (13 years ago)

Author:

eugene

Message:

merging changes from trunk

Location:

branches/eam_branches/ipp-20121219

Files:

• . (modified) (1 prop)
• ippTools/share/stacktool_tobkg.sql (modified) (1 diff)

branches/eam_branches/ipp-20121219/ippTools/share/stacktool_tobkg.sql

@@ -25 +25 @@
     -- WHERE hook %s
 GROUP BY stack_id
-HAVING (SUM(IF(warpRun.state = 'full', 1, 0)) = COUNT(stackInputSkyfile.warp_id) AND
+HAVING ((SUM(IF(warpRun.state = 'cleaned', 1, 0)) = COUNT(stackInputSkyfile.warp_id) OR
+         SUM(IF(warpRun.state = 'full', 1, 0)) = COUNT(stackInputSkyfile.warp_id)) AND
         SUM(IF(warpSkyfile.background_model = 1, 1, 0)) = COUNT(stackInputSkyfile.warp_id))