made most commmented not check for hidden comments

[nyc.indymedia.org.git] / etc / producer / producers.xml

diff --git a/etc/producer/producers.xml b/etc/producer/producers.xml
index f7d9b22..5546f53 100755 (executable)
--- a/etc/producer/producers.xml
+++ b/etc/producer/producers.xml
@@ -594,11 +594,11 @@
       <List key="mostcomments"
                  table="content c"
                  extratables="comment cm"
-                 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,
+                 selection="c.webdb_create > NOW()-'2 weeks'::interval and c.is_published=true and and cm.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"
-                         order="count(cm.id) desc"
+                         order="count(cm.id) desc, c.webdb_create desc "
                          limit="3"
                    />