Changeset 26556

Timestamp:

Jan 9, 2010, 10:54:14 AM (16 years ago)

Author:

bills

Message:

 

File:

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

trunk/ippTools/share/magicdstool_getskycells.sql

@@ -1 +1 @@
 SELECT DISTINCT
     diffSkyfile.diff_id,
+    diffRun.tess_id,
     diffSkyfile.skycell_id,
-    diffSkyfile.path_base
+    diffSkyfile.path_base,
+    diffSkyfile.data_state
 FROM magicDSRun
 JOIN magicRun USING(magic_id)
 JOIN magicInputSkyfile USING(magic_id)
+JOIN diffRun ON magicRun.diff_id = diffRun.diff_id
 JOIN diffSkyfile
     ON magicRun.diff_id = diffSkyfile.diff_id