Changeset 31407 for branches/czw_branch/20110406/ippTools/share/laptool_stacks.sql

Timestamp:

Apr 28, 2011, 6:41:17 PM (15 years ago)

Author:

watersc1

Message:

Majority of ippTools/SQL work should be complete now. Need to start queueing exposures, and testing the script

File:

• branches/czw_branch/20110406/ippTools/share/laptool_stacks.sql (modified) (8 diffs)

branches/czw_branch/20110406/ippTools/share/laptool_stacks.sql

@@ -1 @@
-SELECT lapRun.*,stacks.* FROM
+SELECT 
+       lapRun.lap_id,lapRun.seq_id,lapRun.tess_id,lapRun.projection_cell,lapRun.filter,
+       lapRun.state,lapRun.label,lapRun.dist_group,lapRun.registered,lapRun.fault,
+       skycell_id,
+       quick_sass_id,quick_data_group,quick_stack_id,quick_state,quick_fault,quick_quality,
+       final_sass_id,final_data_group,final_stack_id,final_state,final_fault,final_quality
+       FROM
        lapRun LEFT JOIN 
-       (SELECT DISTINCT * FROM (
-
+       (
+SELECT DISTINCT 
+       lap_id,tess_id,projection_cell,filter,skycell_id,
+       quick_sass_id,quick_data_group,quick_stack_id,quick_state,quick_fault,quick_quality,
+       final_sass_id,final_data_group,final_stack_id,final_state,final_fault,final_quality
+       FROM
        (select lapRun.lap_id,
                stackAssociation.sass_id AS quick_sass_id,
-               stackAssociation.data_group AS quick_data_group
+               stackAssociation.data_group AS quick_data_group,
                stackAssociation.projection_cell,
                stackAssociation.tess_id,
-               stackAssocaition.filter,
+               stackAssociation.filter,
                stackRun.stack_id AS quick_stack_id,
                stackRun.skycell_id,
@@ -19 +29 @@
            LEFT JOIN stackRun USING(stack_id)
            LEFT JOIN stackSumSkyfile USING(stack_id)
-           where lapRun.lap_id = @LAP_ID@
+           WHERE 1 @WHERE@
            AND sass_id = lapRun.quick_sass_id
-       ) AS quick USING(lap_id,projection_cell,tess_id,filter) LEFT JOIN
+       ) AS quick LEFT JOIN
        (select lapRun.lap_id,
                stackAssociation.sass_id AS final_sass_id,
@@ -27 +37 @@
                stackAssociation.projection_cell,
                stackAssociation.tess_id,
-               stackAssocaition.filter,
+               stackAssociation.filter,
                stackRun.stack_id AS final_stack_id,
                stackRun.skycell_id,
@@ -38 +48 @@
            LEFT JOIN stackRun USING(stack_id)
            LEFT JOIN stackSumSkyfile USING(stack_id)
-           where lapRun.lap_id = @LAP_ID@
+           WHERE 1 @WHERE@
            AND sass_id = lapRun.final_sass_id
        ) AS final USING(lap_id,projection_cell,tess_id,filter,skycell_id)
-
        UNION
-
+SELECT DISTINCT 
+       lap_id,tess_id,projection_cell,filter,skycell_id,
+       quick_sass_id,quick_data_group,quick_stack_id,quick_state,quick_fault,quick_quality,
+       final_sass_id,final_data_group,final_stack_id,final_state,final_fault,final_quality
+       FROM
        (select lapRun.lap_id,
                stackAssociation.sass_id AS quick_sass_id,
@@ -49 +62 @@
                stackAssociation.projection_cell,
                stackAssociation.tess_id,
-               stackAssocaition.filter,
+               stackAssociation.filter,
                stackRun.stack_id AS quick_stack_id,
                stackRun.skycell_id,
@@ -60 +73 @@
            LEFT JOIN stackRun USING(stack_id)
            LEFT JOIN stackSumSkyfile USING(stack_id)
-           where lapRun.lap_id = @LAP_ID@
+           WHERE 1 @WHERE@
            AND sass_id = lapRun.quick_sass_id
-       ) AS quick USING(lap_id,projection_cell,tess_id,filter) RIGHT JOIN
+       ) AS quick RIGHT JOIN
        (select lapRun.lap_id,
                stackAssociation.sass_id AS final_sass_id,
@@ -68 +81 @@
                stackAssociation.projection_cell,
                stackAssociation.tess_id,
-               stackAssocaition.filter,
+               stackAssociation.filter,
                stackRun.stack_id AS final_stack_id,
                stackRun.skycell_id,
@@ -79 +92 @@
            LEFT JOIN stackRun USING(stack_id)
            LEFT JOIN stackSumSkyfile USING(stack_id)
-           where lapRun.lap_id = @LAP_ID@
+           WHERE 1 @WHERE@
            AND sass_id = lapRun.final_sass_id
        ) AS final USING(lap_id,projection_cell,tess_id,filter,skycell_id)
- ) stacks USING(lap_id,projection_cell,tess_id,filter)
+ ) stacks USING(lap_id,projection_cell,tess_id,filter,quick_sass_id,final_sass_id)
+WHERE 1 @WHERE@