IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Changeset 23651


Ignore:
Timestamp:
Apr 1, 2009, 9:04:55 AM (17 years ago)
Author:
Paul Price
Message:

Fixing query, similar to fix on trunk.

File:
1 edited

Legend:

Unmodified
Added
Removed

  • branches/pap/ippTools/share/warptool_definebyquery.sql

    r23418 r23651  
    1 SELECT
    2     *
    3 FROM
    4     (SELECT DISTINCT
    5         fakeRun.*,
    6         chipRun.chip_id,
    7         rawExp.camera,
    8         rawExp.telescope,
    9         rawExp.dateobs,
    10         rawExp.exp_tag,
    11         rawExp.exp_name,
    12         rawExp.exp_type,
    13         rawExp.filelevel,
    14         rawExp.filter,
    15         rawExp.airmass,
    16         rawExp.ra,
    17         rawExp.decl,
    18         rawExp.exp_time,
    19         rawExp.sat_pixel_frac,
    20         rawExp.bg,
    21         rawExp.bg_stdev,
    22         rawExp.bg_mean_stdev,
    23         rawExp.alt,
    24         rawExp.az,
    25         rawExp.ccd_temp,
    26         rawExp.posang,
    27         rawExp.object,
    28         rawExp.sun_angle
    29     FROM fakeRun
    30     JOIN camRun
    31         using(cam_id)
    32     JOIN chipRun
    33         using(chip_id)
    34     JOIN rawExp
    35         using(exp_id)
    36     WHERE
    37         fakeRun.state = 'full') as Foo
     1SELECT DISTINCT
     2    fakeRun.*,
     3    chipRun.chip_id,
     4    rawExp.camera,
     5    rawExp.telescope,
     6    rawExp.dateobs,
     7    rawExp.exp_tag,
     8    rawExp.exp_name,
     9    rawExp.exp_type,
     10    rawExp.filelevel,
     11    rawExp.filter,
     12    rawExp.airmass,
     13    rawExp.ra,
     14    rawExp.decl,
     15    rawExp.exp_time,
     16    rawExp.sat_pixel_frac,
     17    rawExp.bg,
     18    rawExp.bg_stdev,
     19    rawExp.bg_mean_stdev,
     20    rawExp.alt,
     21    rawExp.az,
     22    rawExp.ccd_temp,
     23    rawExp.posang,
     24    rawExp.object,
     25    rawExp.sun_angle
     26FROM fakeRun
     27JOIN camRun
     28    using(cam_id)
     29JOIN chipRun
     30    using(chip_id)
     31JOIN rawExp
     32    using(exp_id)
     33WHERE camRun.state = 'full'
     34AND chipRun.state = 'full'
     35
Note: See TracChangeset for help on using the changeset viewer.