Index: trunk/ippTools/share/difftool_definewarpwarp_select.sql
===================================================================
--- trunk/ippTools/share/difftool_definewarpwarp_select.sql	(revision 27444)
+++ trunk/ippTools/share/difftool_definewarpwarp_select.sql	(revision 27445)
@@ -23,4 +23,6 @@
     ON templateRawExp.exp_id = templateChipRun.exp_id
     AND templateRawExp.filter = inputRawExp.filter
+WHERE inputWarpRun.state = 'full'
+    AND templateWarpRun.state = 'full'
 -- WHERE hook %s
 GROUP BY input_warp_id
Index: trunk/ippTools/src/difftool.c
===================================================================
--- trunk/ippTools/src/difftool.c	(revision 27444)
+++ trunk/ippTools/src/difftool.c	(revision 27445)
@@ -1656,5 +1656,5 @@
     if (psListLength(selectWhere->list)) {
         psString new = psDBGenerateWhereConditionSQL(selectWhere, NULL);
-        psStringAppend(&whereClause, "\n%s %s", whereClause ? "AND" : "WHERE", new);
+        psStringAppend(&whereClause, "\nAND %s", new);
         psFree(new);
     }
@@ -1662,5 +1662,5 @@
 
     if (!rerun) {
-        psStringAppend(&whereClause, "\n%s diffs.diff_id IS NULL", whereClause ? "AND" : "WHERE");
+        psStringAppend(&whereClause, "\nAND diffs.diff_id IS NULL");
     }