Changeset 25193 for branches/pap_mops/ippTools/share/difftool_skyfile.sql

Timestamp:

Aug 25, 2009, 3:04:26 PM (17 years ago)

Author:

Paul Price

Message:

Need more info out of difftool -diffskyfile, for publishing.

File:

• branches/pap_mops/ippTools/share/difftool_skyfile.sql (modified) (1 diff)

branches/pap_mops/ippTools/share/difftool_skyfile.sql

@@ -16 +16 @@
     camProcessedInput.zpt_lq,
     camProcessedInput.zpt_uq,
+    camProcessedInput.sigma_ra,
+    camProcessedInput.sigma_dec,
     rawInput.exp_time,
     rawInput.camera,
     rawInput.exp_name AS exp_name_1,
+    rawInput.exp_id AS exp_id_1,
+    chipInput.chip_id AS chip_id_1,
+    camInput.cam_id AS cam_id_1,
+    fakeInput.fake_id AS fake_id_1,
     rawTemplate.exp_name AS exp_name_2,
-    rawInput.exp_id AS exp_id_1,
-    rawTemplate.exp_id AS exp_id_2
+    rawTemplate.exp_id AS exp_id_2,
+    chipTemplate.chip_id AS chip_id_2,
+    camTemplate.cam_id AS cam_id_2,
+    fakeTemplate.fake_id AS fake_id_2,
 FROM diffRun
 JOIN diffSkyfile USING(diff_id)