Changeset 24268 for trunk/ippScripts/scripts/ipp_serial_mops_warps.pl

Timestamp:

May 27, 2009, 5:18:20 PM (17 years ago)

Author:

Paul Price

Message:

Need to use trick to get corresponding value for MAX() field.

File:

• trunk/ippScripts/scripts/ipp_serial_mops_warps.pl (modified) (1 diff)

trunk/ippScripts/scripts/ipp_serial_mops_warps.pl

@@ -78 +78 @@
 SELECT
     rawExp.exp_id,
-    camProcessedExp.zpt_obs,
-    MAX(warpRun.warp_id) AS warp_id
+    MAX(warpRun.warp_id) AS warp_id,
+    -- The following trick pulls out the 'zpt_obs' value for the maximum warp_id
+    CONVERT(SUBSTRING_INDEX(GROUP_CONCAT(camProcessedExp.zpt_obs ORDER BY warpRun.warp_id), ',', 1), UNSIGNED) AS zpt_obs
 FROM warpRun
 JOIN fakeRun USING(fake_id)