Changeset 31761

Timestamp:

Jun 29, 2011, 9:20:47 AM (15 years ago)

Author:

Serge CHASTEL

Message:

LAP stacks

File:

• branches/sc_branches/ippMonitorLap/def/lapStacks.d (modified) (2 diffs)

branches/sc_branches/ippMonitorLap/def/lapStacks.d

@@ -1 @@
-TABLE lapRun LEFT JOIN (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.projection_cell,               stackAssociation.tess_id,               stackAssociation.filter,               stackRun.stack_id AS quick_stack_id,               stackRun.skycell_id,               stackRun.state AS quick_state,               stackSumSkyfile.fault AS quick_fault,               stackSumSkyfile.quality AS quick_quality FROM           lapRun            LEFT JOIN stackAssociation ON (lapRun.quick_sass_id = stackAssociation.sass_id)           LEFT JOIN stackAssociationMap USING (sass_id)           LEFT JOIN stackRun USING(stack_id)           LEFT JOIN stackSumSkyfile USING(stack_id)           WHERE 1 @WHERE@           AND sass_id = lapRun.quick_sass_id       ) AS quick LEFT JOIN       (select lapRun.lap_id,               stackAssociation.sass_id AS final_sass_id,               stackAssociation.data_group AS final_data_group,               stackAssociation.projection_cell,               stackAssociation.tess_id,               stackAssociation.filter,               stackRun.stack_id AS final_stack_id,               stackRun.skycell_id,               stackRun.state AS final_state,               stackSumSkyfile.fault AS final_fault,               stackSumSkyfile.quality AS final_quality FROM           lapRun            LEFT JOIN stackAssociation ON (lapRun.final_sass_id = stackAssociation.sass_id)           LEFT JOIN stackAssociationMap USING (sass_id)           LEFT JOIN stackRun USING(stack_id)           LEFT JOIN stackSumSkyfile USING(stack_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,               stackAssociation.data_group AS quick_data_group,               stackAssociation.projection_cell,               stackAssociation.tess_id,               stackAssociation.filter,               stackRun.stack_id AS quick_stack_id,               stackRun.skycell_id,               stackRun.state AS quick_state,               stackSumSkyfile.fault AS quick_fault,               stackSumSkyfile.quality AS quick_quality FROM           lapRun            LEFT JOIN stackAssociation ON (lapRun.quick_sass_id = stackAssociation.sass_id)           LEFT JOIN stackAssociationMap USING (sass_id)           LEFT JOIN stackRun USING(stack_id)           LEFT JOIN stackSumSkyfile USING(stack_id)           WHERE 1 @WHERE@           AND sass_id = lapRun.quick_sass_id       ) AS quick RIGHT JOIN       (select lapRun.lap_id,               stackAssociation.sass_id AS final_sass_id,               stackAssociation.data_group AS final_data_group,               stackAssociation.projection_cell,               stackAssociation.tess_id,               stackAssociation.filter,               stackRun.stack_id AS final_stack_id,               stackRun.skycell_id,               stackRun.state AS final_state,               stackSumSkyfile.fault AS final_fault,               stackSumSkyfile.quality AS final_quality FROM           lapRun            LEFT JOIN stackAssociation ON (lapRun.final_sass_id = stackAssociation.sass_id)           LEFT JOIN stackAssociationMap USING (sass_id)           LEFT JOIN stackRun USING(stack_id)           LEFT JOIN stackSumSkyfile USING(stack_id)           WHERE 1 @WHERE@           AND sass_id = lapRun.final_sass_id       ) AS final USING(lap_id,projection_cell,tess_id,filter,skycell_id) ) stacks ON (stacks.lap_id = lapRun.lap_id AND             stacks.projection_cell = lapRun.projection_cell AND             stacks.tess_id = lapRun.tess_id AND             stacks.filter = lapRun.filter AND             (lapRun.quick_sass_id IS NULL OR lapRun.quick_sass_id = stacks.quick_sass_id) AND             (lapRun.final_sass_id IS NULL OR lapRun.final_sass_id = stacks.final_sass_id))
+TABLE lapRun LEFT JOIN (SELECT DISTINCT lap_id,tess_id,projection_cell,filter,stackRun.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.projection_cell,               stackAssociation.tess_id,               stackAssociation.filter,               stackRun.stack_id AS quick_stack_id,               stackRun.skycell_id,               stackRun.state AS quick_state,               stackSumSkyfile.fault AS quick_fault,               stackSumSkyfile.quality AS quick_quality FROM           lapRun            LEFT JOIN stackAssociation ON (lapRun.quick_sass_id = stackAssociation.sass_id)           LEFT JOIN stackAssociationMap USING (sass_id)           LEFT JOIN stackRun USING(stack_id)           LEFT JOIN stackSumSkyfile USING(stack_id)           WHERE 1 @WHERE@           AND sass_id = lapRun.quick_sass_id       ) AS quick LEFT JOIN       (select lapRun.lap_id,               stackAssociation.sass_id AS final_sass_id,               stackAssociation.data_group AS final_data_group,               stackAssociation.projection_cell,               stackAssociation.tess_id,               stackAssociation.filter,               stackRun.stack_id AS final_stack_id,               stackRun.skycell_id,               stackRun.state AS final_state,               stackSumSkyfile.fault AS final_fault,               stackSumSkyfile.quality AS final_quality FROM           lapRun            LEFT JOIN stackAssociation ON (lapRun.final_sass_id = stackAssociation.sass_id)           LEFT JOIN stackAssociationMap USING (sass_id)           LEFT JOIN stackRun USING(stack_id)           LEFT JOIN stackSumSkyfile USING(stack_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,               stackAssociation.data_group AS quick_data_group,               stackAssociation.projection_cell,               stackAssociation.tess_id,               stackAssociation.filter,               stackRun.stack_id AS quick_stack_id,               stackRun.skycell_id,               stackRun.state AS quick_state,               stackSumSkyfile.fault AS quick_fault,               stackSumSkyfile.quality AS quick_quality FROM           lapRun            LEFT JOIN stackAssociation ON (lapRun.quick_sass_id = stackAssociation.sass_id)           LEFT JOIN stackAssociationMap USING (sass_id)           LEFT JOIN stackRun USING(stack_id)           LEFT JOIN stackSumSkyfile USING(stack_id)           WHERE 1 @WHERE@           AND sass_id = lapRun.quick_sass_id       ) AS quick RIGHT JOIN       (select lapRun.lap_id,               stackAssociation.sass_id AS final_sass_id,               stackAssociation.data_group AS final_data_group,               stackAssociation.projection_cell,               stackAssociation.tess_id,               stackAssociation.filter,               stackRun.stack_id AS final_stack_id,               stackRun.skycell_id,               stackRun.state AS final_state,               stackSumSkyfile.fault AS final_fault,               stackSumSkyfile.quality AS final_quality FROM           lapRun            LEFT JOIN stackAssociation ON (lapRun.final_sass_id = stackAssociation.sass_id)           LEFT JOIN stackAssociationMap USING (sass_id)           LEFT JOIN stackRun USING(stack_id)           LEFT JOIN stackSumSkyfile USING(stack_id)           WHERE 1 @WHERE@           AND sass_id = lapRun.final_sass_id       ) AS final USING(lap_id,projection_cell,tess_id,filter,skycell_id) ) stacks ON (stacks.lap_id = lapRun.lap_id AND             stacks.projection_cell = lapRun.projection_cell AND             stacks.tess_id = lapRun.tess_id AND             stacks.filter = lapRun.filter AND             (lapRun.quick_sass_id IS NULL OR lapRun.quick_sass_id = stacks.quick_sass_id) AND             (lapRun.final_sass_id IS NULL OR lapRun.final_sass_id = stacks.final_sass_id))
 TITLE LAP Stacks
 FILE  lapStacks.php
@@ -28 +28 @@
 FIELD lapRun.registered,      19, %T,    Registered
 FIELD lapRun.fault,           3, %d,     fault
-FIELD skycell_id
+FIELD stackRun.skycell_id
 FIELD lapRun.quick_sass_id,
 FIELD quick_data_group,