Changeset 33919 for trunk/ippTools/share/staticskytool_definebyquery_select.sql

Timestamp:

May 25, 2012, 11:17:45 AM (14 years ago)

Author:

bills

Message:

various enhancements to staticskytool mostly to allow selection by
ra/dec and galactic coordinates

File:

• trunk/ippTools/share/staticskytool_definebyquery_select.sql (modified) (2 diffs)

trunk/ippTools/share/staticskytool_definebyquery_select.sql

@@ -10 +10 @@
   FROM stackRun
   JOIN stackSumSkyfile USING(stack_id)
+  JOIN skycell using(tess_id, skycell_id)
   WHERE stackRun.state = 'full'
       AND stackSumSkyfile.fault = 0
@@ -29 +30 @@
     JOIN stackRun USING(stack_id)
     JOIN stackSumSkyfile USING(stack_id)
+    JOIN skycell USING(tess_id, skycell_id)
     WHERE 1
     -- restrict by selected filters, stackSumSkyfile.good_frac, stackRun.skycell_id, stackRun.label