Changeset 28375 for trunk/ippTools/share/stacktool_associationdefine_select.sql

Timestamp:

Jun 16, 2010, 5:30:27 PM (16 years ago)

Author:

watersc1

Message:

merge of stack association and warp/stack/diff jpegs

Location:

trunk

Files:

• . (modified) (1 prop)
• ippTools/share/stacktool_associationdefine_select.sql (copied) (copied from branches/czw_branch/20100519/ippTools/share/stacktool_associationdefine_select.sql ) (1 diff)

trunk/ippTools/share/stacktool_associationdefine_select.sql

@@ -2 +2 @@
        sass_id,
        data_group,
+       projection_cell,
        tess_id,
-       filter,
-       CASE WHEN LOCATE('.',skycell_id,9) > 0 THEN
-            SUBSTRING_INDEX(skycell_id,'.',2) ELSE
-            SUBSTRING_INDEX(skycell_id,'.',1) END
-       AS projection_cell
+       filter
+       FROM stackAssociation
+RIGHT JOIN (
+      SELECT 
+             data_group,
+             tess_id,
+             filter,
+             CASE WHEN LOCATE('.',skycell_id,9) > 0 THEN
+                  SUBSTRING_INDEX(skycell_id,'.',2) ELSE
+                  SUBSTRING_INDEX(skycell_id,'.',1) END
+             AS projection_cell
        FROM stackRun 
-       LEFT JOIN stackAssociationMap USING (stack_id)
-       WHERE stackRun.stack_id = @STACK_ID@
+       WHERE stackRun.stack_id = @STACK_ID@ 
+             ) AS RUN USING (data_group,tess_id,filter,projection_cell) LIMIT 1