producer.xml rewrite with extratables
authorrk <rk>
Tue, 25 Nov 2003 00:50:12 +0000 (00:50 +0000)
committerrk <rk>
Tue, 25 Nov 2003 00:50:12 +0000 (00:50 +0000)
etc/producer/producers.xml

index 06d71f9..3a82a06 100755 (executable)
         <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>