From 778f293a2ce5a0b7f28c2e3913a1c9d8a271fcf7 Mon Sep 17 00:00:00 2001
From: mtopper <mtopper>
Date: Tue, 9 Aug 2005 15:43:26 +0000
Subject: [PATCH] changed most commented to last two weeks

---
 etc/producer/producers.xml | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/etc/producer/producers.xml b/etc/producer/producers.xml
index 7cdd5de..f7d9b22 100755
--- a/etc/producer/producers.xml
+++ b/etc/producer/producers.xml
@@ -594,7 +594,7 @@
       <List key="mostcomments"
 	          table="content c"
 	          extratables="comment cm"
-	          selection="c.webdb_create > NOW()-'2 years'::interval and c.is_published=true and c.id=cm.to_media group by c.id,c.title,
+	          selection="c.webdb_create > NOW()-'2 weeks'::interval and c.is_published=true and c.id=cm.to_media group by c.id,c.title,
 	          			 c.subtitle,c.edittitle,c.date,c.creator,c.creator_main_url,c.creator_email,c.creator_address,c.creator_phone,c.description,
 	          			 c.comment,c.source,c.is_published,c.is_produced,c.to_publisher,c.to_language,c.to_rights,c.webdb_create,c.webdb_lastchange,
 	          			 c.content_data,c.is_html,c.to_article_type,c.to_content,c.keywords,c.to_locking_user"
-- 
2.11.0