Index: trunk/ippTools/share/difftool_definewarpstack_part1.sql
===================================================================
--- trunk/ippTools/share/difftool_definewarpstack_part1.sql	(revision 26139)
+++ trunk/ippTools/share/difftool_definewarpstack_part1.sql	(revision 26144)
@@ -25,4 +25,5 @@
     JOIN chipRun USING(chip_id)
     WHERE warp1 IS NOT NULL
+        AND warpRun.state = 'full'
     -- warp where hook %s
 ) AS diffExp USING(exp_id, warp_id)
Index: trunk/ippTools/src/difftool.c
===================================================================
--- trunk/ippTools/src/difftool.c	(revision 26139)
+++ trunk/ippTools/src/difftool.c	(revision 26144)
@@ -1205,10 +1205,4 @@
     psFree(warp2Where);
 
-    if (!available) {
-        // diff what's available, even if warp run has some faults and is incomplete
-        psStringAppend(&warp1Query, " AND warpRun.state = 'full'");
-        psStringAppend(&warp2Query, " AND warpRun.state = 'full'");
-    }
-
     // don't queue for exposures that have already been diff'd unless requested
     psString diffQuery = NULL;
@@ -1392,5 +1386,5 @@
 
         if (num == 0) {
-            psTrace("difftool", PS_LOG_INFO, "no skycells with stack found for %" PRId64, warp_id);
+            psTrace("difftool", PS_LOG_INFO, "no skycells with stack found for warp_id %" PRId64, warp_id);
             continue;
         }
@@ -1398,5 +1392,5 @@
         if (!available && (num != skycell_count)) {
             psTrace("difftool", PS_LOG_INFO, "%" PRId64 " skyfiles with stack found for warp_id %" PRId64
-                    " need %" PRId64, num, warp_id, skycell_count);
+                    " but need %" PRId64, num, warp_id, skycell_count);
             continue;
         }
Index: trunk/ippTools/src/difftoolConfig.c
===================================================================
--- trunk/ippTools/src/difftoolConfig.c	(revision 26139)
+++ trunk/ippTools/src/difftoolConfig.c	(revision 26144)
@@ -192,5 +192,5 @@
     psMetadataAddBool(definewarpstackArgs, PS_LIST_TAIL, "-new-templates", 0, "also search for diffs with new template", false);
     psMetadataAddBool(definewarpstackArgs, PS_LIST_TAIL, "-rerun", 0, "define new run even if one exists", false);
-    psMetadataAddBool(definewarpstackArgs, PS_LIST_TAIL, "-available", 0, "define new run even if warpRun has some faults", false);
+    psMetadataAddBool(definewarpstackArgs, PS_LIST_TAIL, "-available", 0, "define new run even if no stacks available for some skycells", false);
     psMetadataAddBool(definewarpstackArgs, PS_LIST_TAIL, "-simple", 0, "use the simple output format", false);
     psMetadataAddBool(definewarpstackArgs, PS_LIST_TAIL, "-pretend", 0, "list results but to not queue", false);
@@ -328,5 +328,5 @@
     PXOPT_ADD_MODE("-topurgedskyfile", "set skyfile as purged", DIFFTOOL_MODE_TOPURGEDSKYFILE, topurgedskyfileArgs);
     PXOPT_ADD_MODE("-toscrubbedskyfile", "set skyfile as scrubbed", DIFFTOOL_MODE_TOSCRUBBEDSKYFILE, toscrubbedskyfileArgs);
-    
+
     if (!pxGetOptions(stderr, argc, argv, config, modes, argSets)) {
         psError(PS_ERR_UNKNOWN, true, "option parsing failed");