IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Ignore:
Timestamp:
Nov 20, 2009, 4:13:39 PM (17 years ago)
Author:
eugene
Message:

updates from head

File:
1 edited

Legend:

Unmodified
Added
Removed

  • branches/eam_branches/20091113/ippTools/share/difftool_inputskyfile.sql

    r24677 r26236  
    2727    JOIN chipRun
    2828        USING(chip_id)
    29     JOIN chipProcessedImfile
    30         USING(chip_id)
    3129    JOIN rawExp
    32         ON chipRun.exp_id = rawExp.exp_id
    33     WHERE
    34         -- diffRun.state = 'new' AND
    35         warpRun.state = 'full'
    36         AND warpRun.state = 'full'
    37         AND fakeRun.state = 'full'
    38         AND camRun.state = 'full'
    39         AND chipRun.state = 'full'
     30        USING(exp_id)
    4031        -- where hook %s
    4132    UNION
    … …  
    6758    JOIN chipRun
    6859        USING(chip_id)
    69     JOIN chipProcessedImfile
    70         USING(chip_id)
    7160    JOIN rawExp
    72         ON chipRun.exp_id = rawExp.exp_id
    73     WHERE
    74         -- diffRun.state = 'new' AND
    75         warpRun.state = 'full'
    76         AND fakeRun.state = 'full'
    77         AND camRun.state = 'full'
    78         AND chipRun.state = 'full'
     61        USING(exp_id)
    7962        -- where hook %s
    8063    UNION
    … …  
    10790        USING(chip_id)
    10891    JOIN rawExp
    109         ON chipRun.exp_id = rawExp.exp_id
    110     WHERE
    111         (diffRun.state = 'new' or diffRun.state = 'full')
     92        USING(exp_id)
    11293        -- where hook %s
    11394    UNION
    … …  
    140121        USING(chip_id)
    141122    JOIN rawExp
    142         ON chipRun.exp_id = rawExp.exp_id
    143     WHERE
    144         (diffRun.state = 'new' or diffRun.state = 'full')
     123        USING(exp_id)
    145124        -- where hook %s
    146125    ) as Foo
     126-- template where hook %s
Note: See TracChangeset for help on using the changeset viewer.