Index: /branches/pap_mops/ippTools/share/pubtool_definerun.sql
===================================================================
--- /branches/pap_mops/ippTools/share/pubtool_definerun.sql	(revision 24436)
+++ /branches/pap_mops/ippTools/share/pubtool_definerun.sql	(revision 24437)
@@ -13,5 +13,5 @@
         AND diffRun.state = 'full'
     -- WHERE hook %s
-    ) AS publishDiffs UNION (
+    UNION
     -- Get cameras to publish
     SELECT
@@ -23,6 +23,6 @@
         AND camRun.state = 'full'
     -- WHERE hook %s
-    ) AS publishCams
+    ) AS publishToDo
 -- Only get stuff that hasn't been published
 LEFT JOIN publishRun USING(client_id, stage_id)
-WHERE publishRun.client_id IS NOT NULL
+WHERE publishRun.client_id IS NULL