Index: trunk/ippTools/share/regtool_finishcompressexp.sql
===================================================================
--- trunk/ippTools/share/regtool_finishcompressexp.sql	(revision 27198)
+++ trunk/ippTools/share/regtool_finishcompressexp.sql	(revision 27199)
@@ -67,23 +67,16 @@
     magicked
 FROM
-    (SELECT
-	rawExp.*,
-	count(rawImfile.class_id) AS complete,
-	count(newImfile.tmp_class_id) AS total
-	FROM rawExp
-	JOIN newImfile
-	     ON rawExp.exp_id = newImfile.exp_id
-	LEFT JOIN rawImfile
-	     ON rawExp.exp_id = rawImfile.exp_id
-	     AND rawImfile.tmp_class_id = newImfile.tmp_class_id
-	WHERE
-	     ((rawExp.state = 'goto_compressed' 
-	       AND rawImfile.data_state = 'compressed')OR
-	      (rawExp.state = 'goto_lossy'
-	       AND rawImfile.data_state = 'lossy'))
-	GROUP BY
-	      rawExp.exp_id
-      ) as foo
-      WHERE (foo.complete = foo.total)
+    (SELECT V.*,
+     count(class_id) AS complete
+     FROM 
+     	  (SELECT rawExp.*,count(newImfile.tmp_class_id) AS total
+	   FROM rawExp
+	   LEFT JOIN newImfile ON rawExp.exp_id = newImfile.exp_id
+	   WHERE (rawExp.state = 'goto_compressed' OR rawExp.state = 'goto_lossy') 
+	   GROUP BY rawExp.exp_id) AS V
+     JOIN rawImfile ON V.exp_id = rawImfile.exp_id
+     WHERE ((V.state = 'goto_compressed' AND rawImfile.data_state = 'compressed') OR
+     	    (V.state = 'goto_lossy' AND rawImfile.data_state = 'lossy'))
+     GROUP BY V.exp_id) as foo
+WHERE (foo.complete = foo.total)
 	
-