IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Ignore:
Timestamp:
Sep 22, 2010, 3:05:52 PM (16 years ago)
Author:
bills
Message:

don't join to magicDSRuns in state 'drop'

File:
1 edited

Legend:

Unmodified
Added
Removed

  • trunk/ippTools/share/chiptool_listrun.sql

    r28586 r29200  
    2929LEFT JOIN camProcessedExp USING(cam_id)
    3030LEFT JOIN magicDSRun
    31     ON stage_id = chip_id AND stage = 'chip' AND magicDSRun.re_place
     31    ON stage_id = chip_id AND stage = 'chip' AND magicDSRun.re_place AND magicDSRun.state != 'drop'
Note: See TracChangeset for help on using the changeset viewer.