<Batch key="articles" infokey="batch" table="content"
process="pages" batchsize="20" minbatchsize="10"
<Batch key="articles" infokey="batch" table="content"
process="pages" batchsize="20" minbatchsize="10"
<Batch key="articles" infokey="batch" table="content"
process="pages" batchsize="20" minbatchsize="10"
<Batch key="articles" infokey="batch" table="content"
process="pages" batchsize="20" minbatchsize="10"
as x ON (t.id=x.topic_id) LEFT OUTER JOIN content as c ON (c.id=x.content_id)
WHERE t.archiv_url = 'Category' GROUP BY t.title ORDER BY length(t.title)"
type="set"/>
as x ON (t.id=x.topic_id) LEFT OUTER JOIN content as c ON (c.id=x.content_id)
WHERE t.archiv_url = 'Category' GROUP BY t.title ORDER BY length(t.title)"
type="set"/>
<Log message="Getting Last 5 articles for category: ${category.title} - counter: ${counter}" />
<Define key="topictitle" value="${category.title}" />
<Log message="Getting Last 5 articles for category: ${category.title} - counter: ${counter}" />
<Define key="topictitle" value="${category.title}" />
<List key="randomarticles" table="content"
selection ="id in (select content_id from content_x_topic where topic_id = ${category.id})" order="date DESC"
<List key="randomarticles" table="content"
selection ="id in (select content_id from content_x_topic where topic_id = ${category.id})" order="date DESC"