Changeset 32218 for trunk/ippTools/share
- Timestamp:
- Aug 29, 2011, 6:13:55 PM (15 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/ippTools/share/difftool_pendingcleanuprun.sql
r26927 r32218 2 2 -- all of this is just to get the camera used for the diff run 3 3 SELECT DISTINCT * FROM 4 (SELECT 4 (SELECT DISTINCT 5 5 diffRun.diff_id, 6 6 rawExp.camera, … … 29 29 diffRun.state = 'goto_scrubbed' OR 30 30 diffRun.state = 'goto_purged') 31 @INNERLIMITS@ 31 32 UNION 32 SELECT 33 SELECT DISTINCT 33 34 diffRun.diff_id, 34 35 rawExp.camera, … … 57 58 diffRun.state = 'goto_scrubbed' OR 58 59 diffRun.state = 'goto_purged') 60 @INNERLIMITS@ 59 61 UNION 60 SELECT 62 SELECT DISTINCT 61 63 diffRun.diff_id, 62 64 rawExp.camera, … … 85 87 diffRun.state = 'goto_scrubbed' OR 86 88 diffRun.state = 'goto_purged') 89 @INNERLIMITS@ 87 90 UNION 88 SELECT 91 SELECT DISTINCT 89 92 diffRun.diff_id, 90 93 rawExp.camera, … … 113 116 diffRun.state = 'goto_scrubbed' OR 114 117 diffRun.state = 'goto_purged') 118 @INNERLIMITS@ 115 119 ) as Foo 116 120 WHERE 1
Note:
See TracChangeset
for help on using the changeset viewer.
