changed tolpoiccount to past day

author mtopper <mtopper>

Thu, 4 Aug 2005 21:04:32 +0000 (21:04 +0000)

committer mtopper <mtopper>

Thu, 4 Aug 2005 21:04:32 +0000 (21:04 +0000)
author mtopper <mtopper>
Thu, 4 Aug 2005 21:04:32 +0000 (21:04 +0000)
committer mtopper <mtopper>
Thu, 4 Aug 2005 21:04:32 +0000 (21:04 +0000)
diff --git a/etc/producer/producers.xml b/etc/producer/producers.xml

index 8e3445f..61f4a3a 100755 (executable)
--- a/etc/producer/producers.xml
+++ b/etc/producer/producers.xml
@@ -766,7 +766,7 @@
   <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 t.title"
+                                                                                WHERE c.webdb_create > NOW()-'1 day'::interval t.archiv_url = 'Category' GROUP BY t.title , t.filename ORDER BY t.title"
                    type="set"/>
         <Language>          
         <Generate generator="/topiccount.template"