Index: trunk/ippTools/share/Makefile.am
===================================================================
--- trunk/ippTools/share/Makefile.am	(revision 38062)
+++ trunk/ippTools/share/Makefile.am	(revision 38080)
@@ -525,4 +525,5 @@
 	remotetool_definebyquery_stack.sql \
 	remotetool_definebyquery_staticsky.sql \
+	remotetool_definebyquery_diff.sql \
 	remotetool_dropcomponent.sql \
 	remotetool_listcomponent.sql \
Index: trunk/ippTools/share/remotetool_definebyquery_diff.sql
===================================================================
--- trunk/ippTools/share/remotetool_definebyquery_diff.sql	(revision 38080)
+++ trunk/ippTools/share/remotetool_definebyquery_diff.sql	(revision 38080)
@@ -0,0 +1,21 @@
+SELECT stage_id FROM
+
+( SELECT diff_id AS stage_id
+    FROM diffRun
+WHERE
+diffRun.state = 'new'
+-- where hook %s
+GROUP BY diff_id
+) AS W
+
+LEFT JOIN
+
+(SELECT remote_id,remoteRun.stage,remoteRun.label,remoteComponent.stage_id,remoteRun.state
+   FROM remoteRun
+   JOIN remoteComponent USING(remote_id)
+WHERE
+remoteRun.stage = 'staticsky' AND remoteComponent.state != 'retry'
+-- where hook %s
+) AS R
+USING(stage_id)
+WHERE R.remote_id IS NULL