IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Ignore:
Timestamp:
Mar 30, 2009, 2:52:04 PM (17 years ago)
Author:
Paul Price
Message:

Fixing warptool -definebyquery search terms.

File:
1 edited

Legend:

Unmodified
Added
Removed

  • trunk/ippTools/share/warptool_definebyquery.sql

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