IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Ignore:
Timestamp:
Jun 24, 2024, 9:16:02 AM (2 years ago)
Author:
eugene
Message:

shakedown the xcstack-related tools; make staticsky definebyquery skycell_id selection a LIKE

File:
1 edited

Legend:

Unmodified
Added
Removed

  • branches/eam_branches/ipp-20230313/ippTools/share/xcstacktool_definebyquery_select.sql

    r42541 r42699  
    55    xcstack_id,
    66    stackRun.stack_id,
    7     tess_id,
    8     skycell_id,
    9     filter
     7    stackRun.tess_id,
     8    stackRun.skycell_id,
     9    stackRun.filter
    1010    FROM %s.stackRun
    1111    JOIN %s.stackSumSkyfile USING (stack_id)
    12     LEFT JOIN xcstackInputSkyfile
    13     ON (stackRun.stack_id = xcstackInputSkyfile.stack_id)
    14     AND (xcstackInputSkyfile.camera_id = %d)
    15     WHERE xcstack_id IS NULL
     12    LEFT JOIN
     13   
Note: See TracChangeset for help on using the changeset viewer.