Changeset 24438 for branches/pap_mops/ippTools/share/pubtool_pending.sql

Timestamp:

Jun 16, 2009, 2:24:25 PM (17 years ago)

Author:

Paul Price

Message:

Fixes to get workflow working.

File:

• branches/pap_mops/ippTools/share/pubtool_pending.sql (modified) (3 diffs)

branches/pap_mops/ippTools/share/pubtool_pending.sql

@@ -1 +1 @@
 SELECT
     publishToDo.*
-FROM ((
+FROM (
     SELECT
         publishRun.pub_id,
@@ -16 +16 @@
         AND publishRun.state = 'new'
         AND diffRun.state = 'full'
-    ) AS publishDiffs UNION (
+    UNION
     SELECT
         publishRun.pub_id,
@@ -30 +30 @@
         AND publishRun.state ='new'
         AND camRun.state = 'full'
-    ) AS publishCams
 ) AS publishToDo
 LEFT JOIN publishDone USING(pub_id)