Changeset 24244 for branches/cnb_branches/cnb_branch_20090301/ippTools/share/warptool_definebyquery.sql

Timestamp:

May 26, 2009, 1:59:32 PM (17 years ago)

Author:

beaumont

Message:

merged with trunk

Location:

branches/cnb_branches/cnb_branch_20090301

Files:

• . (modified) (1 prop)
• ippTools/share (modified) (1 prop)
• ippTools/share/warptool_definebyquery.sql (modified) (1 diff)

branches/cnb_branches/cnb_branch_20090301/ippTools/share

@@ -1 +1 @@
 Makefile.in
 Makefile
+pxadmin_create_mirror_tables.sql

@@ -1 +1 @@
 Makefile.in
 Makefile
+pxadmin_create_mirror_tables.sql

branches/cnb_branches/cnb_branch_20090301/ippTools/share/warptool_definebyquery.sql

@@ -1 @@
-SELECT
-    *
-FROM
-    (SELECT DISTINCT
-        fakeRun.*,
-        chipRun.chip_id,
-        rawExp.camera,
-        rawExp.telescope,
-        rawExp.dateobs,
-        rawExp.exp_tag,
-        rawExp.exp_name,
-        rawExp.exp_type,
-        rawExp.filelevel,
-        rawExp.filter,
-        rawExp.airmass,
-        rawExp.ra,
-        rawExp.decl,
-        rawExp.exp_time,
-        rawExp.sat_pixel_frac,
-        rawExp.bg,
-        rawExp.bg_stdev,
-        rawExp.bg_mean_stdev,
-        rawExp.alt,
-        rawExp.az,
-        rawExp.ccd_temp,
-        rawExp.posang,
-        rawExp.object,
-        rawExp.sun_angle
-    FROM fakeRun
-    JOIN camRun
-        using(cam_id)
-    JOIN chipRun
-        using(chip_id)
-    JOIN rawExp
-        using(exp_id)
-    WHERE
-        fakeRun.state = 'full') as Foo
+SELECT DISTINCT
+    fakeRun.*,
+    chipRun.chip_id,
+    rawExp.camera,
+    rawExp.telescope,
+    rawExp.dateobs,
+    rawExp.exp_id,
+    rawExp.exp_tag,
+    rawExp.exp_name,
+    rawExp.exp_type,
+    rawExp.filelevel,
+    rawExp.filter,
+    rawExp.airmass,
+    rawExp.ra,
+    rawExp.decl,
+    rawExp.exp_time,
+    rawExp.sat_pixel_frac,
+    rawExp.bg,
+    rawExp.bg_stdev,
+    rawExp.bg_mean_stdev,
+    rawExp.alt,
+    rawExp.az,
+    rawExp.ccd_temp,
+    rawExp.posang,
+    rawExp.object,
+    rawExp.sun_angle
+FROM fakeRun
+JOIN camRun USING(cam_id)
+JOIN chipRun USING(chip_id)
+JOIN rawExp USING(exp_id)
+WHERE camRun.state = 'full'
+AND chipRun.state = 'full'

@@ -1 +1 @@
 Makefile.in
 Makefile
+pxadmin_create_mirror_tables.sql