Changeset 34726 for trunk/ippTools

Timestamp:

Nov 28, 2012, 5:46:00 PM (14 years ago)

Author:

bills

Message:

include coordinates of skycell center in output of -todo

File:

• trunk/ippTools/share/staticskytool_todo.sql (modified) (1 diff)

trunk/ippTools/share/staticskytool_todo.sql

@@ -7 +7 @@
     stackRun.tess_id,
     stackRun.skycell_id,
+    TRUNCATE(skycell.radeg/15., 4) as rahours,
+    skycell.radeg,
+    skycell.decdeg,
+    skycell.glong,
+    skycell.glat,
     IFNULL(Label.priority, 10000) AS priority
 FROM staticskyRun
 JOIN staticskyInput USING (sky_id)
 JOIN stackRun USING (stack_id)
+JOIN skycell USING(tess_id, skycell_id)
 LEFT JOIN staticskyResult USING(sky_id)
 LEFT JOIN Label ON staticskyRun.label = Label.label