From 4d4dea2de301e20e3acc8d098ac14fe56eadae4e Mon Sep 17 00:00:00 2001
From: rk <rk>
Date: Tue, 25 Nov 2003 00:50:12 +0000
Subject: [PATCH] producer.xml rewrite with extratables

---
 etc/producer/producers.xml | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/etc/producer/producers.xml b/etc/producer/producers.xml
index 06d71f9e..3a82a06c 100755
--- a/etc/producer/producers.xml
+++ b/etc/producer/producers.xml
@@ -211,13 +211,13 @@
         <Define key="storageSuffix" value=".shtml"/>
         
         <List key="special" table="content c" 
-          selection="c.is_published='1' and c.to_article_type = ${articletype.topicspecial} and c.id=cxt.content_id cxt.topic_id = ${topic.id})"
+          selection="c.is_published='1' and c.to_article_type = ${articletype.topicspecial} and c.id=cxt.content_id and cxt.topic_id = ${topic.id}"
           order = "webdb_create desc" limit="1"
           extratables="content_x_topic cxt"/>
       
         <Batch key="articles" infokey="batch" table="content c" 
                process="pages" batchsize="20" minbatchsize="10"
-               selection="c.is_published='1' and c.to_article_type in (${articletype.newswire}, ${articletype.feature}) and c.id=cxt.content_id and cxt.topic_id = ${topic.id})"
+               selection="c.is_published='1' and c.to_article_type in (${articletype.newswire}, ${articletype.feature}) and c.id=cxt.content_id and cxt.topic_id = ${topic.id}"
                order="webdb_create asc" extratables="content_x_topic cxt">
           <batches>
             <Language>
-- 
2.11.0