X-Git-Url: http://erislabs.net/gitweb/?a=blobdiff_plain;f=etc%2Fproducer%2Fproducers.xml;h=73c45b15ec1dca5ad9fc0f3caba8ac613ea9fa35;hb=d7462f564439280ef41b70c2e568e0af41934e55;hp=61f4a3acd2c702867a5f46a412de9c046addd2d4;hpb=d22dc4b2e906620d16cf91cb5bc610f6a0a9c50d;p=nyc.indymedia.org.git
diff --git a/etc/producer/producers.xml b/etc/producer/producers.xml
index 61f4a3a..73c45b1 100755
--- a/etc/producer/producers.xml
+++ b/etc/producer/producers.xml
@@ -1,6 +1,5 @@
-
+
-
+
-
+
+
+
+
+
+
+
+
+
+
+
-
+
+
+
+
-
+
-
+
-
+
+
@@ -375,6 +389,16 @@
+
+
+
+
+
+
+
+
+
+
@@ -526,7 +550,7 @@
-
@@ -565,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"
/>
@@ -684,8 +715,8 @@
@@ -766,7 +797,7 @@
NOW()-'1 day'::interval AND t.archiv_url = 'Category' GROUP BY t.title , t.filename ORDER BY t.title"
type="set"/>
+
+
+
+
+
+
+
+
+
+
+