now its alpha
[nyc.indymedia.org.git] / etc / producer / producers.xml
index bcac99c..8e3445f 100755 (executable)
  <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 , t.filename ORDER BY length(t.title)"
+                                                                                WHERE t.archiv_url = 'Category' GROUP BY t.title , t.filename ORDER BY t.title"
                   type="set"/>
        <Language>          
        <Generate generator="/topiccount.template"