Changeset 33638 for branches/eam_branches/ipp-20111122/ippTools/share/staticskytool_result.sql

Timestamp:

Mar 30, 2012, 2:49:37 PM (14 years ago)

Author:

eugene

Message:

merge changes from trunk

File:

• branches/eam_branches/ipp-20111122/ippTools/share/staticskytool_result.sql (modified) (2 diffs)

branches/eam_branches/ipp-20111122/ippTools/share/staticskytool_result.sql

@@ -1 @@
-SELECT DISTINCT
+SELECT
     staticskyResult.*,
     staticskyRun.state,
@@ -6 +6 @@
     stackRun.tess_id,
     stackRun.skycell_id,
-    stackRun.filter
+    count(stackRun.filter) AS num_filters
 FROM staticskyRun
 JOIN staticskyResult USING(sky_id)