producer.xml rewrite with extratables

diff --git a/etc/producer/producers.xml b/etc/producer/producers.xml
index 8f15803..06d71f9 100755 (executable)
--- a/etc/producer/producers.xml
+++ b/etc/producer/producers.xml
@@ -210,14 +210,15 @@
         <Define key="docSuffix" value=".shtml"/>
         <Define key="storageSuffix" value=".shtml"/>
         
-        <List key="special" table="content" 
-          selection="is_published='1' and to_article_type = ${articletype.topicspecial} and id in (select content_id from content_x_topic where topic_id = ${topic.id})"
-          order = "webdb_create desc" limit="1"/>
+        <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})"
+          order = "webdb_create desc" limit="1"
+          extratables="content_x_topic cxt"/>
       
-        <Batch key="articles" infokey="batch" table="content" 
+        <Batch key="articles" infokey="batch" table="content c" 
                process="pages" batchsize="20" minbatchsize="10"
-               selection="is_published='1' and to_article_type in (${articletype.newswire}, ${articletype.feature}) and id in (select content_id from content_x_topic where topic_id = ${topic.id})"
-               order="webdb_create asc">
+               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>
               <Define key="pagePrefix" value="${pathprefix}/${topic.filename}/archive"/>