Changeset 31511 for trunk/ippTools/share/laptool_definerun.sql

Timestamp:

May 10, 2011, 1:51:21 PM (15 years ago)

Author:

watersc1

Message:

Update laptool_definerun to not attempt to define two rows for the same exp_id. Speed up laptool_exposures, as well as add better quality handling for lap_science.pl

File:

• trunk/ippTools/share/laptool_definerun.sql (modified) (1 diff)

trunk/ippTools/share/laptool_definerun.sql

@@ -8 +8 @@
   ) AS want
   LEFT JOIN 
-  (SELECT *
+  (SELECT exp_id,MAX(chip_id) AS chip_id
      FROM lapExp 
      where private IS FALSE