Changeset 30283 for trunk/ippTools/share/regtool_pendingburntoolimfile.sql

Timestamp:

Jan 14, 2011, 7:24:31 PM (15 years ago)

Author:

watersc1

Message:

is_daytime fix in register_imfile; bad class_ids in regtool; bad joins in the SQL

File:

• trunk/ippTools/share/regtool_pendingburntoolimfile.sql (modified) (2 diffs)

trunk/ippTools/share/regtool_pendingburntoolimfile.sql

@@ -12 +12 @@
        newImfile.tmp_class_id,
        summitExp.exp_type,
-       rawExp.dateobs,
-       rawExp.obs_mode AS obs_mode,
-       rawExp.object AS object,
+       rawImfile.dateobs,
+       rawImfile.obs_mode AS obs_mode,
+       rawImfile.object AS object,
        rawImfile.burntool_state AS burntool_state,
        rawImfile.class_id,
@@ -27 +27 @@
        LEFT JOIN newImfile ON (summitImfile.class_id = newImfile.tmp_class_id AND newExp.exp_id = newImfile.exp_id)
        LEFT JOIN rawExp ON rawExp.exp_id = newExp.exp_id
-       LEFT JOIN rawImfile ON (rawImfile.exp_id = rawExp.exp_id AND rawImfile.tmp_class_id = newImfile.tmp_class_id)
+       LEFT JOIN rawImfile ON (rawImfile.exp_id = newExp.exp_id AND rawImfile.tmp_class_id = newImfile.tmp_class_id)
        WHERE
              summitExp.dateobs >= '@DATEOBS_BEGIN@'