<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"/>