<body>
<FreeQuery key="topicCounts" query=" SELECT count(x.content_id) as count, t.title, t.filename FROM topic as t LEFT OUTER JOIN content_x_topic
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)"
+ WHERE t.archiv_url = 'Category' GROUP BY t.title , t.filename ORDER BY length(t.title)"
type="set"/>
<Language>
<Generate generator="/topiccount.template"
- destination="${config.storageRoot}/${pathprefix}/topiccount.html" />
+ destination="${config.storageRoot}/topiccount.html" />
</Language>
</body>
</producer>
projects / nyc.indymedia.org.git / commitdiff