Index: /branches/bills_081204/ippTools/share/difftool_completed_runs.sql
===================================================================
--- /branches/bills_081204/ippTools/share/difftool_completed_runs.sql	(revision 20904)
+++ /branches/bills_081204/ippTools/share/difftool_completed_runs.sql	(revision 20904)
@@ -0,0 +1,16 @@
+SELECT DISTINCT
+    diff_id
+FROM (
+    SELECT
+        diffSkyfile.*
+    FROM diffRun
+    JOIN diffInputSkyfile USING(diff_id)
+    LEFT JOIN diffSkyfile USING(diff_id)
+    WHERE 
+        diffRun.state = 'new'
+    GROUP BY
+        diffSkyfile.diff_id
+    HAVING
+        COUNT(diffInputSkyfile.diff_id) = COUNT(diffSkyfile.diff_id)
+        AND SUM(diffSkyfile.fault) = 0
+    ) as Foo