IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Changeset 24008


Ignore:
Timestamp:
Apr 29, 2009, 6:58:09 PM (17 years ago)
Author:
bills
Message:

When joining to distRun add AND distRun.clean = distTarget.clean

Location:
trunk/ippTools/share
Files:
7 edited

Legend:

Unmodified
Added
Removed

  • trunk/ippTools/share/disttool_definebyquery_camera.sql

    r23783 r24008  
    99JOIN chipRun USING(chip_id)
    1010JOIN rawExp USING(exp_id)
    11 JOIN distTarget ON distTarget.stage = 'camera' AND rawExp.obs_mode = distTarget.obs_mode
     11JOIN distTarget ON distTarget.stage = 'camera'
     12    AND rawExp.obs_mode = distTarget.obs_mode
    1213JOIN rcInterest USING(target_id)
    13 LEFT JOIN distRun ON distRun.stage = 'camera' AND camRun.cam_id = distRun.stage_id
     14LEFT JOIN distRun ON distRun.stage = 'camera'
     15    AND camRun.cam_id = distRun.stage_id
     16    AND distRun.clean = distTarget.clean
    1417    -- JOIN hook %s
    1518WHERE distTarget.state = 'enabled'

  • trunk/ippTools/share/disttool_definebyquery_chip.sql

    r23765 r24008  
    88FROM chipRun
    99JOIN rawExp USING(exp_id)
    10 JOIN distTarget ON distTarget.stage = 'chip' AND rawExp.obs_mode = distTarget.obs_mode
     10JOIN distTarget ON distTarget.stage = 'chip'
     11    AND rawExp.obs_mode = distTarget.obs_mode
    1112JOIN rcInterest USING(target_id)
    12 LEFT JOIN distRun ON distTarget.stage = 'chip' AND distRun.stage_id = chipRun.chip_id
     13LEFT JOIN distRun ON distTarget.stage = 'chip'
     14    AND distRun.stage_id = chipRun.chip_id
     15    AND distRun.clean = distTarget.clean
    1316    -- JOIN hook %s
    1417WHERE distTarget.state = 'enabled'

  • trunk/ippTools/share/disttool_definebyquery_diff.sql

    r23765 r24008  
    1616JOIN rcInterest USING(target_id)
    1717LEFT JOIN distRun ON distRun.stage = 'diff' AND (distRun.stage_id = diff_id)
     18    AND distRun.clean = distTarget.clean
    1819    -- JOIN hook %s
    1920WHERE  distTarget.state = 'enabled'

  • trunk/ippTools/share/disttool_definebyquery_fake.sql

    r23765 r24008  
    1313JOIN rcInterest USING(target_id)
    1414LEFT JOIN distRun ON distRun.stage = 'fake' AND (distRun.stage_id = fake_id)
     15    AND distRun.clean = distTarget.clean
    1516WHERE  distTarget.state = 'enabled'
    1617    AND rcInterest.state = 'enabled'

  • trunk/ippTools/share/disttool_definebyquery_raw.sql

    r23765 r24008  
    1111JOIN rcInterest USING(target_id)
    1212LEFT JOIN distRun ON distRun.stage = 'raw' AND distRun.stage_id = exp_id
     13    AND distRun.clean = distTarget.clean
    1314    -- JOIN hook for magicked stuff %s
    1415WHERE distTarget.state = 'enabled'

  • trunk/ippTools/share/disttool_definebyquery_stack.sql

    r23968 r24008  
    1717JOIN rcInterest USING(target_id)
    1818LEFT JOIN distRun ON distRun.stage = 'stack' AND (distRun.stage_id = stack_id)
     19    AND distRun.clean = distTarget.clean
    1920    -- JOIN hook %s
    2021WHERE  distTarget.state = 'enabled'

  • trunk/ippTools/share/disttool_definebyquery_warp.sql

    r23765 r24008  
    1414JOIN rcInterest USING(target_id)
    1515LEFT JOIN distRun ON distRun.stage = 'warp' AND (distRun.stage_id = warp_id)
     16    AND distRun.clean = distTarget.clean
    1617WHERE  distTarget.state = 'enabled'
    1718    AND rcInterest.state = 'enabled'
Note: See TracChangeset for help on using the changeset viewer.