X-Git-Url: http://erislabs.net/gitweb/?a=blobdiff_plain;f=etc%2Fproducer%2Fproducers.xml;h=868b14d5e5f5b2ada730e33dfedde74452355c7f;hb=0180b034440e52dfd50f6d9b6cf72ce2f2827aca;hp=8e3445fdf3cd21986f2eebbfc13b18a6081c4f36;hpb=d986a088e168a9ab01a9a4690196d543efc068c4;p=nyc.indymedia.org.git
diff --git a/etc/producer/producers.xml b/etc/producer/producers.xml
index 8e3445f..868b14d 100755
--- a/etc/producer/producers.xml
+++ b/etc/producer/producers.xml
@@ -1,6 +1,5 @@
-
+
-
+
-
+
+
+
+
+
+
+
+
+
+
+
-
+
-
+
-
+
+
@@ -375,6 +387,16 @@
+
+
+
+
+
+
+
+
+
+
@@ -526,7 +548,7 @@
-
@@ -565,10 +587,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 +713,8 @@
@@ -766,7 +795,7 @@
NOW()-'1 day'::interval AND t.archiv_url = 'Category' GROUP BY t.title , t.filename ORDER BY t.title"
type="set"/>
+
+
+
+
+
+
+
+
+
+
+