Index: trunk/ippTools/share/faketool_pendingimfile.sql
===================================================================
--- trunk/ippTools/share/faketool_pendingimfile.sql	(revision 18125)
+++ trunk/ippTools/share/faketool_pendingimfile.sql	(revision 18793)
@@ -1,6 +1,6 @@
-SELECT DISTINCT * FROM 
-     -- the subselect is so where criteria can be specified without knowing
-     -- which table the field came from
-    (SELECT
+SELECT DISTINCT * FROM (
+    -- the subselect is so where criteria can be specified without knowing
+    -- which table the field came from
+    SELECT
         fakeRun.*,
         chipProcessedImfile.exp_id,
@@ -29,16 +29,13 @@
         rawExp.filelevel
     FROM fakeRun
-    JOIN camRun
-        USING(cam_id)
-    JOIN camProcessedExp
-        USING(cam_id)
-    JOIN chipRun
-        USING(chip_id)
-    JOIN chipProcessedImfile
-        USING(chip_id)
+    JOIN camRun USING(cam_id)
+    JOIN camProcessedExp USING(cam_id)
+    JOIN chipRun USING(chip_id)
+    JOIN chipProcessedImfile USING(chip_id)
     JOIN rawExp
         ON chipProcessedImfile.exp_id = rawExp.exp_id
     LEFT JOIN fakeProcessedImfile
         ON fakeRun.fake_id = fakeProcessedImfile.fake_id
+        AND chipProcessedImfile.class_id = fakeProcessedImfile.class_id
     LEFT JOIN fakeMask
         ON fakeRun.label = fakeMask.label
@@ -47,3 +44,3 @@
         AND fakeProcessedImfile.class_id IS NULL
         AND fakeMask.label IS NULL
-    ) as foo
+    ) as fakePendingImfile