Changeset 30178
- Timestamp:
- Dec 26, 2010, 6:57:38 AM (15 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/ippTools/share/regtool_pendingburntoolimfile.sql
r30049 r30178 23 23 LEFT JOIN pzDownloadExp USING(exp_name) 24 24 LEFT JOIN newExp ON exp_name = tmp_exp_name 25 LEFT JOIN newImfile USING(exp_id)25 LEFT JOIN newImfile USING(exp_id) 26 26 LEFT JOIN rawExp USING(exp_id, exp_name) 27 27 LEFT JOIN rawImfile ON (rawImfile.exp_name = newExp.tmp_exp_name AND rawImfile.tmp_class_id = newImfile.tmp_class_id) 28 28 WHERE 29 29 summitExp.dateobs >= '@DATE@T00:00:00' 30 AND summitExp.dateobs <= '@DATE@T23:59:59'30 AND summitExp.dateobs <= '@DATE@T23:59:59' 31 31 ORDER BY newImfile.tmp_class_id,summitExp.dateobs
Note:
See TracChangeset
for help on using the changeset viewer.
