Changeset 24437 for branches/pap_mops/ippTools/share/pubtool_definerun.sql

Timestamp:

Jun 16, 2009, 2:03:06 PM (17 years ago)

Author:

Paul Price

Message:

Fixing query.

File:

• branches/pap_mops/ippTools/share/pubtool_definerun.sql (modified) (2 diffs)

branches/pap_mops/ippTools/share/pubtool_definerun.sql

@@ -13 +13 @@
         AND diffRun.state = 'full'
     -- WHERE hook %s
-    ) AS publishDiffs UNION (
+    UNION
     -- Get cameras to publish
     SELECT
@@ -23 +23 @@
         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