X-Git-Url: http://erislabs.net/gitweb/?a=blobdiff_plain;f=etc%2Fproducer%2Fproducers.xml;h=73c45b15ec1dca5ad9fc0f3caba8ac613ea9fa35;hb=d7462f564439280ef41b70c2e568e0af41934e55;hp=7444f703a8eb1aa2e256ddbab4585d564644df5d;hpb=faed77a5635656dfb5136c39b820c29fb5c2fd66;p=nyc.indymedia.org.git
diff --git a/etc/producer/producers.xml b/etc/producer/producers.xml
index 7444f70..73c45b1 100755
--- a/etc/producer/producers.xml
+++ b/etc/producer/producers.xml
@@ -1,6 +1,5 @@
-
+
+
+
+
-
+
+
+
+
@@ -385,6 +389,16 @@
+
+
+
+
+
+
+
+
+
+
@@ -536,7 +550,7 @@
-
@@ -575,10 +589,17 @@
+
+
+
+
+
+
+
NOW()-'1 week'::interval and c.is_published=true 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"
/>
@@ -694,8 +715,8 @@
@@ -802,7 +823,7 @@