IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Changeset 28627


Ignore:
Timestamp:
Jul 7, 2010, 3:13:55 PM (16 years ago)
Author:
bills
Message:

list magicDSRun state and magic_ds_id in -listrun and -warped

Location:
trunk/ippTools/share
Files:
2 edited

Legend:

Unmodified
Added
Removed

  • trunk/ippTools/share/warptool_listrun.sql

    r27880 r28627  
    1010    rawExp.ra,
    1111    rawExp.decl,
    12     rawExp.exp_time
     12    rawExp.exp_time,
     13    magicDSRun.state AS dsRun_state,
     14    IFNULL(magicDSRun.magic_ds_id, 0) AS magic_ds_id
    1315FROM warpRun
    1416JOIN fakeRun
    … …  
    2022JOIN rawExp
    2123    ON chipRun.exp_id  = rawExp.exp_id
     24LEFT JOIN magicDSRun
     25    ON stage = 'warp' AND stage_id = warp_id

  • trunk/ippTools/share/warptool_warped.sql

    r27880 r28627  
    1212    rawExp.ra,
    1313    rawExp.decl,
    14     rawExp.exp_time
     14    rawExp.exp_time,
     15    magicDSRun.state AS dsRun_state,
     16    IFNULL(magicDSRun.magic_ds_id, 0) AS magic_ds_id
    1517FROM warpRun
    1618JOIN warpSkyfile
    … …  
    2628JOIN rawExp
    2729    ON chipRun.exp_id  = rawExp.exp_id
     30LEFT JOIN magicDSRun
     31    ON stage = 'warp' AND stage_id = warp_id
Note: See TracChangeset for help on using the changeset viewer.